# Bill Wise Tax Wise Sale
Sale invoice totals broken down by tax component — one row per bill with CGST, SGST, IGST, and other tax amounts for compliance and reconciliation.
Overview
Go to Sales → Reports → Bill Wise Tax Wise Sale.
Report title in ERP: Bill Wise Tax Wise Sale
What it shows. Each approved sale invoice with bill number, date, customer, payment mode, taxable value, and individual tax columns plus bill total.
When to use it. Use for GST/VAT filing support, tax reconciliation, and verifying tax amounts on invoices.
How amounts are calculated. Includes approved sale invoices within the selected date range. Cancelled invoices are excluded unless the status filter includes them.
Use Cases
- Tax filing — Export bill-wise tax breakdown for monthly or quarterly returns.
- Audit review — Verify IGST vs CGST/SGST split on interstate and intrastate sales.
- Finance reconciliation — Compare total tax collected against ledger tax accounts.
- Branch compliance — Filter by center to review tax reporting for a specific location.
Filters
Date, Status, Customer, Employee, Payment Mode, Center / Branch. Advanced Filter: Form Type, Customer Group, Supply Type.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Date | Sale invoice date. |
| Inv No. | Invoice number. Click to open the sale invoice. |
| Customer | Customer name. |
| Tax Reg. No | Customer GSTN or TRN valid on the invoice date. See Customers — tax registration numbers. |
| PayMode | Payment mode. |
| Center | Billing center or branch. |
| InCharge | Employee in charge. |
| Taxable Value | Amount subject to tax. |
| CGST | Central GST amount. |
| SGST | State GST amount. |
| IGST | Integrated GST amount. |
| Cess | Additional cess, if applicable. |
| Tax Amount | Total tax on the invoice. |
| Bill Total | Final invoice total. |
Actions
- Generate — run the report for the selected filters
- Export / Export All — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active filters
- Inv No. link — open the source sale invoice
FAQ
How is this different from Sale Report?
Sale Report shows general bill totals. This report adds a dedicated tax component breakdown per invoice.
Are credit notes included?
No. Use credit note or return reports for sales returns.
Why are some tax columns zero?
Only applicable tax types show values — intrastate sales use CGST/SGST; interstate sales use IGST.
Can I export for Tally?
Yes. Use Export or Export All to download in Excel format.
Does this include credit notes?
No. This report aggregates approved sale invoice tax lines. Use Sale Return Report for return tax analysis.
Why do tax totals not match the GL?
Confirm the date range and branch filters match your tax return period. Exports and cancelled bills may be excluded.