A business owner sees $24,890 in the bank account on the balance sheet, but the year-end bank statement shows $25,000. That difference needs an explanation before the records are ready for tax preparation. It does not necessarily mean the books are wrong: outstanding checks, deposits in transit, unrecorded activity, or a bank error can account for it.
This article is part of our guide to QuickBooks cleanup and bookkeeping controls.
The profit-and-loss statement reports income and expenses over a period; it does not report the bank cash balance. Start a reconciliation with the bank statement and the corresponding cash account in the general ledger, using the same account and cutoff date.
What a reconciliation establishes
A reconciliation compares recorded transactions with independent bank evidence and explains differences in the balances. IRS Publication 583 discusses reconciling a business checking account, including bank charges, deposits, uncleared checks, and errors in either the bank statement or the books.
A balanced reconciliation is an important control, but it does not prove that every transaction has the right income, expense, asset, liability, or owner classification. A $10,000 loan deposit posted as sales can match the bank perfectly while overstating revenue. Likewise, a personal purchase can clear the bank and still be an improper business deduction.
Review the supporting documents and the classification as well as the cash. IRS Publication 583 also explains that proof of payment alone does not establish entitlement to a deduction. An invoice, receipt, business purpose, and any additional required substantiation may be necessary.
A worked reconciliation with different starting balances
Assume the statement shows $25,000 and the unadjusted ledger cash balance is $24,890. The following items are documented for the same month-end:
- A $2,000 deposit was recorded and delivered to the bank before the cutoff but posted by the bank afterward.
- Checks totaling $3,500 were recorded and issued but had not cleared.
- The bank incorrectly charged $300 belonging to another account and confirmed that it will correct the error.
- The books omit $60 of bank interest and a $150 bank fee.
- A $1,000 loan receipt was accidentally posted twice to cash and loan payable.
| Bank side | Amount | Book side | Amount |
|---|---|---|---|
| Statement ending balance | $25,000 | Unadjusted ledger cash | $24,890 |
| Add deposit in transit | $2,000 | Add unrecorded interest | $60 |
| Subtract outstanding checks | ($3,500) | Subtract unrecorded bank fee | ($150) |
| Add confirmed erroneous bank charge | $300 | Remove duplicate loan receipt | ($1,000) |
| Adjusted bank balance | $23,800 | Adjusted book balance | $23,800 |
The valid deposit and outstanding checks already appear correctly in the books; recording them again would create duplicates. Track the bank’s $300 correction until it posts. Correct the book-side omissions and duplicate with documented entries. Removing the duplicate loan receipt debits loan payable and credits cash for $1,000; it does not reduce revenue because the duplicate was recorded as borrowing.
The adjusted balance is an accounting result, not a promise that all $23,800 is immediately spendable. Check restrictions, bank holds, pending corrections, and the timing of payments and collections separately when managing liquidity.
Find the cause before changing an entry
Beginning balances changed after a prior reconciliation
Compare the current beginning balance with the saved prior reconciliation. Look for transactions changed, deleted, moved to another bank account, or assigned a different date after the prior close. Preserve the earlier report and the software audit history so the reviewer can understand what changed.
Start with the last supported reconciliation and work forward. A forced entry to opening equity or miscellaneous expense can make the current screen balance while leaving the actual error unresolved. If the correction affects an already filed return, flag it for the tax preparer before deciding which period or filing procedure applies.
Bank-feed items are confused with posted transactions
A downloaded item awaiting review is not necessarily a second ledger entry. Distinguish three situations: an unposted duplicate download, a duplicate already posted to the books, and two real bank transactions with the same amount. Their corrections are different.
Before adding a downloaded receipt or payment, check whether the underlying transaction is already recorded and should be matched. Intuit’s reconciliation troubleshooting guidance addresses beginning balances, statement details, missing or duplicate records, and possible bank errors. Review the actual transaction rather than treating a matching amount and date as conclusive proof of duplication.
A posted duplicate deposit can overstate revenue, loan payable, owner equity, or another account depending on its coding. A missing withdrawal might represent an expense, equipment purchase, debt principal, or owner activity. Neither every deposit nor every withdrawal belongs on the profit-and-loss statement.
Outstanding items are left unexplained
Maintain a list showing each outstanding item’s date, payee or source, amount, and expected resolution. A valid timing difference can be large and can remain open for more than one period. It does not automatically clear in the next month.
For an old check, investigate whether it was delivered, lost, replaced, stopped, or paid under another reference. Avoid recording both an original and replacement as separate expenses. Confirm whether the underlying obligation still exists before voiding a check or recognizing income.
Old unpaid amounts may raise unclaimed-property questions. Florida’s general abandoned-property statute is a starting point, but the applicable jurisdiction, property category, dormancy rule, and reporting requirements need review. An uncleared check is not automatically money the business may keep.
Customer receipts are counted twice
A receipt can pass through undeposited funds or a payment-processor clearing account before reaching the bank. Trace it through the whole path. If a customer pays an invoice already recorded in accounts receivable, the collection reduces that receivable; it does not create the same sale again.
For example, three customer payments of $400, $350, and $250 total a $1,000 deposit. Match the bank deposit to the group instead of adding another $1,000 of revenue. If the processor deducts a $30 fee and sends $970, reconcile the gross receipts and fee to the net payout using its settlement report. Also account for refunds, reserves, and transactions still in transit when present.
Transfers and debt payments are misclassified
A $5,000 transfer between two accounts owned by the same business reduces one cash account and increases the other. It does not create $5,000 of sales or operating expense. Where funds move between different legal entities, determine whether the transaction is a loan, capital contribution, reimbursement, payment for services, or something else.
A loan payment must be split according to the lender’s records and the applicable accounting: principal reduces the liability, while interest and fees receive their appropriate treatment. Do not categorize the entire withdrawal as interest expense merely because it went to a lender.
Owner activity and other balances need separate review
Keep a supported schedule of owner contributions, distributions, loans, reimbursements, and personal costs paid through the business. The correct treatment depends on the facts and the business’s tax classification. A bank match does not establish shareholder basis, a deductible expense, or appropriate wage treatment.
Reconcile credit cards, loans, payment processors, payroll liabilities, sales-tax liabilities, and other significant accounts to their own records. For example, paying a credit-card balance reduces the card liability; it should not duplicate expenses already recorded from individual card charges.
A practical close process
- Set the cutoff. Identify each account and period, obtain complete statements, and retain the prior reconciliation and general ledger.
- Compare the activity. Match transactions to independent records, identify grouped deposits and settlement deductions, and confirm valid outstanding items.
- Resolve exceptions. Record the cause, supporting evidence, proposed treatment, affected periods, reviewer, and completion date for each correction.
- Review classifications. Check unusual deposits, withdrawals, owner activity, debt, assets, and clearing accounts even where bank amounts agree.
- Save the result. Retain the final reconciliation, statements, adjustment support, and remaining outstanding-item schedule. Review subsequent changes to closed periods.
Monthly reconciliation is a useful operating routine. Businesses with frequent activity or tight cash may also compare bank activity daily or weekly. Interim reconciliation can use reliable transaction and balance evidence through a stated date; the final statement then supports the formal period-end close. Waiting for a statement does not prevent earlier monitoring.
We cover Small Business Month-End Close in a companion article, “A Reliable Month-End Close Checklist for Small Businesses.”
Protect filing and payment deadlines during cleanup
Give the tax preparer an open-issues list early, including amounts, periods, and the records still missing. Reconciliation work does not suspend tax deadlines. Determine whether unresolved items prevent completing an accurate return, what further evidence is needed, and whether a timely extension is appropriate.
The Form 7004 instructions explain extensions for specified business returns and state that the form does not extend the time to pay tax. An individual reporting a business on their individual return uses the applicable individual extension procedure, described in the IRS extension guidance. Confirm the actual return, taxpayer, deadline, and any applicable relief rather than choosing an extension form from the LLC label alone.
Estimate and address tax due using the best supported information available, and continue resolving the records. An entity extension and an owner’s individual extension are separate matters when separate returns are required. An unexplained balancing adjustment should not substitute for that analysis.
Prepare a useful handoff and confirm scope
Send the preparer the statements and reconciliations, current trial balance and financial statements, relevant receivable and payable detail, asset and loan schedules, payroll and sales-tax reconciliations, owner-transaction support, prior tax adjustments, and the open-issues list. Explain which periods are complete and which remain under review.
CPA Firm South Florida’s published pricing includes bookkeeping cleanup needed for the quoted tax return. Ongoing bookkeeping and services outside that quoted return scope require separate arrangements. The condition of the records affects the preparation quote; a larger cleanup need is not by itself a reason to label work necessary for the quoted return an excluded add-on.
Provide the records before agreeing on the scope, identify any separate reconstruction or ongoing work, and confirm changes if additional needs emerge. Contact CPA Firm South Florida’s accounting and tax team with the account details and unresolved questions so the requested work can be defined.
Frequently asked questions
Must the bank statement and book balance show exactly the same number?
Their unadjusted balances can differ because of valid outstanding checks, deposits in transit, or errors requiring correction. The reconciliation should explain those differences and bring the adjusted bank and book balances into agreement.
Does a duplicate bank download automatically overstate income?
No. A duplicate waiting for review may not be posted to the ledger. If a duplicate has been posted, its effect depends on the accounts used: it could overstate revenue, a loan, an owner contribution, or another balance.
Can I reconcile before the monthly statement is available?
Yes. Interim comparisons can use reliable bank transaction and balance records through a stated date. Complete the formal period-end reconciliation when the statement is available, and investigate any differences between the interim and final records.
Should I postpone filing until every reconciliation question is resolved?
Do not ignore a filing or payment deadline. Give the preparer the unresolved items promptly and arrange the appropriate timely extension and tax payment when needed. An extension to file generally does not extend the time to pay.
Is reconciliation cleanup included in the firm’s tax-preparation fee?
CPA Firm South Florida’s published pricing includes bookkeeping cleanup needed for the quoted tax return. Ongoing bookkeeping and work outside that quoted return scope are separate services; clarify the boundaries in the engagement before work begins.