The bank reconciliation consists in matching the operations registered on your bank statement with the transactions recorded in your ERP.
With the OFX format, Dokos will not create duplicates since each transaction is uniquely identified.
You can therefore import a file containing data already registered.
With the XLSX/Csv format, if the field
reference_number is not defined, the software will not be able to uniquely identify the transactions and will import duplicates.
Open the page Bank Reconciliation
The reconciliation tool allows a reconciliation between one or several lines of your bank statement with one transaction in Dokos (Payment entry, journal entry, ...)
It also allows a reconciliation between one line on your bank statement and several transactions in Dokos.
But it doesn't handle the reconciliation of several lines on your bank statement with several transactions at the same time.
If the options proposed by the tool don't handle a particular use case, you can always open the transaction and add reconciliation line by allocating the reconciled amounts manually.
If you reconcile an invoice, Dokos will automatically create the corresponding payment.
If the invoice currency is not the invoice of the bank account, you will need to create the payment manually first.
If you use Stripe as payment gateway, Dokos can reconcile your payments with the payouts made by Stripe on your bank account.
You only need to add Stripe "Charge" ID in the field "Cheque/Reference No" in the Payment Entry.
If you ask you customers to add the invoice number in the wire transfer references, Dokos can make the reconciliation automatically when you click on "Automatic reconciliation".
The regional_reconciliation method allows the configuration of reconciliation methods specific to some regions.
You can add a field esr_reference in your invoices in order for Dokos to automatically reconcile them based on the ESR number.
The auto_reconciliation_methods hook allows the creation of your own reconciliation methods in a custom application.