01
Monthly Entry (12 Months)
One row per month, April to March. Enter sales, other income and six expense heads. Total income, expenses, profit and margin fill in for every month on their own.
Annual Financial Summary Template Free Excel for Indian Businesses
Roll up a full financial year, April to March, into one clear view: sales, expenses, gross and net profit, margins, and a GST summary, all on connected sheets. Updated for FY 2026-27.
- Enter 12 months once, get whole-year profit, margins and a GST summary automatically
- Every figure net of GST, with tax collected and input credit tracked on their own
- Best and worst months, cumulative profit, and a year-end view ready for loans and planning
No spam. Instant download link to your
email.
Petpooja presents
Annual Financial Summary Template
For Indian Businesses
5
Sheets · Excel template
FY 2026-27
What's Inside
Everything inside your year-end summary
02
Annual Summary Dashboard
Your whole year on one page: income, cost of goods, every expense head, and net profit. It rolls up from your monthly entries, so it updates the moment you change a number.
03
Gross & Net Profit Margins
Gross profit after cost of goods, net profit before tax, and both margins as clean percentages. See exactly how much of every rupee of sales you actually keep.
04
GST Summary (Output minus ITC)
Total GST collected on sales, total input tax credit on purchases, and the net GST paid to the government for the year. Kept fully separate from your profit.
05
Monthly Trend & Highlights
Revenue, expenses, profit and a running cumulative profit, month by month. The sheet flags your best and weakest months so the seasonal shape is obvious.
06
Worked Example + Instructions
A fully filled FY 2026-27 for a sample retail store, plus an instructions sheet explaining every figure, the colour code, and the golden rule: enter everything net of GST.
Do all of this automatically with Petpooja Invoice
Petpooja Invoice records every GST bill as you raise it, so your sales, the tax you collect, and your input credit add up on their own. Your year-end summary is ready without copying a single figure into a spreadsheet.
Explore Petpooja Invoice
Why This Matters
The Year-End Scramble Every Indian Business Owner Knows
31 March closes the books. Your CA asks for the year's numbers, the bank wants a summary for your loan, and you are staring at twelve months of GST returns, bank statements and a billing app that never quite agree.
Most Indian SME owners, from a garment store in Surat to an electronics dealer in Jaipur, never see their full year in one place. They know roughly what sales were. They are far less sure what the business actually earned after every cost.
The confusion usually starts with GST. Tax you collect on a sale is not your income, and tax you pay a supplier is not your expense. Mix those into your revenue and your turnover looks bigger and your profit looks wrong. This template keeps GST in its own summary, so what you read as profit is really profit.
Then there is the gap between sales and profit. A ₹1.5 crore year can leave ₹7 lakh in the bank or almost nothing, depending on cost of goods, rent, salaries and marketing. Without every cost in one view, you are guessing at the number that matters most.
This template fixes the shape of the problem. Enter each month once, net of GST, and the Annual Summary rolls up income, cost of goods, every expense head, gross and net profit, and both margins. A separate GST summary shows tax collected, input credit and net GST paid. The Monthly Trend shows the seasonal pattern and flags your best and weakest months, so next year you plan instead of scramble.
Sample Preview
What the summary shows for a ₹1.5 crore retail year
Here's a preview of what you'll get inside:
Total Income (net of GST): ₹1,50,02,000 for the year, rolled up
from 12 monthly entries of sales and other income
Cost of Goods Sold: ₹1,07,64,000, leaving a Gross Profit of
₹41,86,000, a 28% gross margin
Operating Expenses: ₹34,86,000 across salaries, rent, utilities,
marketing and other costs
Net Profit (before tax): ₹7,52,000, a 5.0% net margin, about
₹62,666 a month, highlighted in green
GST Summary: ₹22,42,000 collected on sales, less ₹16,57,000
input credit = ₹5,85,000 net GST paid, kept out of the profit
... plus a month-by-month trend, running cumulative profit, and best and weakest
months flagged (October is the Diwali peak at ₹16,50,000), across 5 connected sheets.
Key Stats
The year-end numbers every business faces
1 Apr to 31 Mar
India's financial year. Every business summarises income and expenses on this cycle for income tax and the GST annual return, not the calendar year.
Source: Income Tax Act 1961, financial year definitionUp to 24
Monthly GST returns a regular taxpayer can file in a year (GSTR-1 and GSTR-3B), plus the annual GSTR-9. One clean summary keeps all of it reconciled.
Source: CBIC, GST return filing framework₹2 crore
The GSTR-9 annual return is optional for turnover up to ₹2 crore and mandatory above it. A year-end summary makes filing straightforward either way.
Source: GST Portal, CBIC GSTR-9 exemption notification
Common Mistakes
7 Year-End Mistakes Indian Businesses Make
01
Counting GST as income
The tax you collect on a sale belongs to the government, not to you. Add it into revenue and your turnover and your profit both look bigger than they really are.
02
Treating input GST as an expense
Input tax credit reduces the GST you owe, it is not a business cost. Put it in your expenses and you understate profit while double-counting the tax.
03
Using the calendar year, not the financial year
India's financial year runs April to March. Summarise January to December and your figures will not line up with your GST returns or your income tax return.
04
Tracking sales but never expenses
Plenty of owners know their monthly sales by heart and have no idea of total costs. Sales are not profit, and without every expense head you are flying blind.
05
Leaving out annual and non-cash costs
Depreciation on equipment and interest on a loan are real costs. Ignore them and a business that looks profitable may barely be breaking even.
06
Never looking month by month
A single annual total hides the story. Without a monthly trend you miss the festive peak and the lean months, and you staff and stock for the wrong ones.
07
Rebuilding the year at the last minute
Reconstructing twelve months from GST returns and bank statements the night before a CA meeting is how errors creep in. Enter each month as you close it instead.
Comparison
Year-End Summary: From Scratch vs This Template
| Aspect | Building it from scratch | With this template |
|---|---|---|
| Time to compile the year | Days of digging through returns and statements | Enter each month, the year is ready anytime |
| GST vs revenue | Easily mixed into sales and profit | Kept separate by design, profit stays real |
| Profit visibility | Only at year-end, if at all | Every month, with running cumulative profit |
| Expense coverage | Some heads quietly forgotten | Six expense heads, same structure every month |
| Best and worst months | Worked out by hand, if ever | Flagged automatically on the trend sheet |
| Consistency | Formulas differ across tabs | One locked structure, every figure traceable |
| Loan or CA readiness | Rebuilt from scratch each time | One clean page, ready to share |
See your whole year on one page
Download the free Annual Financial Summary Template and close your year without the scramble.
FAQ
Frequently asked questions
What is an annual financial summary?
It is a management view of your full financial year on one page: total income, every expense
head, gross and net profit, your margins, and a GST summary. It is built for a year-end review, a loan or
bank application, and planning the next year, not for statutory filing.
Is this the same as a Profit & Loss statement I can file with my ITR?
No. This is a management summary and it shows net profit before tax. Your statutory Profit
& Loss statement and your income tax return are prepared by your CA, with depreciation, interest and tax
treated formally. Use this template to understand your year and to hand your accountant clean, organised
numbers.
Should I enter figures with GST or without?
Enter everything net of GST, the amount before tax. GST you collect on sales is not your
income and GST you pay on purchases is not your expense. The template tracks tax separately in its GST
summary (output GST, input credit, and net GST paid), which keeps your profit figure accurate. If your figures are GST-inclusive, a free GST Calculator helps you split out the tax and the net amount.
What is the financial year in India?
The Indian financial year runs from 1 April to 31 March. FY 2026-27 means April 2026 through
March 2027. This template is laid out on that cycle so your summary matches your GST returns, your books and
your income tax filing.
Do I need to file a GSTR-9 annual return?
The GSTR-9 annual return is optional for businesses with aggregate turnover up to ₹2 crore
and mandatory above that, as per CBIC notifications. Either way, a clean annual summary of your sales,
purchases and GST makes the filing far easier and helps you spot mismatches before they become notices.
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.
Close every financial year without the spreadsheet marathon
Petpooja Invoice keeps every sale, purchase and GST bill in one place, reconciled all year. Your annual summary and GST returns are ready when you are, no manual roll-up needed.
Book a Free Demo
Call: +91-92279 80766