TruImpact

Brand MIS

Monthly P&L Actuals

Example figures. Sample numbers so you can see the math. Clear brand data and plug in real figures; the blue-tinted GST settings stay as you set them.

Gross Sales

Tick the channels you sell on, then enter one month of sales for each, including GST.

Rates used in formulas

Marketing

Monthly spends, before GST.

Agency Fees

Monthly fees, before GST.

Other Expenses

Orders & Customers

P&L Summary

EBITDA
₹26,186
0.7% of net sales
Net sales
₹37,83,051
Gross sales less GST and returns
CM 2
₹9,26,186
24.5% of net sales
Blended ROAS
5.50x
bill value / marketing
ParticularsAmount%
Sales mix (% of gross sales)
Own website₹25,00,00053.2%
Marketplaces₹8,00,00017.0%
Quick Commerce₹4,00,0008.5%
Offline retail (pop-ups)₹3,00,0006.4%
Offline retail (shelves)₹4,00,0008.5%
B2B (corporate gifting)₹2,00,0004.3%
International₹1,00,0002.1%
Gross Sales₹47,00,000100.0%
(-) Returns/Cancellations (own website)-₹2,00,000
(-) Returns (marketplaces, quick commerce)-₹36,000
(-) GST @ 18% on sales after returns-₹6,80,949
P&L (% of net sales)
Net sales₹37,83,051100.0%
(-) COGS-₹11,94,91531.6%
Gross margin₹25,88,13668.4%
(-) Commission expenses (marketplaces, shelves)-₹2,54,2376.7%
(-) Commission expenses (quick commerce)-₹1,01,6952.7%
(-) Shipping expenses-₹3,18,6448.4%
(-) Payment gateway expenses-₹42,3731.1%
(-) Website & Software expenses-₹40,0001.1%
CM 1₹18,31,18648.4%
(-) Inorganic Marketing exp (Meta)-₹5,00,00013.2%
(-) Inorganic Marketing exp (Google)-₹1,70,0004.5%
(-) WhatsApp, email and CRM exp-₹40,0001.1%
(-) Organic Marketing exp-₹60,0001.6%
(-) Social media agency fees-₹25,0000.7%
(-) Performance agency fees-₹40,0001.1%
(-) Creative agency fees-₹20,0000.5%
(-) Pop-Up Rental exp-₹50,0001.3%
CM 2₹9,26,18624.5%
(-) Salary-₹4,00,00010.6%
(-) Rent (office, warehouse, store)-₹1,20,0003.2%
(-) Other expenses (utilities, travel, admin)-₹80,0002.1%
Operational profit₹3,26,1868.6%
(-) Director salary (partners' remuneration)-₹2,00,0005.3%
(-) Brand building / Other non-recurring expenses-₹1,00,0002.6%
EBITDA₹26,1860.7%

Key metrics

Total orders
3,290
AOV
₹1,429
bill value per order
Gross margin %
68.4%
CM 1 %
48.4%
CM 2 %
24.5%
Operational profit %
8.6%
EBITDA %
0.7%
Marketing as % of net sales
22.6%
Blended ROAS
5.50x
bill value / marketing
Paid ads ROAS
3.73x
website bill value / Meta + Google spend
CAC
₹570
marketing / new customers
Marketing here is Meta, Google, CRM, organic marketing and agency fees.
All figures in Indian Rupees (₹) · Updates live as you type

How the Monthly P&L (MIS) Calculator works

Tick the channels you sell on, then enter one month of sales for each, your cost rates, marketing spends, agency fees, other expenses and orders. The calculator builds the month's P&L from gross sales down to EBITDA, with each margin as a % of net sales, plus blended ROAS, paid ads ROAS, AOV and CAC. Gross sales are entered including GST and every expense before GST. GST is taken only on the sales kept after returns. COGS, commission, shipping and payment gateway charges are worked out as a % of sales, with the GST on expenses taken out.

Net sales
Gross sales across all channels, minus returns and cancellations (a % of own website sales, and a % of marketplace and quick commerce sales), minus the GST in the sales kept.
Gross margin
Net sales minus COGS.
CM 1
Gross margin minus marketplace, quick commerce and shelf commission, shipping, payment gateway charges and website and software expenses.
CM 2
CM 1 minus Meta, Google and CRM spend, organic marketing, agency fees and pop-up rental.
Operational profit
CM 2 minus salary, rent and other expenses.
EBITDA
Operational profit minus director salary and brand building or other non-recurring expenses.

Frequently asked questions

What is an MIS report for a D2C brand?

MIS stands for management information system. For a D2C brand it usually means the monthly P&L the founders and finance team review: sales by channel, costs, contribution margins and profit for the month. This calculator builds that view for one month.

What is the difference between CM 1 and CM 2?

CM 1 (contribution margin 1) is what is left after the costs of making and delivering the sale: COGS, commission, shipping, payment gateway charges and software. CM 2 also takes out marketing: Meta, Google, CRM, organic marketing, agency fees and pop-up rental. CM 2 shows whether sales still make money after paying to win them.

How is blended ROAS calculated?

Blended ROAS is gross sales across every channel ÷ total marketing. Marketing here is Meta, Google and CRM spend, organic marketing and agency fees. In the example, ₹47,00,000 of gross sales against ₹8,55,000 of marketing gives a blended ROAS of 5.50x.

How is paid ads ROAS different from blended ROAS?

Paid ads ROAS is own website sales ÷ Meta and Google spend. Blended ROAS counts sales from every channel against all marketing, so it shows the return on the whole marketing budget. In the example, ₹25,00,000 of website sales against ₹6,70,000 of Meta and Google spend gives a paid ads ROAS of 3.73x.

How is CAC calculated?

CAC (customer acquisition cost) is total marketing for the month ÷ new customers that month. In the example, ₹8,55,000 of marketing and 1,500 new customers give a CAC of ₹570.

Should I enter ad spends with or without GST?

Without GST, like every other expense in the calculator. For Meta and Google that is the spend Ads Manager shows. Only gross sales are entered including GST.