Accounts payable is where most money leaves the business, so it is where duplicate payments, price errors and supplier fraud are caught or missed. These guides cover invoice approval, three-way matching, payment runs, supplier records, accruals and month-end for AP teams, with Excel methods you can use straight away.
What 2/10 net 30 means, how to calculate the annualised value of an early payment discount in Excel, and how to decide whether paying early is worth it.
What common supplier payment terms mean, how to calculate the due date in Excel for each one, and how to manage terms consistently across your supplier base.
Find purchases split into smaller orders or invoices to dodge approval limits, with an Excel test for same-supplier, same-day spend just under a threshold.
The accounts payable KPIs worth tracking, how to calculate each in Excel from an invoice register, and how to use them without encouraging bad habits.
A step-by-step invoice processing checklist for accounts payable: receipt, validity, duplicate checks, matching, coding, approval and payment scheduling.
How a purchase order process works from requisition to payment, the controls at each step, and how to spot retrospective POs in Excel.
How to control non-PO invoices: a short exemption list, named approvers, Excel analysis of non-PO spend by supplier, and moving recurring spend onto POs.
A vendor debit balance means the supplier owes you, not the other way round. The six causes, how to find them in Excel and how to recover the cash or clear it.
How to calculate and post AP accruals at month end: sources of uninvoiced costs, Excel estimates, the journal, reversal and the accuracy review.
How to design a payment and invoice approval limits matrix: levels, dual approval, bank portal limits, and Excel formulas that flag approvals over limit.
How to run supplier statement requests: which suppliers to include, how often, a request email template, a tracking log in Excel, and the fraud checks to apply.
Find duplicate bills in QuickBooks Online: what its duplicate bill number warning misses, how to export your bills and the four tests to run.
Find duplicate bills in Xero: what Xero's duplicate bill warning compares, the near-duplicates it misses, and four tests to run on your export.
Find duplicate vendor bills in NetSuite: what the Duplicate Number Warnings preference does, what it misses, and four tests to run on a bill export.
Find duplicate supplier invoices in SAP: how the standard duplicate invoice check works in FI and MIRO, its gaps, and four tests to run on an export.
Find duplicate vendor invoices in Dynamics 365 Business Central: the setup that helps, its limits, and four tests to run on vendor ledger entries.
Find duplicate AP bills in Sage Intacct: what its duplicate detection covers, how bills entered other ways slip past it, and four tests to run.
Excel formulas that strip spaces, dashes, slashes and leading zeros from invoice numbers so duplicate tests catch invoices entered in different formats.
Use conditional formatting formulas to colour possible duplicate invoices and payments in Excel by supplier, amount and date, so reviewers see them at a glance.
Excel formulas for supplier payment due dates: net days, end-of-month terms, weekends and holidays moved to a working day, and grouping into payment runs.
Excel 365 formulas to review a vendor master: list shared bank accounts, find suppliers with missing details, and pull dormant or recently changed records.
A complete accounts payable controls checklist: vendor master, invoice entry, approval, payment run, bank detail changes and the review evidence to keep.
Find duplicate invoice numbers in Excel in three steps: COUNTIFS for exact repeats, a normalised key for near-matches, a date window for re-bills. Free checker.
Find and recover duplicate supplier payments from the last 12 to 24 months: what to extract, which tests to run, how to confirm and how to recover.
Clean up your vendor master: block dormant suppliers, merge duplicates, fill missing data, verify bank details and restrict who can change records.
Which accounts payable duties must be separated, why each combination is risky, a simple duties matrix, and compensating controls for small finance teams.
What to check before releasing a supplier payment run: totals, duplicates, bank changes, new suppliers, unusual payments and the bank file itself.
How to design an invoice approval workflow: an approval matrix by amount, PO and non-PO routes, and the tests that catch split invoices and self-approval.
How to read an accounts payable ageing report, reconcile it to the ledger, and spot debit balances, stuck invoices and overdue suppliers before they cost you.
A step-by-step accounts payable month-end checklist: cut-off, goods received not invoiced, supplier statements, debit balances and the ledger tie-out.
What a three-way match checks, how to set tolerances, what to do with exceptions, and a simple Excel layout that matches purchase orders, receipts and invoices.
GRNI meaning in plain words: goods received not invoiced is stock you hold but have not been billed for. How to accrue it, why it grows and a monthly clean-up.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
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.
The Invoice & Payment Fraud Defence Kit puts every payment through a Release, Hold or Pulled-from-run decision, with a bank detail change verification log, supplier checks, an incident log, a staff training record and a Fraud Defence Playbook (PDF). Excel, no macros, one-time price.
Payment Fraud · Month-End Close · Reconciliations · Cash & Credit · Fixed Assets · Expenses · Comparisons · Glossary
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.