EN
Bookkeeping

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
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is expense analysis, and why isn't total expense enough?
  3. Lesson 2: How do you separate fixed and variable expenses?
  4. Lesson 3: How is the expense-to-revenue ratio calculated by category?
  5. Lesson 4: How do you read expenses when comparing two periods?
  6. Lesson 5: How do you find break-even revenue from expenses?
  7. Lesson 6: Which expense should be reduced first?
  8. Lesson 7: How do you keep expenses accurate in the records?
  9. Lesson 8: How do you do a monthly expense analysis?
  10. What are the most common mistakes in expense analysis?
  11. How does NetKasam make expense management easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Separate your expenses into fixed and variable this month
  14. 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.

Training mapThe six steps of expense analysis
  1. 01
    CategoryDivide expenses into consistent categories.
  2. 02
    BehaviorMark each category as fixed or variable.
  3. 03
    RatioCalculate the expense-to-revenue ratio by category.
  4. 04
    ComparisonPut two periods side by side.
  5. 05
    Break-evenFind the revenue that covers fixed expenses.
  6. 06
    PriorityRank 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:

QuestionWhat does it show?Which lesson?
Where is the money going?Category breakdownLesson 3
If sales fall, do expenses fall?Fixed vs. variable splitLesson 2
Are expenses growing relative to revenue?Expense-to-revenue ratio and period comparisonLessons 3 and 4
How much do I need to sell to avoid a loss?Break-even revenueLesson 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?"

ExpensesMonthly amountBehaviorRationale
Rent60.000 ₺FixedIndependent of sales
Staff (salaries and SGK)180.000 ₺FixedDoesn't change with sales in the short term
Software and subscriptions12.000 ₺FixedFixed monthly fee
Electricity, water, internet18.000 ₺FixedBarely sensitive to sales
Shipping85.000 ₺VariableIncreases with the number of orders
Packaging materials20.000 ₺VariableIncreases with packages shipped
Advertising90.000 ₺VariableDepends on the budget and sales target
Marketplace commission130.000 ₺VariableProportional to the sales amount
Bank and virtual POS charges25.000 ₺VariableIncreases with the collection amount
Total620.000 ₺Fixed ₺270,000Variable ₺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.

Chart₺1,500,000 in revenue turns into ₺80,000 in net profit after expenses
  1. Net sales₺1,500,000
  2. Cost of goods sold−₺800,000
  3. Fixed expenses−₺270,000
  4. Variable expenses−₺350,000
  5. Net profit₺80,000

Prepared with sample values. Net profit margin 5.3%.

Product pageFree Bookkeeping Software

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.

CategoryMonthly expenseExpense-to-revenue ratioShare of total expenses
Personnel180.000 ₺%12,0%29,0
Marketplace commission130.000 ₺%8,7%21,0
Advertising90.000 ₺%6,0%14,5
Shipping85.000 ₺%5,7%13,7
Rent60.000 ₺%4,0%9,7
Other (packaging, bank, subscriptions, utility bills)75.000 ₺%5,0%12,1
Total620.000 ₺%41,3%100
ChartExpense-to-revenue ratio: staff is the heaviest item relative to revenue, commission second
  1. Staff12.0%
  2. Marketplace commission8.7%
  3. Advertising6.0%
  4. Shipping5.7%
  5. Other5.0%
  6. Rent4.0%

Prepared with sample values. Total expense-to-revenue ratio 41.3%.

ChartExpense breakdown: staff and commission make up half of total expenses
  • 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.

IndicatorSeptemberOctoberChange
Net sales1.320.000 ₺1.500.000 ₺+%13,6
Cost of goods sold704.000 ₺800.000 ₺+%13,6
Fixed expenses270.000 ₺270.000 ₺0
Advertising66.000 ₺90.000 ₺+%36,4
Other variable expenses229.000 ₺260.000 ₺+%13,5
Net profit51.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.

FormulaThe five formulas of expense analysis
  1. Expense-to-revenue ratio = Expense ÷ Net sales × 100
  2. Contribution margin = (Net sales − Cost of goods sold − Variable expenses) ÷ Net sales
  3. Break-even revenue = Fixed expenses ÷ Contribution margin
  4. Margin of safety = (Actual revenue − Break-even revenue) ÷ Actual revenue
  5. 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.

RevenueContribution (23.33%)Fixed costsResult
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.

IdeaAccountMonthly gainDifficulty
Reduce the advertising-to-revenue ratio from 6% to 5%1.500.000 × %115.000 ₺Medium: shut down low-return campaigns
Reduce shipping costs by 5% (desi and rate checks)85.000 × %54.250 ₺Low: invoice checks
Reduce packaging materials by 10%20.000 × %102.000 ₺Low
Lower rent by 5%60.000 × %53.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.

Takeaways from the exampleFour numbers from the sample business
  • 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 ruleWhy does it matter?
Keep the category list fixedMonth-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 recordNo need to search for receipts and invoices later
Select who incurred the expenseExpense differences by employee become visible
Put bank charges in a separate categoryThe cost of collection becomes visible
Cancel an incorrect entry; don't delete or modify itA 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 weekExpenses are recorded with their category and documentAccounting, employees
Month-endMissing and payable expenses are reviewed; see month-end closeAccounting
Start of monthCategory ratios and the difference from the previous month are calculatedAccounting
Start of monthItems whose ratio is growing faster than revenue are examinedManagement
Once a quarterThe fixed/variable classification and break-even revenue are refreshedManagement
Once a yearRent, subscription, and rate contracts are renegotiatedManagement

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?

  1. Looking only at total expenses. What the problem is remains invisible.
  2. Confusing fixed and variable. You misjudge which expenses will decrease when sales fall.
  3. Comparing amounts but not ratios. In a business with growing sales, expense amounts naturally increase.
  4. Changing categories every month. Comparison between periods breaks down.
  5. Treating advertising as an expense without measuring its return. Cutting advertising may take sales with it.
  6. Not recording expenses without an invoice or document. Actual profit looks higher than it is.
  7. 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.

  1. If net sales are ₺800,000 and total expenses are ₺280,000, what is the expense-to-revenue ratio?
  2. If fixed expenses are ₺120,000, product cost is 50% of revenue, and variable expenses are 20%, what is break-even revenue?
  3. 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?
  4. Is a shipping fee a fixed or variable expense?
  5. Why is the expense-to-revenue ratio a better measure of comparison than the total expense amount?

Answer key:

  1. 280.000 ÷ 800.000 × 100 = %35.
  2. Contribution margin 1 − 0.50 − 0.20 = 30%; break-even revenue 120,000 ÷ 0.30 = ₺400,000.
  3. First 8% (40/500), then 9.1% (50/550). The ratio rose 1.1 points; advertising grew 25%, revenue 10%.
  4. Variable; it increases with the number of shipments.
  5. 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.

Start FreeFree Bookkeeping Software

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools