How to export Zoho Books data for a GST refund

Export sales invoices, purchase bills and the GSTR-2B reconciliation as separate files. Keep those originals, then add bank evidence and filed GST records to build the refund working.

This workflow is for an accumulated input tax credit (ITC) refund on service exports under a Letter of Undertaking (LUT).

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

Include unpaid, partly paid and adjusted invoices in the source review. Include older invoices if receipts in the proposed claim period relate to them.

2. Export purchase bills

1. Go to Purchases → Bills.
2. Open More and select Export Bills.
3. Choose the period and fields, then export as CSV, XLS or 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.

Use the free preparation pack for blank working templates and a receipt-allocation checker. Keep your Zoho exports as supporting sources for those working files.

Close the gaps left by an accounting export

An accounting export may still need bank realisation evidence and a review of the invoice issued to a foreign client. Use the books-versus-returns reconciliation example to explain differences before preparing your statement files.