Option to link manual Journal Entries to VAT 201 return (input/output VAT mapping)

ERPNext Feature Requests
1

Problem statement:
Manual Journal Entries that book VAT (e.g., expense corrections, late supplier invoices, or adjustments) do not appear in the VAT 201 report, forcing duplicate work or non-standard workflows. Filing expenses via JE is often the simplest path operationally, but VAT compliance requires those entries to flow into VAT 201.

Proposed feature:

Add VAT 201 mapping on Journal Entry and JE Account rows:

    Fields: VAT type (Input/Output), VAT box code, Tax Rate, Taxable Amount, Tax Amount.

    Validate against company tax template.

Include a checkbox “Include in VAT Return” at JE level; when set, the entry is considered in VAT 201 aggregates for the relevant period.

Update VAT 201 report logic to pick up qualifying JEs based on posting date, company, and mapping fields, alongside Purchase/Sales Invoices.

Provide reconciliation view to see which JEs were included/excluded and why.

Benefits/use cases:

Enables compliant VAT filing when using JEs for expenses, accruals, or adjustments without re-entering data as purchase invoices.

Clear audit trail for tax authorities, with explicit VAT boxes and amounts tied to each JE line.
2

Hi @NeerajL

The JE is not advisable to record big vendor oriented expenses as Invoices can handle them efficiently with all possible scenarios.

VAT adjustments usually arise in cases like:

  • Input VAT disallowance / reversal (e.g., for entertainment expenses, non-business use).
  • Bad debt relief (recoverable after 6 months if conditions are met).
  • Error corrections (wrong VAT accounted earlier).
  • Year-end or periodic reconciliations to align with VAT return.

and that is why JE is not reflecting on VAT 201 because;

  • The Federal Tax Authority (FTA) requires adjustments to be reported in the VAT Return (Form 201) under the proper boxes (Output VAT Adjustments, Input VAT Adjustments, etc.).
  • A JV itself is not sufficient compliance — it’s only your internal accounting mechanism. You must ensure the amounts also reflect correctly in the VAT return period recorded through invoices/debit/credit notes mainly.
3

Hi @ahsantareen (again :smile: )

Really appreciate your responses on all my threads.

Absolutely makes sense, what you’ve stated, however, I’m not sure if everyone agrees but it’d be a lot easier to create just JE for smaller expenses like taking a customer to dinner rather than creating a whole PI for it.