CounterChef
Request a demo

Restaurant Credit Card Reconciliation: How to Match Sales, Tips, Fees, and Bank Deposits

Restaurant credit card reconciliation is the process of matching what your restaurant records in card sales against what your payment processor reports and what actually reaches your bank account. The trick is to stop treating those three numbers as if they should always match on the same day, then build a weekly routine that explains every difference instead of letting small discrepancies accumulate.

Start by separating the three numbers you are trying to reconcile

A restaurant can have a perfectly accurate sales report and still receive a bank deposit that looks wrong. That is because the point-of-sale (POS) system, payment processor, and bank each record a different stage of the transaction.

Think of reconciliation as three connected records.

1. Your restaurant's sales record

This is what your POS records when guests pay. It should include:

  • Gross credit card sales.
  • Refunds and voids.
  • Discounts and promotions.
  • Tips charged to credit cards.
  • Sales tax collected.
  • Other card-funded transactions.
  • Cash and other payment methods, recorded separately.

Your POS closing report tells you what the restaurant believes it processed. It is the starting point, not proof that the money arrived.

2. Your payment processor's settlement record

The processor records the card transactions it accepts and groups them into batches for settlement. Its reports may show:

  • Captured transactions.
  • Refunds.
  • Chargebacks.
  • Processing fees.
  • Adjustments.
  • Batch settlement amounts.
  • Settlement dates.

The processor's settlement report is the bridge between restaurant sales and the bank.

3. Your bank statement

The bank shows the deposits and withdrawals that actually posted to your account.

A deposit may combine several batches, arrive on a different business day, or reflect deductions made before the money reaches your account.

Your reconciliation job is to explain the movement from the first record to the third.

Establish one consistent reporting period before comparing numbers

One of the easiest ways to create a false discrepancy is to compare reports that cover different periods.

Restaurants often operate past midnight. A Saturday dinner shift may finish at 1:30 a.m. Sunday, while the POS assigns the transactions to Saturday's business date. The processor may use the actual transaction date, and the bank may not show the resulting deposit until Monday.

These are not necessarily errors.

Before comparing records, establish three rules:

  • Business date: The date assigned by your POS closing procedure.
  • Settlement date: The date the processor groups or releases the batch.
  • Bank posting date: The date the deposit appears in your bank account.

Keep all three dates in your reconciliation worksheet.

Also, use the same time zone across reports whenever possible. If your processor operates using a different time zone, document the difference.

For restaurants, a weekly reconciliation is usually easier to manage than trying to force every daily deposit to match every daily sales report.

A practical schedule is to reconcile Monday through Sunday after the processor has had enough time to settle the final weekend batches.

Bank and cash accounts with balances

Use this one-week reconciliation table as your working model

The following example demonstrates how to reconcile card activity over one restaurant week.

All amounts, dates, transaction counts, fees, and business activity in this example are hypothetical. The figures are illustrative, not industry averages or recommended processing rates.

Assume the restaurant closes its weekly reporting period on Sunday and reviews the records on Tuesday.

Hypothetical weekly POS card activity

DayGross card salesCard refundsCard tips
Monday$2,400$50$360
Tuesday$2,650$0$400
Wednesday$2,800$100$420
Thursday$3,100$0$465
Friday$4,800$75$720
Saturday$5,600$125$840
Sunday$4,200$50$630
Total$25,550$400$3,835

For this example, gross card sales include the card-funded guest checks and their associated tips. Refunds are shown separately.

The first calculation is:

  • Hypothetical gross card sales: $25,550
  • Hypothetical card refunds: $400
  • Hypothetical net card activity before processing fees: $25,150

The $25,150 is the amount to compare with the processor's settlement activity, subject to timing differences and any additional adjustments.

Hypothetical processor reconciliation

Assume the processor reports the following:

ItemHypothetical amount
Gross captured card transactions$25,550
Refunds-$400
Processing fees-$638.75
Chargebacks-$50
Expected net settlement$24,461.25

