Skip to main content

Check the books against the bank

Each month, check that what the book says each account holds is what the bank says: find where they differ and why, put right what is wrong, record a balance no statement brings, and close the period once it agrees.

All how-tos

  1. 1

    Open the Reconciliation view

    In Finance, Reconciliation sits beside the ledger once the book has a bank, card or loan account. Its four figures count Accounts agreeing, Differing, Statements in review and Feeds needing attention; Accounts agreeing and Differing open the accounts they count. Bank, card and loan accounts are listed, a brokerage account once a balance is recorded for it; cash has no statement to check against, so it is not listed.

  2. 2

    Read the balance check by account

    Balance check by account lists each account with its status: Agrees, Differs, Other currency, or Not checked when no balance has been observed for it yet. Beside it are the Last observed balance, where it came from, and the book's balance on that day — Book now, while none has been observed. The Difference says whether the bank's balance is higher or lower than the book's; for a card or a loan, whether you owe more or less. Show accounts narrows the list to the Agreeing or the Differences. An account whose opening balance is not in the book yet, but can be worked out from a balance observed for it, shows that opening on its row — the balance, less the rows since — with Establish opening balance beside Record the bank's balance; nothing is posted until you choose it.

  3. 3

    Check a statement's balance

    A statement's review ends with its Balance check: type the Closing balance the statement shows for its last day — for a card or a loan, the Closing amount owed — and choose Check balance. A file that stated its own closing balance — an OFX file, a CSV with a balance column — has it filled in already. Every check becomes the account's last observed balance here.

    See also: Bank accounts, statements and receipts

  4. 4

    Find what explains a difference

    When the book and the statement differ, the Balance check says the Difference and, under On this statement, what may explain it: rows that still need you, rows ready to post, rows ignored and possible duplicates, each with its amount and Show them, which leads to those rows, days no statement covers, and entries in the book the bank had not cleared by the statement's day, with the day it did where it has since — a difference of timing that the next statement settles. Most differences are a row still waiting or one ignored by mistake.

  5. 5

    Record an adjustment for a real difference

    When what is left is real — a fee or interest no statement row carried — Record a balance adjustment… opens an entry on the statement's account, its last day and the difference, for you to name and categorize before you post it. Nothing is adjusted for you.

  6. 6

    Record a balance no statement brings

    An account no statement or bank feed reports — a loan read off the lender's site, a pension — is checked by hand. On its row, Record the bank's balance takes the Balance — for a card or a loan, the Amount owed — and the day it was On, and Record balance keeps it, shown as Recorded by hand. It is compared with the book like a statement's balance, and never posted.

  7. 7

    Create the period a statement needs

    A statement with a row dated where no accounting period is open cannot post that row. Open the statement from Inbox → Statement imports: its review page says so and, to a member who may change the book's setup, offers Create missing accounting period, with Starts on and Ends before (exclusive) filled in for the calendar year its dates need — change them if the book's year runs differently — and Create adds it; the rows then post as usual. Anyone else is told to ask such a member.

  8. 8

    Keep the data current

    Overview's Data health, and the last card of the Reconciliation view, say which accounts are behind: a bank feed that missed its sync, a consent ending, a last statement that ended more than 45 days ago, an account with neither statement nor feed — each line naming the account, with a way to put it right.

    See also: Connect a bank or an aggregator

  9. 9

    Close the period

    Once a month or a year agrees, close it. Under Settings → Books, Accounting periods lists the book's periods, open or closed; Close period, with a reason, stops anything being posted into it. Reopen period takes it back when something must be corrected, and both are kept on record. A category changed afterwards on an entry in a closed period is recorded beside it, never by editing it.