How do I reconcile a bank account I track by hand?

Compare your hand-kept ledger with a bank statement at the same closing date, then match every deposit and withdrawal. A reconciliation is complete only when the adjusted statement balance equals the corrected ledger balance and every difference has an explanation. Keep payments and deposits that have not posted on an outstanding-items list rather than deleting them. Correct recording errors from evidence, not with an unexplained balancing entry.

Reconciliation compares two records at one cutoff date

Bank reconciliation checks whether your records of an account agree with the bank's records after you explain differences in timing and fix errors. Your ledger records account activity as you enter it. The statement records the activity the bank posted during its stated period.

Use the statement's closing balance, not today's balance or a number that includes a different set of transactions. A payment that posts after the statement closes belongs outside that statement period, even if you can already see it in online banking. Later activity can help explain a difference without changing the earlier cutoff.

Reconciliation is not a comparison between a spending plan and cash on hand. Include every movement through the account, including transfers between your own accounts, because each one changes this account's balance. For the separate planning question, see why your budget never matches your bank balance.

A worksheet needs the statement period, both opening balances, both closing balances, matched transactions, outstanding items, corrections, and a completion date. Keep the bank statement and supporting receipts with that record.

Match the opening balance and every movement before adjusting anything

Work from individual transactions toward the closing balance, rather than starting with the difference and guessing what caused it. A spreadsheet or paper ledger works as long as each entry has a date, description, amount, and matching status.

1. Fix the cutoff date. Save the statement and use only ledger activity through its closing date. Keep later transactions visible separately so a payment made next month cannot accidentally explain this month's balance.
2. Verify the opening balances. Match the statement opening to the previous statement closing, and your ledger opening to the previous corrected ledger closing. Earlier outstanding items should explain any difference between those openings. If they do not, resolve the earlier discrepancy first.
3. Match deposits one by one. Compare amounts, descriptions, and references. Dates may differ because your entry date and the bank's posting date need not be identical. A promised payment is not a deposit; retain evidence that money was actually received or deposited.
4. Match withdrawals one by one. Check payments, purchases, cash withdrawals, and transfers. Mark one ledger entry against one statement entry unless supporting records show that a bank entry combines several items. Do not match solely by amount when several transactions share that amount.
5. Classify every unmatched item. A ledger payment absent from the statement may be outstanding, duplicated, or incorrect. A statement fee absent from the ledger may be an omission. Check receipts, check numbers, deposit confirmations, and later bank activity before deciding.
6. Make supported corrections and test the totals. Add omitted entries, remove genuine duplicates, and correct wrong amounts. Record what changed and why, then compare the corrected ledger with the statement adjusted for verified timing differences.

An outstanding check is a check you issued that has not cleared the account. It remains a commitment even though the statement balance still contains the money. A deposit recorded in your ledger but not yet posted needs similar tracking on the deposit side.

Timing differences belong on the reconciliation worksheet; recording errors require a ledger correction. A suspected bank error stays identified as unresolved while you ask the bank to investigate.

A $210 difference resolves into timing items and two recording errors

Suppose you reconcile May 31. Both records start May at $2,400, with no outstanding items carried from April. You match $3,200 of deposits and $3,050 of withdrawals, including one genuine $80 purchase.

The statement also contains a $20 account fee you missed. Your ledger contains a $300 deposit made May 31 that has not posted, a $450 check issued May 29 that has not cleared, and a second entry for the same $80 purchase.

A zero means that record has no entry for the item at the cutoff. The statement closes at $2,400 + $3,200 − $3,050 − $20 = $2,530. The uncorrected ledger closes at $2,400 + $3,200 − $3,050 + $300 − $450 − $80 = $2,320.

The raw difference is $210, but neither adding $210 to the ledger nor subtracting it from the statement explains anything. Check the underlying items instead. In this example, later bank activity confirms that the $300 deposit posts June 2 and the $450 check clears June 3.

The statement-side calculation is $2,530 + $300 − $450 = $2,380. The corrected ledger is $2,320 − $20 + $80 = $2,380. Both sides now agree, and every adjustment has evidence.

