Know your monthly GST in one spreadsheet.
Log each invoice and GSTbook splits CGST, SGST and IGST for you, then shows what you collected and what you owe this month. Works in Excel and Google Sheets. One-time price, no subscription.
No payment today. We email you once when it is ready.
| Invoice | Customer | Value | Supply | CGST | SGST | IGST | Total |
|---|---|---|---|---|---|---|---|
| INV-001 | Aarav Traders | 42,000 | Within state | 3,780 | 3,780 | – | 49,560 |
| INV-002 | Nova Studio | 1,20,000 | Other state | – | – | 21,600 | 1,41,600 |
| INV-003 | Kiran Foods | 18,000 | Within state | 450 | 450 | – | 18,900 |
| INV-004 | Patel & Sons | 76,000 | Within state | 6,840 | 6,840 | – | 89,680 |
| INV-005 | Urban Decor | 2,26,000 | Other state | – | – | 40,680 | 2,66,680 |
Preview of the planned sheet. Sample data.
Month-end, without the calculator
Built for registered shops, traders and freelancers who invoice from Word, Excel or a billing app.
Right tax split, automatically
Enter the invoice value and whether the sale is within your state or to another state. The sheet works out CGST + SGST or IGST.
See what you owe
A monthly summary shows sales, GST collected and GST payable, ready for you to compare with your return.
Never lose track of who has not paid
Unpaid invoices are listed and sorted by age.
What the sheet will include
Planned contents. We will update this as each part is finished.
- Invoice log with automatic tax split
- Monthly summary of sales and GST collected
- Unpaid invoice list
- Printable invoice sheet
- A short guide on how to use it
- Opens in Excel and Google Sheets. No macros, no add-ins
Three steps
Open the file
Download it after purchase and open it in Excel or Google Sheets.
Add your invoices
Enter your business details, then add each invoice as you issue it.
Check the summary
At month-end, open the Summary tab to see your totals.
Yours to keep. Not on sale yet.
- Invoice log, summary and unpaid list
- Printable invoice sheet
- No account, no subscription
Early-access signups get one email at launch. A bookkeeping aid, not tax advice.
Questions
Is this on sale now?
No. It is being built. Press the button, leave your email, and you will get one email when it is ready. Nothing is charged today.
Does it file my GST return?
No. It is a record-keeping and calculation aid. Always check your numbers with your accountant before filing.
Which GST rates does it use?
The current slabs, which you can edit. When rates change we update the file.
Excel or Google Sheets?
Both. Open the file in either. No macros or add-ins.
Do I need an account?
No. It is a file you keep, and your data stays in it.
Want it when it is ready?
Leave your email and we will write once, at launch.