The calculation is:

$25,550 - $400 - $638.75 - $50 = $24,461.25.

Now suppose the bank statement shows three deposits:

Bank posting dateHypothetical deposit
Tuesday$8,200.00
Thursday$7,900.00
Monday (following week)$8,361.25
Total deposits$24,461.25

The total bank deposits match the expected net settlement.

However, the deposits do not match the individual daily sales totals. That is not a problem by itself. The processor has grouped transactions into settlement batches, and some funds arrived after the restaurant's Sunday reporting cutoff.

The important result is that the weekly activity is accounted for.

If the final deposit had been $8,300 instead of $8,361.25, the restaurant would have an unexplained $61.25 difference to investigate.

That difference should not be written off as a processing fee without supporting documentation.

Check these five usual reasons deposits do not match

Most reconciliation problems come from a small number of recurring situations. Work through them in a consistent order rather than immediately assuming the processor made a mistake.

1. Settlement timing crosses business dates

A restaurant may process transactions on Friday night, but the processor may not release the funds until Saturday or Monday.

Weekends, bank holidays, cutoff times, and processing schedules all affect settlement timing.

What to do: Compare the processor's batch ID and settlement date against the bank deposit date. If a batch is still pending, list it as outstanding rather than recording it as missing.

A useful practice is to maintain an outstanding-settlement column. Every batch should eventually be marked as deposited, adjusted, or under investigation.

2. Processing fees reduce the deposit

Your POS may report $5,000 in card activity while the processor deposits less because it deducts fees.

Depending on the agreement, fees may include transaction charges, percentage-based processing charges, authorization charges, and other contracted items.

Some processors deduct fees from individual settlements. Others may bill them separately.

What to do: Obtain the actual processor fee statement. Compare its individual charges against the terms of your processing agreement.

Never estimate fees using a percentage from an old statement when the actual charges are available.

Also, avoid recording the entire difference between gross sales and deposits as one unexplained bank fee. Separate refunds, processing charges, chargebacks, and adjustments.

3. Tips are recorded differently across systems

Tips can create confusion because the POS may record them when a guest closes a check, while the processor captures the final transaction after tip adjustment.

For example, a guest may initially authorize $80 and leave a $16 tip. The final captured amount may be $96.

If the restaurant compares the original authorization against the final settlement, the numbers will differ.

Tip handling can also involve separate employee payout procedures, depending on how the restaurant distributes tips.

What to do: Compare final captured amounts rather than initial authorizations. Reconcile card tips separately from food and beverage sales.

Do not assume that a card tip is additional restaurant revenue. It is generally an amount collected for distribution under the restaurant's applicable tip policies and legal obligations.

Confirm tip distribution, payroll treatment, and recordkeeping requirements with an appropriate professional and the relevant state or local authorities.

4. Refunds, voids, and chargebacks appear in different places

A refund entered on Wednesday might not reduce a bank deposit until Thursday or later.

A void may cancel a transaction before settlement, while a refund may be processed after the original payment has already settled.

A chargeback is different again: it represents a disputed transaction and may produce a separate debit or adjustment.

What to do: Keep a refund and dispute log with these fields:

  • Original transaction date.
  • Refund or dispute date.
  • Original transaction amount.
  • Refund or disputed amount.
  • Reason.
  • Approval or reference number.
  • Processor adjustment date.
  • Final resolution.

This makes it easier to explain why a particular week's bank deposits include activity from an earlier week.

5. Batches are missing, duplicated, or assigned to the wrong account

Sometimes the issue is operational rather than financial.

An employee may forget to close a batch. A manager may accidentally close it twice. A terminal may process under a different merchant account. A processor account may be linked to the wrong bank account.

Multiple terminals and locations make these problems harder to spot.

What to do: Compare terminal IDs, merchant account identifiers, batch numbers, and settlement totals.

