Skip to content

How do I load the bank statement from a file?

When the bank connection does not reach —past months or years, or an account you do not connect—, the statement is loaded from the Norma 43 file that any Spanish bank provides or from the online banking transactions PDF. The lines go into the same inbox as the connection's and are reconciled the same way.

What do I need before I start?

The statement in one of these two formats:

For the lines to be reconciled, the bank account has to be paired with a treasury account of type Bank. If that treasury account has its IBAN filled in, the pairing happens on its own when loading.

How do I do it?

  1. Go to Treasury → Bank transactions.
  2. Click Load statement, at the top right. If the window is narrow, it is inside the ··· menu.
  3. Choose the file. The ERP reads it and shows, for each account, the period, the Opening balance, the Closing balance and how many lines it holds: New, Already loaded and From the connection.
  4. Check the Goes to column: it says which account the lines will go to and which treasury account they will be reconciled against.
  5. Click Load.
  6. Click Analyse pending for the ERP to suggest what each new line matches.

What happens if I load a file that overlaps another one?

Nothing bad: each line is recognised and what was already there is not loaded again. You can load January and then the whole first quarter; from the second file only February and March go in. If you load the same file twice, the ERP tells you when you loaded it and records nothing.

Two identical charges on the same day (same amount and same description) are two lines, and they stay that way.

What if that account is already connected to the bank?

The file's lines go to the same account, not to another one. So that nothing is there twice:

So you can load last year from a file and let the connection bring the current transactions.

Why won't it let me load the file?

Because the ERP checks the bank's control figures before loading anything. Each account in the file carries its opening balance, its closing balance and the number and total of debits and credits. If the opening balance plus the transactions does not give the closing balance, the file is incomplete or badly generated, and none of its accounts goes in.

In the PDF, the check is each line's balance: the previous line's balance plus the amount has to give the line's balance. If any line does not match, the ERP says which transaction fails and loads nothing.

What happens to what I wrote on the PDF?

The text notes you put on the PDF when matching by hand (“Factura 360093”, “Nóminas”…) are saved with the line they sit on. They show in amber, with a ✎, in Bank transactions and when reconciling, and they go in the matching proposal. The preview says how many the PDF has. Highlights are not saved.

If you already loaded the month from an unmarked PDF, load the marked one afterwards: no new line goes in, its notes are just added to the lines that were already there. The line, its amount and its reconciliation are not touched.

Can I load the PDF of a month I already loaded in Norma 43?

Yes, without duplicating anything: days already brought by one format are not loaded from the other and show in the From the connection column. The same goes for two overlapping PDFs, such as two fortnights and the whole month: each line is recognised and only what is new goes in.

Where are the accounts I only load from a file?

In Bank connections, grouped under Statements loaded from file. There you can pair them with their treasury account if they were not paired on their own. That group is not synchronised and does not expire: its Load statement button takes you to the inbox.

If something goes wrong

What you seeWhat has happenedWhat to do
“The file holds no account: it is not a Norma 43 statement.”You chose another kind of file, such as an ExcelDownload the statement in Norma 43 or as a PDF
“The PDF has no text: it is a scanned image…”The PDF is a photo or a scan of the paperDownload the transactions PDF from online banking
“The PDF is not recognised as a bank statement…”The PDF has no transactions table with date, description, amount and balance; for example, an accounting ledgerChoose the bank's transactions PDF
“The PDF balances do not match at the transaction of…”That line could not be read properly, or the PDF is truncatedDownload it again; if it happens again, tell support and send the PDF
“The account IBAN is not on the first page of the PDF.”The PDF does not show the full IBANDownload the PDF from the account's transaction enquiry, which has it in the header
“The opening balance (…) plus the transactions does not give the bank's closing balance (…).”The file is truncated or badly generatedDownload it again from the bank
“Account … is in another currency…”The account is not in eurosThat account cannot be loaded
“Account … appears twice in the same file…”The bank put two periods of the same account in one fileDownload each period separately
Goes to shows “No treasury account”No treasury account has that IBANLoad anyway and pair the account in Bank connections
“The file is larger than 50 MB…”The period is very longDownload the statement by months or quarters

See also: Review the bank transactions · Reconcile the bank transactions

More about Banks