Blog

Finance

Bank reconciliation for a restaurant or café, step by step

Card fees, delivery commission and last night's cash: why the bank never matches the till, and how to name every dirham of the gap.

A bank reconciliation for a restaurant or café checks that the bank balance in your books agrees with the bank statement, and explains every difference. The two rarely match on the day: card takings arrive a day or two late minus fees, delivery apps pay weekly minus commission, and cash is banked after the till closes. Check card payouts daily, delivery payouts weekly and the whole account monthly, and treat any gap you can't explain as a problem, not rounding.

Why doesn't the bank balance match the till?

The till records a sale when it happens. The bank records the money when it arrives. In between are the usual causes:

  • Card settlement delays. The acquirer, the bank or company behind your card machines, pays a day or more after the sale, and longer over a weekend.
  • Fees deducted at source. The acquirer keeps its fee and pays you the rest, so the deposit is never the till's card total.
  • Refunds. A refund put back on a customer's card comes out of a later settlement, not out of the day it belongs to.
  • Delivery app payouts. The apps pay weekly or fortnightly, one lump for many days of orders, net of commission and sometimes of refunds and promotions.
  • Cash deposits. Last night's cash is banked this morning, or three nights are banked together.
  • Transfers between accounts. Money moved to a savings account, a second company or the petty cash float shows on the statement, but it is neither a sale nor a cost.
  • Bank charges and cheques. Charges the bank takes without a bill, and cheques you've written that the supplier hasn't banked yet.

None of these is an error. Each is a delay or a deduction you can name. Once you have named them all, whatever is left is a real problem.

How do you do a bank reconciliation for a restaurant?

Work forward from the last month that agreed, one bank account at a time.

  1. Start from an agreed balance. Last month's reconciled closing balance is this month's opening. If it never agreed, fix that first, or every month inherits the gap.
  2. Match deposits to settlements by day. Put each day's card total from the till next to the settlement that paid it, and each delivery payout next to the days of orders it covers. A day with no settlement is the first thing to chase.
  3. Book the fees. The gap between the sales and the settlement is the fee or the commission. Book it as an expense in the month of the sale, check it against the rate in your contract, and question any day where it differs.
  4. Tick off the money going out. Supplier payments, salaries, rent, petty cash top-ups and transfers, each against the entry that recorded it.
  5. Find what's missing. A line on the statement with nothing in the books is usually a bank charge or a direct debit nobody recorded: book it. An entry in the books with nothing on the statement is a deposit in transit or a payment that hasn't cleared: list it.
  6. Write the reconciliation statement. Take the bank's balance, add the deposits in transit and subtract the uncleared payments, and you have the adjusted bank balance. It must equal your books after the entries from step 5.

How do you handle card fees and delivery commission?

Record the full sale, never the net deposit. The sale is what the customer paid, and the fee is a cost of collecting it.

An invented example: the tills record 9,450 of card sales on the last day of the month, and the bank receives 9,261 two days later. The 189 gap is a 2% fee.

The sale and the fee both belong to the month just ended, even though the money arrived in the new one. Until it arrives, the 9,261 is owed to you by the acquirer. It is not in the bank yet.

Delivery apps work the same way, with bigger amounts. In an invented week, an app takes 6,200 of orders for you and pays 4,340, keeping 1,860 as a 30% commission. Record 6,200 of sales owed by the app, let the payout clear it, and book the commission as an expense.

For how VAT works on those sales, read our guide to VAT on delivery app sales.

What does a bank reconciliation statement look like?

Here is an invented café at the end of a month, in AED. The two halves must land on the same figure.

Line AED
Balance on the bank statement 52,640
Add: the last day's cash, banked the next morning 3,180
Less: a cheque to a supplier, not yet presented −4,200
Adjusted bank balance 51,620
Balance in the books 51,635
Add: a supplier's refund paid into the bank, not yet booked 480
Less: the internet bill, paid by direct debit, not yet booked −420
Less: the bank's monthly charge −75
Adjusted book balance 51,620
Difference 0

Every line is explained. The deposit in transit and the cheque will show on the statement in the first days of next month, so tick them off then. If the difference were 64 instead of 0, that 64 would be the number to spend your time on.

Card fees and delivery commission don't appear here, because they were booked when each settlement was matched to its days.

If your books put card sales straight into the bank at full value, the fees show here as items not yet booked. Matching each settlement to its days shows you the fees every day, not once a month.

How often should a café reconcile its bank account?

On three schedules, because the risks are different:

  • Daily, for cards. Check that yesterday's settlement arrived and that the fee looks right. It takes minutes, and a missing day is easy to chase at two days old and hard at two months.
  • Weekly, for delivery apps. Match each payout to the orders it covers, before the next one arrives.
  • Monthly, in full. The whole account, line by line, against the statement, in the first days of the new month. It's one step of the month-end close checklist, and it should be done before the profit and loss is reviewed.

What are the red flags in a bank reconciliation?

  • The same unexplained difference, month after month. A gap carried forward means no one has looked into it.
  • A day with sales and no settlement. Card machines sometimes send a day's batch late, but a missing day should be found within the week.
  • A fee rate that drifts. 2% in the contract and 2.4% on the statement is real money over a year.
  • Cash deposits that don't match the counted cash. If the till's count says 3,180 and the deposit says 3,000, the question is where 180 went between the drawer and the bank.
  • Refunds on the card machine that aren't on the till. Every refund should have a sale behind it and a name beside it.
  • A balancing entry. A line called "difference" or "adjustment" that makes it agree is not a reconciliation.
  • One person banks the cash and does the reconciliation. Keep those two jobs apart.

Most of these are easier to spot when you don't have to copy the till and the bank into the books first. That's the case for one version of the truth.

That's how Seyaqi handles it. Sales arrive from your tills line by line, and each card and delivery channel has its own account.

Upload a provider's statement and each payout is matched to its days, with the fee or commission drafted on its own line. A day that doesn't agree is flagged.

Upload the bank statement as the bank sends it. Each line is matched to the entry behind it, and a charge nobody booked becomes a draft entry for a person to approve. See how the books keep up with the day, or book a demo.

Common questions

Why is my bank deposit less than my card sales?

Because the card provider takes its fee before paying you, a day or more after the sale. In an invented example, 9,450 of card sales reaches the bank as 9,261: the 189 difference is a 2% fee. Record the full sale, and the fee as an expense in the month of the sale.

What is a deposit in transit?

Money your books show as banked that the bank hasn't shown yet, such as the last day's cash deposited the next morning. On the reconciliation, add it to the bank balance. If it is not on the statement within a few days, find out why.

How do you record delivery app payouts in the books?

Record each order as a sale the app owes you. When the payout arrives, it clears what the app owed, and the commission it kept is an expense. In an invented example, 6,200 of orders is paid as 4,340, with 1,860 kept as a 30% commission.

Who should do the bank reconciliation in a small business?

Someone who neither handles the cash nor makes the payments, usually the accountant, with the owner reviewing it each month. The person who banks the takings should not be the one who explains the gaps.

Every number in your business, in context.

Seyaqi runs stock, production, purchasing, sales, people and the books in one system, with an AI Advisor that reads it all every night and tells you what needs you.

Book a demo Get a quote

Read next