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
Before You Run It
- Confirm the branch tax system, GST identity and item tax rates in Manage -> Tax.
- 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.
- Click Run. Posnic loads the monthly summary and purchase register from separate report requests, so wait for both areas.
- 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.
- Use CSV after reviewing exceptions. The export contains both the monthly summary and purchase-register sections.
Read the Monthly Working Paper
| Field | Meaning | Review |
|---|---|---|
| Output tax | Tax collected on sales for the month. | Tie to the sales tax report and outward-supply records. |
| Input credit | Purchase tax accepted by the report's eligibility rules. | Tie every material amount to a supplier invoice and external credit statement. |
| Net payable | Output remaining after permitted credit offsets. | A positive amount is the operational payment estimate, not a filed liability. |
| Credit carried | Eligible 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 pool | Applied first | Then | Never directly |
|---|---|---|---|
| IGST credit | IGST liability | CGST, then SGST | Not applicable |
| CGST credit | CGST liability | IGST | SGST liability |
| SGST credit | SGST liability | IGST | CGST liability |
Audit the Purchase Register
| Column or signal | What to verify |
|---|---|
| Purchase ID and date | Document exists, belongs to the period and has not been duplicated. |
| Supplier and Tax ID | Legal supplier identity and GSTIN/tax number agree with the invoice. |
| IGST / CGST / SGST or Total | Tax components match place-of-supply and invoice treatment. |
| ITC Yes / No | Only eligible purchases should feed the input-credit working total. |
| Invoice mismatch | Resolve differences between recorded and supplied invoice details before claiming credit. |
| Document | Open or obtain the supporting attachment; a missing document is an audit exception. |
| Status | Cancelled 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
- Run Tax Summary and Tax Payable for the identical branch and dates.
- Tie output tax to sales and outward-supply reports.
- Review every No, mismatch, missing attachment and missing supplier tax ID in the purchase register.
- Reconcile eligible invoices with GSTR-2B or the applicable external tax statement.
- Check component netting and carried credit month by month; do not compare only the grand total.
- 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.