Skip to content

Banking

Bank and cash accounts, statement import, reconciliation and bank rules.

11 guides About 44 minutes in total

  1. Set up bank and cash accounts Create a bank, cash, petty cash or wallet account, choose its currency and ledger account, and post its opening balance. 4 min read
  2. Import a bank statement Upload a CSV, OFX/QFX, MT940 or CAMT.053 file from your bank; duplicates are skipped automatically. 4 min read
  3. Map CSV columns and save the mapping Tell the system which CSV columns hold the date, amounts and text, and remember it for the next import. 4 min read
  4. Reconcile statement lines Match bank statement lines with entries in your books, accept suggestions, ignore noise and undo a match. 6 min read
  5. Book a statement line that is not in your books Post bank fees, interest or a customer receipt straight from the statement line and reconcile it in one step. 4 min read
  6. Reconciliation report and completing a period Compare the statement balance with your books, find the difference, and lock the period once it is zero. 5 min read
  7. Bank rules: book recurring lines automatically Create rules that recognise statement lines such as bank fees or rent and book them for you. 5 min read
  8. Block all bank and cash accounts as rule targets A company setting that stops bank rules from booking to any bank or cash account, so transfers are always entered by hand. 3 min read
  9. Transfers between your bank and cash accounts Record money moved between two of your own accounts, from a statement line, a rule or a journal entry. 3 min read
  10. Who can do what in Banking The permissions behind bank accounts, reconciliation, rules and the banking setting, and which roles have them. 2 min read
  11. Common banking errors and how to fix them What the import, reconciliation and booking messages mean and what to do about each one. 4 min read
Chat with AI