Download a bank statement template that matches Kumry’s statement import, and use the setup guides to bring across your chart of accounts and opening balances.
Use this to load bank transactions, including history from before you started with Kumry. Kumry's statement import also reads OFX and QIF files straight from your bank.
When you upload a file, Kumry shows a preview and lets you confirm which column is which, so your bank's own CSV layout works too. A file with separate Debit and Credit columns instead of one Amount column is fine.
kumry-bank-statement-template.csv| Column | What to put in it |
|---|---|
| Date | DD/MM/YYYY or YYYY-MM-DD. Each row needs a real calendar date. |
| Description | The narration from your statement. Columns called Memo, Narration or Payee also work. |
| Amount | Money in is positive, money out is negative (a leading minus or brackets). Up to two decimal places; commas and $ signs are ignored. |
| Reference | Optional. The bank’s transaction reference, which helps Kumry recognise a line it has already imported. |
Date,Description,Amount,Reference 01/07/2026,Opening deposit,5000.00,REF0001 02/07/2026,Supplier payment - example,-412.50,REF0002 03/07/2026,Customer receipt - example,1320.00,REF0003
Replace the example rows with your own. You can also record the statement's closing balance and date during import so the reconciliation has a figure to agree to.
Coming from Xero or QuickBooks Online? The import brings your chart of accounts across as it is, so you start from the structure you already know. Starting fresh? Set up your accounts in Kumry and choose the GST codes your business needs.
How the import worksAn import from Xero carries your full history and is reconciled to the cent against the source trial balance. An import from QuickBooks Online brings your chart of accounts, contacts and transaction history. Either way, opening balances come from the books themselves rather than being re-keyed.
Choosing and switching software
