Account reconciliation means proving that a balance in your books is correct by comparing it to an outside record and explaining every difference. In most repair shops, the bank account gets reconciled every month, and everything else gets reconciled the day the accountant calls in March asking why the parts vendor says you owe $11,000 and QuickBooks says $6,200.
(Nobody knows. Nobody has known since August.)
That’s the meaning. This post is the map: which accounts a repair shop should reconcile, what each one gets compared to, and where the money usually hides. The detailed how-to for the big ones lives in their own posts, linked below.
I’ll say this up front: I run WickedFile, which handles one slice of this. It reads your vendor invoices, credit memos and statements and flags the credits and parts that don’t line up with your repair orders. The rest of the list is yours, a spreadsheet, and a quiet afternoon.
What account reconciliation means, in one paragraph
AccountingTools defines an account reconciliation as “the actions taken to prove that an account balance is valid.” It applies mainly to asset, liability and equity accounts, because their balances carry forward year after year. That’s why you’ll also hear it called balance sheet reconciliation.
There are two ways to do it. The documentation review, which auditors prefer, means opening the account detail and checking each transaction. The analytics review means estimating what the balance should be and investigating if it’s far off. In a shop, you’ll mostly do the first.
And the timing advice from the same page is worth taping to the monitor: reconciliations “should not be saved for the year-end closing process.”
Account reconciliation in a repair shop: the 9 accounts to check
The types of account reconciliation in a textbook are bank, receivables and payables. AccountingTools lists those three, plus reconciling inventory records to physical on-hand balances. A repair shop has a few more that no generic guide mentions.
| Account | Compare it to | What usually breaks |
|---|---|---|
| Bank accounts | Bank statement | Uncleared checks, unrecorded fees, bounced customer checks |
| Credit cards | Card statement | Parts-counter charges with no invoice, personal purchases |
| Accounts payable (by vendor) | Vendor statement | Missing invoices, credits never applied, duplicate charges |
| Inventory | Physical or cycle count | Parts used and never billed, returns never sent |
| Core deposits | Your list of cores out for credit | Cores returned but never credited |
| Sales tax payable | Your sales tax return and SMS sales report | Refunds that didn’t reverse the tax, manual entries |
| Card merchant deposits | Processor batch reports | Fees, refunds and chargebacks netted out of deposits |
| Loans and equipment notes | Lender statement | Interest posted as principal, or the reverse |
| Petty cash | Cash count plus receipts | Missing receipts, cash parts runs with no RO |
A few notes on the ones that are specific to shops:
- Core deposits. When you pay a core charge to a vendor, that money is coming back only if the core goes back and the vendor credits it. If your books track cores in their own account, its balance should equal the cores physically waiting to go back plus the ones in transit. If it keeps growing, cores are going back without credits, or not going back at all.
- Card merchant deposits. Card sales don’t land in the bank as one clean number. Square, for example, says plainly that its “processing fees are deducted before funds are transferred to your linked bank account.” Check the batch against your SMS payments and the deposit against the batch. The automotive POS post has the daily version.
- Sales tax payable. Right after you file and pay, this balance should be close to zero. If it isn’t, something got posted wrong months ago and is still sitting there.
For the bank, see the full bank reconciliation walkthrough. For vendors, the step-by-step is in vendor statement reconciliation. For the cash bag, there’s a log template and a worked example in the petty cash guide. For inventory, cycle counting vs a physical count covers which one fits your shop.
The account reconciliation process, in five steps
Every account on that list uses the same account reconciliation process. Only the outside record changes.
- Pick a date and pull the balance. Usually the last day of the month. Write down the general ledger balance.
- Get the outside record for the same date. Bank statement, vendor statement, loan statement, count sheet.
- List every difference. Don’t net them. Three $40 errors and a $120 error in the other direction look like zero, and they aren’t.
- Sort each difference. Timing (it will clear next month), an error in your books, an error in theirs, or something nobody can explain yet.
- Fix, document, sign. Post the correcting entries, attach the backup, and have someone other than the preparer sign it. Carry anything unexplained to next month by name, not as “misc.”
Do this for all nine accounts every month and you’ve done most of a month end close.
A balance that reconciles can still be wrong
Here’s the part that bothers me most. Reconciliation proves that two records agree. It doesn’t prove that either one is true.
Say your books show $8,412.50 owed to your main parts vendor at the end of October. The vendor’s statement says $8,412.50. Perfect match. Reconciled. You sign it and pay it.
Now look at what neither record shows. On October 11 your driver returned a $189.00 alternator that was the wrong pulley. On October 18 he returned a $95.00 core. Both went back on the truck. No credit memo came. Because your bookkeeper only enters credits when they arrive, your books never recorded them either.
| Your books | Vendor statement | What actually happened | |
|---|---|---|---|
| Balance owed | $8,412.50 | $8,412.50 | $8,128.50 |
| Difference | $284.00 overpaid |
(Illustrative numbers.) The account reconciled. You still paid $284.00 for parts that are sitting back on the vendor’s shelf. If that happens once a month, it’s $3,408 a year, from one vendor, on an account that “ties out” every single month.
That’s why I’ll keep saying it: accounting software doesn’t verify reality. QuickBooks records what someone entered. It has no idea a part went back on a truck, or that a part bought for RO 51877 never got billed to the customer. That’s an operations question, not an accounting one, and you only answer it by checking invoices, returns, credit memos and repair orders against each other.
Good operators ask one more question after the numbers tie
I’ve talked with hundreds of shop owners about their back office, and the ones who run tight shops share a habit. They don’t stop when the reconciliation balances. They ask uncomfortable questions anyway:
- Where did this part end up?
- Why didn’t this credit appear?
- Why doesn’t this invoice exist?
- Does this statement actually reconcile, or does it just match?
Average shops assume a matching number means a correct number. Great shops verify the paperwork behind it. For the AP account, that means one extra step after the statement ties: take the returns and cores list for the month and check each one for a credit memo. That’s fifteen minutes with a highlighter, and it’s the step that would have caught the $284.
Reconcile the balance, then reconcile the parts behind it
Most of this list doesn’t need software. A disciplined bookkeeper and a monthly calendar will handle the bank, the cards, sales tax, loans and petty cash just fine in QuickBooks.
The AP and inventory side is different, because the evidence lives in four places at once: vendor invoices, credit memos, the vendor statement and your repair orders. That’s the slice WickedFile was built for.
What it reads: vendor invoices, credit memos and statements; repair orders from your shop management system; QuickBooks Online; and bank and card transactions through Plaid.
What it flags for account reconciliation:
- Statement lines with no invoice behind them, and invoices that never made it onto the statement.
- Returns and cores with no credit memo, and credit memos the vendor issued but never applied.
- Parts bought for a repair order that never got sold on it.
- Bank or card charges to a vendor with no supporting invoice, and accounting entries with no source document.
How to spend the free trial (500 scanned pages, no credit card): take last month’s statement, invoices and credit memos from your two biggest parts vendors, connect your shop management system, and compare what WickedFile finds to what your last reconciliation said. If they agree, you’ve lost nothing but an afternoon.
What it doesn’t do: it doesn’t reconcile your bank accounts, sales tax, loans or merchant deposits. It isn’t a payment processor, it doesn’t replace your shop management system, and it doesn’t replace QuickBooks or your bookkeeper. After the trial, the Grow plan is $299 a month, flat.
Check your biggest vendor’s balance free →
Reconcile all nine accounts, every month, and then ask the uncomfortable question about the one that matched too easily. Your accountant will still call in March. This time it’ll just be to say hi.
