A bank reconciliation proves that the cash in your books matches the cash in your bank, and explains every dollar of difference. In most repair shops it happens on the last Friday of the month, at the front counter, by someone holding a bank statement in one hand and the phone in the other while a customer asks if the Tahoe is ready. (The Tahoe is not ready. Neither is the bank rec. They never are at the same time.)
That’s the definition. Here’s the part most guides skip: a clean bank reconciliation proves the cash matches the books. It does not prove you should have paid any of it.
Full disclosure: I run WickedFile, which works on that second question. It reads the vendor invoices, credit memos and statements behind your parts payments and flags the charges you paid that something should have reduced. It does not do your bank rec. So let’s do the bank rec properly first, by hand.
What a bank reconciliation actually checks
Your books and your bank record the same money at different times. That’s the whole reason this exercise exists.
AccountingTools puts it plainly: a bank reconciliation “compares the cash balance in an entity’s accounting records with the corresponding balance on the bank statement.” Differences usually come from a short list:
- Deposits in transit. You recorded Saturday’s deposit. The bank hasn’t yet.
- Outstanding checks. You mailed the parts store a check. They haven’t cashed it.
- Bank fees and charges you haven’t entered.
- Returned customer checks (NSF, “not sufficient funds”).
- Interest the bank paid you.
- Errors, on either side.
Repair shops add one more: card processor deposits. Your shop management system shows gross card sales. The deposit that lands is net of fees. Square, for one, says its processing fees “are deducted before funds are transferred to your linked bank account.” If you book the gross and never book the fee, your books will run high every single month.
How to do a bank reconciliation in 7 steps
Do this for every bank account and every company credit card. Same steps.
- Pick one date. Use the bank statement’s closing date and pull your book balance as of that same day.
- Match deposits. Tick each deposit in your books against the bank statement. Card batches should match the processor’s payout report, net of fees.
- Match withdrawals. Checks, ACH payments to vendors, card payments, transfers. Tick every one.
- List what’s left on the bank side. Deposits in transit get added to the bank balance. Outstanding checks get subtracted.
- List what’s left on the book side. Bank fees, processor fees, returned checks and their fees get subtracted from the book balance. Interest gets added.
- Compare the two adjusted balances. They should be identical. If they’re off, look for transposed numbers, a check entered at the wrong amount, or a transaction entered twice.
- Record the book-side adjustments, then sign and date it. Only the book-side items need journal entries. The bank-side items clear on their own next month.
If you use QuickBooks Online, its reconcile screen does steps 2 through 6 with checkboxes. It will also let you finish with a difference and post an adjusting entry to make the numbers agree. Please don’t make a habit of that. A forced adjustment doesn’t explain the difference. It just files it somewhere you’ll find it again at tax time.
One more housekeeping item. AccountingTools notes that some old checks simply never get cashed. For those, contact the payee, then void and reissue. A three-month-old check to a parts vendor usually means they lost it, not that they’re feeling generous.
A bank reconciliation example from a repair shop
These numbers are illustrative. Plug in your own.
Bank side, as of October 31:
| Item | Amount |
|---|---|
| Ending balance per bank statement | $48,210 |
| Add: deposits in transit (Friday card batch and Saturday cash) | +$6,340 |
| Less: outstanding checks (parts vendor statement $8,420, sublet $1,455) | -$9,875 |
| Adjusted bank balance | $44,675 |
Book side, as of October 31:
| Item | Amount |
|---|---|
| Ending cash balance in QuickBooks | $45,138 |
| Less: monthly bank service charge | -$35 |
| Less: customer check returned NSF | -$412 |
| Less: returned item fee | -$16 |
| Adjusted book balance | $44,675 |
Both sides land on $44,675. Difference: zero. You’d book three entries: the $35 fee to bank charges, the $16 fee to bank charges, and the $412 back to accounts receivable so somebody calls that customer. That’s a textbook bank reconciliation statement.
Now look at that $8,420 check again.
A perfect bank rec can still be paying the wrong bill
That check paid the parts vendor’s October statement in full. The bank rec matched it to the penny. Check written, check cleared, books agree.
What the bank rec can’t see is what was on the statement. Say it included:
- A $640 alternator that went back with the driver on the 12th. No credit memo ever arrived.
- A $185 core that was returned the same week. Never credited.
You paid $825 for parts the vendor already has back. The bank reconciliation is flawless. It’s also completely uninterested. Its job is to confirm the money left. Whether it should have left is somebody else’s job.
This is where “we don’t lose parts” comes from. Every shop says it, and every shop’s bank rec backs them up, because the bank rec can’t see parts. It sees checks and deposits. The shops that actually measure it, by holding the vendor statement up against their invoices, returns and cores before paying, are the ones that stop saying it.
Run that $825 every month across a couple of vendors and it’s a five-figure year, with every bank account reconciled perfectly the whole time. The vendor statement reconciliation guide covers the line-by-line method, and the return-and-forget loophole explains why returns are where most of it hides.
Bank rec vs vendor statement rec: you need both
They sound similar. They answer different questions.
| Bank reconciliation | Vendor statement reconciliation | |
|---|---|---|
| Question it answers | Does my cash match my books? | Does this vendor’s balance match my invoices and credits? |
| Documents | Bank statement, cash ledger | Vendor statement, invoices, credit memos, return slips |
| Catches | Unrecorded fees, bounced checks, short deposits, unauthorized debits | Missing credits, uncredited cores, duplicate invoices, charges with no invoice |
| Can’t catch | Paying a bill that was wrong | Cash problems at the bank |
| When | After the bank statement closes | Before you pay the vendor |
The timing row is the important one. The bank rec looks backward. The statement rec has to happen before the check goes out, because after that you’re asking for a refund instead of short-paying a statement.
If you’re building a full close routine, both of these sit on the month-end close checklist, and the QuickBooks practices for repair shops post covers the setup side.
The person who writes the checks shouldn’t reconcile them
Here’s the control that makes a bank rec worth doing.
The New York State Comptroller’s internal controls guide says bank reconciliations should be done by someone “who does not have custody or access to cash and who does not record cash receipt, cash disbursement, or journal entry transactions.” It’s written for local governments, but the logic is the same in a four-bay shop. If one person handles the money, records the money and reconciles the money, that person is grading their own homework.
Small shops can’t always split those jobs. The same guide’s answer for one-person offices is a monthly supervisor review. In a shop, that’s the owner, reading the reconciliation and flipping through the bank statement for anything strange: a payee you don’t know, a round-number transfer, a vendor you stopped using.
A shop owner at a conference once told me about hiring his wife’s brother. When things went wrong, dealing with it wasn’t simple, because the relationship came with the job. Eventually they found he’d been stealing from the business, and it was on camera. His takeaway wasn’t about family. It was that good systems don’t make exceptions for relatives. The owner review on the bank rec applies to your bookkeeper, your spouse and your cousin equally. That’s not suspicion. That’s the process doing its job so you don’t have to.
AccountingTools also suggests reconciling daily from the bank’s online activity, which flags ACH debits you didn’t authorize while they’re fresh. For a shop with vendors pulling payments by ACH, a five-minute look each morning is cheap insurance.
A balanced bank account is where the parts audit starts, not where it ends
So, your bank rec balances. Good. Now someone has to ask whether the payments were right.
For one or two vendors, you can do that by hand. Hold the statement against your invoice folder and your list of returns and cores, and short-pay anything that isn’t credited. That process costs nothing, and you should start there.
When you’ve got several vendors, card purchases at the parts counter and a stack of statements every month, WickedFile does the comparison for you.
What it reads: vendor invoices, credit memos and statements; repair orders from your shop management system; QuickBooks Online data; and bank and card transactions through Plaid.
What it flags next to your bank rec:
- Bank or card charges to a vendor with no invoice behind them.
- Statement lines with no supporting invoice.
- Credit memos missing for returns and cores, and credits issued but never applied to the statement.
- Accounting entries with no source document.
How to spend the free trial: 500 scanned pages, no credit card. Take October’s statements, invoices and credit memos from your two biggest parts vendors, connect the bank account those vendors get paid from, and see whether anything you paid should have been smaller.
What it doesn’t do: it doesn’t reconcile your bank account. QuickBooks still does that, with you or your bookkeeper. It isn’t a payment processor, it doesn’t pay vendors, and it doesn’t replace your bookkeeping or your shop management system. After the trial, the Grow plan is $299 a month, flat.
Check last month’s vendor payments free →
Reconcile the bank so you know the money’s where you think it is. Reconcile the vendors so you know it should have gone where it went. Then you can finally tell the customer the Tahoe is ready, with a straight face and a balanced checkbook.
