MarCat

Purchase register format for a shop: columns, Excel formulas and the monthly GSTR-2B check

A purchase register format for a supermarket or grocery shop: the columns, Excel formulas, supplier totals, and how to match it with GSTR-2B every month.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 15 November 2026

Every supplier bill that comes into your store does two things. It adds stock, and it adds a bill you have to pay and claim GST on. The stock side lives in your stock register. The money and tax side lives in the purchase register.

When supplier bills are entered in stock and inventory management software, this register builds itself from the entries.

How to enter one supplier bill is covered in purchase bill entry. This guide is about the register as a whole: one row per bill, the format, the Excel formulas, the supplier-wise totals, and the one check every month that protects your input tax credit.

This is general information for a store owner, not tax advice. Your accountant decides how your books are kept.

The purchase register format

One row per supplier bill. Made-up numbers, an in-state regular store:

Entry date Supplier Supplier GSTIN Invoice no. Invoice date Taxable value CGST SGST IGST Bill total Due date Paid Balance
03-11 Supplier A 24AAAAA0000A1Z5 SA/1045 02-11 20,000 500 500 0 21,000 17-11 21,000 0
05-11 Supplier B 24BBBBB1111B1Z6 SB-778 05-11 10,000 900 900 0 11,800 05-12 0 11,800
09-11 Supplier A 24AAAAA0000A1Z5 SA/1102 08-11 15,000 375 375 0 15,750 23-11 5,000 10,750

Supplier names and GSTINs here are made up.

A few columns that are easy to skip and expensive to miss:

  • Supplier GSTIN, copied from the bill. One wrong character and the bill will not match on the portal.
  • Invoice number exactly as printed. "SA/1045" and "SA-1045" look the same to you, not to a search.
  • Both dates. The invoice date is the supplier's. The entry date is when the goods reached you. They are often different.
  • IGST column. A bill from a supplier in another state carries IGST instead of CGST and SGST. Keep the column even if it is usually empty.
  • Credit and debit notes as their own rows. A return to the supplier or a rate difference comes as a note. Enter it with its own number and a minus sign, and mention the original invoice.

The formulas

With taxable value in F, CGST in G, SGST in H, IGST in I:

  1. Bill total (J2): =F2+G2+H2+I2. Then check it against the total printed on the bill. A gap of more than a rupee of rounding means a wrong line.
  2. Balance (M2): =J2-L2.
  3. Overdue flag (N2): =IF(AND(M2>0,TODAY()>K2),"OVERDUE","").
  4. Duplicate check (O2): =COUNTIFS(C:C,C2,D:D,D2). Anything above 1 means the same bill was entered twice. This happens more than anyone admits, usually when a bill is re-sent on WhatsApp.

Supplier-wise totals

On a second sheet, list your suppliers in column A and add up what you bought, what you paid and what you still owe:

  • Bought this month: =SUMIFS(Register!J:J,Register!B:B,A2)
  • Still owed: =SUMIFS(Register!M:M,Register!B:B,A2)

From the example: Supplier A, bought ₹36,750, owed ₹10,750. Supplier B, bought ₹11,800, owed ₹11,800.

This one sheet answers the two questions a distributor's salesman always asks: "How much did you buy from us this month?" and "When will you clear the old bill?"

The monthly check: your register against GSTR-2B

This is the step most small stores leave to the accountant at the last minute, and the one that costs money when it is skipped.

What GSTR-2B is. On the GST portal, every registered person gets an auto-drafted statement called GSTR-2B. It is built from what your suppliers reported in their own returns, and it shows the input tax credit available to you. It is generated on the 14th of the month after the tax period. You do not file it. It is read-only, and you are expected to check your own records against it.

Why it matters. Section 16(2)(aa) of the CGST Act makes your input tax credit depend on the supplier having reported the invoice. A bill that is in your register but not in GSTR-2B usually means the supplier has not reported it yet, or reported it with a mistake.

How to check, step by step:

  1. After the 14th, download GSTR-2B for last month from the portal, or ask your accountant for it.
  2. In your register, filter last month's bills.
  3. Match each bill on supplier GSTIN + invoice number. Then compare taxable value and tax.
  4. Mark each row: Matched, Not in 2B, Amount differs.
  5. Look the other way too: anything in GSTR-2B that is not in your register.

What each result usually means:

Result Usual reason What to do
In register, not in 2B Supplier filed late, or used a wrong GSTIN Call the supplier with the invoice number. Tell your accountant
Amount differs Rate typed wrong by one side, or a discount handled differently Check the paper bill. Ask for a corrected document if needed
In 2B, not in register Bill not entered, or a bill for another business with a wrong GSTIN Find the bill. If it is not yours, tell the supplier

In Excel, put the GSTR-2B rows on a sheet named 2B, and in your register use:

=IF(COUNTIFS('2B'!A:A,C2,'2B'!B:B,D2)>0,"Matched","Not in 2B")

where column A on the 2B sheet is the supplier GSTIN and column B is the invoice number. Clean the invoice numbers first (same case, no extra spaces), or nothing will match.

Habits that keep the register clean

  • Enter bills the day the goods arrive, not when the accountant asks.
  • Never enter goods you have not received. Short supply gets noted on the bill.
  • Keep the paper or a scan of every bill, filed by month and supplier.
  • One person owns the register. Two people entering bills is how duplicates start.

Where software helps

A purchase register in Excel works for a few suppliers. When bills come in every day, the same bill is typed once for stock, again for the register, and again by the accountant. Software where one purchase entry updates stock, supplier balance and the purchase report at the same time saves the typing and most of the mismatches. The monthly GSTR-2B check is still a job for you and your accountant.

How MarCat handles it

We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. Supplier bills come in every day, so this is how MarCat treats them:

  • One entry, the way bills arrive. Purchase entry follows how a supplier bill actually arrives, and vendor records and outstanding balances stay in the same system.
  • Stock moves with the bill. Every purchase moves stock automatically, with batch, MRP and cost tracking.
  • Reports for the accountant. Purchase reports and GST-ready reports to download and hand over.
  • Your data. The store owns its data and can export it whenever it wants.

If you want to see a month of supplier bills in one place, message us on WhatsApp at +91 96787 65518.

Questions

What columns should a purchase register have?
Entry date, supplier name, supplier GSTIN, supplier invoice number, invoice date, taxable value, CGST, SGST, IGST, bill total, credit or debit note reference, payment due date, amount paid and balance. One row per supplier bill.
What is the difference between a purchase register and a stock register?
A purchase register lists supplier bills: who, which invoice, how much, how much tax. A stock register follows items: how many units came in, went out and are left. The same supplier bill feeds both.
What is GSTR-2B?
An auto-drafted statement on the GST portal showing the input tax credit available to you, built from what your suppliers reported. It is generated on the 14th of the month after the tax period. You do not file it; you check your own records against it.
What do I do if a supplier bill is in my register but not in GSTR-2B?
Tell the supplier and your accountant. Under section 16(2)(aa) of the CGST Act, credit depends on the supplier reporting the invoice. Often the supplier filed late or typed your GSTIN wrong.
Does MarCat keep a purchase register?
Purchase entry in MarCat follows how a supplier bill arrives, with vendor records and outstanding balances in the same system. Purchase reports and GST-ready reports can be downloaded for your accountant.