Invoice To Bank Transaction Matching Guide
Tie every bill and sales invoice in a DocuClipper project to the payment on its bank or credit card statement: suggested automatically, accepted in one click, reviewed for the whole project at once, and exported with your invoices.
Last updated
Put your invoices and the bank or credit card statements that paid them in the same project, and DocuClipper finds the payment for each invoice. You review the suggestions for the whole project in one place, accept them in one click, and every invoice then shows when and how it was paid. It works whether or not the project is connected to QuickBooks or Xero.
Use it to prove that every bill ties to a payment on the statement (catch-up bookkeeping, audit support, forensic work), to find bills that were never paid, and to find payments with no invoice behind them.
How it works
- Convert the invoices and receipts (Upload > Bills & Receipts (you pay) or Sales Invoices (you send)) and the bank or credit card statements (Upload > Bank/Credit Card Statements (PDF)) into the same project, in any order.
- Open the project's Invoices/Receipts tab. Above the invoices list, the Bank matches bar counts the invoices already matched, the ones with a suggested payment, and the ones with no payment found.
- Click Review suggestions, check the matches, and click Accept selected.

Nothing is matched until you accept it. Suggestions are recalculated every time you open the list, so a statement you add later brings in new suggestions.
How DocuClipper finds the payment
A suggestion needs all of these:
- The same amount, to the cent. A payment with fees taken out, or in another currency, is not suggested; match it by hand (see below).
- The right direction. A bill or receipt is money out of the account; a sales invoice is money in. A credit note is a refund: a supplier's credit note is money in, a credit note you issued to a customer is money out.
- A date that fits. From a few days before the invoice date to about two and a half months after the due date (or the invoice date when there is no due date).
DocuClipper then looks for evidence that the transaction belongs to this invoice, and labels each suggestion:
- Strong match - the transaction's check number or reference number is the invoice number. These are selected for you in the review.
- Likely - the full vendor or customer name appears word for word in the description ("CLIENT PAYMENT - ALDER & PINE LLP" for Alder & Pine LLP), or the invoice number stands on its own in it. Likely matches are listed first but not selected: check them, then click Select all likely (or tick them one by one).
- Check this one - the amount and date fit, but the evidence is weaker: a shortened name ("BRIGHTLINE OFFICE SUP"), no name at all (a check, a generic transfer), or another invoice of the same amount could be the one.
A name, however exact, never selects a match for you: two businesses can share a name, and a bank prints the payment processor's name in front of the shop's ("PAYPAL *JOESHOP" was paid to the shop). Dates, phone numbers and masked card numbers in a description are never read as invoice numbers. When you correct a vendor or customer name on the invoice, matching uses your name.
It also finds the two common cases where amounts do not line up one to one, as long as every transaction names the vendor or customer. These are always Check this one, never selected for you:
- Paid in parts - one invoice paid in two to four payments that add up to its total.
- One payment, several invoices - one payment that covers two to four invoices of the same vendor or customer.
When a single payment of the exact amount that names the vendor or customer (or carries the invoice number) also fits, that one-to-one match is suggested instead.
Excluded transactions, duplicate invoices, purchase orders and debit notes are never suggested.
Review and accept for the whole project
Review suggestions opens the review panel for every invoice in the project.

- Each row shows the invoice (number, vendor or customer, due date, total), the bank transaction (description, date, amount) and why it was suggested.
- Strong matches are already checked. Select all likely adds the Likely ones; check or uncheck rows, then click Accept selected.
- Dismiss a suggestion that is wrong. It is not suggested again for that invoice.
- The Matched section lists every invoice already tied to a payment, with Unmatch.
- Click an invoice number to open the invoice.
Where you see the match
- Invoices list - In a project with statements, the Bank match column shows Paid (or Received for a sales invoice) with the payment date and amount, Payment found (a strong match), Likely payment or Possible payment when there is a suggestion (click it to open the review), or No payment found. Its filter picks Matched or Not matched invoices. An invoice without a match also reads No bank match in Needs attention and appears under Exceptions (see Invoice workflow presets).
- Invoice detail - On the invoice's Matching tab, the Bank Transaction Matching card shows the match, or the suggested payment with Confirm match and Dismiss.
- Bank transactions - On the project's Bank/CC Transactions tab, the Invoice column lists the invoices each transaction paid. Click an invoice number to open it, or the unlink icon to unmatch. The column appears in projects that hold invoices.


Match an invoice by hand
For a payment DocuClipper does not suggest (fees deducted, a different currency, a payment outside the date range):
- Open the invoice and go to its Matching tab.
- Click Match to Bank Transactions. The drawer shows the suggested payment, if there is one, above the project's bank transactions.
- Filter the transactions by account, date, description or amount, check one or more rows and click Add to Matches, then Create Matches.

When the project has no bank or credit card statements and is connected to QuickBooks or Xero, the drawer lists the bank transactions from QuickBooks or Xero instead, with a Top suggestion and its confidence.
Once the project holds its own statements, matching runs against them. Matches you made earlier against QuickBooks or Xero bank transactions stay: they are listed in the drawer's Matched table with QuickBooks (or Xero) as their status, they count on the invoice's Bank Transaction Matching card, and the trash icon removes them. An invoice already matched in QuickBooks or Xero gets no new suggestion, in the review panel or on the invoice.
Unmatch
Unmatch from any of the three places: Unmatch in the review panel's Matched section, the trash icon in the invoice's matching drawer, or the unlink icon in the bank transactions' Invoice column. The invoice goes back to unmatched, and if the payment still fits it is suggested again; Dismiss it if it is not the right one.
Export the matches
In Download Data for invoices, turn on Customize Fields and add Bank match (payment) to the invoice fields. The export then has three more columns: Bank Match Date, Bank Match Amount (the total paid) and Bank Match Description. An invoice paid in several payments lists each date and description, separated by semicolons. The columns are only added when you pick the field, and saved custom export formats can use them too. See How to convert invoices and receipts to Excel.
When documents change
- Editing an invoice or a transaction keeps its match.
- Re-converting a statement or an invoice keeps its matches and dismissed suggestions: each one moves to the re-extracted transaction or invoice with the same date, amount and description (for an invoice: the same number, total and date). A transaction that reads differently after the re-conversion loses its match, and is suggested again if it still fits.
- Deleting an invoice, a transaction, a document or a project removes the matches of what was deleted.
FAQs
Do I need QuickBooks or Xero to match invoices to bank transactions?
No. Matching uses the bank and credit card statements you convert into the project. Convert the statements that paid the invoices into the same project and the suggestions appear in the invoices list.
How do I match all the invoices in a project at once?
On the project's Invoices/Receipts tab, click Review suggestions in the Bank matches bar. Strong matches are already selected; click Accept selected.
Can a single invoice match multiple bank transactions?
Yes. DocuClipper suggests an invoice paid in two to four payments that add up to its total when each one names the vendor. You can also select several transactions by hand in the invoice's matching drawer.
Can one payment match several invoices?
Yes. A payment that covers two to four invoices of the same vendor or customer is suggested as One payment, several invoices, and every invoice it covers shows the payment.
Why is an invoice not suggested?
The statement has no transaction with exactly the invoice total, in the right direction, within the invoice's date range, or several transactions fit and none names the vendor. Match it by hand from the invoice's Matching tab.
Is anything matched automatically?
No. DocuClipper only suggests; an invoice is matched when you accept the suggestion or create the match yourself.
How do I remove a match created in error?
Click Unmatch in the review panel, the trash icon in the invoice's matching drawer, or the unlink icon in the bank transactions' Invoice column.