Core system · $497 · single-organisation licence

E-Invoicing Control & Reconciliation System

An e-invoice error is still an error. Now it is on record.

E-Invoicing Control & Reconciliation System: product box and Overview dashboard

Wrong VAT numbers, totals that don't add up and e-invoices that never reach the ledger, or reach it twice, cause rework and tax queries. As e-invoicing is phased in country by country, supplier master data that isn't ready causes rejections.

$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
Inside the system

Opens on a live dashboard

Headline figures, charts and an action list of what to fix first, then the tabs where the work happens. Shown here with the worked example that comes with your download.

E-Invoicing Control & Reconciliation System Overview dashboard

Real screenshot of the Overview tab. Every figure is calculated by the workbook.

The fix

How it solves it

This system matches every e-invoice received on your platform to your accounts payable ledger by supplier VAT number and invoice number, checks supplier master data against the country dates you record, and holds the review as Not clear until every exception is resolved.

9Tabs
300Supplier rows
1,000E-invoice rows
v1.3Build version

Replaces matching the platform's e-invoice report to the ledger by hand and the supplier readiness list kept in an email thread.

What it tests

Controls this system runs

  • E-invoice to ledger match — by supplier, through its VAT number in the supplier master, and invoice number, ignoring case, spaces and punctuation in invoice numbers.
  • Hard exceptions that can't be cleared — a duplicate e-invoice, net plus tax not equal to the total, or a VAT number not in your supplier master.
  • Supplier name check — an e-invoice name that differs from the master legal name, or adds words to it, is flagged.
  • Ledger tests — duplicate bookings, currency differences from the e-invoice and rejected e-invoices still needing follow-up.
  • Supplier readiness — each supplier is tested against the e-invoicing dates you record for its country, with a VAT prefix and country cross-check.
  • Review gate with independent sign-off — the gate shows clear only when every exception line is nil, and the reviewer who signs off cannot have posted any invoice in the review.
Built for

Who this is for

Built for accounts payable teams and finance managers handling e-invoices. Also included in The Controller's Vault and the Firm Licence.

Questions

Before you buy

How much does the workbook hold?

300 suppliers, 1,000 e-invoices and 1,000 ledger lines per review. Use one workbook per period.

Does it contain the e-invoicing rules for my country?

You record each country's VAT number format and e-invoicing dates on the Countries tab, and must confirm them with your tax authority. The VAT number check is a basic format check and does not prove a number is live.

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
Also in the catalogue

Other control systems

Accounts Payable Control

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

View system →

Invoice & Payment Fraud Defence Kit

The fraudulent email will look exactly like your real supplier.

View system →

Supplier Statement Reconciliation

The supplier's statement and your ledger never match, and the gap gets written off as "timing."

View system →

See all systems & The Controller's Vault