Connecting the bank and reconciling the statement

The ERP can read your accounts’ statement on its own and compare it with what you have already recorded. What matches is closed practically on its own; what doesn’t is resolved on a single work screen. This page describes the whole process and links to the detail of each step.
Where do I start?
By connecting your bank to the ERP. A bank connection is the authorisation you give the ERP to read your accounts’ statement. It is read-only: the ERP never orders payments this way.
The first time, you have to set up your company’s access to Enable Banking, the authorised service through which the ERP reads the banks. It is done only once and works for all your banks.
Before that, you need a treasury account of type Bank for each bank account you want to follow. It is the account the transactions are compared against, and whoever administers the ERP creates it. The authorisation itself you do on the bank’s website, with your online banking credentials.
Where do I see what has come in from the bank?
In the imported statement inbox, which is explained in review the transactions that come in from the bank. It shows line by line what the bank has posted to your connected accounts, with four counters at the top: Pending, Suggested, Reconciled and Discarded.
It is a lookup screen: here you look, you don’t resolve. If the inbox is empty, the problem is in the connection and not on this screen.
For the months the connection does not reach —last year, for example— or for an account you do not connect, the statement is loaded from the bank's Norma 43 file or transactions PDF and goes into the same inbox.
To work as you would by hand, month by month and account by account, there is monthly reconciliation: each month with what it is missing, the bank balance against the books and its closing. What you keep in sheets outside the ERP is loaded as reconciliation hints so the reconciliation has it at hand.
What does reconciling mean?
Reconciling means saying, for each statement line, which ERP operation it corresponds to. The workstation where all that is done is in reconcile the bank transactions.
The screen works with a table, Bank lines, that by default brings what needs action: the Pending and the Suggested lines. You can search it by description, note, counterparty or amount and sort it by column, so it copes with a whole year’s statement. For each line there are several ways out:
- Accept the suggestion the ERP proposes, or reject it and resolve it another way.
- Choose a candidate from the list of possible counterparts, each one with its score.
- Search for another counterpart among transactions, batches or settlements.
- Discard the line, when nothing in the ERP corresponds to it.
A counterpart can only be used up once: if a batch already backs another statement line, the ERP prevents you from using it twice and says so.
What do I do with a deposit that pays several invoices at once?
It is the customer who settles several instalments with a single transfer. You resolve it by composing the statement line against those instalments, on the same workstation as bank reconciliation. If the ERP has identified the customer by their IBAN, the composition is already proposed and you only have to adjust it.
To close a standalone receipt or payment this way, you need an active numbering series for batches. Without a series, that particular case can’t be accepted.
What about the deposit from the POS or the payment gateway, which comes in as a lump sum?
A POS or a payment gateway —Redsys, Stripe, PayPal, GoCardless— doesn’t pay in each sale separately: it groups many operations and credits the net amount in one go. That aggregated deposit is a settlement, and balancing it means checking that the sum of the operations, minus the fees, is exactly what reached the bank. The procedure is in balance a POS or payment gateway settlement.
You need a treasury account that acts as the aggregator’s bridging account. With Stripe, PayPal or GoCardless the breakdown is brought in through the connection. With Redsys it comes in through the settlement CSV file from the portal or the bank, unless the sales come from your online store: then the ERP already knows which orders each remittance contains and balances it on its own. You can see them all in POS remittances.
What happens when I reconcile a line?
When you resolve a statement line, that line is left Reconciled against the chosen counterpart and who resolved it and when is recorded. The queue and the counters refresh on their own, and the counterpart is used up: it can no longer be used for another line.
Rejecting a suggestion loses nothing: the line goes back to Pending and is still available to resolve it any other way.
More about Banks
- How do I use my spreadsheets to reconcile the bank?
- How do I load the bank statement from a file?
- 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?
- 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?