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?
- A: Bill date
- B: Supplier name
- C: Supplier GSTIN, copied exactly as printed
- D: Bill number
- E: Base amount, before tax
- F: Tax shown on the bill
- G: Total, with the formula =E2+F2
- H: Tag (for example Resale stock, Shop use, Check with CA)
- 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.
| Date | Supplier | GSTIN | Bill no | Base | Tax | Total | Tag | Paid |
|---|---|---|---|---|---|---|---|---|
| 02-Apr-26 | Sharma Paper Mart | 29XXXXX1111X1Z1 | SP/118 | ₹24,000 | ₹2,880 | ₹26,880 | Resale stock | 10-Apr |
| 05-Apr-26 | Lakshmi Pens | 29XXXXX2222X1Z2 | LP/0421 | ₹9,500 | ₹1,710 | ₹11,210 | Resale stock | 05-Apr |
| 09-Apr-26 | City Packaging | 29XXXXX3333X1Z3 | CP/77 | ₹3,200 | ₹576 | ₹3,776 | Shop use | 09-Apr |
| 14-Apr-26 | Sharma Paper Mart | 29XXXXX1111X1Z1 | SP/131 | ₹18,000 | ₹2,160 | ₹20,160 | Resale stock | 25-Apr |
| 18-Apr-26 | Neo Electricals | 29XXXXX4444X1Z4 | NE/902 | ₹1,800 | ₹324 | ₹2,124 | Shop use | 18-Apr |
| 22-Apr-26 | Kiran Notebooks | 29XXXXX5555X1Z5 | KN/55 | ₹15,000 | ₹750 | ₹15,750 | Resale stock | 30-Apr |
| 27-Apr-26 | Royal Furniture | 29XXXXX6666X1Z6 | RF/310 | ₹6,000 | ₹1,080 | ₹7,080 | Check with CA | 27-Apr |
| 29-Apr-26 | Lakshmi Pens | 29XXXXX2222X1Z2 | LP/0447 | ₹7,200 | ₹1,296 | ₹8,496 | Resale stock | Unpaid |
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
- Add each new bill the day it arrives.
- Fill the paid date as soon as you pay.
- On Sunday, check the Unpaid lines.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


