Skip to content
LedgerDock

Blog · Clearing accounts

Why do my card processor deposits not match my sales?

Card processor deposits never equal sales because the processor pays you net: sales minus fees, refunds and chargebacks, and usually a day or two later. Record gross sales, fees and refunds from the processor's report against a merchant clearing account, and code each bank deposit to the same account. It returns to 0.00 once every payout has arrived.

Why is the deposit never the same as the sale?

A processor such as Stripe or Square collects from the customer and pays you later, after taking its part. Four things sit between a sale and a deposit:

  • Fees. Taken out before you are paid.
  • Refunds and chargebacks. Taken out of a later payout.
  • Batching. One deposit covers many sales.
  • Timing. Sales on the 30th are paid on the 1st or 2nd.

So matching one deposit to one sale cannot work. What works is tying totals.

How do I book it with a clearing account?

Use the processor’s report for the period and one merchant clearing account. Example numbers: gross sales 5,000.00, refunds 100.00, fees 150.00, deposits received 4,750.00.

From the processor’s report:

AccountDebitCredit
Merchant clearing5,000.00
Sales5,000.00
Sales refunds100.00
Merchant clearing100.00
Merchant fees150.00
Merchant clearing150.00

From the bank, each deposit:

AccountDebitCredit
Cash4,750.00
Merchant clearing4,750.00

Clearing was debited 5,000.00 and credited 100.00, 150.00 and 4,750.00. It holds 0.00.

If the gross amount includes sales tax or tips, credit those parts to their liability accounts, not to sales.

What if it does not come to zero?

At month end it usually should not be exactly zero, because the last days of sales are still unpaid. The balance must equal what the processor owes you on that date. Compare it with the processor’s balance or payout report.

If it does not agree, check in this order:

  1. A deposit coded to sales instead of clearing.
  2. A refund or chargeback missing from the entry.
  3. Fees booked from an estimate instead of the report.
  4. A second processor or a reserve the processor is holding back.

Why not record it deposit by deposit?

You can, when volume is small: split each deposit into gross sales and fees. It gets slow quickly, and refunds that reduce a later payout are easy to miss. One entry per period from the report, plus the bank deposits, is faster and ties to a document.

This is the same idea as any clearing account: two records of the same money meet in one place.

What does a close check here?

That the clearing balance is explained. In LedgerDock an account set up as a clearing account blocks the lock while it has a balance, until it is zero or the reason, for example “payouts in transit, ties to the processor report”, is written into the close. See when a month is really closed.

Questions people also ask

Should I record the net deposit as sales?

No. Recording the net deposit understates both sales and fees. Sales should be the gross amount customers paid for what you sold, before the processor's fees. Sales tax and tips inside that amount are liabilities, not sales. The fees are an expense.

Why does merchant clearing have a balance at month end?

Sales from the last days of the month have not been paid out yet. The balance should equal the amount the processor still owes you on that date, which the processor's balance or payout report shows.

Where do chargebacks go?

A chargeback reduces what the processor pays you, like a refund. Record it against the clearing account as a reduction of sales, or to a chargeback expense account if you track them separately, plus any chargeback fee to fees.

All articles

An accountant's close tool. Month-end, year-end, closed right.