Daily Sales Reconciliation: Connect Receipts, Deposits and the General Ledger

A business closes the day with $2,484 in customer charges, but only $1,827.48 from its card processor reaches the bank. That gap is not automatically missing cash. The sales report may include tax, the payment total may include cash and cards, and the processor may deposit card receipts after deducting fees.

Want the accounting side handled? Summer Peaks can handle all accounting, one accounting function, or a single project. Tell us what you want handled.

Start with three different questions

A useful reconciliation does not force unlike totals to agree. It connects them:

• What did the business record? Review gross sales, returns, discounts and any separately stated taxes or other liabilities.
• How did customers pay? Tie the amount collected to cash, checks, cards, online payments or other tenders.
• What reached the bank? Match cash deposits and processor settlements after considering timing, fees, chargebacks and adjustments.

Use the same business-day cutoff for each report. A processor's settlement date may differ from the sale date, so the bridge may cross more than one calendar day.

Build a daily bridge

Export or retain the source reports before editing anything. A short daily record can show the business date, gross sales, returns, net sales, taxes or other liabilities, total customer charges, tender totals, cash over or short, expected deposits, actual settlements, fees and unresolved differences.

First, prove that the sales report reaches the total charged to customers. Next, prove that the tender report reaches the same total. Then trace each tender to its destination. Cash may move from a register to cash on hand and later to the bank. Card receipts may remain in a clearing account until the processor settles them.

A simplified example

Assume a business reports $2,400 of gross sales, $100 of returns and $184 of sales tax collected. Net sales are $2,300, and total customer charges are $2,484. Customers paid $600 in cash and $1,884 by card.

The $600 cash deposit matches cash collected. The processor withholds a supported $56.52 fee and deposits $1,827.48. The accounting bridge is:

• At the sale: $600 to cash on hand plus $1,884 to card clearing equals $2,300 of net sales plus $184 of sales-tax liability.
• At settlement: $1,827.48 to the bank plus $56.52 of processing expense clears the $1,884 card balance.
• At the cash deposit: $600 moves from cash on hand to the bank.

This illustration is not a universal entry. The treatment of taxes, tips, discounts, returns, fees and chargebacks depends on the facts and the reporting framework. The point is to preserve the bridge instead of recording the net bank deposit as sales when the source reports support additional components.

Investigate differences without plugging them

Common exceptions include a refund recorded on a different day, a duplicated sale, an omitted cash deposit, a processor batch still in transit, a chargeback, an unsupported fee or a cutoff mismatch. Record the date, amount, source report, likely cause, owner and resolution. If the difference is timing, carry it forward until the related settlement appears rather than creating an unsupported adjustment.

Small teams may not be able to divide every step among different employees. A compensating review can still separate preparation from oversight: one person prepares the reconciliation, while an owner or another authorized reviewer compares source totals, deposit support and unusual adjustments before the period closes.

What to review each day

• Every expected register or sales channel is included.
• Returns, discounts and voids have support and appropriate approval.
• Tender totals equal total customer charges.
• Cash counted plus documented cash activity explains the expected cash.
• Processor batches, fees and chargebacks tie to settlement reports.
• Deposits and settlements are traced to the bank and general ledger.
• Open differences have an owner and a follow-up date.

A daily review can shorten the distance between a transaction and an answer. It does not replace the monthly bank reconciliation; it gives that reconciliation a cleaner, documented trail.

Sources and factual boundaries

University of California, Berkeley, Controller's Office, “Bank Deposit Handling and Recording” states that its deposit function creates daily general-ledger entries and identifies timely deposits and bank-to-ledger reconciliation actions. University of California Office of the President, “Quiz: How does your department rate?” describes separating receipt, daily balancing and deposit-verification duties, and reconciling cash receipts. These sources govern or assess university processes, not every business. Summer Peaks uses them only to support the stated control principles. Sources reviewed October 10, 2026. The example and workflow above are original Summer Peaks guidance, not a client result.