Request a Demo
Manual Journal Entry vs Purchase Invoice: The Duplication That Inflates Expenses and Distorts VAT Input

Manual Journal Entry vs Purchase Invoice: The Duplication That Inflates Expenses and Distorts VAT Input

Manual Journal Entry vs Purchase Invoice

The silent duplication that inflates expenses, distorts AP balances, and exposes you to ZATCA penalties

One of the most widespread and impactful errors in financial reporting is when an accountant posts a manual journal entry for a purchase invoice that was already posted from the Purchases module. The result is a silent duplication that inflates expenses, doubles supplier balances, and distorts input VAT on the ZATCA return. Worse, this duplication often goes undetected until monthly reconciliation or even the annual audit, accumulating impact across multiple periods and corrupting management decisions built on flawed numbers.

This in-depth guide dissects the issue from its organizational and technical roots, quantifies the accounting and tax impact, and presents a full system of preventive ERP controls plus professional post-posting correction paths including detection methodology via Journal Entry Testing under ISA 240.

1) Root cause: multiple entry paths for one transaction

Every modern ERP offers two ways to record a purchase invoice in the ledger: the correct path through the Purchase Invoice module which auto-generates the JE and updates all sub-ledgers in sync, and the exceptional path through a manual JE that should be reserved only for transactions that cannot originate from operational modules. When both paths are used for the same invoice, duplication occurs and the GL becomes a distorted mirror of economic reality.

The organizational causes are many and interrelated: weak communication between Purchasing and Accounting, junior accountants unfamiliar with auto-posting logic, the mistaken belief that “entering a JE manually is safer than letting the system do it,” or unclear authorities allowing each function to touch another’s transactions. Time gaps between goods receipt, paper invoice arrival, and e-invoice delivery via Fatoora open “windows of ambiguity” that errors exploit.

In companies that recently migrated from a legacy accounting tool to an ERP, the risk multiplies because senior accountants are used to entering everything manually and continue doing so, ignoring that the new system already auto-posts from operational modules.

2) The auto-entry from the Purchases module

When a purchase invoice is registered in the Purchases module, the system auto-generates the following JE (example: SAR 10,000 plus 15% VAT):

Dr Expense or Inventory    10,000
Dr Input VAT    1,500
Cr Supplier (AP)    11,500
Narration: Booking supplier invoice #XXXX dated YYYY linked to PO #ZZZZ.

This JE simultaneously updates three sub-ledgers: AP Sub-ledger, Input VAT ledger, and General Ledger and updates PO status from “Received” to “Invoiced.” Any later manual duplication will hit the three sub-ledgers a second time without touching PO status, producing a detectable inconsistency through “invoices without linked POs” reports.

Mature systems also bind this entry to a Three-Way Match (PO + GR + Invoice). Any breach blocks posting and moves the invoice to “Pending Reconciliation” status.

3) When and why the parallel manual entry happens

From analyzing dozens of duplication cases in mid and large enterprises, the scenarios cluster as follows:

  • Visibility gap: The accountant never saw that the invoice was already booked and created a manual JE based on the invoice image emailed to them.
  • Draft invoice: Purchasing entered the invoice as Draft and didn’t post it; the accountant assumed it was missing and entered it manually, then Purchasing posted it later.
  • Wrong correction: The accountant wanted to fix an expense account they believed was wrong; instead of editing the original JE, they created a new full-value JE rather than just the correction differential.
  • Parallel systems: A legacy purchasing system and a new ERP without sync, so the invoice is entered in both with good intentions.
  • Re-post after wrong post: The accountant unposted from Purchasing then re-entered the JE manually instead of re-posting from the source module.
  • Closed-period JEs: Opening a closed period to enter a “late” invoice manually while it was originally posted in the correct period.
  • Foreign currency invoices: Manual entry at a different FX rate because the accountant couldn’t find today’s rate in the system.

4) Five-level accounting impact

