Tax and GST

Purchase register template with GST columns

A purchase register template with GST columns, a filled sample for a stationery shop and a reminder to confirm the tax tagging scheme with your CA.

Editorial illustration for Purchase register template with GST columns

A purchase register lists every supplier bill you receive, one row each, with columns for supplier, supplier GSTIN, bill number, base amount, tax, total, a tag and the date you paid. The layout below is for Excel or Google Sheets. How you tag each bill for tax is something your CA should decide, so the tag column is a note for them, not a ruling.

Which columns should it have?

  1. A: Bill date
  2. B: Supplier name
  3. C: Supplier GSTIN, copied exactly as printed
  4. D: Bill number
  5. E: Base amount, before tax
  6. F: Tax shown on the bill
  7. G: Total, with the formula =E2+F2
  8. H: Tag (for example Resale stock, Shop use, Check with CA)
  9. I: Paid date, or the word Unpaid

What does the sample look like for a stationery shop?

The suppliers and numbers below are invented. The GSTIN shown is a dummy; type the one on your actual bill.

DateSupplierGSTINBill noBaseTaxTotalTagPaid
02-Apr-26Sharma Paper Mart29XXXXX1111X1Z1SP/118₹24,000₹2,880₹26,880Resale stock10-Apr
05-Apr-26Lakshmi Pens29XXXXX2222X1Z2LP/0421₹9,500₹1,710₹11,210Resale stock05-Apr
09-Apr-26City Packaging29XXXXX3333X1Z3CP/77₹3,200₹576₹3,776Shop use09-Apr
14-Apr-26Sharma Paper Mart29XXXXX1111X1Z1SP/131₹18,000₹2,160₹20,160Resale stock25-Apr
18-Apr-26Neo Electricals29XXXXX4444X1Z4NE/902₹1,800₹324₹2,124Shop use18-Apr
22-Apr-26Kiran Notebooks29XXXXX5555X1Z5KN/55₹15,000₹750₹15,750Resale stock30-Apr
27-Apr-26Royal Furniture29XXXXX6666X1Z6RF/310₹6,000₹1,080₹7,080Check with CA27-Apr
29-Apr-26Lakshmi Pens29XXXXX2222X1Z2LP/0447₹7,200₹1,296₹8,496Resale stockUnpaid

Totals for the month: base ₹84,700, tax ₹10,776, total ₹95,476. That is 26,880 + 11,210 + 3,776 + 20,160 + 2,124 + 15,750 + 7,080 + 8,496. Only the last bill, ₹8,496, is unpaid.

How do you tag each row?

Tags give your CA a quick view of what each purchase was for. Use only a few and write them the same way each time. Resale stock for things you sell on, Shop use for things you consume or keep, Check with CA for anything you are unsure about, such as furniture or a mixed-use item. Your CA decides what each tag means for tax; do not assume it from the sheet.

Which formulas help?

  • Row total: =E2+F2
  • Unpaid total: =SUMIF($I$2:$I$500,"Unpaid",$G$2:$G$500)
  • Total from one supplier: =SUMIF($B$2:$B$500,"Sharma Paper Mart",$G$2:$G$500)
  • Tax shown on a month's bills, with the month start in L1: =SUMIFS($F$2:$F$500,$A$2:$A$500,">="&$L$1,$A$2:$A$500,"<"&EDATE($L$1,1))

Enter dates as real dates, not as text, or the month formula will return zero. Keep ranges like $A$2:$A$500 so new rows are included.

What if a bill has a mistake or no GSTIN?

Do not fix a printed bill with a pen. Ask the supplier to correct or reissue it, and keep the first copy until the new one arrives. If a supplier's bill shows no GSTIN, leave the column blank and tag the row Check with CA so it is not forgotten. The register should show what the document says, and the question goes to your CA, not into a guess.

What should you check on each bill?

  • Supplier name and GSTIN as printed.
  • Bill number, date and the total in figures and words.
  • Base and tax shown separately.
  • Your payment proof, filed with the bill.

Keep one sheet per financial year, from April to March, and copy the headers into a fresh sheet each April rather than extending last year's rows. Last year's file then stays as a closed record that you can hand over without worrying that a formula changed.

A weekly routine

  1. Add each new bill the day it arrives.
  2. Fill the paid date as soon as you pay.
  3. On Sunday, check the Unpaid lines.
  4. At month end, send the sheet and the bills to your CA.

If you also want your payments categorised, SpendixAI can read your bank statement and keep receipts, but it does not replace this register.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports