Every GSTR-1 needs the same thing: for each invoice, how much taxable value went out at 5%, 12%, 18% and 28%. If you run Zoho Books you already know the uncomfortable truth. No standard report gives you that. Not the Sales by Customer report, not the Tax Summary, not the GST reports, and not a customised report either.The return module gives you the answer, the template lets you verify it.
So most accountants do what I did for years. Export the invoice register, look at the taxable value and the tax amount, divide one by the other, and back into the rate. On a 300-invoice month that is an hour of error-prone arithmetic. Across several client organisations it is an afternoon every filing period.
This post explains why the reports never show the rate, where the data actually lives, and a free Excel template that turns a raw Zoho export into an invoice by rate matrix in one paste.
Why Zoho Books reports never show a tax-rate column
Zoho Books stores tax at the line-item level. Every line on an invoice carries its own tax rate and tax amount. The invoice itself only carries totals.
Reports in Zoho Books are built on invoice-level data. When you add a "Tax" column to a customised report you get the total tax on the invoice, not the rate. When one invoice mixes an 18% item with a 5% item, no invoice-level figure can tell you the split. The information is not lost, it simply is not exposed where you are looking.
Where the rate actually lives: the module export
The place that does expose line-item detail is the module export, not the Reports section.
1. Go to Sales → Invoices.
2. Open the ⋯ (more) menu at the top right of the list.
3. Choose Export and select the option that exports invoice data with line items.
4. Pick your date range and export as XLSX or CSV.
The file you get has one row per invoice line, and among the columns you will find Item Tax % and Item Tax Amount along with the taxable amount for that line. That is the exact data GSTR-1 wants. It has been sitting there the whole time.
The same route works for Sales → Credit Notes, which you need for the amendment and credit note tables of the return.
Turning the export into a return-ready matrix
The export is correct but shapeless: hundreds of line rows, several per invoice, in no useful order. What you want is one row per invoice, with columns for the taxable value at each rate, the tax at each rate, and a total that ties back to the invoice.
I built a reusable template that does this. You paste the raw export into a Raw sheet, and a Report sheet fills itself in:
• One row per invoice number with customer, date and GSTIN.
• Taxable value and tax split into 0%, 5%, 12%, 18% and 28% columns.
• A row total that must equal the invoice total, so mismatches show themselves.
• A Config sheet that locates columns by header name, so it does not break when Zoho reorders the export or when a client has extra custom columns.
How I use it in practice
The monthly routine now looks like this:
1. Export invoices with line items for the month.
2. Paste into Raw. Check the Report tab tie-out column shows zero differences.
3. Repeat for credit notes.
4. Reconcile the rate-wise totals to the GSTR-1 summary before filing.
The whole thing takes about ten minutes per organisation. The tie-out check has also caught a handful of genuine data-entry errors in client books, usually an item set up with the wrong tax rate, which would otherwise have gone straight into the return.
A note on what the template will not do
It will not fix a wrong tax rate on an item. If an item master says 12% when the product attracts 18%, the export will faithfully show 12% and the return will be wrong. Treat the rate-wise matrix as a review tool as much as a compilation tool. When a customer that normally buys at 18% suddenly shows a 5% column, that is the item master asking for attention.
Get the template
The Invoice Rate Bifurcation Template is free. Leave your email below and I will send the file along with a two-minute walkthrough. If you would like us to run the GST compilation for your organisation every month, that is a standard part of our Zoho Finance service.
