To see month wise profit and loss in Tally Prime, open Profit & Loss A/c and press Alt+N (Auto Column), then choose Monthly. A month that bought heavily for a season can still read as a loss when closing stock is entered only at year-end; when Tally values your stock month by month, each month carries its own closing stock and the loss disappears. Which of the two you see depends on one setting, Integrate Accounts with Inventory, and on whether your item records are kept up to date. The worked example below takes a paint and hardware distributor's September 2026: ₹14,00,000 of sales and ₹18,00,000 of purchases made ahead of the festival season. Read without that month's closing stock, September shows a ₹10,00,000 loss. Read with its closing stock of ₹11,80,000, the same month made ₹1,80,000 of gross profit. The steps, the reason and the month wise balance sheet follow, along with the phone view an owner reads on the go.
Key Highlights
- Profit & Loss A/c with Alt+N (Auto Column) set to Monthly puts each month of the year in its own column
- A month's profit is only right when that month has its own closing stock. Without it, a heavy buying month looks like a loss
- Takkada's Monthly P&L & Balance Sheet shows twelve months side by side, with each month's closing stock in that month's profit
In This Article
- How do I see month wise P&L in Tally Prime?
- Why does September look like a loss?
- What monthly closing stock needs
- Month wise balance sheet
- Monthly P&L on the phone
- Which group made the difference?
- Frequently Asked Questions
How do I see month wise P&L in Tally Prime?
- From Gateway of Tally open Profit & Loss A/c, or press Alt+G (Go To) and type Profit & Loss A/c.
- Press F2 (Period) and set the period to the financial year so far, for example 1 April to 30 September.
- Press Alt+N (Auto Column) and choose Monthly. Tally adds one column per month. Tally's help lists daily, weekly, monthly and quarterly among the choices, so the same step gives a quarterly view.
- Drill into any figure, such as Purchase Accounts for September, to see the vouchers behind it.
- Press Ctrl+E to export the columns to Excel or PDF for your CA.
If you only need to compare two periods, Alt+C (New Column) adds one column at a time with a period of your choice. Press F12 to switch between the horizontal and vertical layout; Tally's help notes that the gross profit split shows in the horizontal form.
Why does September look like a loss?
A distributor who stocks up for Diwali buys most of the season's goods in September and sells them in October and November. Profit for a month is sales minus the cost of what was sold, and the cost of what was sold is opening stock plus purchases minus closing stock. Leave out the month's closing stock and every rupee of September's buying is charged to September's sales.
| September 2026 | Without September's closing stock | With it |
|---|---|---|
| Sales | ₹14,00,000 | ₹14,00,000 |
| Opening stock | ₹6,00,000 | ₹6,00,000 |
| Purchases | ₹18,00,000 | ₹18,00,000 |
| Closing stock | not counted | ₹11,80,000 |
| Cost of goods sold | ₹24,00,000 | ₹12,20,000 |
| Gross profit | ₹10,00,000 loss | ₹1,80,000 |
Nothing about the business changed between the two columns. ₹11,80,000 of paint, pipe and putty is sitting in the godown, and the left column treats it as if it had been thrown away. In October and November the opposite happens: sales come in with little buying and the months look far better than they were. Over the full year the totals agree. Month by month, only the right column tells you anything.
What monthly closing stock needs
Tally can carry closing stock in two ways. With Integrate Accounts with Inventory set to Yes in F11 (Features), Tally values your stock items at each date from the inventory vouchers, so every monthly column gets its own closing stock. With it set to No, closing stock is a ledger under Stock-in-Hand whose closing values you type in yourself, and many businesses type one figure at the year-end. That is the book where September reads a loss.
If your books are integrated and a month still looks wrong, the usual causes are purchases entered without their stock items, sales billed through accounting-only vouchers, or items with no rate or cost so Tally values them at zero. Fix those in the vouchers and the monthly closing stock follows. If your books are not integrated, type a closing value for each month-end in the stock ledger, or ask your CA which they prefer.
Month wise balance sheet
The same Alt+N (Auto Column) step works in the Balance Sheet. Choose Monthly and you see stock, debtors, creditors, bank and loans at each month-end side by side. It is the quickest way to see working capital build up before a season: in the example, stock rises by ₹5,80,000 from August to September while sales are still flat, and creditors usually rise with it.
Monthly P&L on the phone
Takkada's Monthly P&L & Balance Sheet sits in the Reports tab under Accounts. It shows twelve months side by side, with each month's closing stock in that month's profit, so September above reads ₹1,80,000 of gross profit and not a loss. The figures come from your Tally, as of the last sync. The same screen switches to the balance sheet month by month, and you can send both statements as Excel, one sheet each, or as a print-ready PDF pack from the phone's share sheet. Owners and full-access team members see item-wise sales and profit; you choose who else sees reports.
The year totals, the profit and loss account and the balance sheet each have their own reports in the same tab. Every report is on the Tally reports on mobile page, and the regular statement is covered in profit and loss in Tally on mobile.
Which group made the difference?
A monthly P&L tells you that October's gross profit fell. It does not tell you which goods fell. For that, put your stock groups side by side month by month. The sales comparison report for Tally does that, sorted by the biggest drop, and opens any group into its items. In the example, paints fell from ₹4,10,000 in August to ₹3,52,000 in September, a 14% drop, while adhesives rose 15%.
Frequently Asked Questions
Q: How do I see month wise P&L in Tally Prime?
A: Open Profit & Loss A/c, press F2 to set the period to the year so far, then press Alt+N (Auto Column) and choose Monthly. Each month gets its own column, and you can drill into any figure for its vouchers.
Q: Why does my monthly profit look wrong in Tally?
A: Usually because the month has no closing stock of its own. If closing stock is entered only at the year-end, a month with heavy buying carries all of it as cost: in the example, September reads a ₹10,00,000 loss instead of ₹1,80,000 of gross profit. With integrated inventory and complete stock vouchers, each month gets its own closing stock.
Q: Can I see a month wise balance sheet?
A: Yes. Open the Balance Sheet in Tally and use the same Alt+N (Auto Column) step with Monthly. Takkada's Monthly P&L & Balance Sheet shows both statements month by month on the phone, from your Tally as of the last sync.
Q: What is the difference between an MIS report and P&L?
A: The P&L answers whether a period made money, and a month by month MIS view answers how each month moved against the others. The full comparison is in MIS report vs profit and loss.
Q: Can I export the monthly P&L to Excel?
A: In Tally, press Ctrl+E in the monthly Profit & Loss A/c. In Takkada, Monthly P&L & Balance Sheet exports both statements to Excel, one sheet each, or to a print-ready PDF.
Takkada shows your profit and loss and balance sheet month by month, with each month's closing stock, on the phone and the web app. Message us on WhatsApp to see your own year laid out.