Accounts Payable
Part of Accounts payable software
Matching a payment to the approved bill and bank withdrawal
Trace an approved supplier bill through payment and bank matching without creating a second expense or hiding an unpaid balance.
Start with the approved supplier bill, trace it to its payment record, then match that record to the bank withdrawal. Match the withdrawal to an existing record rather than entering it as new spend: QuickBooks defines matching as linking a downloaded transaction to one already categorised and posted, and says matching avoids duplicates.
Keep the bill, payment and bank line together
Compare the supplier, amount and reference on the bill, payment record and bank transaction. In MYOB, when recording a supplier payment, choosing Electronic payment and selecting the supplier uses the bank details saved in that supplier’s contact record.
A payment-file export is not proof that the bank processed the payment. Xero says exporting a payment file marks selected bills as paid in Xero; check the bank transaction to confirm the withdrawal occurred.
| Bank movement | Check before matching |
|---|---|
| Exact approved amount | Supplier, reference, bank account and whether a payment was already recorded. |
| Less than the bill | Whether this is an authorised part payment or a difference needing investigation. |
| One amount for several bills | The payment batch and its component bills; the bank line may match a grouped payment record. |
| Different amount | Whether a documented credit, fee, withholding or error explains it. Do not invent a balancing amount. |
| No obvious bill | Search existing payments and supplier credits before creating an expense. |
Before Matching a Bank Transaction: Key Checks
- Verify supplier name matches exactlyPrevents mismatched payments and incorrect allocations.
- Confirm the amount matches the approved billIf less, determine if it's a part payment or error.
- Check for grouped paymentsOne bank withdrawal may cover multiple bills—review the payment batch.
- Investigate discrepanciesDo not invent balancing amounts; document credits, fees or errors.
- Search existing payments firstAvoid creating duplicate expenses or hiding unpaid balances.
Use the matching action that fits
In MYOB, open Banking > Bank transactions. The page can automatically match exact transactions to records; its three-dot options include Match to MYOB records and Match to invoices and bills. Match to invoices and bills requires Match to MYOB records to be selected in the Bank rules settings.
If MYOB shows a suggested match, check that it is the payment for the approved bill before choosing it. An automatic match or allocation appears with a magic wand icon, and you can unmatch it if it is wrong.
For one withdrawal covering several supplier payments in MYOB, record each supplier payment using Electronic payment, then go to Banking > Prepare electronic payments. Choose Pay Bills, select the payments and click Download bank file; when the withdrawal appears in the bank feed, match it to the grouped electronic payment record and click Save.
On the QuickBooks bank transactions page, review any AI suggestion before matching. Match the downloaded withdrawal to an existing payment record; categorising it instead creates a different entry, while matching links it to a transaction already categorised and posted.
In Xero, selected bills can be paid together by exporting a payment file for online banking; each supplier receives a single payment and reference, and the bills are marked paid in Xero. Then reconcile the bank transaction in Xero to check that the withdrawal reached the bank account.
Matching vs Categorising: Key Differences Across Platforms
- QuickBooksMatching links a downloaded transaction to an existing categorised record; categorising creates a new entry.
- MYOBMatch to invoices and bills only works after enabling 'Match to MYOB records' in Bank rules.
- XeroExporting a payment file marks bills as paid; reconcile the bank transaction to confirm withdrawal.
Resolve a difference
If the amount or supplier does not agree, inspect the bill and the payment record before accepting a suggested match. MYOB allows a bank transaction to be unmatched if the match is wrong; do not categorise a supplier-bill withdrawal as new spend merely to clear it.
For a grouped MYOB withdrawal, compare the selected supplier payments with the grouped electronic payment record before saving the match. The bank feed shows the withdrawal as one transaction, while the record represents the selected payments together.
Finish by checking that the bill’s status and the bank transaction agree with the payment. In MYOB, matching a payment to an open bill records the payment against it and closes the bill; in Xero, check both the paid bill status and the bank reconciliation.
Key Facts on Payment Matching Accuracy
- Avoid duplicates
- Matching prevents double-entry of payments.
- Unmatched transactions possible
- MYOB allows unmatching if a suggested match is incorrect.
- Reconciliation required
- Always check that the bank transaction and bill status agree.
