How do you match a restaurant location's card deposits to its sales?

 To match a restaurant location's card deposits to its sales, start from the POS card total for the month, subtract the last batch still in transit at month end, subtract the processing fees the processor withheld, and the result should equal what landed in that location's bank account. Book the fees as an expense so sales stay at the full POS figure. ZeraBooks does this monthly for each location.

With one location, a small gap between card sales and deposits is annoying. With three or four, it's where real money goes missing without anyone noticing, because each location's numbers blur into the others'.

The month-end match for one location

A fictional example. One location of a restaurant group, October 2026.

| | Amount | |---|---| | POS card batches for October (sales, tax and tips) | 74,300.00 | | Less: October 31 batch, deposited November 2 | (1,210.40) | | Less: processing fees withheld by the processor | (1,634.60) | | Card deposits in the location's account in October | 71,455.00 |

74,300.00 less 1,210.40 is 73,089.60. Less 1,634.60 is 71,455.00. If the bank statement shows 71,455.00 of card deposits for the month, every dollar is explained.

The October 31 batch belongs to October's sales. It just arrives in November. Next month's match will start by adding it back in.

Why the fees matter for sales

Many processors pay out net: they keep their fee and deposit the rest. If you book the deposits as sales, October's sales show 71,455.00 plus whatever the in-transit batch adds. That's short of what customers actually paid, and your fees line shows nothing.

Book sales at the POS figure and the 1,634.60 as card processing expense. Now sales agree with the POS, and you can see what card acceptance costs each location each month.

Where tips and tax fit

The POS card total includes sales tax and card tips. Neither is restaurant revenue. Tax collected is owed to the tax authority. Card tips are owed to staff and usually paid out through payroll. So the match uses the full card total, but the books split it: net sales to revenue, tax to a sales tax liability, tips to a tips payable account that clears when payroll runs.

The multi-location problem: deposits in the wrong account

This is the error that only happens when you have more than one location. A processor terminal gets moved, a merchant account gets set up against the wrong bank account, or a new location's batches go to the old location's account for a few weeks while setup finishes.

Say 2,480.00 of this location's card batches landed in a sister location's account in October. The match above would come up 2,480.00 short, and the sister location's would be 2,480.00 over. Both look broken. Neither is.

Record the deposit where it actually landed, because that's what the bank statement shows. If both locations belong to one company, move it between their sales lines with a simple reclassification. If each location is its own company, it's intercompany: the sister location owes this one 2,480.00, recorded on both sides. Then fix the processor setup.

A habit that catches it early

Do the match for every location in the same week each month. Lay them side by side. When one location is short and another is over by the same amount, you've found a misrouted batch in minutes.

How we do it at ZeraBooks

Our bookkeeping team keeps the books for each location on the ZeraBooks ledger. You upload each location's bank statements and POS month-end summary to a portal. We match card deposits to POS totals, book fees separately, and prove each bank account against its statement to the cent before the month is signed off.

There's no POS, bank feed or payroll connection, and ZeraBooks has no location tags or consolidated report across companies yet; each location's reports download as Excel. Pricing for a restaurant group comes from a free call about your locations and volume, starting at $150 a month in USD.

Royalty fees, intercompany loans and a three-location worked month are in our guide to multi-location restaurant bookkeeping.

Written by ZeraBooks, which provides the bookkeeping service described.

Comments

Popular posts from this blog

How to clean up messy books without redoing the same month twice

How to convert a credit card statement PDF to Excel, step by step

How to scan a bank statement so it converts to Excel cleanly