Grocery Shop Invoice Format Preview

Grocery Store Bill Format in Word, Excel & PDF – Free Download

Searching for a ready-to-use and GST-compatible grocery bill format? Download free grocery invoice templates in Word, Excel, and PDF. Perfect for grocery stores, supermarkets, and kirana shops, these formats make day-to-day billing fast and professional.

Download Grocery Bill Format

Simplify Your Grocery Store Billing with a Ready-to-Use GST Bill Format

Billing for everyday grocery sales can get repetitive and error-prone. Our templates help reduce effort with clear formats that include GST calculations and product-level itemization. They are ideal for both large supermarkets and small local shops. Oil mills and flour mills that supply packaged staples to grocery stores can use it for their bulk bills too.

Download Free Grocery Bill Format in Word, Excel & PDF

Get your hands on the grocery bill format in Word for customization, Excel versions for entering items and reviewing tax and totals, or PDF formats for instant printing and sharing. All templates are clean, easy to edit, and fully functional for business use.

Grocery Shop Invoice Template-1

Grocery Shop Invoice Template 1 Preview

Grocery Shop Invoice Template-2

Grocery Shop Invoice Template 2 Preview

Grocery Shop Invoice Template-3

Grocery Shop Invoice Template 3 Preview

Kirana Store and Supermarket Bill Format

This grocery bill format suits kirana stores, grocery shops and supermarkets. Add items by weight or by piece, enter discounts, and show GST on each line. Use the sample bill below to see how a finished grocery bill looks.

Grocery Bill Format in Excel (Free Download With GST Columns)

A grocery bill format in Excel is an editable .xlsx file with item rows, CGST, SGST and IGST columns and a total. Download it, add your business name, GSTIN and items, then print the bill or save it as PDF.

ItemQty or weightRateDiscountTaxable valueGSTTotal
Enter detailsEnter quantityEnter rateEnter discountAmount before taxEnter taxFinal amount

How to make a grocery bill in Excel in 4 steps

  1. Download the grocery bill format in Excel.
  2. Enter your business name, address, GSTIN, bill number and date.
  3. Add each item with quantity and rate, and enter the tax.
  4. Save the bill as PDF or print it.

Key Components of a Grocery Store Bill

# Component Details
01 Shop Information Shop name, logo, address, and GSTIN (if applicable)
02 Customer Details Customer name and invoice number
03 Billing Information Billing date and mode of payment
04 Product List List of grocery items with quantity, price, and total
05 GST Calculation GST fields (CGST/SGST or IGST) with HSN codes
06 Payment Summary Subtotals, discounts (if any), and grand total
07 Terms & Contact Terms & conditions, contact details

Who Should Use This Grocery Bill Format?

Grocery Store Owners

Grocery store owners and cashiers looking for professional billing solutions.

Billing Software Users

Billing software users needing a printable template for backup or offline use.

Anyone Needing Free Templates

Anyone looking for a grocery invoice format free download or editable template.

Benefits of Using Our Grocery Bill Template

User-Friendly Layout with Editable Fields

Intuitive design with easily editable fields for quick customization.

GST-Ready Format with Automatic Tax Fields

Pre-formatted with CGST, SGST, IGST fields and HSN codes for full GST compliance.

Available in Multiple Formats

Download in Word, Excel, and PDF formats to suit your business needs.

Saves Time and Avoids Errors

Eliminates manual calculation errors and speeds up the billing process.

Ideal for Day-to-Day Billing

Perfect for daily grocery shop billing needs with high-volume transactions.

India's No.1 GST Billing & Accounting Software

Manage Grocery Billing Easily with BUSY Accounting Software

Lightning-Fast Billing with Barcode scanning

Auto E-Way Bill & E-Invoicing

Mobile App

Complete Accounting

Advanced Inventory Management

Auto Payment Reminders

1-Click GST Filing & Reconciliation

24*7 support

+91

* No credit card required

Found this useful? Add BUSY as a preferred source to see more of us on Google.

Frequently Asked Questions

Clear answers to common queries about this invoice format.

What Is a Grocery Invoice Format?

It's a structured format used for billing grocery items sold by shops or supermarkets. It includes product details, GST, totals, and payment info.

Can I Get Grocery Bill Format in Word?

Yes. You can download an editable grocery bill format in Word that suits any shop layout.

Is the Format Suitable for Supermarkets?

Absolutely. We also offer supermarket bill format that works for large-scale inventory billing.

Do You Provide Grocery Bill Format in Excel?

Yes. The grocery bill format in Excel is an editable file with GST columns (CGST, SGST, IGST). It does not calculate automatically, so enter the tax and totals yourself, then print the bill or save it as PDF.

Can I Share PDF Bills with Customers?

Yes. Use the grocery invoice format PDF to share or print instantly.

Is There a Sample Grocery Bill Available?

Yes. You can use the downloaded template as a grocery bill sample for reference and customization.

What’s the difference between a cash memo and a GST invoice?

A cash memo is a basic record of a cash sale and is not automatically a GST tax invoice. A GST invoice includes the supplier’s GSTIN, invoice number and date, item details, HSN code, taxable value, and applicable GST rate and amount, along with customer and place-of-supply details where required.

Does the grocery bill Excel template auto-calculate totals, weight-based pricing and discounts?

No. The current Excel template provides editable billing fields, but totals, weight-based prices, discounts and GST must be calculated and entered manually.

Is this bill format valid for GST filing and ITC claims?

This format can be used as a GST tax invoice after the required details are added. For a B2B invoice or ITC claim, replace “Cash” in the Billing Details section with the buyer’s legal name and add the buyer’s address and GSTIN. The item and tax sections must clearly show the applicable HSN codes, taxable values and GST amounts. If e-invoicing applies, the invoice must also display a valid IRN and signed QR code. 

The supplier must report the invoice through GSTR-1 or IFF for it to appear in the buyer’s GSTR-2B. The template supports invoice record-keeping but is not itself filed as a GST return.

Is there a kirana store bill format in Excel or Word?

Yes. The grocery bill format in Excel and Word works for kirana stores, grocery shops and supermarkets. Edit the item rows, rates and GST fields for your shop.

Explore Accounting & Billing Software for Small Businesses

Trusted by Industry Leaders

Ready to scale your business?

Join 6,00,000+ growing businesses who trust Busy for their financial management. Experience the power of professional accounting in the palm of your hand.

Start Free Trial
No Credit Card Required