Core system · $497 · single-organisation licence

Accounts Payable Control System

The first place a duplicate payment gets caught is the bank statement.

Same invoice, different reference. Same supplier, a slightly different amount. A bank account changed the week before a payment run, with nobody checking who changed it. Manual invoice review catches the obvious cases and misses the rest — and the rest is where the loss sits.

$497
One-time payment · single-organisation licence
  • Download links emailed within minutes
  • Blank master + worked example included
  • Excel (.xlsx) — no macros, no add-ins
  • Faulty file? Fixed or refunded — terms
The fix

How it solves it

This accounts payable control system runs four separate duplicate invoice detection tests, a set of supplier master fraud checks, and a three-way match against purchase order and goods receipt — on every invoice, every run, without anyone remembering to look. A payment run cannot be released while exceptions are open.

7Tabs
150Supplier rows
300Invoice rows
v1.3Build version

Replaces manual invoice review, the ad-hoc duplicate payment check and the supplier master spreadsheet nobody audits.

What it tests

Controls this system runs

  • Four duplicate-invoice tests — matching on reference, amount, supplier, and a near-match on date and value.
  • Supplier master fraud checks — shared bank account, shared tax ID, unauthorised bank detail changes, dormant-but-active suppliers.
  • Three-way match — invoice tested against purchase order and goods receipt.
  • Tax and arithmetic check — run on every invoice line.
  • Segregation of duties test — on invoice capture and payment run approval.
  • 18-line exception panel with release gate — payment runs are blocked from release while exceptions remain open.
Built for

Who this is for

Built for accounts payable managers, AP controllers, financial controllers and anyone who signs off a payment run.

Questions

Before you buy

How big a supplier and invoice population does it handle?

The workbook ships sized for 150 suppliers and 300 invoices per period, and every test is formula-driven across that range. It is built for a departmental AP run, not for a full ERP data dump.

Do I need Excel, or will it work in Google Sheets?

Every system is built as a standard Excel (.xlsx) workbook using formulas only — no macros, no add-ins, nothing to install. Because there are no macros, the files also open in Google Sheets and LibreOffice.

What happens straight after I pay?

Checkout is processed by Paddle. Within a few minutes of payment clearing, your download links are emailed automatically from info@appiqfinance.com. You get the blank master workbook and a fully worked example.

What if it doesn't do what this page says?

Report it within 14 days with the file, tab and cell, and we fix it and redeliver — or refund you in full if we can't. See the refund policy for the exact terms.

Free tool

Test your current process first

Run the free check on your own numbers today. If it finds gaps, this system closes them every period.

Duplicate Invoice Checker

Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.

Use the free tool

Lookalike Domain Checker

Check whether a supplier email comes from the real domain. Free to use online.

Use the free tool
Also in the catalogue

Other control systems

Month-End Close & Controls

Close finishes when the file gets sent, not when the numbers are proven right.

View system →

Credit Control & Receivables

Your cash is sitting in a customer's bank account, and nobody can say for how many days.

View system →

Cash Flow Forecasting

You find out you're short on cash the same week you're short on cash.

View system →

See all systems & The Controller's Vault