Duplication doesn’t just distort one account its impact cascades across multiple accounts and reports:

  • Inflated expense: Expense shows at double its real value, artificially reducing net profit and corrupting Budget vs Actual comparisons.
  • Inflated supplier balance: A duplicate liability that may be paid twice by mistake, especially with suppliers issuing periodic statements.
  • Reconciliation breakdown: Supplier statement no longer reconciles with our books; unexplained differences consume hours of investigation.
  • Double input VAT: Tax that was never actually paid is deducted twice detected by ZATCA via auto-matching e-invoices with the return.
  • Inventory cost distortion: If the invoice relates to stock items, weighted-average cost inflates and item/customer/branch margins are corrupted.
  • Cost-center distortion: Duplicated cost on a single cost center skews manager performance evaluation and pricing decisions.
  • Liquidity ratio impact: Inflated AP artificially worsens Quick Ratio and confuses bank credit analysis.

5) Tax impact on the VAT return and Fatoora

Under Fatoora Phase 2 (Integration), ZATCA performs real-time matching between e-invoices issued by suppliers via the platform and input VAT claimed by the entity. Any duplication means input VAT is deducted twice for the same single e-invoice instantly flagged by ZATCA’s automated analytics.

Consequences the entity may face:

  • Mandatory return amendment and repayment of incorrectly deducted VAT.
  • Late-payment penalty of 5% per month on the unpaid tax.
  • Misleading-return penalty up to 50% of the VAT value under the Saudi VAT Law.
  • Subjection to a detailed five-year field audit.
  • Potential classification as a “high-risk” taxpayer, increasing future field visits.
  • Negative impact on obtaining the Zakat certificate, halting eligibility for government tenders.

6) Extended numerical case

A mid-sized trading company (annual revenue ~SAR 45M) received a supplier invoice for SAR 230,000 including VAT. Purchasing booked it on day 12; on day 14 the accountant manually posted the same amount without seeing the auto-entry because they lacked visibility permissions on Purchases-module JEs.

End-of-month duplication impact:

  • Expense showed at SAR 400,000 instead of 200,000.
  • Supplier balance showed at SAR 460,000 instead of 230,000.
  • Net profit dropped phantom SAR 200,000 (~12% of monthly profit).
  • Input VAT deducted: SAR 60,000 instead of 30,000.
  • On payment, finance nearly cut a second SAR 230,000 cheque caught only by the supplier during reconciliation.
  • Internal audit later found 7 similar cases the same quarter, totaling SAR 1.4M.
  • The quarterly VAT return would have overstated input by SAR 182,500, exposing the entity to a potential penalty exceeding SAR 90,000.

Corrective action: documented reversing JEs, voluntary VAT return amendment before audit, redesign of approval workflow for AP manual JEs, and permanent revocation of manual posting rights on the AP account.

7) Internal auditor detection methodology

Effective internal auditors rely on five detection pillars:

  • Journal Entry Testing: Filter all manual JEs touching supplier accounts and review them manually or with data-analytics tools (ACL/IDEA).
  • Monthly (not annual) AP sub-ledger reconciliation with supplier statements, with formal documentation of differences.
  • Duplicate Invoice Detection via composite fingerprint (Supplier ID + Invoice No + Amount + Date) with fuzzy matching for minor coding variations.
  • Suspicious-timing analysis: Manual JEs posted after 5 PM, on weekends, or in the last days of the period.
  • Volume reconciliation: Count purchase invoices in the Purchases module vs JEs in the AP account any gap signals parallel manual entry.
  • Benford’s Law analysis on manual JEs to detect anomalous digit patterns that may indicate fabrication.

