QuickBooks reconciliation · Monthly routine
Reconciling multiple accounts in QuickBooks, every month.
Reconciling the checking account is where most people stop — and where the trouble starts. Most businesses have to reconcile more than that every month: every bank account, every credit card, loans and lines of credit, merchant and payment-processor clearing accounts, the Undeposited Funds account, and PayPal-type balances. This page covers building that into a repeatable monthly routine — the checklist, the order, how it ties into the close, and the cadence that keeps small errors small. Independent firm, not affiliated with Intuit Inc.
Reconciling multiple accounts every month means matching every account that holds or moves money — not just checking — to its own statement or activity, on a consistent schedule. For most businesses that’s each bank account, each credit card, every loan and line of credit, the merchant and payment-processor clearing accounts, the Undeposited Funds account, and any PayPal-type balance. Done as a routine — one checklist, a sensible order, the same days each month — it’s the evidence step that makes the rest of the month-end close trustworthy. Reconciling only checking leaves errors hiding in the clearing accounts and cards, where they quietly distort the financial statements.
Reference maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not Intuit, and not Intuit’s official software support. Not affiliated with Intuit Inc.
Multi-account reconciliation, in five questions.
What does it mean to reconcile multiple accounts every month?
It means reconciling every account that holds or moves money — not just the main checking account. For most businesses that’s each bank account, each credit card, any loan or line of credit, merchant and payment-processor clearing accounts, the Undeposited Funds account, and any PayPal-type balance. Each one is matched to its own statement or activity for the month, on a consistent schedule.
Which accounts actually need reconciling each month?
More than people expect. Every bank account and every credit card should be reconciled to a statement. So should loans and lines of credit (to the lender’s balance and interest), merchant or payment-processor clearing accounts, the Undeposited Funds account, and PayPal, Stripe-style, or similar balances. If money flows through it, it gets reconciled — checking alone is not enough.
What order should I reconcile accounts in?
Work from the simplest, most active accounts to the trickiest. A common, accurate sequence: operating checking first, then any other bank accounts, then each credit card, then loans and lines of credit, and finally the merchant, processor, and Undeposited Funds clearing accounts — because those clearing accounts often surface the leftovers and timing differences the bank reconciliations didn’t.
How does multi-account reconciliation fit into month-end close?
Reconciliation is the evidence step of the close, not the whole close. The full month-end close also covers accruals, prepaids, payroll, depreciation, and reviewing the financial statements. Reconciling all the accounts is what makes the rest of the close trustworthy — you can’t rely on a balance sheet built on accounts that were never tied out.
Why do unreconciled clearing accounts cause problems?
Because clearing accounts — Undeposited Funds, merchant and processor holding accounts — are exactly where duplicate deposits, fees booked twice, and timing errors hide. A growing balance in one of them is usually a sign that income, fees, or transfers were recorded wrong. Reconcile them every month and the errors surface while they’re still small.
Why every account needs reconciling, not just checking.
Reconciliation is the monthly act of matching what your books say against what an outside record — a bank statement, a card statement, a lender’s balance, a processor’s report — says actually happened. Reconcile the operating checking account and you’ve verified one slice of the business. The problem is that money rarely lives in just one place: it sits on credit cards, against loans and lines of credit, and inside the clearing accounts that payment processors and QuickBooks use to hold funds in transit. Every one of those is an account whose balance ends up on your financial statements — and every one that goes unreconciled is a balance nobody has verified.
That’s why “is the bank reconciled?” is the wrong question on its own. A card with duplicate charges, a loan whose interest was never split from principal, or an Undeposited Funds account quietly double-counting income will leave the books looking balanced while the numbers are wrong. The fix isn’t more effort on checking — it’s widening the net to every account that holds or moves money, and reconciling them all on the same monthly rhythm. What reconciling can’t fix on its own is a backlog: months that never tied, or accounts never reconciled at all. That part is a file review and a cleanup before the routine can carry the books forward.
The accounts most businesses must reconcile.
More than the checking account — each of these carries a balance that lands on your financial statements, so each one belongs on the monthly reconciliation checklist.
Bank accounts · Every bank account, not just checking
Operating checking is the obvious one, but savings, payroll, tax, and any secondary or escrow account each carry their own balance and their own statement. An account that never gets reconciled quietly drifts — an uncashed check, a bank fee, or a transfer recorded once instead of twice — until the balance sheet stops reflecting reality.
Credit cards · Every credit card and store card
Each card is reconciled to its monthly statement the same way a bank account is. Cards are where duplicate charges, missed fees and interest, and personal-versus-business mixups concentrate — and an unreconciled card balance flows straight into overstated or understated expenses.
Loans & lines of credit · Loans, lines of credit, and notes
Term loans, lines of credit, vehicle and equipment notes carry a balance that should tie to the lender’s statement each month, with interest split from principal correctly. Skip these and the liabilities on the balance sheet — and the interest expense on the P&L — both go wrong.
Clearing accounts · Merchant, processor, and clearing accounts
Payment processors and merchant services route money through holding or clearing accounts before it lands in the bank. Reconciling these against the processor’s reports is how you catch fees booked twice, deposits that never cleared, and refunds recorded against the wrong sale.
Undeposited Funds · Undeposited Funds (the silent one)
Undeposited Funds is a clearing account QuickBooks uses to hold received payments until they’re grouped into a deposit. If it isn’t worked every month it balloons with payments that were already deposited — double-counted income that inflates revenue and never ties to the bank.
Digital balances · PayPal, Stripe-style, and digital balances
PayPal, Stripe, Square, and similar accounts hold a real balance with their own fees, refunds, and transfer timing. Each behaves like a hybrid bank-and-clearing account and needs reconciling to its own activity — otherwise the fees and the held balance never reconcile to anything.
How to run a multi-account monthly reconciliation routine.
Six steps, in order, the same way every month. Build the checklist once, then work it from the simplest accounts to the trickiest — and finish on the clearing accounts, where the leftovers hide.
Build one reconciliation checklist of every account
Before the first close, list every account that holds or moves money — each bank account, each credit card, every loan and line of credit, the merchant and processor clearing accounts, Undeposited Funds, and any PayPal-type balance. That single checklist is the routine: nothing on it is “done” for the month until it’s reconciled.
Gather the statements and reports for the period
Pull the month’s statement or activity report for every account on the checklist — bank and card statements, lender statements, and the processor and PayPal-type reports. Reconciling against the source document, not a memory of it, is what keeps the routine honest.
Reconcile bank and credit-card accounts first
Start with operating checking, then the other bank accounts, then each credit card — matching every transaction to the statement and confirming the ending balance ties exactly. These are the highest-volume accounts, and clearing them first makes the trickier accounts easier to read.
Reconcile loans, lines of credit, and notes
Tie each loan and line of credit to the lender’s balance for the month, confirming that interest and principal were split correctly. A clean liability balance here is what lets the balance sheet and the interest expense both be trusted.
Reconcile the clearing accounts last — and to zero where they should
Finish with the merchant, processor, and Undeposited Funds clearing accounts. These should clear toward zero (or a known in-transit amount) each month; a balance that keeps growing is the routine telling you income, fees, or transfers were booked wrong — investigate before you close.
Tie it into close and keep the cadence
Once every account is reconciled, the rest of the month-end close — accruals, review of the statements — rests on solid ground. Then do it again, same checklist, same days each month. The consistency is what keeps small errors small instead of compounding into a cleanup.
Accounts unreconciled, or a clearing balance climbing?
A Certified ProAdvisor reviews the file free, clears the backlog, then sets up the monthly routine — a focused diagnostic is typically a $1,200–$3,000 fixed-fee scope; cleanup runs $1,500–$15,000+ if the books are behind. Independent firm.
When to bring in a ProAdvisor.
Only checking ever gets reconciled
If checking is reconciled but the cards, loans, processor accounts, and Undeposited Funds are not, the books look balanced while errors accumulate everywhere else. That gap is exactly what a ProAdvisor sets up a proper multi-account routine to close.
A clearing account keeps growing
An Undeposited Funds or merchant-clearing balance that climbs month after month is double-counted income or mis-booked fees piling up. The longer it runs unreconciled, the more it distorts revenue — that’s cleanup work, not a quick fix.
Reconciliation no longer ties — or never started
When prior months won’t reconcile, balances don’t match the statements, or the accounts have never been reconciled at all, a routine alone can’t fix the backlog. That’s a file review and a focused diagnostic or cleanup first, then the cadence going forward.
A Certified ProAdvisor sets up the routine and clears the backlog.
Reconciling one account is mechanical. Running a clean multi-account routine month after month — and untangling the backlog when several accounts have never tied — is the work that actually restores trust in the numbers: building the checklist of every account, reconciling each to its statement in the right order, clearing the merchant and Undeposited Funds accounts toward zero, and splitting loan interest from principal so the balance sheet and the P&L are both right. A Certified QuickBooks ProAdvisor with active Online and Desktop certifications does that against a written scope, then keeps the cadence so the close always rests on reconciled accounts. Independent firm — not Intuit, and not Intuit’s software support; an Intuit account, login, or billing matter stays with Intuit.
Free
file review first — we look before we scope
$1,200–$3,000
typical fixed-fee diagnostic for a focused reconciliation fix
Independent
Certified ProAdvisor firm — not Intuit, not Intuit’s software support
What people ask about reconciling multiple accounts.
Is this Intuit’s official QuickBooks support?
Do I really need to reconcile more than my checking account?
What order should I reconcile accounts in?
Why does an unreconciled clearing account hide errors?
How is this different from the month-end close?
How is this different from reconciling a single account?
How often should I reconcile, and does it matter if I’m behind?
Can a ProAdvisor set up and run this routine for me?
Only checking gets reconciled, or a clearing account keeps growing?
Get the file reviewed, then run the routine right.
If the cards, loans, processor accounts, and Undeposited Funds never get reconciled — or a clearing balance keeps climbing — the financial statements are drifting whether the books look balanced or not. Start with a free file review; from there a focused diagnostic is typically a $1,200–$3,000 fixed-fee scope, and a full cleanup runs $1,500–$15,000+ when the books are behind. Independent ProAdvisor firm, written scope before any work begins.