Free Excel template

Purchase Register Format: Free Excel Template + Example

A purchase register lists every purchase bill your business receives in a period, one row per bill. Each row has supplier GSTIN, invoice details, taxable value and GST. Download a free Excel format with a blank sheet and a filled example for a manufacturer.

Download the Excel template

A purchase register lists every purchase bill your business receives in a period, one row per bill. Each row carries the supplier name and GSTIN, invoice number and date, taxable value, CGST, SGST or IGST, and the invoice total. GST law does not fix one format, but your records must carry these details to support input tax credit. You must keep them for at least 72 months from the due date of the annual return. For a manufacturer, also add the PO and GRN number to each row, so every bill matches what was ordered and received.

What is a purchase register?

A purchase register is your list of every supplier bill: raw material, consumables, packing, services and capital goods. Don't mix it up with these three records.

RecordWhat it listsWhen a row is added
Purchase registerEvery supplier bill, with GSTWhen the bill arrives
Purchase order registerEvery purchase order you sentWhen you place the order
Purchase bookOften the same as the purchase register. Strictly, credit purchases of goods onlyWhen the bill is booked
Stock registerQuantity in, out and in hand for each itemWhen stock moves

Is a purchase register required under GST?

GST does not prescribe one purchase register format. But Section 35 of the CGST Act and Rule 56 require records of inward supplies and ITC. That includes a register of invoices, credit notes and debit notes received.

Electronic records, including Excel, are allowed. Entries should not be overwritten, and edits in electronic records must be logged. Ask your CA what applies in your case.

What each column in the purchase register format means

The template's 12 columns fall into four sets.

Bill and supplier details

ColumnWhat to enterWhy it matters
Bill dateThe date printed on the supplier's invoiceGSTR-2B matches on this date, not the day goods arrived
Invoice no.The number exactly as printed, with prefixes and slashesOne changed character turns a match into a mismatch
SupplierThe name on the invoiceHelps you find the bill fast
GSTINThe 15-character GSTIN. Blank if unregisteredITC is matched on the GSTIN

Copy these straight from the supplier's bill. Our purchase invoice format shows where each detail sits.

Value and tax

ColumnWhat to enterWhy it matters
Taxable valueThe amount before GSTThe base for every tax column
CGST and SGSTHalf the rate each, for same-state billsSame-state credit is split this way
IGSTThe full rate, for other-state billsOther-state credit sits here
Invoice totalTaxable value plus GSTShould equal the amount on the bill

Factory columns: qty, unit, PO no., GRN no.

ColumnWhat to enterWhy it matters
PO/GRN no.Your purchase order and goods received note numbersChecks the bill against what you ordered and what arrived
Item and qtyWhat was bought, how much, and in kg, nos or litreCatches short supply and kg-versus-tonne errors

No GRN format yet? Use our goods received note format.

Check columns: ITC eligible, GSTR-2B status, remarks

ColumnWhat to enterWhy it matters
ITC and GSTR-2B statusY or N for ITC, then Matched, Mismatch, Missing in 2B or Not applicable, with a short noteDecides which ITC you claim this month and who chases what

Mark ITC as N for unregistered suppliers and for items your CA lists as blocked. Need more detail? Add columns for HSN/SAC, GST rate and supplier state.

[[IMAGE {"type":"compare","title":"GST-only register vs manufacturer's register","columns":["GST-only register","Manufacturer's register"],"rows":[["Supplier and GSTIN","Yes","Yes"],["Invoice no. and date","Yes","Yes"],["Taxable value and GST","Yes","Yes"],["PO and GRN no.","No","Yes"],["Item, qty and unit","No","Yes"]]}]]

How TranZact handles the purchase flow

A spreadsheet register works until bills, POs and GRNs sit in different files. Then the same supplier, item, rate and tax get typed two or three times. Every retyping is a chance for a mismatch. The fault is the patchwork, not the person typing.

TranZact AI is manufacturing AI software used by 10,000+ manufacturers. Its purchase management runs the whole purchase flow.

TranZact purchase facts (as of 18 Nov 2026)

  • Purchase flow: MRP report → indent → RFQ → PO → GRN → payment, with vendor coordination.
  • TranZact's AI matches supplier invoices to the POs they belong to.
  • The MRP engine runs through your orders and BOMs, then tells you what to buy and when. See our bill of materials format.
  • Accounting stays in Tally. Operations run in TranZact, with one-way sync and no double entry. Busy and Zoho Books work too.
  • See pricing for what each plan includes.
  • Live in 2–3 weeks. Data is stored in India on AWS servers in Mumbai.

