Restaurant Bank Reconciliation: How to Find Missing Deposits, Duplicate Transactions & Accounting Errors
A restaurant bank reconciliation is more than checking whether
the balance in QuickBooks matches the balance at the bank. Done correctly, it
helps you find missing deposits, duplicate transactions, merchant settlement
problems, accounting errors and money that simply doesn’t make sense.
Restaurants are particularly difficult to reconcile because money moves through
several systems before it reaches the bank.
POS → Cash + Credit Cards → Processor → Clearing Accounts → Bank → QuickBooks
Add tips, refunds, chargebacks, processing fees, cash deposits, payroll and
vendor payments, and a seemingly simple bank reconciliation can expose much
larger financial-control problems.
The purpose of a bank reconciliation isn’t to make QuickBooks say $0.00.
It’s to prove that the money recorded in your books can be explained.
What Is a Restaurant Bank Reconciliation?
A bank reconciliation compares the transactions recorded in your accounting
system with the transactions that actually cleared your bank account.
The process identifies timing differences and errors so you can explain the
difference between your book balance and bank balance.
Bank Statement Balance ± Reconciling Items = Adjusted Bank Balance
That adjusted balance should agree with your correctly stated accounting balance.
Why Restaurant Bank Reconciliation Is Different
Restaurants can generate hundreds or thousands of transactions while only a
handful of deposits appear on the bank statement.
A single day may include:
- Food sales
- Beverage sales
- Sales tax
- Cash sales
- Credit-card sales
- Credit-card tips
- Gift cards
- Discounts and comps
- Refunds
- Processing fees
- Cash payouts
The bank may show only one or two merchant deposits representing all of that
activity.
Your bank statement shows money movement. It does not explain the underlying
restaurant transactions that created that movement.
The Three Numbers Restaurant Owners Often Confuse
One of the easiest ways to create reconciliation problems is assuming these
three numbers should be identical.
POS Sales
What the restaurant sold during the business day.
Merchant Settlement
The amount processed and settled by the credit-card processor.
Bank Deposit
The amount that actually reached the restaurant’s bank account.
Accounting Entry
How the underlying sales, liabilities and payments were recorded in the books.
Those numbers can legitimately differ.
If you’re struggling with this specifically in Toast, read
Why Toast Sales Don’t Match Your Bank Deposits
.
1. Start With the Bank Statement
Use the actual statement for the period you’re reconciling rather than relying
only on the current online bank balance.
Verify:
- Statement beginning date
- Statement ending date
- Beginning balance
- Ending balance
- Deposits
- Withdrawals
- Bank fees
The beginning balance should agree with the prior month’s completed
reconciliation before you start working on the current month.
2. Verify the Beginning Balance
If the beginning balance is wrong, stop before continuing.
A changed beginning balance can indicate:
- A previously reconciled transaction was edited
- A reconciled transaction was deleted
- A transaction date was changed
- An opening balance was modified
- A prior reconciliation was undone
Don’t Force the Current Month to Fix the Prior Month
If the opening balance changed, determine why. Creating an adjustment just to
make the reconciliation work can hide the original error.
3. Match Bank Deposits
Compare every deposit on the bank statement with the corresponding activity
recorded in your accounting system.
Restaurant deposits commonly include:
- Credit-card merchant settlements
- Cash deposits
- Delivery-platform deposits
- Catering payments
- Owner contributions
- Loan proceeds
- Vendor refunds or credits
A deposit appearing in the bank does not automatically mean it should be
recorded as restaurant sales.
4. Don’t Book Net Merchant Deposits as Sales
This is one of the most common restaurant bookkeeping mistakes.
Example
Restaurant sales:
$10,000
Sales tax:
$850
Credit-card tips:
$1,200
Refunds:
($150)
Bank deposit:
$11,900
Recording the $11,900 bank deposit directly to sales would mix multiple types
of activity together.
Instead, the POS activity should be recorded correctly and the settlement
should clear the appropriate receivable or clearing account.
Sales + Tax + Tips + Adjustments → Clearing Account → Bank Settlement
5. Use a Clearing Account for Merchant Settlements
A properly used clearing account creates a bridge between your POS and bank.
When the restaurant closes the business day, POS activity is recorded.
Credit-card amounts expected from the processor enter the clearing account.
When the processor deposits the money:
Debit Bank → Credit Merchant / POS Clearing
Ideally, cleared settlement activity eventually brings the corresponding
clearing balance back toward zero.
A clearing account that continually grows is telling you something isn’t
reconciling.
6. Investigate Old Clearing Account Balances
Don’t assume an unexplained clearing balance is harmless.
Old balances can indicate:
- Missing merchant deposits
- Duplicate POS entries
- Settlement timing differences
- Refunds
- Chargebacks
- Processing adjustments
- Incorrect accounting mappings
Aging Matters
A settlement from yesterday may simply be timing. A balance that’s been
sitting there for three months deserves investigation.
7. Reconcile Cash Deposits Separately
Cash should have its own audit trail.
POS Cash Sales → Expected Cash → Drawer Reconciliation → Deposit → Bank
Compare expected cash from the POS with:
- Starting drawer
- Cash sales
- Cash tips
- Payouts
- Paid-ins
- Ending drawer
- Cash removed
- Bank deposit
For stronger cash controls, see
Restaurant Cash Handling Procedures
.
8. Find Missing Deposits
A missing deposit should never simply disappear into a reconciliation
adjustment.
If the POS or clearing account shows money expected but the bank does not,
determine whether the difference is:
- Normal settlement timing
- A weekend or holiday delay
- A processor hold
- A chargeback
- A refund
- A cash deposit not taken to the bank
- A deposit posted to another bank account
- An accounting error
“It probably hit the next day” is not a reconciliation. Find the deposit.
9. Look for Duplicate Transactions
Duplicate transactions can enter restaurant books several ways.
- POS integration plus manual entry
- Bank feed plus manually entered expense
- Duplicate vendor bills
- Duplicate deposits
- Repeated journal entries
Common Example
A manager manually enters a $3,000 merchant deposit. The bank feed later
downloads the same $3,000 and someone adds it again instead of matching it.
The bank has one deposit. QuickBooks now has two.
10. Match Bank Feed Transactions—Don’t Automatically Add Them
Bank feeds are useful, but they do not understand your restaurant’s accounting
structure.
Before clicking Add, determine whether the transaction already
exists.
If a transaction was already created by your POS integration, payroll system,
bill entry or journal entry, the downloaded bank transaction may need to be
matched—not added again.
11. Review Withdrawals and Expenses
Match bank withdrawals to the appropriate transactions in the accounting system.
Review:
- Vendor payments
- Payroll withdrawals
- Payroll taxes
- Rent
- Utilities
- Loan payments
- Credit-card payments
- Owner draws
- Bank fees
Unrecognized withdrawals should be investigated rather than categorized to a
miscellaneous expense account simply to finish the reconciliation.
12. Separate Loan Payments Correctly
A loan payment may contain both principal and interest.
Example
Total loan payment:
$2,000
Principal:
$1,600
Interest:
$400
Recording the entire $2,000 as an expense would overstate expenses and fail to
reduce the loan liability correctly.
$1,600 → Loan Liability | $400 → Interest Expense
13. Review Payroll Withdrawals
Payroll can create several bank transactions rather than one.
You may see:
- Net payroll
- Payroll taxes
- Benefits
- Payroll service fees
- Tip-related payments
Make sure bank transactions are matched against the payroll entries already
recorded rather than creating duplicate payroll expenses.
14. Review Sales Tax Payments
Sales tax payments generally reduce the sales tax liability previously created
when tax was collected.
They should not automatically be treated as a new restaurant operating expense.
Debit Sales Tax Payable → Credit Bank
For the complete process, read
Restaurant Sales Tax: How to Record, Reconcile & Avoid Reporting Errors
.
15. Understand Outstanding Checks
A check or payment recorded in QuickBooks may not have cleared the bank by the
statement date.
That creates a legitimate timing difference.
Example
QuickBooks records a vendor check on August 29:
$2,400
Vendor deposits it September 3.
The August bank statement will not show the withdrawal, but the August books
may already contain it.
That payment is an outstanding transaction—not necessarily an accounting error.
16. Understand Deposits in Transit
The same timing issue can occur with deposits.
Example
Restaurant records a cash deposit on August 31:
$1,800
Bank processes it September 1.
The deposit may legitimately appear in the books before it appears on the
statement.
Deposits in transit should clear shortly afterward. Old “deposits in transit”
are a warning sign.
17. Don’t Use Reconciliation Adjustments as a Shortcut
QuickBooks may allow you to create an adjustment when the reconciliation
doesn’t balance.
That doesn’t mean you should.
The Dangerous Shortcut
Reconciliation difference: $427.18
Instead of finding the error, the difference gets posted to
“Reconciliation Discrepancies.”
The reconciliation now says zero, but you still don’t know where $427.18 went.
Zero is only meaningful when you understand why it is zero.
18. Investigate Old Uncleared Transactions
After reconciling, review old transactions that remain uncleared.
Look especially for:
- Old checks
- Old deposits
- Duplicate transactions
- Voided payments
- Incorrectly dated entries
- Transactions posted to the wrong bank account
An old uncleared transaction can keep your book balance wrong long after the
month was supposedly reconciled.
19. Review Owner Transactions
Owner money moving in or out of the restaurant should be identified clearly.
Examples include:
- Owner contributions
- Owner draws or distributions
- Owner-paid business expenses
- Business-paid personal expenses
An owner depositing $10,000 into the restaurant bank account does not
automatically create $10,000 of restaurant sales.
20. Finish the Reconciliation Before Closing the Month
Bank reconciliation should be a core part of the restaurant’s month-end close.
Before finalizing financial statements, confirm:
- All bank accounts are reconciled
- Merchant settlements are accounted for
- Cash deposits are accounted for
- Clearing accounts are reviewed
- Old uncleared transactions are investigated
- Duplicate transactions are corrected
- Loan payments are allocated correctly
- Payroll withdrawals are matched
- Sales tax payments are recorded correctly
Then continue through the complete
Restaurant Month-End Close
process.
Are the Numbers in Your Restaurant Actually Connected?
Use the Margin & Menu Restaurant Financial Leak Checklist to review
deposits, POS activity, accounting, inventory, labor, cash and other places
where restaurant financial systems can quietly break down.
A Simple Restaurant Bank Reconciliation Workflow
Verify the Statement
Confirm the statement period, beginning balance and ending balance.
Match Merchant Deposits
Trace credit-card settlements through the clearing account to the bank.
Match Cash Deposits
Trace expected cash from the POS and drawer close to the bank deposit.
Match Withdrawals
Review vendors, payroll, taxes, loans, owners and other bank activity.
Identify Timing Differences
Document legitimate outstanding payments and deposits in transit.
Investigate Differences
Find missing deposits, duplicates, mapping errors and unexplained activity.
Review Clearing Accounts
Make sure old settlement balances aren’t accumulating unexplained.
Complete the Reconciliation
Only close the period once the difference is explained—not merely adjusted away.
Restaurant Bank Reconciliation Red Flags
Changing Beginning Balance
Prior reconciled transactions may have been edited or deleted.
Growing Clearing Balance
Merchant settlements may not be matching POS activity correctly.
Old Deposits in Transit
Cash or merchant deposits may be missing or incorrectly recorded.
Duplicate Bank Feed Entries
Existing transactions may have been added instead of matched.
Large Reconciliation Adjustments
Differences may have been written off rather than investigated.
Months Not Reconciled
Financial statements may contain accumulated errors nobody has identified.
Why Bank Reconciliation Matters to Restaurant Profitability
Bank reconciliation isn’t just bookkeeping.
It validates many of the numbers used to manage the restaurant.
Sales → Deposits → Expenses → Cash → Financial Statements
If those transactions are incomplete or duplicated, your P&L and balance
sheet can be wrong even if the reports look professional.
A restaurant can appear more profitable—or less profitable—simply because
transactions were recorded incorrectly.
Good financial reporting begins with proving that the underlying transactions
actually happened.
The Bottom Line
A restaurant bank reconciliation should answer a simple question:
Can we explain every meaningful difference between the books and the bank?
If the answer is yes, the reconciliation is doing its job.
If the answer is, “We made an adjustment until it balanced,” you haven’t
reconciled the account—you’ve hidden the difference.
Find Out Where the Money Stops Making Sense.
Margin & Menu’s 360° Restaurant Financial Audit follows the money across
your POS, merchant deposits, bank accounts, QuickBooks, cash, payroll,
inventory and financial reporting.
- POS-to-bank reconciliation
- Merchant clearing accounts
- QuickBooks structure
- Bank reconciliations
- Cash deposits
- Sales tax liabilities
- Payroll and labor
- Inventory and COGS
- Financial reporting
You receive a financial health score, written findings and a
prioritized action plan showing what should be fixed first.
360° Restaurant Financial Audit — $995
Fix the Systems Behind Your Restaurant’s Numbers.
Better restaurant financial performance starts with systems that connect.
Explore the areas where Margin & Menu helps restaurant owners improve
control, reporting and profitability.
ACCOUNTING
Restaurant Accounting Services
Reconciliation, QuickBooks & financial reporting →
POS SYSTEMS
Restaurant POS Consulting
POS setup, reporting & back-office controls →
INVENTORY + COGS
Inventory & COGS Controls
Purchasing, variance, waste & food cost →
PAYROLL + LABOR
Payroll & Labor Controls
Scheduling, payroll & labor-cost control →
CASH + TIPS
Cash & Tip Controls
Drawers, tips, payouts & deposits →
PROFITABILITY
Profitability & Financial Reporting
Prime cost, cash flow, margins & KPIs →