How do I reconcile daily sales with deposits?
Daily sales rarely match bank deposits dollar for dollar. The difference usually comes down to timing, payment processor fees, and how different payment methods settle.
Credit card transactions don’t hit your bank the same day. Your POS shows $2,500 in card sales on Monday, but that batch might not deposit until Wednesday. And when it does, you’ll see around $2,425 because the processor took their 2-3% cut. To reconcile, match each deposit to the original batch date, not the deposit date. Your processor portal shows batch details including the settlement date and fees deducted.
Cash is more straightforward but requires discipline. If your register shows $340 in cash sales, that’s what should go in the deposit bag. If your actual deposit is $320, you have a $20 variance to investigate. Either the register was wrong, someone made incorrect change, or cash walked out the door. Cash discrepancies need to be caught daily because the trail goes cold fast.
If you’re running a restaurant or other cash-heavy business, daily reconciliation prevents small problems from becoming big ones. A $50 daily variance might seem minor until you realize it’s been happening for three months.
For businesses using multiple payment methods like credit cards, cash, checks, and third-party apps, each one needs its own reconciliation path. The actual process goes like this. Start with your daily sales report from the POS. Break it into payment types. Match credit card totals to your processor batches, accounting for fees. Match cash to deposit slips. Match third-party payments to their respective settlement reports. Any difference is a variance you need to explain.
Timing differences are normal. A credit card batch closed at 9pm might not settle until two days later. This isn’t a discrepancy, it’s just how payment processing works. Your books should record revenue when earned on the sale date, not when deposited. The deposit is just cash collection on revenue you already recorded.
A San Diego bookkeeping service handling full-service monthly books will typically create a daily sales summary that breaks down each tender type and matches it to the corresponding deposit or processor report. If you’re handling this yourself, set up a simple spreadsheet or use your accounting software’s deposit matching feature. The goal is getting every dollar of sales traced to a bank deposit within a few days of the transaction. When this works, month-end becomes verification rather than detective work.
San Diego's Small Business Bookkeeper
The Next Step:
A Short Conversation
A quick call to tell us about your business. We'll listen, answer your questions, and give you a clear price quote.
More Questions
How do I set up sales tax in QuickBooks?
Start by getting your California seller's permit, then enable the sales tax feature in QuickBooks Online and configure your business address. QuickBooks will calculate district-level rates automatically based on customer locations.
Read answerCan a bookkeeper fix years of neglected books?
Yes. Bookkeepers regularly handle catch-up work for businesses with years of neglected records. As long as bank statements and basic documentation exist, the books can almost always be reconstructed and brought current.
Read answerWhat financial reports should I review monthly?
Every business should review the profit and loss statement, balance sheet, and cash flow statement monthly. Adding accounts receivable and payable aging reports helps you spot collection issues and plan for upcoming bills.
Read answerWhat documents do I need for bookkeeping cleanup?
Bank statements are essential. Credit card statements, prior tax returns, and existing bookkeeping records also help. You probably won't have everything perfectly organized, and that's okay.
Read answerHow much does catch-up bookkeeping cost?
Catch-up bookkeeping is priced per project, typically ranging from $750 to $5,000 or more depending on how far behind you are, transaction volume, and business complexity. The condition of existing records also affects the cost.
Read answerCan QuickBooks integrate with my POS system?
Yes, QuickBooks Online integrates with most major POS systems including Square, Toast, Clover, and Shopify. The key is setting up the integration correctly so sales data flows into the right accounts.
Read answer