Why are columns or dates wrong on a Kontuly CSV import?
When a CSV statement comes into Kontuly with wrong amounts or dates, the column roles, the First row is a header tick or the Date format in the Import statement window need changing. The preview updates as you change them, so fix them before you click import.
Checks in order
- Column roles. Above each column is the role Kontuly will use: Date, Description, Balance, and either Amount (signed) (one column, money out negative) or Debit (out) and Credit (in) (two columns). Set everything else to Ignore. A common mistake is mapping a single amount column when your bank uses two, or the other way round.
- First row is a header. Tick it if the first line holds column names. If it's wrong, your first transaction is missing, or the column names appear as a row with an error.
- Date format. Australian banks use Day/Month/Year. A file where every day is 12 or less can't be told apart from Month/Day/Year, so check a few dates early in the month in the preview.
Rows that are skipped
Rows that can't be read are shown faded with the reason, and aren't imported:
- Unrecognised date: the date is empty or in another format. Check Date format and which column is mapped as Date.
- Invalid amount: the amount isn't a number. Check the amount columns are mapped correctly.
- Zero amount: a row with no money, often a heading or a "balance brought forward" line. These are safe to skip.
The import button shows how many valid rows will be imported. The preview shows the first 100 rows; all valid rows are imported.
I already imported it wrongly
Unassign any lines that were coded, delete the wrong lines (bin icon in Banking), then import the file again with the right settings. See How do I import a bank statement CSV?
Related questions
- How do I import a bank statement CSV into Kontuly?Download a CSV statement from your internet banking, choose the account in Kontuly's Banking screen, click CSV and check the columns before importing.
- Why does Kontuly say "duplicates skipped" after a bank import?Kontuly skips bank lines it already has with the same date, amount and description, so overlapping statements never double up. Here's when that matters.
- Why do transactions from a PDF statement look wrong in Kontuly?PDF statement reading in Kontuly is best effort. Check each row's amount and in/out direction, untick summary rows, or import a CSV instead.
More about troubleshooting
- Why can't I edit an approved invoice or bill in Kontuly?Kontuly says "Only draft invoices can be edited" or "Only draft bills can be edited"? Fix an approved document by voiding it or raising a credit note.
- Why does Kontuly say "Period is locked"?The transaction is dated on or before the lock date in Kontuly's Settings. Date the correction after it, or clear the lock date, fix it and set it again.
- Why can't I change the currency of a business in Kontuly?Kontuly fixes a business's currency once any transaction is posted, because every amount is stored in it. If it's wrong, set up a new business.
- Why can't I void a bill or credit note in Kontuly?No Void button on a Kontuly bill or credit note? Remove its payments, allocations and refunds first, and check the lock date. What each message means.
- Kontuly says an account has transactions and its type can't changeKontuly locks an account's type once it's been used, so past reports don't change. Create a new account of the right type and move the balance with a journal.