Skip to content
ColibriOSHelp CenterSign in
Search
TopicsGetting startedColibri, your AI helperYour websiteScheduling and bookingContacts and communityEmail and marketingShop and coursesPayments and moneyPlan, billing and settings
FAQOpen a support ticketSign in to ColibriOS

Import your bank statements

Upload a statement file from your bank so your transactions are ready to sort, match and report on.

Banking keeps your bank and card account activity in ColibriOS, so your reports and taxes add up. Download a statement from your bank’s website, upload it here, review it, and you’re done.

Add the account once

  1. Open Money > Banking.
  2. Under Accounts, press New.
  3. Give it a Name (like “Business checking”) and pick the Account type.
  4. Under Books, choose Business, or Personal for an account only you should see.
  5. Add the Institution, Last 4 of account and Opening balance if you like. Save it.

Upload a statement

  1. On your bank’s website, download a statement. The best formats are OFX / QFX (Quicken), QuickBooks (.QBO) or CSV.
  2. In ColibriOS, click the account’s name to open it.
  3. Press Upload statement, choose the file and press Upload.
  4. Look over the Review transactions list. Tick Skip on any row you don’t want, fix a date or amount if needed, pick a category or Business or Personal for a row, or press Flip all signs if money in and money out look backwards.
  5. Press the Commit button (it shows the number of rows, like Commit 42 rows) to bring them in.

Sort what came in

  • Pick a Category for each transaction. Your reports group spending this way.
  • Press Match confident to link transactions to the invoices and expenses they belong to. Or press Link on a single row.
  • Press Merchant rules on the Banking page so a shop or payee is sorted the same way every time.

Good to know

  • PDF statements are read on a best-effort basis and often need fixing by hand. A scanned PDF can’t be read at all. Use OFX, QFX, QBO or CSV when your bank offers it.
  • Statements that overlap are fine. Rows you’ve already imported are skipped.
  • Missed one? Press Add transaction to type it in.
  • Personal accounts and their transactions are only visible to the workspace owner. Business reports leave personal rows out.
  • Tired of downloading statements? Press Connect a bank account at the top of Banking to have transactions arrive on their own. Connecting a bank is part of ColibriOS Pro.
  • Transactions without a category still count in your Expenses report, under “Not categorised yet”. See Profit and other reports.