01
Daily Sales Register
Enter one bill per row: date, taxable value, GST rate, and payment mode. CGST, SGST, IGST, and the invoice total calculate on their own. Sample rows are filled so you can see the pattern.
Daily Sales Report Template with GST Breakup, Free Excel for Indian Businesses
Record every bill of the day. The sheet splits CGST, SGST, and IGST automatically, reconciles cash against digital collections, and rolls up into GSTR-1 and GSTR-3B ready totals. Built on the current GST 2.0 rates. Updated for FY 2026-27.
- Enter taxable value and rate, get CGST, SGST, IGST, and invoice total instantly
- Type any date and see that day's sales, tax, and cash vs digital split
- Month-end view builds GSTR-1 rate-wise and GSTR-3B liability totals
No spam. Instant download link to your
email.
Petpooja presents
Daily Sales Report Template
For Indian Shops, Stores & GST Filers
5
Sheets · Excel template
FY 2026-27
What's Inside
Five sheets that turn daily bills into filing-ready totals
02
Date-Driven Daily Summary
Type any date and read that day's number of bills, gross taxable sales, total tax, average bill value, and a rate-wise breakup across 0, 5, 18, and 40 percent.
03
Cash vs Digital Reconciliation
Every day's collection splits across Cash, Card, UPI, Bank Transfer, and Credit. Match the cash figure against your drawer before you close, and spot any gap the same day.
04
Monthly Summary with GSTR Blocks
Pick a month and year for a day-by-day sales table, a GSTR-1 rate-wise summary, and a GSTR-3B output tax block showing CGST, SGST, and IGST payable for the month.
05
Worked Example (Filled Day)
A busy retail day filled in end to end, with notes on B2B vs B2C sales and Intra-State (CGST plus SGST) versus Inter-State (IGST). Use it as a reference while you set up your own.
06
Instructions + GST 2.0 Rate Reference
A quick-start guide plus the current GST slabs (0, 5, 18, 40 percent) after the 22 September 2025 rationalisation. The old 12 and 28 percent slabs are gone, so the reference keeps you on the right rate.
Why This Matters
The Nightly Tally Every Shop Owner Dreads
It is 9:30 pm. The shutter is half down, and you are adding up the day on a scrap of paper. Cash in the drawer, some UPI screenshots, a few card slips, and two customers who took goods on udhaar. The numbers almost match. Almost.
Thousands of Indian shop owners, from a kirana store in Pune to a garment shop in Surat, close the day this way. The trouble starts weeks later at GST filing time, when a plain total on paper cannot tell you how much was taxable, how much tax you collected, and how it splits between intra-state and inter-state supplies.
A daily sales report fixes both problems at once. Recorded properly, each bill carries its taxable value, its GST rate, and its tax split. Do that every day and your GSTR-1 and GSTR-3B almost write themselves at month-end, instead of turning into a frantic hunt through old bill books.
The GST split is where most manual registers go wrong. A sale to a customer in your own state carries CGST plus SGST, half each. A sale to another state carries the full tax as IGST. Record it the wrong way and your return does not reconcile, which is exactly the kind of mismatch that draws a notice. Keeping a clean GST return filing checklist alongside this report keeps the whole cycle on track.
Then there is the money itself. Cash that does not match the day's cash sales is either a billing slip or a leak, and you want to catch it that night, not at month-end. Digital adds its own puzzles, which is why card and UPI settlement reports so often disagree with the day's billing. This template separates Cash, Card, UPI, and Bank Transfer from Credit, so the drawer and the sheet tell the same story before you lock up. All GST rates follow the current GST 2.0 structure notified by the CBIC.
Sample Preview
What the summary shows for one day's sales
Here is the Daily Summary for the worked example, 07-Jul-2026:
Number of Bills: 8 sales recorded for the day, B2B and B2C
together
Gross Taxable Sales: ₹53,830 before tax, across the 0, 5, 18,
and 40 percent slabs
Total Tax Collected: ₹8,025 split as ₹2,032.50 CGST + Rs
2,032.50 SGST + ₹3,960 IGST
Total Collection incl. Tax: ₹61,855 with an average bill value
of ₹7,731
Cash vs Digital: Cash ₹3,512, Card ₹14,750, UPI ₹8,813,
Bank Transfer ₹25,960, and ₹8,820 still on credit
... plus the rate-wise GSTR-1 breakup and a monthly view that builds your GSTR-3B
liability across all 5 sheets.
Key Stats
The GST dates and penalties that make this worth it
11th & 20th
GSTR-1 (outward supplies) is due by the 11th and GSTR-3B by the 20th of the following month for monthly filers. Businesses under the QRMP scheme file quarterly, on the 13th and the 22nd or 24th. A clean daily report means every deadline is met without a last-minute scramble.
Source: CBIC, Rule 59 and Rule 61 of the CGST Rules, 2017₹50/day
Late fee for a delayed GSTR-3B: ₹25 CGST plus ₹25 SGST per day, or ₹20 per day for a nil return. It adds up fast, and it is fully avoidable when your monthly totals are already tallied.
Source: Section 47, CGST Act, 2017 with Notification 76/2018-Central Tax₹5 crore
Turnover above which e-invoicing is mandatory for B2B supplies. Below it, an Excel sales report like this is enough. Recording taxable value and tax daily makes the eventual switch painless.
Source: CBIC Notification 10/2023-Central Tax, dated 10-May-2023
Common Mistakes
7 Daily Sales Recording Mistakes Indian Businesses Make
01
Recording only the bill total, not the tax split
A single figure per sale cannot be filed. GSTR-1 needs the taxable value and the tax separately, rate by rate. Capture both at the point of sale, not by back-calculating weeks later.
02
Charging CGST plus SGST on an inter-state sale
A sale to a buyer in another state carries IGST, not CGST plus SGST. Getting the split wrong means your return will not reconcile with your customer's input credit claim.
03
Still using the old 12% and 28% rates
Since the GST 2.0 change on 22 September 2025, the slabs are 0, 5, 18, and 40 percent. The 12 and 28 percent slabs no longer exist. Old templates quietly carry the wrong rate.
04
Skipping nil-rated and exempt sales
A sale of loose pulses or fresh produce at 0 percent still belongs in your records. GSTR-1 has a nil-rated and exempt column, and leaving these out understates your turnover.
05
Mixing B2B and B2C without the buyer GSTIN
Registered buyers (B2B) report separately from walk-in customers (B2C) in GSTR-1. If you never capture the customer GSTIN on the bill, you cannot split them at filing time.
06
Never reconciling cash against the drawer
If the day's cash sales say ₹3,512 but the drawer holds ₹3,200, that ₹312 gap is a billing miss or a leak. Found on the day it is fixable. Found at month-end it is a mystery.
07
Waiting until month-end to compile everything
Thirty days of bills stuffed in a drawer become thirty days of errors to untangle. A few minutes of recording each evening turns filing into a copy-paste job.
Comparison
Daily Sales Tracking: Paper Register vs This Template
| Aspect | Paper Register | With This Template |
|---|---|---|
| Tax split (CGST/SGST/IGST) | Calculated by hand, often skipped | Auto-split from taxable value and rate |
| GST rates used | Whatever was memorised, often outdated | Current GST 2.0 slabs built in (0/5/18/40) |
| Daily total | Re-added every night | Type a date, totals appear |
| Cash vs digital check | Rarely reconciled | Split across Cash, Card, UPI, Bank, Credit |
| Month-end GSTR-1 prep | Hours of sorting bills | Rate-wise summary ready to copy |
| GSTR-3B liability | Worked out separately | Output CGST, SGST, IGST auto-totalled |
| B2B vs B2C separation | Hard to reconstruct later | Captured via customer GSTIN on each row |
Close every day with numbers that match
Download the free Daily Sales Report Template and walk into filing season already done.
FAQ
Frequently asked questions
What is a daily sales report and why does a small business need one?
A daily sales report records every sale made in a day with its taxable value, GST rate, tax
amount, and payment mode. For a GST-registered business it does two jobs: it reconciles your cash and digital
collections against what you actually billed, and it builds the rate-wise totals your GSTR-1 and GSTR-3B need
at month-end. Kept daily, it turns filing from a scramble into a copy-paste task. If you also want a
ready-made invoice format, our
GST Invoice Template Pack
pairs neatly with this report.
How is GST shown in this daily sales report?
You enter the taxable value and pick the GST rate. The template then splits the tax based on
the supply type. For an intra-state sale (buyer in your state), it charges CGST and SGST at half the rate
each. For an inter-state sale (buyer in another state), it charges the full rate as IGST. The invoice total,
CGST, SGST, and IGST columns all fill automatically, so you never split the tax by hand. You can read the
definition of a
GSTIN
and how the split works in our glossary.
What GST rates does the template use?
It uses the current GST 2.0 slabs that took effect on 22 September 2025: 0 percent (nil), 5
percent, 18 percent, and a 40 percent special rate for sin and luxury goods. The earlier 12 and 28 percent
slabs were removed in that rationalisation, so any older template still showing them is out of date. Always
confirm the exact rate for your goods against their HSN code. For a quick rate check on a single item, the
free GST calculator
is handy.
Does this help me file GSTR-1 and GSTR-3B?
Yes. The Monthly Summary sheet builds a GSTR-1 style rate-wise table (taxable value and tax at
each rate) and a GSTR-3B output tax block showing the CGST, SGST, and IGST payable for the month. These match
the figures you enter in the respective returns. Note the template shows output tax before Input Tax Credit,
so deduct eligible ITC on your purchases to arrive at net GST payable. Pair it with the step-by-step
GST Return Filing Checklist
so nothing slips past a deadline.
Can I track cash versus UPI and card sales separately?
Every bill is tagged with a payment mode: Cash, Card, UPI, Bank Transfer, or Credit. The Daily
Summary then totals each mode for the day, so you can match the cash figure against your drawer and see how
much is still owed on credit. This is also where you catch the classic problem of
sales that never quite match the money hitting your bank.
It works in Microsoft Excel, and in Google Sheets after a quick import. If you are weighing up a billing
system for a busy counter, our guide to
retail billing software pricing in India
is a good next read.
About Petpooja
Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across retail, restaurants, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.
Skip the nightly tally altogether
Petpooja Invoice bills with GST built in, records every sale as it happens, and gives you daily sales and tax reports without a spreadsheet. See your GST-ready sales reports update themselves.
Book a Free Demo
Call: +91-92279 80766