Match outgoing payments with your supplier payments
Supplier bank reconciliation links the outgoing payments on your statements to the supplier payments recorded in CAPPS. This way you know which payments have actually gone through the bank.
Before you start
- The statements are the ones imported for customer reconciliation: import them first. See Import a bank statement.
- Only debit transactions (outgoing payments) appear here.
- To match, you need the Pay suppliers permission and the Bank reconciliation accounting permission. Without the Pay suppliers permission, the page is read-only; without the accounting permission, CAPPS refuses the match.
Open the page
On the Suppliers page, click Purchasing, then the Supplier bank reconciliation card. At the top, the To match and Matched (suppliers) indicators summarize the period. Filter with From, To, Statement and To match only.
Match a transaction
On a To match transaction, click Suggestions.
CAPPS suggests the nearby supplier payments, with a Score. It searches within ± 7 days, for the same amount or for a reference (transfer, bill of exchange, check number) quoted in the label.
Choose the payment that matches.
If the amounts differ (bank fees, for example), select Force the match despite the difference and enter the Reason for the difference (400 characters at most).
Click Match. The transaction changes to Matched (supplier), with the date and the name of the person who matched it.
On the customer reconciliation side, the transaction matched here changes to the Ignored status, with the reason “Supplier payment” followed by the payment number. It is therefore not offered twice. See Understand bank transaction statuses.
Automatic matching
The Automatic matching button handles the certain pairs in one go: same amount and single best match on both sides. The summary shows the number of transactions matched and those that remained ambiguous, to handle manually.
CAPPS refuses the match in these cases:
- different amounts without forcing: “Different amounts: force the match and give the reason for the difference.”; forcing without a reason;
- “This transaction is no longer to be matched.”;
- payment cancelled, or already matched with another transaction;
- payment by offset: it has no bank movement and is not matched with a transaction.
Cancel a match
On a matched transaction, click Cancel. The message “Match cancelled: the transaction is to be matched again.” confirms the operation. If the row has been handled differently in the meantime, its status is kept.
No transaction shown? Check the period and the To match only filter, then import the missing statement. If the list is truncated, narrow the period.