How do I record cash and card sales so the books match the bank?
Record the sale when it happens, and record the deposit the way the bank recorded it. Those are two separate steps, and most mismatches come from squashing them into one. Intuit's guide to bank deposits puts the whole idea in one line: your deposit in QuickBooks has to be for the exact same amount as the deposit on your bank statement.
The QuickBooks steps here come from Intuit help pages updated in August 2026, and the IRS guidance comes from Publication 583, revised December 2024. Both change, so check the current page before you rely on a specific step.
Why don't my sales and my deposits line up?
Because the bank sees totals and your register sees sales. Intuit says that when you deposit several payments together, the bank groups them into one total, and if you record each payment separately your records won't match. Twelve cash sales and one trip to the bank give you twelve entries and one bank line.
Card money does the same thing. If your card company pays out a batch of the day's card sales, and takes its fee before it does, the bank shows one smaller number than the sales you rang up. Neither number is wrong. They just need to be tied together in the books.
| Money coming in | What you record first | What the bank shows | How to tie them together |
|---|---|---|---|
| Cash sales for the day | A sales receipt for each sale or the day's total | One deposit for the cash you took in | Group the receipts into one bank deposit |
| Card sales for the day | A sales receipt for each sale or the day's total | One payout for the batch | Group the card receipts into one bank deposit |
| Fee taken before payout | Nothing yet | A payout smaller than the card sales | Add the fee as a negative line in the deposit |
| Bank fee you never entered | Nothing yet | A charge on the statement | Enter it so the books show it too |
What's the right way to enter a day's sales?
Use a sales receipt when the customer pays on the spot. Intuit's sales receipt guide says a sale paid right away is a sales receipt, and one paid later is an invoice. For a shop on Van Dyke that takes cash and cards at the counter, almost every sale is the first kind.
On each receipt, choose Undeposited Funds as where the money goes. Intuit calls it a temporary account for payments you plan to deposit later, and it's what lets you combine several payments into one bank deposit. If a payment goes into the bank on its own, Intuit says you can skip it and pick the bank account directly.
How do I record the deposit itself?
One exception first. If your card payments run through QuickBooks Payments, Intuit's article on QuickBooks Payments deposits and fees says QuickBooks Online records those deposits and the fees taken out automatically. Don't enter them again: match what's already there to the bank line. The same care applies if another app already posts your sales or deposits, so check the register before you add anything.
Make one bank deposit in QuickBooks for each deposit the bank shows. Pick the bank account and the date, then tick the receipts sitting in Undeposited Funds that made up that deposit. The total should equal the deposit slip or the payout line on the statement.
If a fee came out first, don't go back and edit the sales. Intuit says to add the fee in the same deposit window: choose Bank Charges & Fees as the account and enter the fee as a negative number. The sales stay at full value, the fee shows as a cost, and the deposit matches the bank to the cent.
Write the source on the deposit slip too. IRS Publication 583 says to note where each deposit came from, keep copies of the slips, and deposit all daily receipts into the business checking account. It lists cash register tapes, deposit slips and credit card charge slips among the records that back up your income.
Deposits and sales never quite agree?
Call TrustBooks Bookkeeping in Warren for a free consultation.
What does this look like for a Center Line shop?
The same as anywhere, with one local quirk worth knowing. Center Line is its own city, but Wikipedia's Center Line entry notes it's entirely surrounded by Warren, with Van Dyke Avenue running north and south through the middle and 10 Mile Road crossing it. If your shop is in Center Line, check that your records and accounts carry Center Line, not Warren, as the city.
City business questions go to the City of Center Line, whose office is at 7070 East Ten Mile Road. For the books themselves, see what bookkeeping for Center Line businesses covers.
How do I check it all at the end of the month?
- Make sure every day's sales are entered as sales receipts.
- Check that Undeposited Funds is empty except for money you haven't taken to the bank yet.
- Confirm each bank deposit in QuickBooks equals a deposit or payout on the statement.
- Enter any bank charges from the statement that aren't in the books yet.
- Reconcile the account against the statement's ending balance.
Publication 583 says to reconcile your checking account each month, and that the statement may not agree with your books if it carries bank charges you never entered or misses deposits made after the statement date. If a month still won't balance, Intuit's page on fixing reconciliation problems names missing or duplicate transactions and a wrong ending balance as usual causes. Our post on bank reconciliation vs bank feeds covers what that monthly check looks for.
When is it worth getting help?
If every sale, payout and fee is accounted for and the account reconciles each month, you can probably keep doing this yourself. It's worth a call when Undeposited Funds has months of old payments in it, when your income looks bigger than your bank balance can explain, or when you've stopped reconciling altogether.
TrustBooks monthly bookkeeping covers transaction categorization and bank and credit card reconciliation. If months have piled up, catch-up bookkeeping reconciles past periods and corrects errors. You deal with Vince directly. Call (586) 863-6663 for a free consultation.
