| Particulars | Amount (₹) | |--------------|------------| | | =SUM(CGST+SGST+IGST+Cess) | | Total ITC Claimed (B) | =SUM(Net ITC from above) | | Net Tax Payable (A-B) | =A-B | | Interest / Late Fee | | | Total Payment Due | |
Values of exempt, nil-rated, and non-GST inward supplies, alongside any payable interest or late fees.
His phone buzzed. It was his older cousin, Priya, a veteran Chartered Accountant. gstr-3b format in excel
"Did you find it?" Priya asked, checking in.
"You're still at the office?" Priya asked, surprised, as she picked up his call. "Did you find it
"Excel utility?" Rohan asked, sitting up straighter.
The portal auto-populated every single field—Table 3.1 (Outward Supplies), Table 4 (Eligible ITC), and the Cash Ledger details—all matched his Excel sheet perfectly. The portal auto-populated every single field—Table 3
Details of supplies made through e-commerce operators where the operator is liable to pay tax.
Within twenty minutes, a task that usually took him three hours was finished. He clicked the "Generate JSON" button in the Excel tool. He saved the file to his desktop.
| Particulars | ITC Available (₹) | ITC Reversed (₹) | Net ITC (₹) | |--------------|------------------|------------------|--------------| | On inputs | | | | | On input services | | | | | On capital goods | | | |