The $300 deposit and $450 check are legitimate timing differences. They stay in the ledger and on the outstanding-items list. The missing fee and duplicate purchase are recording errors, so you correct the ledger itself.

The bank's actual May statement still closes at $2,530. The $2,380 figure is the reconciled ledger balance after accounting for activity you recorded that had not yet posted; it does not rewrite the statement or establish how much cash the bank makes available today.

Carry outstanding items forward until they clear

Each reconciliation should leave a short list of unresolved timing items with an amount, original date, reference, and last checked date. Carry the list forward, not a second copy of each transaction. When the bank later posts an item, match it to the existing ledger entry.

In the example, the June 2 deposit and June 3 check match May's existing entries. Do not add another $300 receipt or another $450 payment to the ledger when they appear on June's statement. Remove them from the outstanding list after matching them.

Review older items instead of leaving them outstanding indefinitely. Confirm whether a deposit was accepted, whether a payment reached its recipient, or whether a transaction was reversed. Do not assume an uncleared check is canceled or that its money is free to spend merely because time has passed.

A reconciled balance is a dated result, not a current spending allowance. Later activity, outstanding commitments, and money reserved for bills still matter when deciding what you can use.

An unexplained balancing entry hides the cause

A balancing entry changes the ledger solely to make its total equal another number. Agreement created by an unexplained adjustment is not reconciliation. It can conceal a missing payment, duplicate receipt, wrong opening balance, or transaction from the wrong period.

In the example, adding $210 to the ledger produces the statement's $2,530, but leaves both recording errors untouched and ignores the timing differences. Next month's matching becomes harder because the ledger now contains money with no source.

If the difference remains, leave the worksheet marked incomplete and write down the amount still unexplained. Recheck opening balances, arithmetic, signs, dates, and unmatched entries. An identified correction has a source and a reason; an unexplained adjustment has only a desired result.

Common mistakes

• Comparing different dates. A May 31 ledger cannot be checked directly against a bank balance that includes June activity.
• Skipping the opening balance. An earlier error carries through every later total even when this month's entries are correct.
• Leaving out internal transfers. A transfer may not be spending, but it still changes the account being reconciled.
• Deleting uncleared payments. Keep genuine outstanding payments in the ledger and reserve the money until their status is resolved.
• Recording cleared items twice. Match later postings to existing entries rather than entering the same payment again.
• Stopping when the totals match. Equal totals can conceal offsetting errors, so finish matching the individual transactions too.

Common questions

How often should I reconcile a manually tracked account? Reconcile each statement when it becomes available, and check more frequently if the account has heavy activity or little room for a mistake. Update the ledger between reconciliations so the statement review is a check rather than a reconstruction of everything you did.

What if my opening balance is wrong? Trace it back to the last verified reconciliation and identify the missing or incorrect activity. If you are starting a new ledger, document a verified opening date and balance, including any outstanding items at that date. Do not disguise an unknown historical difference as a current deposit or withdrawal.

Should I delete a check that has not cleared? No, not merely because it is absent from the statement. Keep it outstanding while you verify its status with the recipient and bank. Change the ledger only when you have evidence explaining what happened to the payment.

What if the ending balances match but a transaction is missing? Keep investigating. A missing withdrawal and a missing deposit of the same amount can cancel each other numerically while leaving the records wrong. Reconciliation requires transaction matching as well as an explained closing balance.

What if I think the bank made an error? Keep the statement entry, receipt, and your explanation together, and contact the bank to resolve the discrepancy. Mark it unresolved rather than treating a hoped-for correction as money already returned. Update the worksheet when you have confirmation of the outcome.

How Zypper handles this

After completing the reconciliation, you can enter the corrected ledger balance into a Zypper manual account and update it yourself as activity changes. Manual accounts have no live feed, appear alongside connected accounts, and count toward net worth; you choose whether to include one in your budget. Keep the dated reconciliation worksheet, transaction corrections, and outstanding-items list separately from that balance update. See Manual accounts for the setup, or get started with Zypper to keep a manually maintained balance alongside your other accounts.