Skip to content

How to reconcile the bank with a Norma 43 statement

Upload the bank statement and match each movement with the document it collects or pays; nothing is collected or paid until you confirm.

Bank reconciliation is in Accounting › Banks. The statement never creates money: when you confirm, BizQ collects or pays the documents through the usual paths, with the movement date.

Upload the statement

  1. Download the Norma 43 file from your online banking (also called «Cuaderno 43»; .n43, .txt or .aeb).
  2. Click Upload Norma 43. The account is created automatically if it does not exist; with a Spanish IBAN, later statements are assigned automatically.
  3. Open the statement: each movement shows its Suggestion (exact amount, exact sum, number, tax ID or name in the concept).

Reconcile

  • Credit (money in): click Reconcile, choose the customer's invoices, tickets or albaranes and click Confirm. They are collected by bank transfer, like any other collection. If the documents belong to several customers, one collection per customer is made.
  • Debit (money out): choose the purchase or expense and confirm; the supplier payment is recorded as a bank transfer.
  • If the money was already recorded (the day's card payments that the bank credits net, cash deposits, payments already made), use Money already recorded: it only links, no money is created.
  • Anything that does not match a document (transfers between your own accounts, for example) is marked with Ignore and a reason.

Keep in mind

  • What you assign must be exactly the movement amount. A customer excess is only saved as store credit if you tick it.
  • A payment cannot be dated in the future, before the supplier invoice or in a closed VAT quarter.
  • Uploading statements and reconciling debits needs the Accounting payments permission; reconciling credits needs the collect permission.
  • Export CSV downloads what has been reconciled for your accountant; it does not create journal entries.
Back to the help centre