A supplier master review used to mean hours of sorting. Two functions now do most of it.
Export the supplier master to Excel. Use UNIQUE to list distinct bank accounts, tax numbers and addresses, COUNTIF to find any shared by more than one supplier, and FILTER to pull suppliers with missing details, no recent activity or recent bank changes into review lists that update automatically.
UNIQUE and FILTER need Excel for Microsoft 365 or Excel 2021 or later. Export the supplier master with at least: supplier code (A), name (B), bank account (C), tax number (D), address (E), status (F), last payment date (G) and bank details last changed (H). Format bank account and tax number columns as Text before pasting, so long numbers keep every digit.
Two supplier records paying into one bank account can be a duplicate record, a legitimate group arrangement, or a sign of fraud. List every bank account used by more than one supplier:
=LET(acc,C2:C3000,u,UNIQUE(FILTER(acc,acc<>"")),FILTER(u,COUNTIF(acc,u)>1,"None found"))
Then list the suppliers behind each shared account:
=FILTER(A2:B3000,C2:C3000=K2)
where K2 is one of the shared accounts. Do the same for tax numbers and addresses.
COUNTIF can treat long digit strings as numbers and compare only the first 15 digits. If your bank account numbers are longer than 15 digits, compare exactly instead: =SUMPRODUCT(--EXACT(acc,u)) for each value.
Active suppliers with any key field blank:
=FILTER(A2:F3000,(F2:F3000="Active")*((C2:C3000="")+(D2:D3000="")+(E2:E3000="")>0),"None")
Multiplying conditions means AND; adding them means OR. The result is a live list that empties as records are fixed.
Active suppliers with no payment for over a year are a target for misuse, because nobody notices a payment to them. With today's review date in a cell named ReviewDate:
=FILTER(A2:G3000,(F2:F3000="Active")*((G2:G3000="")+(G2:G3000<ReviewDate-365)>0),"None")
Block or deactivate them unless a buyer confirms they are still needed.
=IFERROR(SORT(FILTER(A2:H3000,H2:H3000>=ReviewDate-30),8,-1),"None")
Every change in the list should have a callback record: who was called, on which number from the file, and who approved the change. See callback verification.
Exact matches miss "ABC Supplies Ltd" and "A.B.C. Supplies Limited". Make a cleaned name column that removes punctuation and common words such as Ltd, Limited, Inc and LLC, then run the same UNIQUE and COUNTIF test on the cleaned names. Review each pair by hand: similar names are often genuinely different businesses.
Compare supplier addresses, phone numbers and email domains with your employee records as well as with each other. A match between a supplier and a staff member is not proof of wrongdoing, but it should always have an explanation and an independent approval on file.
Put each list on its own tab, paste the fresh export into the data tab each quarter, and record the outcome for each flagged supplier. Keep each quarter's file. The full process is in vendor master file clean-up.
UK suppliers are identified by VAT number and sort code plus account number; US suppliers by EIN or TIN and routing plus account number. Keep each part of the bank details in its own column so the comparison is exact.
Audits the supplier master file with an on-device AI and 28 tests: lookalike duplicates written differently, bank-detail changes before payments, vendors matching employees, and a risk score for every vendor. Runs in your browser on your own computer: nothing is uploaded.
Score a payment request against the warning signs of fraud. Free to use online.
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.
Use COUNTIF helper columns and filters on the data tab. It takes longer but gives the same lists.
No. Group companies or factoring arrangements can share one. Each case needs an explanation on file.
At least quarterly, and after any system change or bulk upload. Review bank detail changes every week before the payment run.
Last updated 04 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.