Register with a running balance
Enter the opening balance and one transaction per line, with a description followed by a signed amount: + for deposits and − for checks, card payments, withdrawals and fees. Each line adds to the balance in order: balance = previous balance + amount. The table shows debits, credits and the running balance and downloads as CSV.
Example: opening 1,000.00, then +2,400.00, −1,200.00, −86.45, −60.00 and +25.10 ends at 2,078.65.
Reconciling with a bank statement
Adjusted bank balance = statement ending balance + deposits in transit − outstanding checks. Adjusted register balance = register balance − bank fees not yet recorded + interest not yet recorded. When the two agree, the account is reconciled.
Example: statement 2,150.00 + 300.00 in transit − (120.50 + 42.10) outstanding = 2,287.40. Register 2,295.40 − 8.00 fee = 2,287.40, so the difference is zero.
Finding a difference
If the balances do not match, look for a transaction missing from one side, a deposit recorded twice, or two transposed digits. A difference that divides evenly by 9 often points to a transposition, such as 45.20 entered as 54.20.