How Do You Do an Expense Analysis? A Training on Fixed and Variable Expenses, the Expense-to-Revenue Ratio, Break-Even Revenue, and a Savings Plan
How do you do an expense analysis? Separating fixed and variable expenses, the expense-to-revenue ratio, break-even revenue, and a savings plan: an 8-lesson e-commerce guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is expense analysis, and why isn't total expense enough?
- Lesson 2: How do you separate fixed and variable expenses?
- Lesson 3: How is the expense-to-revenue ratio calculated by category?
- Lesson 4: How do you read expenses when comparing two periods?
- Lesson 5: How do you find break-even revenue from expenses?
- Lesson 6: Which expense should be reduced first?
- Lesson 7: How do you keep expenses accurate in the records?
- Lesson 8: How do you do a monthly expense analysis?
- What are the most common mistakes in expense analysis?
- How does NetKasam make expense management easier?
- Mini quiz: Test what you have learned
- Conclusion: Separate your expenses into fixed and variable this month
- Frequently Asked Questions About Expense Analysis
At the end of the month, profit came in lower than you expected. Sales went up, the number of orders went up, but the money left in the account didn't. In most businesses, the answer lies in expenses: no one has separated which expenses grow with sales and which stay the same even when sales fall. The expense list is in front of you, but "total expenses" is a single number and doesn't tell you what the problem is.
This article is not a narrative but an 8-lesson practical training. We'll answer the question how do you do an expense analysis with figures, using a sample business: separating expenses into fixed and variable, the expense-to-revenue ratio, comparing two months, break-even revenue, savings priorities, and a monthly expense routine. At the end, there is a mini quiz with an answer key. For choosing expense tracking software, see the article how to choose expense tracking software; here we walk step by step through how to read recorded expenses.
What will you be able to do by the end of this training?
In short: You will separate your expenses into fixed and variable, calculate the expense-to-revenue ratio by category, compare two periods, find your break-even revenue, and rank savings priorities in monetary terms.
- 01CategoryDivide expenses into consistent categories.
- 02BehaviorMark each category as fixed or variable.
- 03RatioCalculate the expense-to-revenue ratio by category.
- 04ComparisonPut two periods side by side.
- 05Break-evenFind the revenue that covers fixed expenses.
- 06PriorityRank savings by monetary impact.
The 8 lessons of this training: (1) what expense analysis is, (2) fixed and variable expenses, (3) expense-to-revenue ratio by category, (4) comparing two months, (5) break-even revenue, (6) savings priorities, (7) keeping expenses accurate in the records, (8) the monthly expense routine.
Lesson 1: What is expense analysis, and why isn't total expense enough?
In short: Expense analysis is the work of examining expenses by type, behavior, and ratio to revenue to find which item is putting pressure on profit. Total expense alone doesn't point the way.
Consider two businesses, both with monthly expenses of ₺600,000. In one, ₺500,000 of this is fixed; in the other, ₺500,000 is variable. If sales drop 20 percent, the first one's expenses stay almost the same and profit melts away quickly; the second one's expenses shrink with sales and profit is affected more slowly. The same total, a completely different risk. That's why the analysis seeks answers to three questions:
| Question | What does it show? | Which lesson? |
|---|---|---|
| Where is the money going? | Category breakdown | Lesson 3 |
| If sales fall, do expenses fall? | Fixed vs. variable split | Lesson 2 |
| Are expenses growing relative to revenue? | Expense-to-revenue ratio and period comparison | Lessons 3 and 4 |
| How much do I need to sell to avoid a loss? | Break-even revenue | Lesson 5 |
Sample business (monthly; figures chosen only to illustrate the method): net sales ₺1,500,000, cost of goods sold ₺800,000 (53.3%). For the structure of the income statement, see the article how to prepare an income statement; here we examine operating expenses other than product cost.
Lesson 2: How do you separate fixed and variable expenses?
In short: A fixed expense stays the same whether sales fall or rise; a variable expense rises and falls with sales. The simplest test for the distinction: "If I made no sales at all this month, would I still pay this expense?"
| Expenses | Monthly amount | Behavior | Rationale |
|---|---|---|---|
| Rent | 60.000 ₺ | Fixed | Independent of sales |
| Staff (salaries and SGK) | 180.000 ₺ | Fixed | Doesn't change with sales in the short term |
| Software and subscriptions | 12.000 ₺ | Fixed | Fixed monthly fee |
| Electricity, water, internet | 18.000 ₺ | Fixed | Barely sensitive to sales |
| Shipping | 85.000 ₺ | Variable | Increases with the number of orders |
| Packaging materials | 20.000 ₺ | Variable | Increases with packages shipped |
| Advertising | 90.000 ₺ | Variable | Depends on the budget and sales target |
| Marketplace commission | 130.000 ₺ | Variable | Proportional to the sales amount |
| Bank and virtual POS charges | 25.000 ₺ | Variable | Increases with the collection amount |
| Total | 620.000 ₺ | Fixed ₺270,000 | Variable ₺350,000 |
In reality, some expenses are semi-variable: staff is fixed, but hiring extra people for the season increases it in steps, and an advertising budget can also be managed as a fixed budget. Classify an item you're unsure about according to how it actually behaved this month, and revisit it every quarter. For commission calculations, the article how to calculate marketplace commission and payouts is a useful complement, and for shipping items, how to check a shipping invoice.
- Net sales₺1,500,000
- Cost of goods sold−₺800,000
- Fixed expenses−₺270,000
- Variable expenses−₺350,000
- Net profit₺80,000
Prepared with sample values. Net profit margin 5.3%.
Lesson 3: How is the expense-to-revenue ratio calculated by category?
In short: Expense-to-revenue ratio = category expense ÷ net sales × 100. As amounts grow, comparison becomes harder; the ratio gives a common measure across different months and different items.
| Category | Monthly expense | Expense-to-revenue ratio | Share of total expenses |
|---|---|---|---|
| Personnel | 180.000 ₺ | %12,0 | %29,0 |
| Marketplace commission | 130.000 ₺ | %8,7 | %21,0 |
| Advertising | 90.000 ₺ | %6,0 | %14,5 |
| Shipping | 85.000 ₺ | %5,7 | %13,7 |
| Rent | 60.000 ₺ | %4,0 | %9,7 |
| Other (packaging, bank, subscriptions, utility bills) | 75.000 ₺ | %5,0 | %12,1 |
| Total | 620.000 ₺ | %41,3 | %100 |
- Staff12.0%
- Marketplace commission8.7%
- Advertising6.0%
- Shipping5.7%
- Other5.0%
- Rent4.0%
Prepared with sample values. Total expense-to-revenue ratio 41.3%.
- Staff₺180,00029%
- Marketplace commission₺130,00021%
- Advertising₺90,00014.5%
- Shipping₺85,00013.7%
- Rent₺60,0009.7%
- Other₺75,00012.1%
Prepared with sample values.
What this table shows is that the largest items are also the ones that leave the least room for negotiation: staff and commission. Advertising and shipping, on the other hand, are manageable items. For the calculation that shows the full profit margin, see the articles how to calculate profit margin and how to calculate net profit on a marketplace.
Lesson 4: How do you read expenses when comparing two periods?
In short: A single month's expense-to-revenue ratio means little on its own; when placed side by side with last month and the same month last year, you can see which expense is growing faster than revenue.
| Indicator | September | October | Change |
|---|---|---|---|
| Net sales | 1.320.000 ₺ | 1.500.000 ₺ | +%13,6 |
| Cost of goods sold | 704.000 ₺ | 800.000 ₺ | +%13,6 |
| Fixed expenses | 270.000 ₺ | 270.000 ₺ | 0 |
| Advertising | 66.000 ₺ | 90.000 ₺ | +%36,4 |
| Other variable expenses | 229.000 ₺ | 260.000 ₺ | +%13,5 |
| Net profit | 51.000 ₺ | 80.000 ₺ | +%56,9 |
| Fixed expense-to-revenue ratio | %20,5 | %18,0 | −2.5 points |
| Advertising-to-revenue ratio | %5,0 | %6,0 | +1.0 points |
There are two findings. The first is good: while sales rose 13.6%, fixed expenses stayed the same, so the fixed expense ratio fell 2.5 points and net profit rose 56.9%. This is called fixed cost leverage. The second is a warning: advertising spending grew much faster than sales, by 36.4%; the advertising-to-revenue ratio rose 1 point. Advertising has eaten part of the sales increase. To measure advertising return, see the article what is ad analysis, and how is it done.
Recommended readingHow to Prepare a Cash Flow Statement?Lesson 5: How do you find break-even revenue from expenses?
In short: Break-even revenue = fixed expenses ÷ contribution margin. The contribution margin is the share of revenue left to cover fixed expenses after product cost and variable expenses are deducted.
- Expense-to-revenue ratio = Expense ÷ Net sales × 100
- Contribution margin = (Net sales − Cost of goods sold − Variable expenses) ÷ Net sales
- Break-even revenue = Fixed expenses ÷ Contribution margin
- Margin of safety = (Actual revenue − Break-even revenue) ÷ Actual revenue
- Fixed expense ratio = Fixed expenses ÷ Net sales × 100
All calculations should be done for the same period with the same categorization.
In the example: contribution margin (1,500,000 − 800,000 − 350,000) ÷ 1,500,000 = 350,000 ÷ 1,500,000 = 23.33%. Break-even revenue 270,000 ÷ 0.2333 = ₺1,157,143. Margin of safety (1,500,000 − 1,157,143) ÷ 1,500,000 = 22.9%. So even if revenue falls by about 23%, the business doesn't go into a loss; if it falls more than that, fixed expenses aren't covered.
| Revenue | Contribution (23.33%) | Fixed costs | Result |
|---|---|---|---|
| 1.500.000 ₺ | 350.000 ₺ | 270.000 ₺ | +80.000 ₺ |
| 1.157.143 ₺ | 270.000 ₺ | 270.000 ₺ | ₺0$0 (break-even) |
| 1.000.000 ₺ | 233.333 ₺ | 270.000 ₺ | −36.667 ₺ |
For the unit price and quantity dimension of the break-even calculation, see the article how to calculate the break-even point; for a free calculator, see the NetKasam tools page.
Lesson 6: Which expense should be reduced first?
In short: Look at large, manageable items first. A 50 percent saving on a small item can be worth less than 5 percent on a large one. Rank every savings idea by its monthly monetary value.
| Idea | Account | Monthly gain | Difficulty |
|---|---|---|---|
| Reduce the advertising-to-revenue ratio from 6% to 5% | 1.500.000 × %1 | 15.000 ₺ | Medium: shut down low-return campaigns |
| Reduce shipping costs by 5% (desi and rate checks) | 85.000 × %5 | 4.250 ₺ | Low: invoice checks |
| Reduce packaging materials by 10% | 20.000 × %10 | 2.000 ₺ | Low |
| Lower rent by 5% | 60.000 × %5 | 3.000 ₺ | High: bound by contract |
The first three ideas total ₺21,250; net profit rises from ₺80,000 to ₺101,250 and net margin from 5.3% to 6.8% (if revenue stays the same). While profit margin rises by 1.4 percentage points, profit rises by 26.6 percent; ratios that look small have a large effect on profit. Fixed expenses are hard to cut; managing variable expenses, on the other hand, is an ongoing task. Increasing sales instead of cutting expenses is also an option, but always measure the return on increased advertising.
- 41.3%expense-to-revenue ratio (620,000 / 1,500,000)
- 23.3%contribution margin
- ₺1,157,143break-even revenue
- ₺21,250monthly savings from three ideas
Lesson 7: How do you keep expenses accurate in the records?
In short: An analysis is only as reliable as the records. Every expense should be recorded with the correct category, on the correct date, with who incurred it and its document; categories should not change during the period.
| Recording rule | Why does it matter? |
|---|---|
| Keep the category list fixed | Month-to-month comparison stays intact |
| Enter future-dated expenses as "to be paid" | The expense falls into the correct period and you get a payment reminder |
| Attach the document to the record | No need to search for receipts and invoices later |
| Select who incurred the expense | Expense differences by employee become visible |
| Put bank charges in a separate category | The cost of collection becomes visible |
| Cancel an incorrect entry; don't delete or modify it | A trail remains and balances stay consistent |
For expenses without an invoice, see the article what is an expense voucher, and how and when is it used. For methods of keeping business expenses under control in general, the article how can you keep expenses under control in your company is a useful complement. We've summarized how to record expenses in NetKasam below.
Lesson 8: How do you do a monthly expense analysis?
In short: Do the expense analysis every month in the same order, with the same table: category ratios, period comparison, break-even, and margin of safety. A routine is more valuable than a one-off big analysis.
| When? | What to do? | Who? |
|---|---|---|
| Every day or week | Expenses are recorded with their category and document | Accounting, employees |
| Month-end | Missing and payable expenses are reviewed; see month-end close | Accounting |
| Start of month | Category ratios and the difference from the previous month are calculated | Accounting |
| Start of month | Items whose ratio is growing faster than revenue are examined | Management |
| Once a quarter | The fixed/variable classification and break-even revenue are refreshed | Management |
| Once a year | Rent, subscription, and rate contracts are renegotiated | Management |
You can use the reports screen to keep the monthly report as a saved report and export it to Excel. For its effect on cash planning, see the article cash flow statement.
Recommended readingHow Do You Calculate the Break-Even Point?What are the most common mistakes in expense analysis?
- Looking only at total expenses. What the problem is remains invisible.
- Confusing fixed and variable. You misjudge which expenses will decrease when sales fall.
- Comparing amounts but not ratios. In a business with growing sales, expense amounts naturally increase.
- Changing categories every month. Comparison between periods breaks down.
- Treating advertising as an expense without measuring its return. Cutting advertising may take sales with it.
- Not recording expenses without an invoice or document. Actual profit looks higher than it is.
- Never calculating break-even revenue. Growth plans are made without knowing the margin of safety.
How does NetKasam make expense management easier?
- Expense slip. You record your expenses with an expense slip from the "Expenses" menu (expense management).
- Future-dated expenses and reminders. You create a future-dated expense by setting the payment status to "to be paid"; the system alerts you on the payment date.
- Employee expenses. Your employees can enter their expenses from a mobile phone or computer and upload receipts and invoices to the system; you can select who incurred an expense and filter by it in reports (users and employees).
- Bank charges. The expense slip for charges arising from a collection or payment is created automatically by the system.
- Reversing entries. When you cancel or delete an expense slip, all movements of the transaction are updated with a reversing entry.
- Saved reports. You save the expense report with criteria and export it to Excel (reports).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If net sales are ₺800,000 and total expenses are ₺280,000, what is the expense-to-revenue ratio?
- If fixed expenses are ₺120,000, product cost is 50% of revenue, and variable expenses are 20%, what is break-even revenue?
- As revenue rose from ₺500,000 to ₺550,000, advertising rose from ₺40,000 to ₺50,000. How did the advertising-to-revenue ratio change?
- Is a shipping fee a fixed or variable expense?
- Why is the expense-to-revenue ratio a better measure of comparison than the total expense amount?
Answer key:
- 280.000 ÷ 800.000 × 100 = %35.
- Contribution margin 1 − 0.50 − 0.20 = 30%; break-even revenue 120,000 ÷ 0.30 = ₺400,000.
- First 8% (40/500), then 9.1% (50/550). The ratio rose 1.1 points; advertising grew 25%, revenue 10%.
- Variable; it increases with the number of shipments.
- As revenue grows, the expense amount naturally increases; the ratio shows whether the expense is becoming heavier relative to revenue.
Frequently Asked Questions About Expense Analysis
How do you do an expense analysis?
Expenses are divided into categories and by fixed/variable behavior, expressed as a ratio of revenue, and compared with the previous period; then break-even revenue is calculated and savings opportunities are ranked by their monetary impact.
What is the difference between fixed and variable expenses?
A fixed expense stays the same regardless of sales (rent, salaries). A variable expense rises and falls with sales (shipping, commission, packaging).
How is the expense-to-revenue ratio calculated?
The expense amount is divided by net sales and multiplied by 100. If there are ₺620,000 of expenses on ₺1,500,000 of revenue, the ratio is 41.3%.
How do you find break-even revenue?
Fixed expenses are divided by the contribution margin. The contribution margin is the share that remains after product cost and variable expenses are deducted. In the example, 270,000 ÷ 0.2333 = ₺1,157,143.
What is the margin of safety?
It shows how far actual revenue is above break-even revenue. In the example it is 22.9%; if revenue falls by that much, the business moves into a loss.
Which expense should be reduced first?
Start with large, manageable items: advertising, shipping, packaging. Calculate the monthly monetary value of each idea and rank them; expenses whose return can't be measured come first.
How often should an expense analysis be done?
Recording is daily, analysis is monthly. The fixed/variable classification and break-even revenue are refreshed once a quarter.
How do I record expenses in NetKasam?
You create an expense slip from the "Expenses" menu; by setting the payment status to "to be paid," you can enter a future-dated expense, upload the receipt and invoice, and report by employee.
Conclusion: Separate your expenses into fixed and variable this month
Expense analysis isn't a big project; it's a regular habit. This month, divide your expenses into categories, mark each one as fixed or variable, calculate the expense-to-revenue ratio, and compare it with last month. Once you find your break-even revenue, you'll see how much risk each decision carries.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.