Getting started

What to do when a statement layout isn't recognised on import

If a statement layout is not recognised on import, try the CSV or Excel download, the optional layout-reading feature, or manual entry. Honest steps.

Editorial illustration for What to do when a statement layout isn't recognised on import

When a statement layout is not recognised, try a CSV or Excel download of the same period, use the optional layout-reading feature if you accept that it processes the uploaded document, or add the rows by hand. Not every layout will parse perfectly, particularly from smaller banks and co-operatives.

What does not recognised mean?

A statement is a document laid out by your bank's own software. Columns can be in any order, dates can be formatted in different ways and amounts can be split or combined. When an importer cannot work out which column is which, it cannot turn lines into transactions reliably. Larger formats are seen far more often, so small or unusual ones are the likelier trouble.

Option one: download the CSV or Excel version

This is the first thing to try. A spreadsheet-style export has clearly separated columns, so the guesswork mostly disappears. Look in your bank's net banking or app for a download format choice next to the statement period. If it only offers PDF, move on.

Option two: the optional layout-reading feature

SpendixAI has an optional feature for reading an unfamiliar statement layout. It works on the uploaded document itself, which means the content of your statement is processed to do that. Choose it only if that is acceptable to you, and you can read what is processed and what is not on the AI and privacy page. Statement import works without it, and you can keep AI features off.

Option three: add the rows by hand

For a short statement, typing is quick and entirely under your control. SpendixAI lets you add expenses singly or several at a time, which is also handy for cash. Pick the account first so the rows go to the right place.

SituationBest routeCost
Small bank offers CSVDownload and import the CSVAlmost none
Only PDF, many rowsOptional layout feature, if you accept itA trade-off on privacy
Only PDF, a few rowsAdd by handA few minutes
Closed or rare account, long historyTry layout feature, or enter key months by handDepends on size

How do I know a layout parsed well enough?

Use the review step before saving. Check the first and last dates, count the rows against the statement, look at the signs, and remove totals and headings. Then run the balance proof: opening balance plus credits minus debits should equal the closing balance.

A worked decision

Say you bank with a small co-operative that offers only a PDF, and your March statement has 35 entries. Typing 35 rows at roughly a minute each is about 35 minutes, whereas a clean CSV would take a couple. So you would first ask whether the bank can give a spreadsheet version, perhaps through a branch, and only then decide between the layout feature and typing.

Next steps

  • Ask your bank which statement formats it offers.
  • Try a different period, since a layout can differ between old and new statements.
  • Keep the original statement as your source of truth.

Telling your bank what you need

When you call or visit your bank, be specific. Say that you need a statement for a given period in a machine-readable format such as CSV or Excel, and that the PDF is hard to use. Some branches can email a spreadsheet version even if it is not on the portal. Ask whether older statements are formatted differently from newer ones, because a layout change midway through a year can cause trouble in a single file. Keep a record of what you were told, so you can follow up if the file does not arrive.

If the layout still does not behave, do not feel it is you. Unusual formats are the hardest case for any import tool.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports