Bank Statement Conversion for Daily Sales Reconciliation

What daily sales reconciliation proves

For a restaurant or retail shop, reconciliation answers one question: did the sales your POS rang up actually land in the bank? The POS says what was sold and how it was paid, by cash, card, gift card, or delivery app, and the bank says what was deposited. Tying the two together is what catches skimmed cash, a missed deposit, or a card batch that never settled. The bank side arrives as a PDF statement, though, so matching a month of daily deposits against daily Z-reports by hand is slow. Converting the statement to a CSV turns each deposit into a row you can sort by date and match, which is where the reconciliation actually gets done.

Match cash deposits to the drawer and Z-report

Cash is where discrepancies hide, so it is worth matching carefully. Compare each cash deposit on the converted statement to the drawer count and the cash tender total on that day's Z-report. A deposit that is short, or a day with sales but no matching deposit, is exactly what this catches. Cash should reach the bank daily or every other day at most, and a converted CSV sorted by date makes a growing gap between cash sales and deposits obvious, which matters because those gaps are a classic audit red flag. Small over-and-short amounts are normal; a pattern is the signal.

Match card batches to processor settlements

Credit and debit sales settle in batches, and the processor's daily batch should match the card total on your POS Z-report, typically within about ten cents from rounding. Two things keep the bank deposit from equaling the POS figure: the processor deducts its fees, so the deposit is net, and settlement lags the sale by one to three days, so a Friday batch may land Monday. Matching the converted deposits to the batch settlement by amount, then confirming the date is a day or two later, ties them out. Booking the gross card sales and the fees separately keeps the net deposit reconciling to the bank.

Delivery payouts and other tenders

Not every tender on the Z-report becomes a bank deposit, and knowing which is which prevents false mismatches. Third-party delivery apps pay out on their own schedule, net of commission, so those deposits match a delivery payout report rather than the day's sales directly. Gift cards sold add cash now but are a liability, and gift cards redeemed are not new money, so neither maps one-to-one to a deposit. House accounts settle later. Filtering the converted deposits by descriptor lets you separate card batches, delivery payouts, and cash deposits so each is matched against the right report instead of the total.

Catching shortages and missing deposits

The whole point is exceptions, and structured data surfaces them fast. With the statement in a CSV you can line up deposits against daily sales and immediately see a day that is short, a deposit that never posted, or a card batch missing from the bank. Those are the items to investigate before they close into the month. Because these are live business records, statements are processed to build the CSV and then deleted automatically, with nothing retained on a server afterward. For an operator or bookkeeper reconciling several locations, bulk conversion turns a stack of statements into matchable daily deposits in one pass.

Frequently Asked Questions