How to export Zoho Books data for a GST refund

Export three separate datasets from Zoho Books: sales invoices, purchase bills and the GSTR-2B reconciliation. Then add bank evidence and filed GST records outside Zoho. Combining everything into one spreadsheet too early makes differences harder to explain.

This workflow prepares source data for an accumulated-ITC refund on exports of services without payment of tax under LUT. It does not turn a Zoho export into a filing-ready Statement 3 or Annexure B automatically.

Before you export

Create a folder named for the GSTIN and proposed claim period. Record the Zoho organisation, branch or GST registration, export date, user and filters used.

Check that the proposed period is continuous and that you have not already filed a later overlapping claim. Period choice affects turnover, ITC and which invoices are available. See how to choose the refund period.

1. Export sales invoices

In Zoho Books:

1. Go to Sales → Invoices.
2. Open the More menu and choose Export Invoices.
3. Select the relevant date range and status.
4. Choose or create an export template.
5. Export as CSV, XLS or XLSX.

Zoho documents those formats and lets you control the date range, status and exported fields. It also offers a separate option to include sensitive PII; include only the fields your reviewer actually needs and protect the file appropriately. Zoho Books: export invoices.

Your template should retain at least:

Field	Why keep it
Invoice ID and invoice number	Stable trace back to the source record
Invoice date and status	Period and completeness checks
Customer and country	Export review and duplicate detection
Currency, exchange rate and totals	Reconciliation to books and filed values
GST treatment, place of supply and tax	Check how the outward supply was recorded
Credit-note or adjustment reference	Prevent gross and adjusted values being mixed
Payment status/reference	Useful lead, but not a substitute for bank evidence

Do not export only “paid” invoices. Statement 3 preparation needs an explainable population, including unpaid, partly paid and adjusted invoices.

2. Export purchase bills

Go to Purchases → Bills, open More, select Export Bills, choose the period and fields, and export CSV/XLS/XLSX. Zoho’s documented bill export provides the same kind of custom-template and PII controls. Zoho Books: export bills.

Retain vendor GSTIN, bill number/date, taxable value, tax by head, total, reverse-charge indicators, expense or asset account, currency and source ID. Export vendor credits separately or ensure they are included and identifiable.

The account name can suggest whether a purchase is an input service, input or capital good, but it is not a tax decision. Review the original document and accounting treatment. Capital-goods credit is excluded from Rule 89(4) Net ITC even when it is otherwise eligible; follow the capital-goods guide.

3. Export the GSTR-2B reconciliation

Zoho Books documents this path:

1. Open GST Filing and the relevant GSTIN.
2. Select the required GSTR-2B period.
3. Open Reconciliation.
4. Choose Export As.

Zoho notes that this export is currently available to organisation admins. Zoho Books: export GSTR-2B reconciliation.

Keep matched, partially matched, missing-in-books and missing-in-GSTN statuses. Do not convert every match into eligible refund credit. Annexure B still needs eligibility, reversals, category and actual availment review. Use GST returns vs Zoho Books for the reconciliation logic.

4. Add the records Zoho cannot establish

Create a separate index for:

• filed GSTR-1 and GSTR-3B, including amendments;
• GST portal GSTR-2B downloads for the relevant periods;
• Electronic Credit Ledger and earlier refund claims;
• export invoice PDFs and credit/debit notes;
• bank statements, advice and BRC/FIRC evidence;
• an invoice-to-receipt allocation; and
• LUT acknowledgement and other applicable claim documents.

An accounting “paid” flag does not prove foreign-exchange realisation or allocate one receipt across invoices. Build that mapping with the Statement 3 worked example.

5. Reconcile before converting formats

Add source keys to every working row: Zoho ID, invoice number, return reference, bank reference and reviewer note. Keep the source exports unchanged and do transformations in a new working file.

Your hand-off is ready when sales tie to filed outward supplies, purchases tie to 2B/GSTR-3B or a documented exception, receipts tie to invoices, and every exclusion has a reason.

This is also the workflow Fast GST Refund is being built to automate: preserve the source exports, perform the matching, keep exceptions visible, and prepare the calculation and statement outputs in one workspace. Early access is not open yet, and there is no live Zoho connection today. Start with your claim to see the relevant workflow, or use the refund tools comparison for a route available now.