Reconciling payments using bank statements

To reconcile payments using bank statements, you must have created or imported your bank statement. Please refer to this article to learn more about importing bank statements.

Once you have recorded/imported your bank statements, go to the Accounting -> Overview menu, and in the card for the bank journal, click on the Reconcile button.

Automatic Reconciliation

If you have specified the customer/vendor in your statement lines, AccelGrid will automatically match the payment transaction to an invoice/vendor bill for the same amount. In such cases, simply click on the Validate button to confirm the reconciliation.

Manual Actions

There may be cases where manual actions are necessary.

Customer/Vendor is missing in the statement line

In this case, simply select the customer/vendor using the Select Partner dropdown selector.

Downpayment

For transactions that relate to a downpayment (no invoice/bill has been recorded yet), simply click on the validate icon.

The amount doesn't match an existing invoice or supplier bill

For transactions that relate to a partial payment of an invoice or vendor bill, you must manually click on the corresponding invoice/vendor bill from the Customer/Vendor Matching list.

Part-reconciliation

Click on the Edit icon next to the amount of the selected customer/vendor bill and manually enter the amount to be reconciled with the payment.

Once you have edited the amount, click on the Validate button to confirm the reconciliation.