Automatic matching of bank statements

When you import bank transactions into Bokio (either manually or with bank feeds), Bokio will attempt to match existing payments against existing supplier and customer invoices as well as manual payments (journals that involve bank transactions) you have already recorded.

Match posted records

When importing bank transactions, all transactions are listed under To do now on the Things to do page. If a bank transaction has already been recorded manually, Bokio will be able to match to this manually recorded payment to the imported bank transaction. The manually recorded payment will appear as a green row and if the match is correct click on Match payment.

match payment

As the transaction had already been recorded there is no journal entry to be recorded in this step. However, the imported bank transaction disappears from your Things to do and this will link the imported transaction to the journal entry. You can see this by going to Bank feeds on your menu, then clicking on the related account. The image below shows that this specific transaction is linked to the journal entry V1. For the matching process to work the date of the imported transaction must be the same as the manually record payment.

linked transaction

Match supplier invoice

If an imported bank transaction has exactly the same amount as the supplier invoice that has been recorded, and the due date is within 5 days before or after the imported bank transaction, we will suggest a match as shown below. You can then either choose Match payment or click on '…' next to Match payment in order to disable matching if you do not agree with the suggested match.

suggested match

The payment of the supplier invoice is then recorded automatically.

Match customer invoice

Similarly to a supplier invoice, if an imported bank transaction has exactly the same amount as the customer invoice that has been recorded, and the due date is within 5 days before or after the imported bank transaction, we will suggest a match. You can then either choose Match payment or click on '...' next to Match payment in order to disable matching if you do not agree with the suggested match.

The payment of the customer invoice is then posted directly from Do. Note that when you import a bank, you choose which bank account the bank statement applies to. The payment will be posted on this account.

If bank row does not match

If an imported bank transaction shows no possible matches, you can record transactions directly from the To do list. Click Record on the imported bank transaction.

You then get the choice to take or upload an image or PDF. In addition, there is also the option to Select uploaded receipt. Here, you can directly choose one of the documents that have already been uploaded in Bokio that have not yet been recorded.

record transaction

Choose the invoice or receipt that matches the payment from your uploaded documents. Click Select and then attach the payment to the receipt and record the payment.