If the POS shows a batch that the processor does not show, investigate the terminal and batch status before assuming the money is lost.

If the processor shows a settlement but the bank does not, confirm the destination account and ask the processor for the settlement reference.

Reconcile tips separately so they do not disappear inside sales totals

Tips deserve their own reconciliation because the money belongs to a different operational process than ordinary restaurant revenue.

Consider a hypothetical Friday:

ItemHypothetical amount
Food and beverage sales$4,000
Sales tax$320
Card tips$600
Total card capture$4,920

Assume the hypothetical processing fee is $123.

The expected settlement is:

$4,920 - $123 = $4,797.

The $600 in tips is included in the card capture, but that does not mean the restaurant earned another $600 in sales.

The restaurant must account for the tips payable to employees and their eventual distribution.

For example, if the restaurant distributes the $600 through payroll, the accounting records should reflect the applicable tip liability and payout. If tips are distributed through another approved process, the records should reflect that process instead.

The exact accounting and payroll treatment depends on the restaurant's circumstances and applicable rules.

The important operational point is simple: reconcile the money collected for employees separately from the money earned by the restaurant.

Build a weekly reconciliation worksheet that explains every difference

A useful worksheet should answer five questions:

  1. How much did the restaurant capture?
  2. How much did the processor settle?
  3. What deductions or adjustments occurred?
  4. How much reached the bank?
  5. What remains outstanding?

Here is a ready-to-copy template.

Reconciliation itemAmount
POS gross card sales$________
Less: card refunds$________
Add: other documented card adjustments$________
Expected card activity$________
Processor gross captured$________
Processor refunds$________
Processing fees$________
Chargebacks and adjustments$________
Expected net settlement$________
Bank deposits received$________
Outstanding settlements$________
Unexplained difference$________

Use separate columns for the POS amount, processor amount, bank amount, and explanation if you maintain the worksheet in a spreadsheet.

One important detail: do not subtract an outstanding settlement twice. If it is included in the expected settlement but has not yet reached the bank, identify it as a timing difference, not a loss.

Try three practical changes that make reconciliation easier this week

You do not need a complicated accounting project to improve your process. A few small operating changes can make discrepancies easier to prevent and resolve.

Create a batch-close responsibility for every shift

Assign one person to confirm that the card batch has been closed or that the terminal's settlement process is functioning as expected.

Include the following in the closing procedure:

  • Confirm all terminals are accounted for.
  • Check whether transactions remain unsettled.
  • Record the batch reference.
  • Record the total card activity.
  • Initial the closing report.

This creates a clear handoff between the shift manager and whoever handles the books.

It also makes it easier to identify which shift needs attention when a batch is missing.

Keep a five-minute exception log instead of investigating everything immediately

Not every difference needs a full investigation.

Create a short log for unresolved items with the amount, date, reason, responsible person, and next action.

For example:

DateDifferencePossible causeNext action
Friday$75Pending settlementCheck Monday
Saturday$25Refund timingVerify processor
Sunday$40Unknown terminal batchCheck terminal report

These are hypothetical examples.

The exception log prevents managers from repeatedly investigating the same issue. It also makes unresolved discrepancies visible instead of burying them in email or handwritten notes.

Set a specific deadline for each item. An outstanding $75 should not remain on the list indefinitely just because someone believes it will probably appear later.

Run a reverse reconciliation once a week

Most restaurants start with POS sales and work toward the bank deposit.

Try the opposite once a week.

Start with every card-related bank deposit and trace it backward to the processor settlement report and then to the POS batches.

This catches a different class of problem: deposits that appear in the bank but are not connected to the expected restaurant reporting period.

It can reveal deposits from older batches, unexpected adjustments, or activity from another merchant account.

The reverse check is particularly useful when the restaurant uses multiple terminals or operates more than one location.

Give unresolved discrepancies a deadline and an owner

A reconciliation process is only useful if someone is responsible for finishing it.

A practical division of responsibility might look like this:

ResponsibilityAssigned person
POS closing reportsShift manager
Batch and terminal checksClosing manager
Processor settlement reviewBookkeeper
Bank deposit matchingBookkeeper
Unexplained difference approvalOwner or finance manager

For small restaurants, one person may perform several of these duties. That is fine, provided the records are reviewed and discrepancies are not simply approved without explanation.

Set internal rules for escalation.

For example, a restaurant might require any unexplained discrepancy to be reviewed by the owner within two business days. This is an internal control suggestion, not an industry benchmark.

Also, preserve supporting documents. Keep POS closing reports, processor statements, bank statements, refund records, and adjustment documentation together by reporting period.

Do not rely on the bank statement alone as proof that every transaction was correctly recorded.

Use accounting records to keep the reconciliation connected to the books

Once the processor and bank records agree, the accounting entries must reflect what actually happened.

A simplified accounting structure may include:

  • Card sales and applicable sales tax liabilities.
  • Tips payable.
  • Refunds and sales adjustments.
  • Processing fees.
  • Chargebacks and disputed amounts.
  • Funds awaiting settlement.
  • Bank deposits.

The exact accounts and journal entries depend on the restaurant's accounting method and chart of accounts.

One common mistake is recording the net bank deposit as the restaurant's total sales. That understates gross card activity and hides processing fees.

Another is recording tips as restaurant revenue without accounting for the corresponding employee obligation.

Work with your bookkeeper or accountant to establish a consistent posting method. Confirm tax and payroll treatment with a qualified professional, especially when local requirements affect tips, service charges, or sales tax.

Keep the reconciliation process simple as the restaurant grows

A single-location restaurant with two terminals may be able to reconcile using a weekly spreadsheet.

A restaurant with multiple locations, several merchant accounts, and different settlement schedules needs a more structured process.

Regardless of size, keep these records connected:

  • Daily POS closing reports.
  • Processor batch and settlement reports.
  • Refund and chargeback records.
  • Bank statements.
  • Weekly reconciliation worksheets.
  • Supporting explanations for adjustments.

CounterChef's Finance includes bank accounts and register reconciliation.

The important thing is to maintain a process in which every deposit has a supporting explanation and every unresolved difference has someone responsible for investigating it.

Frequently asked questions

How often should a restaurant reconcile credit card sales?

A restaurant should review its POS closing reports and batch activity daily, then complete a fuller reconciliation weekly.

Daily checks catch missing batches and operational mistakes quickly. Weekly reconciliation allows time for settlement timing differences to resolve.

Monthly reconciliation should also confirm that the accounting records agree with bank statements and processor statements.

Why are credit card deposits lower than restaurant sales?

Deposits may be lower because of processing fees, refunds, chargebacks, settlement timing, or adjustments.

Tips may also be included in card transactions without representing additional restaurant revenue.

Compare the POS report with the processor settlement statement before deciding that a deposit is incorrect.

Should credit card tips be included in restaurant sales?

Card tips are included in the amount collected through card transactions, but they should be accounted for separately from the restaurant's earned sales.

They generally represent amounts owed to employees, subject to applicable tip-sharing and payroll rules.

Confirm the appropriate accounting and reporting treatment with your accountant and relevant state or local authorities.

What should an owner do when a credit card deposit is missing?

First, check whether the batch was closed and whether the processor marked it as settled.

Next, verify the settlement date, batch reference, merchant account, and destination bank account.

If the processor reports that the funds were released but the bank does not show them, contact the processor and bank with the settlement reference and supporting reports.

Record the amount as outstanding while investigating it. Do not classify it as a processing fee or write it off without documentation.

A good restaurant credit card reconciliation process does not depend on every daily number matching perfectly. It depends on being able to explain every difference, trace every deposit, and identify every amount that still needs attention.

Related feature: Finance.

See it with your own menu in mind

Tell us how your restaurant runs. We will walk you through the parts that matter to you.

Request a demo