Ledger Notes

Practical notes on getting bank data into your books without surprises: which file to import, how to check it first, and how to spot what's missing.

• How to check a bank export before you import it

  Three checks that catch most bad imports in a couple of minutes, using numbers already on the statement.

• CSV, OFX or QBO: which bank file should you import?

  What each format carries, what QuickBooks and Xero expect, and where each one goes wrong.

• How to find missing bank statements before year-end

  A simple way to prove a year of statements is complete, and what a gap usually means.