In the test phase

Bank reconciliation matches your transactions, and you only deal with what is left.

In nine passes, reconciliation looks for the counterpart to each bank transaction. That can be an invoice, a supplier, a loan instalment or an advance payment. Whatever is left over, you assign by hand. Every step is recorded in the change log.

Bank reconciliation in the 1x1-WorkOrderAgent: a bank transaction being assigned to a ledger account by hand
Sample data Click to enlarge.

How it goes when a customer pays

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

  1. Transactions arriveTransactions come in daily through FinTS account retrieval or as a CSV bank statement. FinTS is the online banking interface of German banks. If a transaction is in both, the system spots the duplicate.
  2. Nine passesA customer has paid their invoice by bank transfer. Reconciliation checks the reference number, amount and payment reference, among other things, against open invoices and known payments.
  3. Match postedIf the payment fits, it is posted, the invoice is closed and the document is linked. If the customer deducted an early-payment discount, the deduction is posted as a discount.
  4. The rest by handWhatever the passes cannot match with certainty, you assign by hand. That is recorded in the change log too.

What reconciliation matches

Reconciliation does not only know customer payments. Recurring outgoings find their counterpart too.

  • InvoicesAn incoming payment closes the open outgoing invoice. If the payment does not arrive, you send a reminder at the push of a button.
  • SuppliersReconciliation recognises transfers to suppliers and matches them to the incoming invoice.
  • Loan instalmentsThe system splits the instalment on the bank statement into principal and interest.
  • Fixed costs and advance paymentsThe system recognises rent, insurance, subscriptions and electricity as recurring expenses and assigns them to accounts by itself.
  • Discounted paymentsIf a customer deducts an early-payment discount, reconciliation recognises the reduced amount and posts the difference as a discount. With fast discount collection this also applies when you submit the direct debit late.
  • Three types of matchingThere is exact matching, matching with a tolerance and manual matching. All three are recorded in the change log.

What accounting and banking get out of it

From the accounting side
The open items list keeps itself up to date. Receivables from the reminder process in order management move into accounts receivable, and reconciliation closes them as soon as the money is there.
From the banking side
Account retrieval delivers the transactions without you opening the bank’s portal. The system shows pending transactions if the bank supplies them, and keeps them separate from the accounting. View-only accounts are left out entirely.

Have a look at bank reconciliation in the demo

We are happy to show you reconciliation using your own transactions. Beforehand you can see the current state of the accounting in the free demo. The demo is in German.

0173 644 22 17
Request a demo