Operations 7 min read

Bank Reconciliation for Auto Repair Shops

Bank reconciliation for auto repair shops in 7 steps, with a worked $44,675 example and why a balanced bank can still hide an $825 vendor overpayment.

Bank Reconciliation for Auto Repair Shops
In this article
  1. What a bank reconciliation actually checks
  2. How to do a bank reconciliation in 7 steps
  3. A bank reconciliation example from a repair shop
  4. A perfect bank rec can still be paying the wrong bill
  5. Bank rec vs vendor statement rec: you need both
  6. The person who writes the checks shouldn’t reconcile them
  7. A balanced bank account is where the parts audit starts, not where it ends

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.

  1. Pick one date. Use the bank statement’s closing date and pull your book balance as of that same day.
  2. Match deposits. Tick each deposit in your books against the bank statement. Card batches should match the processor’s payout report, net of fees.
  3. Match withdrawals. Checks, ACH payments to vendors, card payments, transfers. Tick every one.
  4. List what’s left on the bank side. Deposits in transit get added to the bank balance. Outstanding checks get subtracted.
  5. 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.
  6. 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.
  7. 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:

ItemAmount
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:

ItemAmount
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 reconciliationVendor statement reconciliation
Question it answersDoes my cash match my books?Does this vendor’s balance match my invoices and credits?
DocumentsBank statement, cash ledgerVendor statement, invoices, credit memos, return slips
CatchesUnrecorded fees, bounced checks, short deposits, unauthorized debitsMissing credits, uncredited cores, duplicate invoices, charges with no invoice
Can’t catchPaying a bill that was wrongCash problems at the bank
WhenAfter the bank statement closesBefore 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.

Frequently asked questions

What is a bank reconciliation?

A bank reconciliation compares the cash balance in your books with the balance on your bank statement for the same date, then explains every difference. Most differences are timing, like deposits in transit and checks that have not cleared, or bank items you have not recorded yet, like service fees and bounced checks. When both adjusted balances agree, the account is reconciled.

What is a bank reconciliation statement?

It is the one-page document that shows the work. It starts with the bank's ending balance, adds deposits in transit and subtracts outstanding checks. Then it starts with your book balance, subtracts bank fees and returned checks and adds any interest. Both sides should land on the same adjusted cash figure, and someone should sign and date it.

How often should an auto repair shop do a bank reconciliation?

At least monthly, for every bank and credit card account, shortly after the statement closes. Weekly or even daily is better for a busy operating account, because you catch unauthorized ACH debits, bounced customer checks and short card deposits while they are still easy to fix.

What is the difference between a bank reconciliation and a vendor statement reconciliation?

A bank reconciliation proves the cash in your books matches the cash in your bank. A vendor statement reconciliation proves the balance a vendor says you owe matches the invoices and credits you actually have. You need both. A bank rec can balance perfectly while you are overpaying a parts vendor for returns and cores that were never credited.

Who should do the bank reconciliation in a small shop?

Ideally someone who does not handle cash, sign checks or enter transactions. The New York State Comptroller's internal control guide says that where one person has to do it all, a supervisor should review the entries and reconciliations every month. In a small shop, that supervisor is usually the owner, reading the reconciliation and the statement before signing off.

Does WickedFile do bank reconciliation?

No. Your bank reconciliation belongs in QuickBooks or your accounting software. WickedFile connects to bank and card activity through Plaid and checks the other side of each payment: whether a vendor charge has an invoice behind it and whether the vendor statement you paid included every credit you were owed. The free trial is 500 scanned pages with no credit card.

Your bank balanced. Did your vendors?

WickedFile checks the invoices, credit memos and statements behind every parts payment, so a balanced bank account isn't quietly hiding a missing credit.

Start the free trial
500 free pages · No credit card · Connects to your SMS