🛒 General Store – Simple Bill Book Excel Template |

🛒 General Store – Simple Bill Book Excel Template

Make Your General Store Billing Simple, Fast & Professional!

Managing daily billing in a general store can be time-consuming. With the AMS Services General Store Simple Bill Book, you can create professional customer bills, calculate totals automatically and maintain basic sales records using Microsoft Excel.

🌟 Key Features

🏪 1. Editable Shop Details

• Shop Name
• Shop Address
• Mobile Number
• Email Address

Add your own shop details once and use them whenever you create a bill.

🛍️ 2. Product & Category Suggestions

Choose from commonly used product categories:

• Grocery
• Dairy
• Snacks
• Beverages
• Personal Care
• Home Care
• Staples
• Spices
• Bakery
• Frozen Food
• Baby Care
• Other

📦 3. Ready Product Suggestions

Select common products from the dropdown, such as:

• Rice
• Wheat Flour (Atta)
• Sugar
• Salt
• Cooking Oil
• Dal
• Tea & Coffee
• Milk & Curd
• Bread & Biscuits
• Chips & Namkeen
• Soap & Shampoo
• Toothpaste
• Detergent
• Cleaning Products
• Noodles
• Cold Drinks
• Water Bottles
• Other

⚖️ 4. Unit Selection

Choose the suitable unit for your products:

• Kg
• Gm
• Litre
• Ml
• Pcs
• Packet
• Bottle
• Box
• Dozen
• Pack

💰 5. Automatic Bill Calculation

• Quantity × Rate
• Item-wise Discount
• Subtotal
• Additional Discount
• Grand Total
• Amount Paid
• Balance Due

💳 6. Payment Management

Select your payment method:

• Cash
• UPI
• Card
• Other

📊 7. Sales Register

Maintain your daily bill records in a separate Sales Register sheet.

🖨️ 8. Print-Ready Bill

• Professional cash memo format
• A4 printing layout
• Save your bill as PDF
• Suitable for daily retail billing

📂 What You Will Receive

1. Create Bill – Create customer bills.
2. Shop Settings – Add your shop details and product suggestions.
3. Sales Register – Maintain sales records.
4. Read Me – Easy user instructions.

File Format: Microsoft Excel (.xlsx)

🎯 Who Can Use This Template?

• General Stores
• Grocery Shops
• Kirana Stores
• Mini Supermarkets
• Daily Needs Stores
• Provision Stores
• Small Retail Shops

🚀 How to Use

1. Download the Excel file after purchase.
2. Open the file in Microsoft Excel.
3. Enter your shop details in Shop Settings.
4. Open the Create Bill sheet.
5. Select product and category suggestions.
6. Select the unit and enter quantity and rate.
7. Check the automatically calculated bill.
8. Print the bill or save it as PDF.

⚠️ Important Information

• This is a digital downloadable product. No physical item will be shipped.
• This is a simple non-GST cash memo template, not a GST Tax Invoice.
• GST calculations are not included.
• Automatic stock/inventory management is not included.
• Sales Register entries need to be copied manually.
• Product rates and quantities must be entered by the user.
• Microsoft Excel desktop is recommended.

Make Your General Store Billing Easier with AMS Services!