Bank & Card Reconciliation
The books matched to the official bank and credit-card statements every month, with unexplained differences investigated instead of carried forward.
Why it matters
A bank feed can import transactions into QuickBooks. That doesn’t, by itself, prove the account is right. Reconciliation is the separate step of comparing the accounting records with the official bank or credit-card statement for the same period and resolving the difference — every month, not once a year.
Missing transactions
A bank fee, interest charge, check, deposit, refund, transfer, or card transaction can appear on the statement without a matching entry in the books. Reconciliation surfaces those omissions because the statement can’t balance until the missing activity is addressed.
Duplicate entries
A bank-feed item can get added even though the same transaction was already entered manually or imported elsewhere — distorting both the account balance and expense or income totals.
Transfers and card payments recorded as expenses
Moving money between two business accounts isn’t spending it, and paying a business credit-card balance isn’t a second expense if the underlying purchases were already recorded. Reconciliation catches cases where transfers or payments got miscategorized instead of matched to the corresponding activity.
Old uncleared transactions
A check or payment can stay uncleared for a legitimate reason, but an item sitting for months deserves review — it may have been voided, duplicated, or entered with the wrong date or amount.
Beginning-balance changes
If a previously reconciled transaction is later edited, deleted, or moved, the next reconciliation can start from a balance that no longer matches the prior statement — a historical change that needs to be found and corrected before the current month can close cleanly.
What reconciliation actually checks
For each statement period, the account’s beginning balance, statement ending date, ending balance, and cleared transactions are compared with the accounting file. Deposits, withdrawals, checks, ACH transactions, transfers, credit-card charges, card payments, fees, interest, refunds, and other statement activity are matched to what’s recorded in the books.
In QuickBooks Online, a completed reconciliation normally reaches a difference of $0.00 — meaning the transactions selected as cleared agree with the statement balance for that period.
Bank feeds are useful. They’re not the final control.
Connected bank and credit-card feeds save a lot of data entry — suggesting matches, downloading transactions, speeding up categorization. But the feed is still a flow of transaction data. The monthly statement is the period-end record used to confirm the books contain the activity that actually cleared.
That distinction matters because an imported transaction can be duplicated, categorized incorrectly, matched to the wrong entry, or omitted entirely. Reconciliation is the check that asks whether the accounting balance and statement balance actually agree.
Credit cards need reconciliation too
Credit-card accounts are liabilities, but the logic is similar: charges, payments, credits, refunds, fees, and the statement ending balance should agree with the card statement. Reconciling the card account also helps prevent a common error — treating the monthly credit-card payment as another expense after the individual purchases were already categorized.
When the books haven’t been reconciled in months
An account that’s several months behind usually can’t be fixed reliably by reconciling only the newest statement — older periods affect the beginning balance of every month that follows. The practical approach is to identify the oldest unreconciled period, resolve the beginning balance and statement activity there, and work forward month by month. If the file also has duplicate transactions, incorrect opening balances, or broken transfers, a broader bookkeeping cleanup may be needed first.
What reconciliation does not prove
A reconciled account agrees with the official statement for the period — an important control, but not an audit opinion, tax certification, or fraud examination. A transaction can clear the bank for the correct amount and still be assigned to the wrong expense category, a loan payment can be reconciled while the principal and interest are classified incorrectly, and a deposit can match the statement while the underlying revenue treatment still needs review.
That’s why reconciliation belongs inside a broader bookkeeping process that also includes transaction review, categorization, and monthly financial reporting, as part of a recurring monthly close.
QuickBooks Online and NetSuite reconciliation
Balanced On Time Books works in QuickBooks Online and NetSuite. In QuickBooks Online, reconciliation compares the recorded transactions with the official statement and works toward a zero difference for the period. Connected feeds can assist with transaction entry and matching, but the account still needs to be reviewed against the statement. If the accounting file has historical reconciliation problems, we may need prior statements and supporting records before the current month can be closed correctly.
The same idea applies in NetSuite, where account balances, cleared transactions, and statement activity are compared inside the platform’s own reconciliation tools rather than tracked separately in a spreadsheet.
Part of a consistent monthly close
For ongoing bookkeeping clients, bank and card reconciliation is part of the monthly close rather than a once-a-year cleanup. The standard is to close the books by the 10th each month, assuming the necessary statements, access, and answers are available. After the accounts are reconciled and the remaining bookkeeping work is complete, the monthly reporting can be prepared from a file that agrees with the actual financial accounts.
Cincinnati, New York City, and remote reconciliation
Balanced On Time Books is based in Cincinnati and building a presence in New York City, and reconciliation is naturally suited to remote work — bank and card statements can be reviewed and matched to the books through QuickBooks Online or NetSuite without an in-person visit, whether the business is in either city or somewhere else.
Need old accounts caught up?
If the last clean reconciliation was several months or years ago, tell us that up front. We can scope the historical work separately and determine whether the account needs catch-up reconciliation, broader bookkeeping cleanup, or both before ongoing monthly service begins.
Tell us what accounting software you use, how many bank and credit-card accounts the business has, and how current the books are. We’ll call to talk through the work, usually within about 30 minutes during the stated callback window.
Reconciling loans, lines of credit, and payment processor accounts
Reconciliation isn’t limited to checking, savings, and credit card accounts. Loans and lines of credit get reconciled too, tying the balance in QuickBooks Online or NetSuite to the lender’s monthly statement so principal and interest are recorded correctly and the loan balance on the books matches what the bank shows. A mismatch beyond the expected running interest usually points to a payment recorded wrong, a missed transaction, or a fee that hadn’t yet been entered.
Businesses using Stripe, Square, PayPal, or a similar processor often run transactions through a clearing account before the money lands in the regular bank account, since the processor deposit rarely equals the sales total. That clearing account holds the difference — fees withheld by the processor, deposits that lag by a day or two, refunds pulled back out — until it’s tied out. Reconciling it means confirming that what the processor reports as processed and what eventually deposits to the bank are both accounted for, rather than left sitting as an unexplained balance.
These accounts follow the same reconciliation schedule as bank and credit card accounts, get worked as part of the monthly close, and show up in that month’s overall reporting — nothing is reconciled or reported outside the regular cycle.
Reconciliation questions
Is a connected bank feed the same thing as reconciliation?
No. A bank feed imports transactions into QuickBooks or NetSuite, but reconciliation is the separate step of matching that activity against the official statement and resolving any difference — the feed is a data source, not a control.
How often do you reconcile accounts?
Monthly, as part of the recurring close — not daily or continuous. Bank and credit-card accounts get matched to their statements on the same schedule every month.
Can reconciliation catch fraud or theft?
It can surface discrepancies worth investigating, but it isn’t a fraud examination. A reconciled account confirms agreement with the statement, not the absence of wrongdoing elsewhere in the file.
What if several accounts haven’t been reconciled in years?
The oldest unreconciled period usually needs to be resolved first, then the account gets worked forward month by month. If the file also has broader problems, a cleanup may need to happen alongside it.
Does a completed reconciliation mean every transaction is categorized correctly?
No. Reconciliation confirms the account agrees with the statement — it doesn’t independently verify that every category, tax treatment, or financial-statement classification is correct. That review happens as part of the broader monthly close.
How are discrepancies reported once you find one?
When a reconciliation doesn’t match, the specific transactions causing the difference get noted — a missing deposit, a duplicate entry, an amount recorded incorrectly — and communicated directly rather than buried in an unexplained adjustment. Corrections are made in the file and flagged as part of that month’s close.
Can you reconcile multiple bank accounts for one business?
Yes. Each account — checking, savings, credit cards, loans, and processor clearing accounts — is reconciled separately against its own statement, and the results roll up together into the monthly close for the business as a whole.
What happens if a discrepancy can’t be resolved with the records available?
Occasionally a difference can’t be traced back with what’s on hand, usually because of a missing statement, a bank error, or a transaction from before records were provided. When that happens, the unresolved amount is documented clearly rather than guessed at, and it’s flagged directly for the client’s attention.
Want this handled for your business?
Fill out a few details for a personal callback, usually within 30 minutes.