Sage Intacct's duplicate detection is a warning on bills that come through AP Automation. Bills that arrive any other way aren't covered.
Sage Intacct flags possible duplicates on AP Automation bills when the vendor, invoice number and amount match, but it warns rather than blocks and bills entered by hand or imported can bypass it. Export your AP bills and run four tests to catch what it misses.
For bills submitted through AP Automation, Sage Intacct compares the vendor, invoice number and amount with existing AP Automation bills. A match appears as an exception marked as a duplicate, for a reviewer to clear or reject.
It is a warning for review, not a block.
From Accounts Payable, list your bills for at least the last 12 months, including paid bills, with the vendor, bill number, date and total amount, and export the list to Excel or CSV. If you run several entities, export them together so a bill keyed in two entities can be compared.
Your system's own check compares fields exactly. Real duplicates usually differ in one small way, so test the export four ways:
The free Online Duplicate Invoice Checker runs all four on up to 1,000 lines in your browser, shows the value at risk and lists each flagged line next to the line it matches. Nothing is uploaded. If you prefer formulas, How to find duplicate invoices in Excel shows how to build the same tests yourself.
Route as many bills as possible through the same entry path so one set of rules applies, and agree that the vendor's invoice number is always keyed exactly as printed. Review duplicate exceptions before approval rather than clearing them in bulk, merge duplicate vendors, and keep the four tests as a regular check across all entities.
Hold every HIGH flag that is still unpaid until someone has compared the two documents. For REVIEW flags, confirm whether it is a genuine repeat charge and note why. If a duplicate has already been paid, ask the supplier for a refund or a credit note straight away and track it until the money is back: the duplicate payment audit guide covers the recovery steps.
Run the check before every payment run, not once a year. Duplicates are usually keyed weeks apart, so always include at least the previous 12 months of bills, not just the invoices in this run.
Sage Intacct uses "bills" and "vendors" in all regions. UK teams may call them purchase invoices and suppliers; the check is the same.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste or upload your invoice list and see likely duplicates in seconds. Runs in your browser; nothing is uploaded.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
No. Its duplicate detection marks possible duplicates for review on AP Automation bills; it doesn't block them.
Not by the AP Automation duplicate check. That is why a regular export-and-test check is worth running.
Export bills from all entities together and test them as one list, so the same bill entered in two entities is caught.
Last updated 03 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.