What TranZact does not do: your books and GST returns stay in Tally or your accounting software. The GSTR-2B check and ITC claim stay with your accountant or CA.

Book a demo →

How to fill the purchase register, step by step

  1. The bill arrives. Keep the supplier's invoice with its PO and GRN.
  2. Match it first. Check the rate against the PO and the quantity against the GRN. Settle any gap with the supplier before you enter the bill.
  3. Add one row per bill. Use one row per item if you track stock and rates.
  4. Fill the right tax columns. Same-state bill: CGST + SGST. Other-state bill: IGST.
  5. Give credit and debit notes their own rows. A credit note goes in minus values, linked to the original bill. Our purchase return guide covers the full flow.
  6. At month end, mark the GSTR-2B status for every row.
  7. Claim ITC on matched rows only. Hold the rest and chase the supplier.

Worked example: one month of purchases at an engineering unit in Pune

Here is October 2026 at a small machining unit in Pune, Maharashtra. It returned 100 kg of steel that failed inspection.

Illustrative numbers; HSN codes and GST rates are examples. Always use what is on your supplier's invoice.

Table 1 (Example): the register rows

BillTaxable value (₹)GST (₹)GSTR-2B status
SS/245 · Supplier A, Pune · MS round bar, 2,000 kg · PO-1041, GRN-22101,30,00011,700 CGST + 11,700 SGSTMatched
KT/1187 · Supplier B, Karnataka · Cutting inserts, 200 nos · PO-1045, GRN-221948,0008,640 IGSTMissing in 2B
CO/0912 · Supplier C, Pune · Cutting oil, 210 litre · PO-1046, GRN-222331,5002,835 CGST + 2,835 SGSTMismatch
112 · Supplier D, Pune (unregistered) · Wooden pallets, 20 nos · PO-1048, GRN-22266,0000Not applicable
CN-12 · Supplier A, Pune · Credit note on SS/245, 100 kg returned−6,500−585 CGST + −585 SGSTMatched

Table 2 (Example): the monthly summary

LineAmount (₹)Rows
Total taxable value2,09,000All five
Total GST on bills36,540All five
ITC claimable now22,230SS/245 less CN-12
ITC on hold14,310KT/1187 and CO/0912
No ITC0Bill 112, no GST charged

How to check your purchase register against GSTR-2B

GSTR-2B is the monthly statement on the GST portal of bills your suppliers have reported. Match each register row to it on five keys: supplier GSTIN, invoice number, invoice date, taxable value and tax.

StatusWhat it meansWhat to do
MatchedAll five keys agreeClaim the ITC this month
MismatchThe bill is in 2B, but one key differsCheck your entry first. If yours is right, ask the supplier to amend
Missing in 2BThe supplier has not reported the billHold the ITC and chase the supplier. Claim when it appears, within the GST time limit
Not applicableRows not checked the usual way, such as unregistered suppliers, reverse charge or importsFollow your CA's treatment for these rows

Common purchase register mistakes

  1. Using the purchase order register instead. A list of POs is not a list of bills. ITC rests on the bill.
  2. Typing the invoice number differently. "SS/245" entered as "245" will not match GSTR-2B.
  3. Not flagging the wrong tax type. If an other-state supplier charged CGST and SGST, note it and ask for a corrected bill.
  4. Entering bills with no GRN. You may pay for, and claim credit on, goods that came short or never came.
  5. Skipping credit notes. Your ITC ends up higher than it should be.

Use the template this month

Download the format and fill it for this month's bills. When PO, GRN and bill data start living in three places, see how TranZact carries them from order to payment.

Don't be the bottleneck. Become the AI-Run Factory.

Book a demo →

Frequently asked questions

Can I keep my purchase register in Excel?

Yes. GST allows electronic records. Keep a backup, don't overwrite old rows without noting the change, and check the register against GSTR-2B every month.

Should I make one row per bill or one row per item?

One row per bill is enough for GST. If you want to track stock and rates, use one row per item. The Excel template supports both.

Do I record purchases from unregistered suppliers?

Yes. Record every purchase bill. Leave GSTIN blank, mark ITC as N, and add a short note in the status column.

Where do purchase returns go?

Record the supplier's credit note (or your debit note) as its own row with minus values, linked to the original bill or GRN.

What does a manufacturer need beyond the GST columns?

PO number, GRN number, quantity and unit. They let you match every bill to what was ordered and received before you pay or claim ITC.

When is a spreadsheet no longer enough?

When bills, POs and GRNs sit in different files and the same data is typed two or three times. A manufacturing system that carries PO and GRN data forward and syncs to Tally removes that retyping.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.