Reports

Review Tax Payable, ITC Netting and the Purchase Register

Tax Payable is the deeper accounting control. It applies purchase ITC eligibility, calculates monthly payable or carried credit and exposes the supplier documents behind the input total.

Menu path
Reports -> Money -> Tax Payable
Verified from
Posnic demo and current POS source reviewed on 2026-09-08
Technical source evidence

Live demo Tax Payable route audited 2026-09-04, frontend/modules/taxPayable.html, frontend/static/script/js/core/PosnicPro.js taxpayable, api/src/controllers/sales.controller.js taxPayable and taxPayableRegister, api/src/utils/tax-netting.js, api/src/repositories/sale.repository.js

Tax PayableUse the Tax Payable tab for the monthly working paper and purchase-register review; allow the route to finish loading before reading its tables.
Cross-check with Tax SummaryRun Tax Summary for the same period, but do not assume its broad purchase-tax total equals eligible ITC.

Before You Run It

  1. Confirm the branch tax system, GST identity and item tax rates in Manage -> Tax.
  2. Open Reports -> Money -> Tax Payable and set the exact From and To dates. The initial range starts at the first day two months before today.
  3. Click Run. Posnic loads the monthly summary and purchase register from separate report requests, so wait for both areas.
  4. Confirm the regime note. A three-head GST profile uses IGST, CGST and SGST; a single-head or sales-tax profile changes the wording and columns.
  5. Use CSV after reviewing exceptions. The export contains both the monthly summary and purchase-register sections.

Read the Monthly Working Paper

FieldMeaningReview
Output taxTax collected on sales for the month.Tie to the sales tax report and outward-supply records.
Input creditPurchase tax accepted by the report's eligibility rules.Tie every material amount to a supplier invoice and external credit statement.
Net payableOutput remaining after permitted credit offsets.A positive amount is the operational payment estimate, not a filed liability.
Credit carriedEligible credit left after the month's offsets.Reconcile opening and closing carry-forward between periods.

GST Credit Netting Order

For a three-head GST profile, Posnic applies credit in the order implemented by its tax-netting engine.

Credit poolApplied firstThenNever directly
IGST creditIGST liabilityCGST, then SGSTNot applicable
CGST creditCGST liabilityIGSTSGST liability
SGST creditSGST liabilityIGSTCGST liability

Audit the Purchase Register

Column or signalWhat to verify
Purchase ID and dateDocument exists, belongs to the period and has not been duplicated.
Supplier and Tax IDLegal supplier identity and GSTIN/tax number agree with the invoice.
IGST / CGST / SGST or TotalTax components match place-of-supply and invoice treatment.
ITC Yes / NoOnly eligible purchases should feed the input-credit working total.
Invoice mismatchResolve differences between recorded and supplied invoice details before claiming credit.
DocumentOpen or obtain the supporting attachment; a missing document is an audit exception.
StatusCancelled purchases are excluded; investigate unusual or incomplete statuses.

Eligibility Rules Used by Posnic

  • Purchases explicitly marked ITC Eligible = No are excluded from input credit.
  • Cancelled receiving documents are excluded.
  • Older records with no ITC Eligible field are treated as eligible for backward compatibility, so they require manual review.
  • Tax component values come from saved documents; later item-rate changes do not rewrite historical liability.
  • The report is a working paper. It does not replace statutory portal matching, filing, payment or professional tax advice.

Reconciliation Routine

  1. Run Tax Summary and Tax Payable for the identical branch and dates.
  2. Tie output tax to sales and outward-supply reports.
  3. Review every No, mismatch, missing attachment and missing supplier tax ID in the purchase register.
  4. Reconcile eligible invoices with GSTR-2B or the applicable external tax statement.
  5. Check component netting and carried credit month by month; do not compare only the grand total.
  6. Export CSV, retain the supporting report pack and obtain accountant approval before filing or payment.

Troubleshooting

  • If the tab initially displays Rate, Tax, Net, Tax Amount, Gross and Lines, the Tax Summary view may still be visible while the Tax Payable module loads. Wait, click Run, then refresh once.
  • If monthly totals appear but the purchase register is absent, retry after confirming Report Read access and API connectivity.
  • If Tax Summary purchase tax exceeds Tax Payable input credit, first inspect ineligible and cancelled purchases; the two pages intentionally apply different purchase rules.
  • If component columns do not match expectations, verify the branch tax regime before changing transactions.