8) Preventive ERP controls

  1. Block manual JEs on supplier accounts: Lock AP accounts to manual entry; updates only via the Purchases module and payment vouchers.
  2. Duplicate-invoice rule: Enforce (Supplier + Invoice No.) as a unique system key with instant rejection of duplicates.
  3. Segregation of Duties (SoD): Invoice creator ≠ approver ≠ payment-voucher issuer ≠ bank reconciler.
  4. Mandatory approval workflow: Any manual JE above a threshold (e.g., SAR 5,000) requires CFO approval; JEs above SAR 50,000 require dual approval from CFO and CEO.
  5. Fatoora integration: Link purchase invoices to ZATCA Phase 2 to prevent posting unauthorized invoices.
  6. Daily manual-JE report: Auto-sent to CFO and internal audit as part of the governance dashboard.
  7. Sub-period locking: Purchasing period locks after review; no later JEs without formal reopening and approval.
  8. Mandatory reference document for every manual JE: invoice number, PO, or calculation memo.

9) Post-posting correction under IAS 8

Professional correction is never by deleting the JE (forbidden post-posting per GL governance), but via a documented reversing JE:

Dr Supplier (AP)    11,500
Cr Expense or Inventory    10,000
Cr Input VAT    1,500
Narration: Reversal of duplicate manual JE #XXX dated YYY against supplier invoice #ZZZ per CFO-approved correction memo #MMM.

If the duplication occurred in a closed prior period, treat it under IAS 8 (Accounting Policies, Changes in Estimates, and Errors). If material, restate comparative periods and adjust opening retained earnings for the earliest period presented. If immaterial, correct in the current period with note disclosure.

Most importantly: don’t close the case with a correction JE alone add a Root Cause Analysis memo identifying the systemic or human gap and closing it to prevent recurrence.

10) Impact on bank reconciliation and supplier statements

Duplication doesn’t stop at the GL it spills into bank reconciliation if double-payment occurred before detection. A bank debit appears with no matching new invoice, left as an “open item” that accumulates month after month. When you approach the supplier to recover the duplicate, they may retain it as an advance on future purchases, complicating future reconciliations.

On supplier statements, an extra liability appears that the supplier doesn’t recognize, forcing recurring reconciliation disputes and burning hours on balances that shouldn’t exist in the first place.

11) KPIs for governance

Manual JE % of total JEs

Target: under 5%. Higher signals weak process automation.

Manual JEs on control accounts

Target: zero. Any movement here requires immediate investigation.

Supplier reconciliation differences

Target: under 0.5% of total purchases.

Duplicate invoices detected per month

Target: zero after enabling the unique-key rule.

Entry-to-approval lead time

Target: under 24 hours for material manual JEs.

VAT return deviation

Target: zero between Fatoora data and submitted return.

FAQ

Are manual JEs on supplier accounts ever allowed?

In principle no. Exceptions are adjustments like FX differences, late earned discounts, or write-offs all with clear references and CFO approval.

Who owns duplication: Purchasing or Accounting?

Shared responsibility, but governance places final accountability on Accounting as owner of the monthly close. The methodical fix isn’t finding blame it’s closing the systemic gap.

How do we prevent duplication when an invoice arrives in multiple formats (PDF + paper + electronic)?

Composite fingerprint (Supplier + Invoice No + Date + Amount) as a unique key, OCR auto-verification on attachments, and reliance on the Fatoora e-invoice ID as the trusted key.

Does the ERP detect duplication automatically?

Mature systems issue real-time alerts, but activation requires explicit rule configuration which many companies skip, fearing it will “slow down work.”

What if we discover duplication after the duplicate has been paid?

Formal communication with the supplier for refund, or agreement to offset future invoices for the same amount with a signed settlement memo.

Is accountant training enough to prevent the issue?

Training is part of the solution, not all of it. The root fix is in permission settings and mandatory system rules relying on human caution alone is a failed strategy.

Conclusion

Duplication between manual and auto-entries isn’t just an operational error it’s a governance gap requiring root-level treatment in permissions and system controls. Entities that govern their data-entry paths in effect govern their financial statements, tax compliance, and supplier relationships. Every manual JE on a control account must be treated as an exception requiring justification, not as acceptable daily practice. This is the mindset that separates mature finance functions from the rest.

Subscribe our Blog through email?