Bank Reconciliation Trail for Freelance Books
A bank reconciliation is not a formality you complete to make a number match. It is the checkpoint where your business checking account, your book summary, and your supporting documents either agree or reveal a gap you can investigate. Force the balance to agree with a plug entry and you have hidden the gap rather than explained it, breaking the trail from bank line to book entry to receipt.
The practical answer is a month-end worksheet with four parts: the ending bank balance, items the bank has not yet recorded, items your books have not yet recorded, and an adjusted balance both sides must reach independently. This is US federal recordkeeping education as of the source-check date, 2026-09-28. It is not a ruling on whether any expense is deductible, and it does not address state rules or your individual tax treatment, which require separate review. Treatment questions belong with a CPA.
What the IRS actually requires of your books
The IRS recordkeeping guidance is permissive about the shape of your system and firm about its function. You may choose any recordkeeping system suited to your business that clearly shows your income and expenses, and that system should include a summary of your business transactions, ordinarily kept in your business books (IRS: what records to keep). The same page notes that for most small businesses the business checking account is the main source for entries in the business books, and that supporting documents such as sales slips, paid bills, invoices, receipts, deposit slips, and canceled checks contain the information you record in those books and support the entries on your tax return.
That framing tells you what a reconciliation is for. The bank statement is evidence that money moved. The book summary is your organized record of what those movements were for. The supporting documents let you explain each line. Reconciliation keeps those three layers connected month after month instead of forcing a year-end reconstruction. The guidance also states that all requirements applying to hard copy books and records also apply to electronic records, so a spreadsheet reconciliation is not a lighter-weight version of the task. Publication 583 illustrates a recordkeeping system that includes a bank reconciliation among its mechanics, alongside a check disbursements journal and an annual summary (IRS Publication 583). Those are illustrations of mechanics, not a prescribed chart of accounts, so the labels below are proposed worksheet choices rather than IRS categories.
Reading the inserted payment-and-refund table
The table inserted after this section is a payment-and-refund illustration, not a reconciliation. It shows one event: a payment of 3,200 USD recorded as transaction T-001, with the receipt and the bank entry both linked to T-001 as evidence of a single transaction. A partial refund of 275 USD is recorded as its own transaction, T-002, with its own evidence. Net cash movement is 2,925 USD, and the table states plainly that tax treatment is not determined.
Read the arithmetic as a movement summary, not a deductible total. The positive-magnitude form is 3,200 minus 275 equals 2,925. Under an outflow-positive signed convention the same entries would be +3,200 and −275; under an inflow-positive convention both signs reverse. State your convention once and apply it consistently.
The reconciliation case below is a separate, explicitly hypothetical case with its own inputs. In the table, 3,200 is a payment and 275 is a refund. In the reconciliation case, 3,475 is the bank statement balance and 275 is an outstanding check. Do not carry the table's labels into the reconciliation case, or the reconciliation case's labels back into the table.
Building the month-end worksheet
A workable reconciliation has two columns that must arrive at the same adjusted figure by different routes. The bank side starts with the ending balance on the statement, adds deposits in transit, and subtracts outstanding checks and any bank errors you have identified. The book side starts with your book balance, adds interest and collections the bank recorded but you have not, and subtracts bank fees, non-sufficient-funds charges, and any book errors.
Use stable transaction IDs for every item. An outstanding check keeps the ID it had when you wrote it; you do not renumber it because it cleared in a later month. When a deposit in transit finally posts, you link the bank line to the existing deposit ID rather than creating a new receipt. This is what makes the trail auditable across months instead of only within one statement period.
Keep three separate fields for each reconciling item: the ID, the amount, and the evidence reference — a check number, a deposit slip, a bank confirmation, or a scanned filename. Every reconciling item should be explainable by pointing at something, not by asserting a number. Do not type the adjusted balance as a number. Compute it as a formula on both sides. If the two formulas disagree, you have a difference to investigate, and the worksheet should show that difference rather than absorb it.
Working the hypothetical case end to end
Take the stated inputs. The bank statement ending balance is 3,475 USD. One check for 275 USD has been written and recorded in your books but has not yet cleared the bank, so it is an outstanding check. Your book balance is 3,200 USD. There are no deposits in transit, no bank fees, and no errors on either side in this simplified case.
The bank side begins at 3,475 USD and subtracts the 275 USD outstanding check, reaching 3,200 USD. The book side begins at 3,200 USD; because the check was already recorded in the books, no further subtraction is made there, and the book side stays at 3,200 USD. Both sides land on 3,200 USD. If they do not, the difference is the item to investigate. Deducting the outstanding check on the book side as well would double-count it, because the 3,200 USD book balance already reflects the check you wrote.
Notice what 3,200 USD does and does not mean. It is an adjusted cash figure for reconciliation purposes — not profit, not taxable income, not a deductible total. The 3,200 USD book balance is not automatically income, and the 275 USD check is not automatically a deduction. Whether either belongs on a return depends on the underlying transactions, your accounting method, and your situation. Those are treatment questions for a CPA. If the check later clears for a different amount than 275 USD, do not edit the original entry. Record the difference as its own item with its own ID and evidence, and let the reconciliation show both the original and the adjustment.
Failure modes that break the trail
The most common failure is the plug entry. When the two sides do not agree, a bookkeeper posts a miscellaneous adjustment for the difference and moves on. The reconciliation appears to close, but the underlying gap — a missing receipt, a duplicated deposit, a transposed digit — is still there and will resurface. A plug entry converts a visible problem into an invisible one.
The second failure is overwriting the original record. If a deposit was recorded at one amount and the bank shows another, do not edit the original deposit to match the bank. Keep the original, record the correction as its own item, and link the evidence. Overwriting destroys the audit trail the IRS guidance expects your books to provide.
The third failure is treating the bank statement as the book of record. The statement shows that money moved; it does not show what the money was for. A bank line described only as a card purchase tells you nothing about whether it was a business expense, a personal withdrawal, or a duplicate. That description has to come from your supporting documents. Reconcile monthly rather than only at year end, and if you have fallen behind, work forward from the oldest unreconciled month rather than starting with the most recent one.
Where the reconciliation ends and tax treatment begins
A clean reconciliation tells you that your books and your bank agree and that every reconciling item is explained. It does not tell you which items are deductible, when income is recognized, or how a refund or returned payment should be treated on a return. Those determinations depend on facts the reconciliation does not contain, so keep the reconciliation separate from a profit-and-loss review: a month can reconcile perfectly and still show a loss.
If you are unsure how a particular reconciled item should be treated, or whether a prior filing needs attention, take the question to a CPA who can see your full situation. State rules and your individual tax treatment require separate review, and nothing in a reconciliation worksheet resolves them. The disclaimer page sets out the limits of this material, and the tax guides index covers related recordkeeping topics in more depth. Keep the completed monthly worksheet with its reconciling items and evidence references; it is part of the summary of your business transactions and is what lets you answer a question about a specific month long after the statement has been filed away.
Sources and method
- IRS: what records to keep — retrieved 2026-09-28
- IRS Publication 583: starting a business and keeping records — retrieved 2026-09-28
AI-assisted writing with automated source, calculation and editorial checks. No hands-on testing or professional certification is claimed. Check the stated assumptions before applying this guide.