01
Outlet Master
List every outlet once: code, city, state, State Code, GSTIN, and manager. Every other sheet links back to this single source, so a rename flows everywhere.
Free Multi-location Sales Consolidation Template for Indian Retail & F&B Chains
Roll up every outlet's sales into one group view. GST breakup, per-outlet contribution, ranking, and month-on-month growth, all in one Excel file. Updated for FY 2026-27.
- One month, one dashboard: total group sales, tax, and bills across every outlet
- Per-outlet contribution %, ranking, and month-on-month growth to spot leaders and laggards
- Built for India's per-state GST: consolidates for MIS while each state files on its own GSTIN
No spam. Instant download link to your
email.
Petpooja presents
Multi-location Sales Consolidation
For Indian Retail & F&B Chains
6
Sheets · Excel template
FY 2026-27
What's Inside
Six sheets that turn outlet data into one group view
02
Monthly Sales Entry
One row per outlet per month. Enter taxable sales split by GST rate (0 / 5 / 18 / 40), bills, and the cash and digital collection. Tax and totals calculate themselves.
03
Group Consolidation
Pick a month and see the whole group: total sales, tax, and bills, a per-outlet contribution table, rate-wise GST for each slab, and the cash-vs-digital-vs-credit split.
04
Outlet Performance & Ranking
Rank outlets by sales for the month, with month-on-month growth and each outlet's share of the group. The leaders and the laggards are obvious at a glance.
05
Worked Example (Filled Month)
A complete month across six outlets in four states, from the group total down to each outlet's share, so you can see exactly how the sheets fit together before entering your own data.
06
Instructions & GST Reference
A plain how-to for every sheet, a GST rate reference for the 0 / 5 / 18 / 40 bands, the colour guide, and a clear note on why each state files GST on its own GSTIN.
Why This Matters
Five Outlets, Five Spreadsheets, No Single Answer
Your Mumbai store manager sends a WhatsApp with the day's total. Pune sends a photo of a register. Ahmedabad exports a POS report. By the time you have added them up in your head, it is next week, and you still cannot say which outlet actually grew.
Running more than one location in India means running more than one set of books. Each state you operate in needs its own GST registration, so a chain across Maharashtra, Gujarat, and Karnataka is already juggling three GSTINs, three GSTR-1 filings, and three sets of totals, before anyone asks the simple question: how did the group do this month?
That question is where most multi-outlet owners lose time. Sales sit in separate places, in different formats, and consolidating them by hand is slow and error-prone. One mistyped figure and the group total is wrong. Worse, without a per-outlet view, a quietly declining store can go unnoticed for months while a strong one carries the average.
The other trap is compliance. It is tempting to add every outlet together and file one return. You cannot. GST is registered and filed state by state, on each state's GSTIN, using only that state's sales. A group rollup is for your own decisions, not for the GST portal.
This template keeps the two jobs separate and does both well. Enter each outlet's month once, and the group consolidation, the per-outlet ranking, the rate-wise GST, and the month-on-month growth build themselves, while a clear reminder keeps your state-wise filing honest.
Sample Preview
What the worked example shows for one group month
The built-in example rolls up six outlets across four states for July 2026:
Total Group Sales: ₹39,67,800 incl. GST across 6 outlets and
5,510 bills, average bill ₹720
Top outlet: Koramangala (Bengaluru) at ₹9,64,800, a 24.3% share
of the group. Smallest: Adajan (Surat) at ₹3,68,500, 9.3%
Rate-wise GST: ₹40,000 at 5%, ₹4,33,800 at 18%, ₹34,000 at 40%,
for ₹5,07,800 total tax, ready to reconcile against each state's filing
Collection mix: Cash ₹9,10,000 (22.9%), Digital ₹26,40,000
(66.5%), Credit ₹4,17,800 (10.5%) across the group
Month-on-month: every outlet's growth vs June, so Koramangala's
+8.8% and a slowing store both show up on the same screen
... plus the Outlet Master, the per-outlet contribution table, and the state-wise
GSTIN note, across 6 sheets.
Key Stats
The rules behind multi-state consolidation
1 per state
GST is registered state by state, so a business needs a separate GSTIN in every state it operates in. A four-state chain holds at least four GSTINs on one PAN, and files a separate set of returns for each.
Source: Section 22 & 25, CGST Act 20175 & 18%
GST now runs on two main slabs, 5% and 18%, plus a special 40% rate on sin and luxury goods, after the 22 September 2025 reform. The old 12% and 28% slabs were removed.
Source: GST reform effective 22-Sep-2025, Ministry of Finance (PIB)₹5 crore
E-invoicing is triggered by aggregate turnover across your whole PAN, not per outlet. Once the group crosses ₹5 crore, every outlet's B2B billing must carry an e-invoice.
Source: Notification 10/2023-Central Tax, CBIC
Common Mistakes
7 Multi-outlet Reporting Mistakes Indian Chains Make
01
Trying to file one GST return for every outlet
GST is filed state by state, on each state's GSTIN, using only that state's sales. Adding all outlets together into one return is non-compliant. Consolidate for management, file per state.
02
Judging outlets only by total sales
A big outlet with thin margins can hide behind revenue. Without contribution %, ranking, and month-on-month growth, a quietly declining store stays invisible while a strong one carries the average.
03
Consolidating by hand every month
Copy-pasting figures from five POS exports into one sheet is slow and easy to get wrong. One mistyped number and the whole group total is off, with no easy way to trace it.
04
Missing the aggregate turnover threshold for e-invoicing
E-invoicing is triggered by turnover across your whole PAN, not per outlet. Owners watch each store's number and miss that the group has crossed ₹5 crore, so every outlet should now e-invoice its B2B bills.
05
Treating an inter-state outlet sale as local
Each outlet charges CGST + SGST on sales within its own state. Stock transfers or deliveries across state lines are inter-state and attract IGST. Mixing these up distorts both the books and the returns.
06
No month-on-month comparison
A single month's numbers tell you what happened, not whether it is getting better or worse. Without a growth column, a slowing outlet only becomes obvious once it is a problem.
07
Not tracking the cash-vs-digital mix per outlet
An outlet running heavy on cash or piling up credit (udhaar) is a working-capital risk. Consolidating only revenue, and not the collection mix, hides where the money is actually stuck.
Comparison
Consolidation: By Hand vs This Template
| Aspect | Manual Consolidation | With This Template |
|---|---|---|
| Group total for a month | Add up five reports by hand | Rolls up the moment you set the month |
| Per-outlet contribution | Rarely calculated | Share % and ranking for every outlet |
| Month-on-month growth | Eyeballed, if at all | Auto growth column vs the prior month |
| GST rate split | Re-keyed per outlet | Rate-wise 0 / 5 / 18 / 40 for the group |
| State-wise filing | Easy to accidentally merge | Clear reminder to file per GSTIN |
| Cash vs digital vs credit | Lost in the totals | Collection mix for the whole group |
| Error risk | High, one typo skews the total | Formulas do the maths, you just enter |
See your whole group in one view
Download the free Multi-location Sales Consolidation Template and roll up every outlet in minutes.
FAQ
Frequently asked questions
Can I file one GST return for all my outlets?
No. GST is registered and filed state by state. A business needs a separate GSTIN in every
state it operates in, and each GSTIN files its own GSTR-1 and GSTR-3B using only that state's sales. This
template consolidates your outlets for management and MIS reporting, but you still file returns per state, on
each state's GSTIN.
How many GSTINs does a multi-state business need?
At least one per state you operate in, under Sections 22 and 25 of the CGST Act. That is the
minimum: since February 2019 a business may optionally hold more than one GSTIN within a single state for
separate places of business, but one per state is the baseline. All GSTINs sit on the same PAN, so the state
code (the first two digits of the GSTIN) is what differs. A chain across Maharashtra, Gujarat, Karnataka, and
Telangana holds at least four GSTINs. The Outlet Master sheet stores each outlet's state GSTIN so your
consolidation always maps to the right registration.
How does this template handle different GST rates across outlets?
On the Monthly Sales Entry sheet you enter each outlet's taxable sales split across the four
GST 2.0 bands (0%, 5%, 18%, and 40%). The sheet calculates the tax, and the Group Consolidation sheet adds up
a rate-wise view for the whole group. It reflects the structure after the 22 September 2025 reform, which
removed the old 12% and 28% slabs.
Does the ₹5 crore e-invoicing limit apply per outlet or overall?
Overall. E-invoicing is triggered by aggregate turnover across your whole PAN, not by any
single outlet. Once the combined turnover of all your outlets crosses ₹5 crore (the threshold since 1 August
2023 under Notification 10/2023-Central Tax), every outlet's B2B invoices must carry an e-invoice, even the
smaller ones.
Can I compare outlet performance month to month?
Yes. The Outlet Performance sheet ranks every outlet by sales for the month you choose, shows
each outlet's share of the group, and calculates month-on-month growth against the previous calendar month.
It is the fastest way to see which locations are pulling ahead and which are slipping.
About Petpooja
Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement Petpooja helps Indian businesses run better, every day.
See every outlet live, without the spreadsheets
Petpooja Invoice consolidates sales across all your outlets in one dashboard, with GST-compliant billing at each location and multi-location reporting built in. 8,000+ businesses bill on it.
Book a Free Demo
Call: +91-92279 80766