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:
- Norma 43 (also called cuaderno 43 or AEB 43). You download it from online banking, in the account's transaction enquiry, choosing that format and the dates. One file can hold several accounts and several months.
- Transactions PDF, the one online banking gives when you look up an account's transactions between two dates. Use it when the bank no longer offers Norma 43 for past months. It has to be the PDF the bank generates, not a photo or a scan.
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?
- Go to Treasury → Bank transactions.
- Click Load statement, at the top right. If the window is narrow, it is inside the ··· menu.
- 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.
- Check the Goes to column: it says which account the lines will go to and which treasury account they will be reconciled against.
- Click Load.
- 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:
- Days the connection already brought are not loaded from the file: they show in the From the connection column.
- Days a file covered are no longer downloaded by the connection.
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 see | What has happened | What to do |
|---|---|---|
| “The file holds no account: it is not a Norma 43 statement.” | You chose another kind of file, such as an Excel | Download 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 paper | Download 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 ledger | Choose 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 truncated | Download 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 IBAN | Download 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 generated | Download it again from the bank |
| “Account … is in another currency…” | The account is not in euros | That account cannot be loaded |
| “Account … appears twice in the same file…” | The bank put two periods of the same account in one file | Download each period separately |
| Goes to shows “No treasury account” | No treasury account has that IBAN | Load anyway and pair the account in Bank connections |
| “The file is larger than 50 MB…” | The period is very long | Download the statement by months or quarters |
See also: Review the bank transactions · Reconcile the bank transactions
More about Banks
- How do I use my spreadsheets to reconcile the bank?
- How do I reconcile the bank transactions?
- How do I connect my bank to the ERP?
- How do I balance a POS or payment gateway settlement?
- How do I set up my company’s access to Enable Banking?
- Connecting the bank and reconciling the statement
- How do I reconcile the bank month by month?
- How do I review my store’s POS remittances?
- How do I review the transactions that come in from the bank?