Skip to Content
ERPX Documentation — Your complete guide to the ERPX platform

Tax Reports

Go to: Financials → Reports → Tax Reports

ReportWhat it shows
Sales Tax ReportTax recorded on Sales Invoices
Purchase Tax ReportTax recorded on Purchase Invoices
Payment Tax ReportTax rows recorded against completed Payment Entries

Use the available fiscal year, party, tax, invoice, account, payment type, and status filters to match the reporting requirement. Reports can be exported to CSV and, where available, PDF.

Reconcile sales tax

  1. Run Sales Tax Report for the period.
  2. Compare it with Customer Tax Ledger.
  3. Review the tax account in General Ledger.
  4. Check returns and credit notes.
  5. Open source Sales Invoices for rate/account differences.

Reconcile purchase tax

  1. Run Purchase Tax Report for the period.
  2. Compare it with Supplier Tax Ledger.
  3. Review the tax account in General Ledger.
  4. Check returns and debit notes.
  5. Open source Purchase Invoices for rate/account differences.

Payment Tax Report

Use Payment Tax Report to review the individual taxes added to or deducted from completed payments. Each row represents one tax row from a Payment Entry. Non-tax charges, draft payments, and cancelled payments are not included.

Go to: Financials → Reports → Tax Reports → Payment Tax Report

Before you run the report

  • Confirm that the Payment Entry is Completed.
  • Confirm that its tax row uses a tax rule rather than a charge rule.
  • Confirm that the tax row has the correct GL account, rate, amount, and Added or Deducted treatment.
  • Ensure your role has the View Payment Tax Report capability.

Generate the report

  1. Select the Fiscal Year.
  2. Optionally select a Payment Type:
    • Pay for outgoing payments.
    • Receive for incoming payments.
  3. Select Generate Report.
  4. Select a Payment Entry number to open and review the source payment.

Report columns

ColumnMeaning
Payment EntryThe completed payment containing the tax row. Select it to open the payment.
Payment TypeWhether the payment was paid or received.
Customer / SupplierThe party associated with the payment.
Tax EntryThe tax rule applied to the payment.
Tax AccountThe GL account used to post the tax.
RateThe tax percentage entered on the payment.
Tax PaidThe tax amount converted to the organization currency.
TreatmentAdded increases the net bank amount; Deducted reduces it.

The summary cards show the total tax amount in organization currency and the number of tax rows returned.

Export and share

  • Select Export CSV for spreadsheet review and reconciliation.
  • Select Export PDF for a presentation-ready report. The PDF includes the company name, primary address, fiscal-year period, applied rows, and report total.

Reconcile payment tax

  1. Run Payment Tax Report for the fiscal year and payment type.
  2. Open the Payment Entry from the report and compare its tax rows.
  3. Verify the tax rule, account, rate, treatment, and amount.
  4. Review the tax account in General Ledger for the same period.
  5. Compare payment-related tax with Sales Tax Report, Purchase Tax Report, and the relevant party tax ledger when investigating a difference.

A payment can contain more than one tax row, so the same Payment Entry may appear multiple times in the report.

If an entry is missing

Check that the Payment Entry is completed, belongs to the selected fiscal year, contains a positive tax amount, and uses a rule configured as Tax. Also clear the Payment Type filter and generate the report again.

Reported tax follows approved transaction rows, accounts, dates, and returns. Confirm local filing rules separately; ERPX report names do not replace legal tax advice.