Check duplicate invoices before QuickBooks Online sync.
Duplicate invoice detection software for QuickBooks helps you check possible repeat submissions. Compare the source documents before approving another QuickBooks Online Bill.
Web uploads compare file fingerprints against files for the same client in your organization, including repeats in the current batch. When configured, email intake compares existing files across the organization before client assignment.
At approval, invoice fields are compared with up to 100 eligible other ScannerPilot documents for the same client. This can include documents under review, approved, syncing, already synced or marked duplicate; deleted documents are excluded.
Existing QuickBooks entries
Previously synced ScannerPilot documents can be comparison candidates. Entries created directly in QuickBooks or by other tools are not searched by these checks. Inspect existing accounting records separately before approving another Bill.
One supplier invoice, submitted twice for the same client. Compare the two sources, see the actual review-warning text and try the supported Mark duplicate action.
Duplicate review/Sample clientINTERACTIVE DEMO
COMPARE The evidence.
Incoming upload
Earlier for this client
SIGNAL
FieldIncoming uploadEarlier uploadComparison
SupplierIncomingNorthline Paper Co.EarlierNorthline Paper Co.Match
A photo and a PDF can describe the same purchase.Exact field match at approval
ACTUAL REVIEW WARNING · SAMPLE DATA
Possible duplicate
INV-2048.pdf
exact_match: Same vendor, invoice number, total, and invoice date.
The new scan has a different fingerprint. Its supplier, invoice number, date and total match the earlier same-client document, so approval returns “Exact duplicate detected.” without an override reason.
Your review comes before any sync.Fictional records · No live connection
Fictional documents in an illustrative layout. Warning text and action names reflect the product; the example uses no live QuickBooks connection and creates no accounting records.
LOOK AT THE DETAILS.Not just the filename.
Supplier01 / 05
Northline Paper Co.
A clue to compare. The decision is yours.
Illustrative field value
A MATCH IS MORE THAN A NAME
Read the invoice. Not its disguise.
ScannerPilot checks file fingerprints during upload and compares supplier, reference, date and amount at approval before QuickBooks Online sync.
Review normalizes supplier-name case, punctuation and spacing before comparing. Confirm the supplier against both originals.
An exact match needs the same normalized reference. A likely match can use equal or overlapping references, or a missing reference, alongside the other required fields.
Exact matches use the same invoice date. Likely matches allow dates up to seven days apart when the supplier, total and reference rules also match.
Review compares totals rounded to two decimal places. A matching amount alone does not trigger a match.
Upload checks compare the file’s checksum. Renaming an unchanged file preserves its fingerprint; a fresh scan can change it. This is separate from invoice-field matching.
SIMILAR ISN’T ALWAYS A REPEAT
Some bills repeat. For a good reason.
Same supplier. Same amount. Another month. A recurring invoice may be perfectly legitimate. Matching amounts alone do not trigger a field match. Check the reference, dates and original documents.
ILLUSTRATIVE BILLING PERIODS
AUGUST08INV-2048$1,248.00
SEPTEMBER09INV-2059$1,248.00
Same total. Different invoice. Worth checking.
A CLEAR NEXT STEP. EVERY TIME.
Less second-guessing. More considered decisions.
01
Spot the possible repeat.
Bring matching details into view before another record reaches your books.
Possible duplicate
02
Look at both documents.
Compare the source and the extracted details. Check anything that needs a closer look.
Evidence, side by side
03
Choose what goes next.
Use Mark duplicate for a confirmed repeat. An exact field match needs a Duplicate override reason to proceed with approval; sending to QuickBooks is a separate step.
Your approval comes first
A LITTLE MORE CLARITY
Good questions. Clear answers.
Duplicate detection, without the complicated explanation.
It is a check for documents that may represent a transaction you have already uploaded. ScannerPilot surfaces possible repeats before QuickBooks Online sync, so you can compare the evidence and decide what to do.
Which details does ScannerPilot check?
There are two checks. Upload checks compare file checksums. At approval, an exact field match requires the same normalized supplier, invoice number, invoice date and total. A likely match requires the same supplier and total, dates within seven days, and invoice references that match, contain one another or are missing on either document.
What if the same invoice has a different filename?
The filename is not the whole check. An unchanged file can have the same fingerprint after it is renamed. A new scan can have a different fingerprint, while its supplier, invoice number, date and total still point to the same transaction.
Will a recurring monthly invoice be treated as a duplicate?
The monthly example on this page does not meet the field-matching rules: its invoice numbers differ and its dates are more than seven days apart. A matching supplier and total alone are not enough. Compare billing periods and originals before approving any separate transaction.
Does a warning delete the invoice or stop a payment?
No. Treat a warning as a reason to investigate, not as an automatic verdict. This is a pre-sync document review workflow, not a payment-blocking service or a guarantee that every duplicate will be detected.
Does this audit every transaction already in QuickBooks?
No. Web uploads check files for the same client, including repeats in the current batch. Configured email intake checks existing files across the organization before client assignment. At approval, field checks compare up to 100 eligible other ScannerPilot documents for the same client, including previously synced documents. They do not query the historical QuickBooks ledger.
What happens when an exact field match is found?
Approval returns “Exact duplicate detected.” unless a non-empty Duplicate override reason is supplied. Compare the originals, then use Mark duplicate for a confirmed repeat. Only override after establishing why another accounting record is appropriate. Approval and sending to QuickBooks remain separate actions.
Can a duplicate still be missed?
Yes. Missing or differently extracted details, changed files and documents outside the eligible comparison set can leave a repeat undetected. Review the source and existing accounting entries. These checks do not provide historical duplicate cleanup, duplicate-payment recovery or guaranteed prevention of every duplicate.
Everyday paperwork. A clearer path.
REVIEW BEFORE ANOTHER ACCOUNTING RECORD
Check the source. Then decide what belongs.
Bring possible duplicates into focus. Keep your next QuickBooks entry considered.