solobillPricing

Back to the blog

The invoice register your CA will ask for

2026-10-28 · 6 min read

An invoice register is a list with a separate row for each invoice, showing its number, date, client, GSTIN, taxable value, tax, total and status. Your CA wants it by GST financial year, from April to March, so they can review the period’s invoices together. Keep it in a sheet or export it from invoicing software, then check the rows against the actual invoices before sharing it.

What belongs in an invoice register?

The register is an index to your invoices. It helps someone find a document and understand its value without opening every PDF. It does not replace the invoices themselves.

Use clear column headings:

  • Invoice number: copy the complete number exactly as issued.
  • Invoice date: use the date printed on the invoice.
  • Client: enter a consistent client name.
  • GSTIN: copy it from the invoice where present; leave it blank where absent.
  • Taxable value: keep this separate from tax and the invoice total.
  • Tax: show the tax amount separately.
  • Total: record the final amount shown on the invoice.
  • Status: distinguish paid, unpaid and void invoices.

If an invoice has no GST, do not invent a tax amount to fill the column. Make the treatment clear to your CA. You can also keep payment status and document status in separate columns, which makes filtering easier.

Why does your CA want it by financial year?

The GST financial year runs from April to March. Grouping the register this way gives your CA a defined set of invoices to review.

They can compare the register with the documents you provide, ask about missing numbers and investigate totals that do not match. A consistent file also makes questions easier to answer: you can both refer to the same invoice number.

Use the invoice date when preparing the invoice register. Keep any payment date in a separate field. Otherwise, an invoice raised near the end of a GST financial year could disappear from that period’s list merely because the customer paid later.

Ask your CA what supporting records they need alongside it. A sales invoice register alone does not explain every entry in your business records.

What does an illustrative register look like?

This illustrative example uses five invoice rows. Each bullet follows the same column order: number; date; client; GSTIN; taxable value; tax; total; status. The amounts are invented for arithmetic only. They do not establish a GST rate or explain the treatment of any particular sale.

“Recorded” means the actual GSTIN would appear in the working file. It is a placeholder here.

  • A; 8 April; Client A; recorded; Rs 10,000; Rs 900; Rs 10,900; paid.
  • B; 12 April; Client B; recorded; Rs 20,000; Rs 1,800; Rs 21,800; unpaid.
  • C; 18 April; Client C; blank; Rs 5,000; Rs 0; Rs 5,000; paid.
  • D; 22 April; Client D; recorded; Rs 8,000; Rs 720; Rs 8,720; void.
  • E; 26 April; Client E; recorded; Rs 15,000; Rs 1,350; Rs 16,350; unpaid.
  • Totals, excluding the void row: taxable value Rs 50,000; tax Rs 4,050; total Rs 54,050.

The taxable values add up as Rs 10,000 + Rs 20,000 + Rs 5,000 + Rs 15,000 = Rs 50,000. Tax adds up as Rs 900 + Rs 1,800 + Rs 0 + Rs 1,350 = Rs 4,050.

The void row remains visible, but this example excludes it from the totals. The unpaid rows remain included. Payment status tells you whether money has arrived; it should not silently decide which invoices appear in the register.

How can you keep the register in a sheet?

Start with the columns above and use the same order throughout. Enter each issued invoice promptly, copying from the final document.

Store invoice numbers and GSTINs as text so the sheet preserves them exactly. Keep amounts in numeric cells, with currency formatting applied separately. This makes addition and filtering easier.

Use consistent status labels. Mixing “paid”, “received” and “settled” makes a simple filter less reliable.

Build totals that clearly state whether void rows are excluded. Avoid adding manually typed summary amounts beneath a growing list without checking the calculation range.

If several people help maintain the file, agree who adds invoices and who changes statuses. Before sharing a copy, save it with a clear GST financial year label.

What should you check before sending it?

Use this checklist whenever you prepare a register for your CA:

  • Confirm that the selected period covers the intended April-to-March GST financial year.
  • Compare the rows with your issued invoice records.
  • Investigate missing or repeated invoice numbers.
  • Check client names and GSTINs against the invoices.
  • Compare taxable value, tax and total with each document.
  • Confirm that void invoices are clearly marked.
  • Check that total formulas handle void rows as intended.
  • Keep unpaid invoices visible.
  • Open the file you will actually send and check that its columns remain readable.
  • Keep the supporting invoices ready for follow-up questions.

Common mistakes

A frequent mistake is treating the register as a list of money received. That can hide unpaid invoices and confuse invoice dates with payment dates.

Another is putting the full invoice total into the taxable value column. Keep those fields separate and copy each from the correct part of the invoice.

Deleting a void row also removes useful context. Preserve its number and status in the register, with its effect on totals clearly explained.

Finally, do not assume an export is complete just because it opened successfully. Check its period, columns and status labels. If a GST treatment is unclear, check the current notification, the official portal or a CA. Rules can change.

Can you export the register from software?

An export can reduce repeated typing, but review the resulting file before sending it. Check whether its filters and totals match the period and invoice statuses you intended.

The SoloBill web app, which is in beta, can download a GST register as a CSV file for a financial year, with one row per issued or void invoice.

FAQ

Is an invoice register the same as an invoice?

No. An invoice records an individual transaction. The register brings key details from your invoices into a list so you can find and review them.

Should unpaid invoices appear?

Yes, keep them visible and mark them unpaid. A register organised around invoices should not become a list containing only invoices for which payment has arrived.

Can I send a CSV instead of a sheet?

Ask your CA which format they prefer. Before sending a CSV, open it and check that invoice numbers, GSTINs and amounts have been preserved correctly.

Does this register replace GST return work?

No. It is a record to support review. Your CA may need other documents and explanations to assess the correct treatment and prepare the relevant work.

Last reviewed: October 2026. This is general information, not tax advice. Rules can change; check the current notification, the official portal or a CA for your circumstances.