How do I import a bank statement CSV into Kontuly?
In Kontuly, open Banking, choose the account in the Bank account list, click CSV and pick the statement file you downloaded from your internet banking. Check the column roles in the preview, then click Import N transactions.
- Download a CSV from your bank. Most banks offer it as "CSV", "Excel (CSV)" or "spreadsheet" in their export options.
- Choose the bank account. In Banking, select it in the Bank account list. Transactions go into whichever account is selected, so check this first.
- Click CSV and choose the file. The Import statement window opens with Kontuly's guess of what each column holds.
- Check the column roles. You need a Date, either Amount (signed) or a Debit (out) and Credit (in) pair, and ideally a Description. Map a Balance column if your file has one. Set anything else to Ignore.
- Check First row is a header and Date format. Australian banks use Day/Month/Year. Look at a few dates early in the month in the preview.
- Click Import N transactions. The summary shows how many were imported, how many duplicates were skipped and how many your bank rules coded.
Why is CSV the best format?
CSV files are read exactly, so there's nothing to guess. Amounts written as $1,234.56, -12.50, 12.50-, (12.50) or 12.50 CR / 12.50 DR are all understood, and so are dates with month names, such as 15 Jul 2026.
Mapping the Balance column is optional but worth it: Kontuly then shows your statement balance on the Banking screen and suggests the closing balance when you reconcile.
Can I import the same statement twice?
Yes. Kontuly skips any line it already has in that bank account with the same date, amount and description, so overlapping files are safe. See Why does Kontuly say duplicates were skipped?
What next?
The imported lines wait in the review list for you to code them. Set up bank rules and regular items such as rent and bank fees are coded as they arrive.
If your bank only gives PDF statements, see Can Kontuly import a PDF bank statement?
Related questions
- Can Kontuly import a PDF bank statement?Kontuly can read transactions out of a PDF bank statement, then shows every row for you to check before importing. CSV is still more reliable.
- Why are columns or dates wrong on a Kontuly CSV import?Fix a Kontuly bank CSV import with wrong columns, swapped days and months or skipped rows by checking column roles, the header row and the date format.
- How do bank rules automatically code transactions in Kontuly?Set up bank rules in Kontuly so rent, phone bills and bank fees are coded automatically when you import a statement, and run them over waiting lines.
More about banking and reconciliation
- Does Kontuly connect to my bank with bank feeds?Kontuly has no bank feeds. You import CSV or PDF statements from your internet banking, so your banking login never leaves your hands.
- How do I add a credit card or another bank account in Kontuly?Add a bank account, credit card, PayPal balance or petty cash tin in Kontuly by ticking "This is a bank / cash account" on an account in the Chart of Accounts.
- How do I code bank transactions in Kontuly?Code each bank line in Kontuly's Banking screen by choosing an account in its Assign to column. GST is split out for you, and you can code many lines at once.
- How do I split a bank transaction across accounts in Kontuly?Split one bank line across several accounts and GST rates in Kontuly, for part-private purchases, mixed GST-free items or a bill covering more than one cost.
- How do I match a bank payment to an invoice or bill in Kontuly?Match money in to a customer's invoice, or money out to a supplier's bill, on Kontuly's Banking screen, including one payment covering several invoices.