Article

Automating supplier invoices with OCR in your ERP

OCR reads supplier invoices into draft ERP records, matches them to purchase orders and sends only exceptions to a person. It works when built around your suppliers and Nigerian tax rules, with a person confirming before posting.

The short answer

OCR (optical character recognition) with AI field extraction reads a supplier invoice, creates a draft purchase invoice in ERPNext or Prometheus, matches it to the purchase order and receipt, and routes it for approval. Clean matches need a quick confirmation; people handle mismatches, duplicates and bad scans. A reliable automation win, if review, matching and tax fields are designed carefully. Posting without review is a new error source, not automation.

How it works in an ERP

  1. IntakeAccounts payable mailbox, scanner folder or upload screen.
  2. ExtractionSupplier, invoice number, date, lines, subtotal, VAT, any withholding tax, total.
  3. Draft recordA draft purchase invoice with the original file attached.
  4. MatchingAgainst purchase order and receipt; quantity, price and tax differences flagged.
  5. ReviewClerk confirms clean matches; mismatches, new suppliers, over-threshold go to an approver.
  6. PostingA person submits the invoice; payment is scheduled.
Demonstration, not a client project

Three invoices on a Monday morning

InvoiceWhat happens
A: regular packaging supplier, matches PO and receipt exactlyThe clerk checks the highlighted fields and submits it
B: freight company, no purchase orderRouted to the operations manager to approve and code
C: same supplier and invoice number as one entered last monthBlocked as a likely duplicate and flagged for review

The Nigerian details that matter

Generic OCR tools are often trained on US or European invoices. In Nigeria, capture must handle:

DetailWhat to design in
VATCharged at 7.5 % on most taxable supplies; some goods and services are exempt or zero-rated, and some suppliers show VAT only inside a total or quote VAT-inclusive prices. Capture the VAT amount separately where it appears and flag invoices where it is missing: your tax templates and any VAT you recover depend on it
Withholding taxDeducted at source on many supplier payments and remitted to the tax authority; the rate depends on the payment type and supplier. Capture the supplier category and let the ERP apply the rule at review, not fix it at payment time
Supplier tax detailsA valid tax invoice generally identifies the supplier and its tax identification number and shows the VAT charged, so missing details are flagged on arrival, not in an audit. Confirm the required details with your accountant, and whether Nigeria Revenue Service e-invoicing requirements apply to you or your suppliers

Local formats

Test on phone photos, WhatsApp images, poor scans, handwritten amendments, rubber stamps, mixed date formats.

Currencies

Naira (₦) with thousands separators, plus dollars or others for imports and cloud subscriptions.

Keep the original

PDFs too: attach to the ERP record, keep for the required period, back up.

An audit trail

Auditors and the tax authority expect source-to-records trails: who confirmed or changed each value.

Keep originals for the period your accountant and the tax authority require. Where power or connectivity is unreliable, run the backup somewhere other than the machine holding the originals. General information, not tax advice; confirm requirements with your accountant.

Rather talk it through? Send us a handful of real supplier invoices (with personal details removed) and we will show you how they would be captured, matched and approved in your ERP. Talk to a Promatics specialist

What usually goes wrong

Unclean supplier data

Duplicate suppliers and missing tax numbers make matching unreliable. Clean the list first.

No purchase orders

OCR saves typing but validates little. Decide which spending must have a PO.

Blind trust in confidence scores

A confident misread is still wrong. Always show total, tax and invoice number.

Ignoring the long tail

Handwritten invoices, poor scans, multi-page statements: give them a manual-entry route.

Unapproved processing

Many extraction services are cloud-based: know where documents are processed and stored.

Check that this fits the Nigeria Data Protection Act 2023, particularly if invoices contain personal data and are processed outside Nigeria (NDPC).

  • Monthly invoice volume known; how many arrive as PDF, photo or paper.
  • Our supplier list is de-duplicated, with tax identification numbers recorded.
  • We have decided which spending requires a purchase order.
  • Approval thresholds and approvers are agreed.
  • Key fields (total, VAT, invoice number, supplier) always shown to the reviewer.
  • Withholding tax treatment is agreed with our accountant.
  • Duplicate detection is tested.
  • We know where the extraction service processes and stores documents.
  • Originals are attached to the ERP record and included in backups.

How we build it

We collect your real invoices, agree what "done" looks like and choose extraction to suit your volume, document quality and data-location needs. Capture, matching and approval live in a separate custom app that survives ERPNext upgrades, tested on your own documents (awkward ones included), with failures alerting a named person, never failing silently. The same approach covers receipts, expense claims and other forms; see ERPNext and Prometheus customisation.

When to bring in help

A few dozen invoices a month from a handful of suppliers may need only a standard add-on or careful manual entry. Bring in help for high volumes, PO and receipt matching, VAT and withholding tax handled correctly, or an auditor asking how each invoice was checked. There, design, testing and accountability matter more than the OCR engine.

Sources and further reading

Product capabilities and guidance change. These are the primary sources this article relies on, checked on the review date above.

  1. Purchase Invoice, ERPNext documentation (Frappe)
  2. Nigeria Data Protection Commission, NDPC

This article is general information, not legal, accounting or security advice for your specific situation. Examples are hypothetical unless stated otherwise.

Talk to Promatics

Stop typing supplier invoices into your ERP

Accounts payable teams should work on exceptions, not data entry. Send real invoices and we will show capture, matching and approval in your ERP.

  • Tested on your own supplier invoices, not a demo set
  • VAT, withholding tax and PO matching designed in from the start
  • A person confirms before anything posts to your books