CEOBOOKS & TAX Book a scope call
Close · 3 min read

Reconciling Payment Processor Payouts to Revenue

Why the deposit in your bank never equals your revenue, and the clearing-account method that ties gross charges, fees, refunds and disputes to every payout.

By CEO Books & Tax

A payout from your payment processor is not revenue. It is the net result of many charges, minus fees, refunds and disputes, often settled days after the charges happened. Recording the deposit as revenue is one of the most common errors in SaaS books, and it quietly breaks revenue recognition, gross margin and the deferred revenue roll-forward.

The clearing account method

Treat the processor like a bank account that sits between your customers and your real bank.

  1. Charges increase the processor clearing account and accounts receivable is relieved (or deferred revenue is credited for upfront billings).
  2. Fees reduce the clearing account and are recorded as an expense.
  3. Refunds and disputes reduce the clearing account, with the revenue or deferred revenue side corrected.
  4. Payouts move cash from the clearing account to the bank.

At month end, the clearing account balance should equal the processor's available plus pending balance.

What to reconcile each month

CheckSource
Gross charges equal invoices paid by card or ACHProcessor report vs. billing system
Fees recorded as expenseProcessor fee report
Refunds and disputes recorded and matched to customersProcessor activity report
Payouts match bank depositsPayout report vs. bank statement
Clearing balance equals processor balanceBalance report

Common breaks

  • Payouts that span months. Charges on the 30th settle on the 2nd. The clearing account carries the difference; the deposit is not next month's revenue.
  • Currency conversion. Multi-currency charges settled in USD create FX gains and losses that belong outside revenue.
  • Disputes. Chargeback fees and reversed revenue land in different accounts.
  • Connected accounts and platform fees. Marketplace models need separate treatment for funds held on behalf of others.

Automating it

Most accounting platforms have connectors that post payout-level summaries. Summaries are fine if they split gross charges, fees and refunds; a connector that posts only the net deposit needs to be fixed before it causes months of cleanup.

We reconcile every processor account at every close, so revenue, fees and cash each land where they belong and the deferred revenue schedule ties.

A sample monthly tie-out

LineAmount
Opening clearing balance$42,300
+ Gross charges$310,500
− Processing fees$9,180
− Refunds$6,200
− Disputes lost$1,100
− Payouts to bank$289,900
= Closing clearing balance$46,420
Processor balance (available + pending)$46,420

When the last two lines agree, revenue, fees and cash are all accounted for. When they do not, the difference usually sits in a payout booked to the wrong month, a dispute recorded once instead of twice (reversal and fee), or a currency conversion posted to revenue.

Invoices paid outside the processor

Customers who pay by wire or check settle invoices directly to the bank. Make sure the billing system marks those invoices paid so they are not also expected through the processor, or receivables will look overdue when they are not.

Revenue, deferred revenue and the processor

The processor knows when cash was collected, not when service was delivered. Annual plans charged through the processor still go to deferred revenue and are recognized monthly from the revenue schedule. The clearing account only proves the cash side; ASC 606 handles the revenue side.

Year-end and audit

Keep the monthly tie-out with the close package. An auditor will ask for a sample of payouts traced to bank deposits and to the underlying charges, and a ready schedule turns that request into a file share.

Sources

Questions founders ask

Why not just record the deposit as revenue?

Because the deposit is net of fees, refunds and disputes, and it often covers charges from several days. Recording it as revenue understates both revenue and fees and makes deferred revenue impossible to tie out.

Where do processor fees go?

As an expense, often in cost of revenue or G&A depending on your policy. They should never be netted out of revenue.

Keep reading

More on close

Book a scope call

Want this run for you, every month?

Revenue recognition, the close, cash, tax and board reporting, run by senior finance people in the accounting software you already use.