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.

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