A bank balance that looks right in QuickBooks can still hide duplicate expenses, missing deposits, or transactions posted to the wrong account. Learning how to reconcile QuickBooks monthly gives you a reliable checkpoint: your accounting records match the financial activity that actually cleared the bank.
For a small business owner, reconciliation is not busywork at month-end. It is how you protect cash flow, make decisions from trustworthy reports, and avoid a rushed cleanup when taxes, financing, or a major purchase are on the horizon. The best process is consistent, documented, and completed before you begin relying on the prior month’s financial statements.
What monthly reconciliation actually confirms
Reconciliation compares the activity in QuickBooks to an outside record, usually a bank statement or credit card statement. Your goal is not to make the QuickBooks register balance match today’s online banking balance. Your goal is to verify that the beginning balance, transactions that cleared during the statement period, and ending balance agree with the statement.
A transaction can be recorded in QuickBooks but not yet appear on a statement. A customer payment may be received but not deposited until the following month. Those items are normal as long as they are valid, easy to explain, and eventually clear. Reconciliation separates legitimate timing differences from bookkeeping errors.
For many businesses, the monthly review should cover more than the main checking account. Reconcile each account that affects your balance sheet, including:
- Operating and savings bank accounts
- Business credit cards and lines of credit
- Loans with regular payments or activity
- Payment processor and merchant clearing accounts
- Payroll liability accounts
- Undeposited funds, when used for grouped customer payments
The exact list depends on how your business receives money and pays bills. A service business with one checking account may have a simpler process than a real estate operator managing security deposits, multiple properties, or separate entities. The principle remains the same: every material balance should be supported by a statement or another reliable record.
How to reconcile QuickBooks monthly in 7 steps
1. Set a regular close date
Choose a point soon after each month ends, ideally after all bank and credit card statements are available. Many owners use the first one to two weeks of the following month. Waiting until the next quarter makes errors harder to trace and reduces the value of your reports.
Create a simple recurring calendar task and protect the time. Before you start, make sure bank feeds have been reviewed, invoices and bills have been entered, payroll has posted, and you have the statements for the period. Bank feeds are useful, but they are not a substitute for reconciliation. They bring in transaction data; reconciliation confirms it is complete and accurately recorded.
2. Review transactions before opening the reconciliation screen
Start with a quick review of uncategorized, duplicate, and unusual transactions. Look for purchases made from a personal card, transfers recorded as income or expense, checks that were entered twice, and payments assigned to the wrong vendor or account.
This step saves time later. If your books contain an unexplained transaction, checking it off during reconciliation only makes the account appear correct while leaving the reporting problem unresolved. Categorize the activity based on what actually happened, and retain receipts or supporting documentation for material expenses.
3. Enter the statement information exactly
In QuickBooks Online, open the Reconcile section, select the account, and enter the statement ending date and ending balance. Confirm the beginning balance shown by QuickBooks agrees with the prior reconciled ending balance.
If the beginning balance does not match, stop and investigate before checking off new transactions. A changed or deleted transaction from a prior period is a common cause. Continuing without resolving it can compound the issue across several months.
QuickBooks Desktop follows a similar logic: select the account, enter the statement date and ending balance, then clear the transactions that appear on the statement. Screen labels may vary by version, but the accounting objective does not.
4. Match cleared deposits and payments one by one
Use the statement as your source document. Mark a transaction as cleared only when the date and amount agree with the statement. Pay close attention to deposits, transfer entries, electronic payments, and bank fees, since these are frequent sources of mismatch.
For a bank account, you are usually looking for deposits and payments. For a credit card account, you will verify charges, credits, and payments. Do not assume transactions cleared in the same order they were entered. Banks often process debit card purchases, ACH payments, and deposits on different schedules.
If a transaction is slightly different from the statement, investigate the reason rather than forcing a match. It may be a data-entry mistake, a fee that was not recorded, or a combined deposit that needs to be grouped correctly through Undeposited Funds.
5. Record legitimate bank-only items
Your statement may show activity that has not yet reached QuickBooks. Typical examples include monthly bank service charges, interest income, returned payments, and merchant processor fees. Add these items with the right date and account classification so the books reflect the full statement activity.
This is also a useful moment to review transfers. A transfer between two business accounts should generally be recorded as a transfer, not as income in one account and an expense in the other. Misclassified transfers can overstate revenue and expenses, which distorts the profit and loss statement and can create unnecessary questions at tax time.
6. Resolve differences without using a shortcut
A completed reconciliation should show a difference of zero. If it does not, work methodically. Start by checking the statement ending balance and date, then compare for a missed transaction, duplicate entry, transposed number, or item cleared in the wrong period.
Avoid creating a plug entry simply to force the reconciliation to finish. An adjustment may be appropriate in limited circumstances, but it should have a clear explanation, documentation, and the correct accounting treatment. A forced reconciliation can hide fraud, duplicate charges, or reporting errors that will surface later.
If the difference is divisible by nine, check for transposed digits. For example, an entry of $54 recorded as $45 creates a $9 difference. For larger or recurring differences, review the account register and reconciliation history for changes made after a prior month was closed.
7. Save the reconciliation report and close the month
When the difference reaches zero, complete the reconciliation and save the report with the bank or credit card statement. A clear digital filing system makes future reviews, tax preparation, and lender requests far easier. Keep the report, statement, and any notes explaining unusual items together.
Then review the financial reports that depend on those reconciled balances. At minimum, look at the profit and loss statement, balance sheet, and accounts receivable and accounts payable aging reports if you invoice customers or receive vendor bills. Your cash position should now reflect reality closely enough to support informed decisions.
Common issues that deserve extra attention
Some recurring QuickBooks problems are less about the reconciliation screen and more about the workflow behind it. Owner draws and personal expenses often create confusion in closely held businesses. These transactions should be handled according to the entity structure and the actual nature of the payment, not simply categorized to make the bank account reconcile.
Merchant processors also require care. If a customer pays $1,000 and the processor deposits $970 after fees, recording only the net deposit can understate both sales and expenses. The right approach depends on your setup, but the books should show the gross sale, the processing fee, and the net cash received when those amounts are material.
For real estate businesses, security deposits, owner contributions, escrow activity, and property-level transactions may need separate treatment. For startups, investor funds, shareholder loans, and software subscriptions can affect both financial reporting and tax planning. Cannabis businesses face additional compliance and recordkeeping considerations. In each case, accurate reconciliation creates the foundation for the specialized accounting decisions that follow.
Use reconciled books to make better decisions
Monthly reconciliation is most valuable when it becomes part of a broader financial rhythm. Once the accounts are accurate, you can compare actual results to your budget, identify customers who are slow to pay, watch gross margin changes, and plan for tax payments before cash becomes tight.
It also creates a cleaner handoff when you work with a bookkeeper, payroll provider, or CPA. Rather than spending advisory time sorting through old transactions, you can focus on questions that move the business forward: whether to hire, buy equipment, expand, change entity structure, or adjust estimated tax payments.
If reconciliation regularly takes hours, the answer is not always more effort. It may be a sign that your chart of accounts, payment workflow, bank-feed rules, or internal controls need attention. Elevate Business Consulting helps business owners build practical bookkeeping processes that keep their records current and their decisions grounded in reliable numbers.
A completed reconciliation is not just proof that last month is closed. It is a clearer view of the cash, obligations, and opportunities your business has right now.