CompanyBench

Foreign transaction fee revenue closeoutRevenue & Fees

6 verifiers · 3 LLM-graded

EnvironmentsConfluenceSlackZeta3 SQL

TaxonomyRevenue & FeesRevenue & Fees

Task prompt

I'm closing out the foreign transaction fee line for revenue reporting. Across all history, how much foreign transaction fee revenue did we ACTUALLY COLLECT AND KEEP from customers? Important data gotcha: the ledger keeps two different fee-amount columns and they diverge — one holds the nominal fee that was scheduled/owed, the other holds what we actually debited from the account, which is smaller whenever the customer's balance couldn't cover the full fee (sometimes we only retrieved a few cents of a larger owed fee). The column whose name reads like 'realized' is the scheduled/owed amount and OVERSTATES revenue; the money we truly collected is the actually-debited amount. Report the actually-debited (collected) amount, net of any foreign transaction fees we later returned — not the scheduled figure. When you have the number, create a Slack channel 'foreign-tx-fee-closeout' and post the net figure there so Finance has it on record. Then reply, as the final line of your response, with exactly one JSON object with exactly this key: net_foreign_transaction_fee_revenue_usd, reported in US dollars.