How to find duplicate payments in Xero and NetSuite
By Shiva Dhali · Updated
Xero and NetSuite both have controls against entering the same bill twice, but they depend on the reference matching exactly. Duplicate payments that differ by a prefix, a typo or a second vendor record go straight through. A periodic duplicate check on your exported payables data is the simplest way to catch them.
Exporting from Xero
In Xero, open Reports and use a payables report such as Payable Invoice Detail, or Account Transactions for your accounts payable account. Choose the date range, include contact, date, reference or invoice number and amount, and export to Excel or CSV.
If you have several Xero organisations, export each one separately. Duplicates rarely cross organisations, but each one needs checking.
Exporting from NetSuite
In NetSuite, the most flexible route is a saved transaction search filtered to Bills (or Bill Payments), with vendor, date, reference number, amount and subsidiary as result columns. Run it for your period and export to CSV or Excel. A standard AP report works too if it includes those columns.
Include the subsidiary column if you run several. The same vendor invoice paid by two subsidiaries is a classic duplicate.
What to look for
- The same invoice number written differently (INV-0042 versus 42).
- The same amount to the same vendor within a short window.
- One-character differences in invoice numbers or amounts.
- Two vendor records for one supplier.
- Bills with no reference number, which can't be matched at all.
Expect some false alarms: monthly retainers and subscriptions repeat the same amount on purpose. Check whether a credit note already reversed a duplicate before chasing it.
Recovering and preventing
- Send each vendor a short credit request listing both payments.
- Merge or archive duplicate supplier records.
- Make the invoice reference mandatory on bills.
- Run the check before each payment run, not once a year.
Common questions
- Which Xero report is best for a duplicate check?
- Any payables report that gives one row per bill with contact, date, reference and amount. Payable Invoice Detail is a good starting point.
- Can I check several NetSuite subsidiaries at once?
- Yes. Export them together with a subsidiary column so cross-subsidiary duplicates show up.
- Will recurring subscriptions show as duplicates?
- PaidTwice recognises legitimate recurring charges to keep those out of the findings.