# Bank reconciliation in 9 passes

> Transactions via FinTS or CSV, nine automatic matching passes against invoices, suppliers, loans and instalments. Discounts recognised, receipts linked.

Source: https://1x1it.de/en/workorderagent/erp/bankabgleich/

Nine automatic passes match every transaction to the right invoice, supplier, loan instalment or advance payment. Whatever is left, you assign by hand. Every step is recorded in the change log.

[Try it free for 20 days](https://1x1it.de/shop/)
[All accounting features](https://1x1it.de/en/workorderagent/erp/)

Bank reconciliation ERP

- **Passes:** 9, automatic
- **Transactions:** via FinTS or CSV import
- **Matching:** exact, with tolerance, manual
- **Discount:** recognised and booked
- **Audit trail:** change log, receipt linked

## From bank transaction to closed invoice

The transactions come from banking, the open items from accounting. Reconciliation brings the two together.

- Transactions arrive: Daily via FinTS account retrieval (the German online banking standard) or as a CSV bank statement. The system detects duplicates between CSV and FinTS.
- Nine passes: Reconciliation checks reference number, amount and payment reference, among other things, against open invoices and known payments.
- Matches booked: The payment is booked, the invoice closed and the receipt linked. Payments with early payment discount are booked as discount.
- The rest by hand: Whatever the passes cannot match with certainty, you assign manually. That is recorded in the change log too.

## What reconciliation matches

Not just customer payments. Recurring outgoings find their counterpart too.

- Invoices: Incoming payments close the open sales invoice. If payment does not arrive, you send a reminder at the push of a button.
- Suppliers: Transfers to suppliers are recognised and assigned to the incoming invoice.
- Loan instalments: The instalment is automatically split into repayment and interest from the bank statement.
- Utility instalments: The system recognises rent, insurance, subscriptions and electricity as recurring expenses and assigns them to accounts automatically.
- Discounted payments: If a customer deducts an early payment discount, reconciliation recognises the reduced amount and books the difference as discount. With fast discount collection, this works even if you submit the direct debit late.
- Three matching types: Exact matching, matching with tolerance and manual matching. All three are recorded in the change log.

## One feature, two perspectives

- **From the accounting side:** The open items list maintains itself. Receivables from dunning in order management flow automatically into accounts receivable, and reconciliation closes them as soon as the money arrives.
- **From the banking side:** Account retrieval delivers the transactions without you opening the bank portal. The system shows pending transactions if the bank provides them, separate from accounting. View-only accounts are left out entirely.

## Related

[Receivables and payables Open items, dunning levels, discount](https://1x1it.de/en/workorderagent/erp/debitoren-kreditoren/)
[FinTS account retrieval Transactions straight from the bank](https://1x1it.de/en/workorderagent/banking/fints-kontoabruf/)
[Recurring entries Rent, subscriptions, electricity assigned automatically](https://1x1it.de/en/workorderagent/erp/wiederkehrende-buchungen/)
[ERP & accounting All features at a glance](https://1x1it.de/en/workorderagent/erp/)

## Never tick off bank statements again?

Try WorkOrderAgent free for 20 days or let us show you bank reconciliation with your own transactions.

[0173 644 22 17](tel:+491736442217)

[Request a demo](https://1x1it.de/en/kontakt/#anfrage)