ProductAccounting
Banking reconciliation
Match bank lines to ledger entries, then close the statement period.
Overview
Reconciliation checks that every movement of a bank account matches an entry in the ledger. The daily work happens in Matching. Reconciliation history keeps the closed statement periods.
Where in the app
- Banking → Matching —
/c/companies/:companyId/accounting/banking/reconciliation/workbench - Banking → Reconciliation history —
/c/companies/:companyId/accounting/banking/reconciliation - Banking → Bank transactions —
/c/companies/:companyId/accounting/banking/transactions - Banking → Bank accounts —
/c/companies/:companyId/accounting/banking/accounts - Banking → Configuration —
/c/companies/:companyId/accounting/banking/config - Banking → Reports —
/c/companies/:companyId/accounting/banking/reports
Before you start
- A bank account linked to the ledger. Each bank account is linked to its ledger account (for example 1020). The link is chosen from a list that follows the account type: an active, postable cash account (group 100 of the Swiss chart) and, for a credit card, also a liability account; never a receivable, payable or transit account. Without a valid link its lines cannot be matched: the Link to ledger action opens the account.
- The payment recorded. With two-step payment posting (the default), an invoice's payment is recorded before matching: its entry goes through a transit account (1091 or 1092).
Where bank lines come from
- A bank statement. From Banking → Bank transactions, click Import and drop the statement exported from your e-banking: camt.052, camt.053 or camt.054 (.xml file) or MT940 (.mt940, .sta, .940 or .txt). The statement's IBAN names the account, with no column to map. When the statement names its account otherwise than by an IBAN the company knows, the preview says so: choose the bank account, then Import into this account. A statement imported twice creates no duplicate, and a payment already recorded in Numezis is confirmed by the statement instead of being copied.
- A payment recorded from a bank account. Paying a supplier bill, an expense or an expense report from a bank account creates the expected line on that account, or takes over the line the statement already imported for that movement.
- A CSV or Excel file. Through the same import, mapping the columns. The account column accepts the account's IBAN.
- Manual entry. From Banking → Bank transactions, when the banking configuration allows it.
Only the direct e-banking connection (bLink) is not available yet: the Connect e-banking button of the matching page is disabled and states why.
Step-by-step
- Open Banking → Matching and pick the account. (Expected: the account's unmatched lines are listed, or the empty screen states what is missing.) (UAT-C-ACCT-BANK-001)
- If the account is not linked to the ledger, click Link to ledger and choose Linked ledger account (for example 1020). (Expected: the account's lines can be matched.) (UAT-C-ACCT-BANK-001)
- Open a line. (Expected: posted entries with the same amount, within a few days, are proposed; the panel's search lists only entries this line can settle, and an entry already matched to another line is no longer proposed.) (UAT-C-ACCT-BANK-001)
- Click Match on the right proposal. When the line pays a supplier bill already posted but not yet paid in Numezis (for example on the first import of a statement), the Open supplier bills of this amount section offers it: Record payment records the bill's payment on this line, which is reused and matched, never duplicated. A bill whose payee the line does not name (different IBAN, reference or supplier) is offered after the others with the difference stated, and its payment needs an explicit confirmation. A bill an ongoing payment run already pays is not listed: mark the run executed. From the bill itself or from a run, the imported line is taken over only if it names the same supplier at a close date; otherwise, use this panel. Create new entry remains for a movement without a document, such as bank fees. (Expected: a refused match states its reason in the panel.) (UAT-C-ACCT-BANK-001)
- Compare the bank balance with the ledger balance of the account. (Expected: any remaining difference is shown.) (UAT-C-ACCT-BANK-001)
- At period end, click Start reconciliation to close the statement period. (Expected: it appears in Reconciliation history.) (UAT-C-ACCT-BANK-001)
Configuration and reports
Banking → Configuration sets the payment posting mode, the matching tolerance and manual entry. The Banking reports area provides:
- Cash position across bank accounts.
- Reconciliation status with reconciliation rate and unreconciled ageing.
- Outbound payment schedule for upcoming payment runs.
- Sync journal for bank connector activity and failures.
Permissions and modules
Accounting banking (accounting.banking.reconciliation).