EN
Bookkeeping

How to Compare Monthly Budget vs. Actuals? Training on Variance Calculation, Flexible Budgets, Profit Bridges, Threshold Rules and the Monthly Meeting

How do you compare the monthly budget with actuals? Variance calculation, flexible budget, profit bridge, threshold rule and monthly meeting: an 8-lesson hands-on 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 a monthly budget for?
  3. Lesson 2: How do you build a monthly budget?
  4. Lesson 3: Where are actual figures collected from?
  5. Lesson 4: How is variance calculated?
  6. Lesson 5: What is a flexible budget, and why is it needed?
  7. Lesson 6: How is the profit gap allocated to line items?
  8. Lesson 7: Which variances are investigated?
  9. Lesson 8: How are the monthly meeting and budget revision done?
  10. What are the most common mistakes in budget comparison?
  11. How does NetKasam make budget tracking easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Put last month's budget side by side with actuals
  14. Frequently Asked Questions About Comparing Budget and Actuals

At the end of the month you look at the sales figure: ₺48,000 more than you budgeted, that is, 8% above. It looks like a good month. A few days later the net profit figure comes in from accounting and you are surprised: ₺7,620 instead of the budgeted ₺28,000. Sales went up, profit went down. This happens very often, and the answer to "where did we miss it" usually only emerges when you put the budget and actuals side by side, line by line.

This article is not a lecture but an 8-lesson hands-on training. We will answer how to compare the monthly budget with actuals using a single month's figures: how to build the budget, where to collect actual data from, calculating the variance as an amount and a percentage, the flexible budget that separates the volume effect, the variance bridge, which variances to investigate and the monthly meeting routine. At the end there is a mini quiz with an answer key. For details on the expense side, see the article how to do an expense analysis; this article focuses on comparing all line items with the budget.

What will you be able to do by the end of this training?

In short: You will build a monthly budget, collect actual figures, calculate the variance as an amount and a percentage, separate the volume effect, produce the variance bridge and decide which variances to investigate.

Training mapSix steps of budget comparison
  1. 01
    BudgetWrite line-by-line targets at the start of the month.
  2. 02
    ActualsTotal them with the same line items at the end of the month.
  3. 03
    VarianceCalculate the amount and percentage.
  4. 04
    Flexible budgetSeparate the effect of sales volume.
  5. 05
    BridgeAllocate the profit gap to line items.
  6. 06
    DecisionInvestigate the items that exceed the threshold.

The 8 lessons of the training: (1) the purpose of the budget, (2) building the budget, (3) collecting actual data, (4) variance calculation, (5) the flexible budget, (6) the variance bridge, (7) which variances to investigate, (8) the monthly meeting and revision.

Lesson 1: What is a monthly budget for?

In short: A budget is not a forecast but a target and a yardstick. It lets you answer "did the month go well or badly" at the end of the month not by gut feeling but against a reference.

Without a budgetWith a budget
A feeling that "sales are good" or "bad"A measure such as +8% or −3% against budget
When profit falls, you search for the reasonYou can see which line item deviated
Spending decisions are made on the spotEvery line item has a limit
Comparison with last monthPlan compared with reality

Comparison with last month alone is misleading: last month may have been unusual. The budget, by contrast, is your "what it should be." Sample business: a 6-person retail team targeting about ₺600,000 in monthly sales, selling both in-store and on marketplaces. The business's expense items are recorded with expense management.

Lesson 2: How do you build a monthly budget?

In short: Build the budget from the average of the last three months plus known changes. Write items that change with sales as a ratio, and those that don't as a fixed amount.

ItemTypeBudget methodBudget
SalesRevenueLast 3 months' average + planned campaign600.000 ₺
Cost of goods soldChanges with sales60% of sales360.000 ₺
Marketplace commissionChanges with sales9% of sales54.000 ₺
ShippingChanges with sales5% of sales30.000 ₺
RentFixedContract amount28.000 ₺
PersonnelFixedSalaries and benefits62.000 ₺
AdvertisingPlannedApproved budget24.000 ₺
Other (internet, accounting, subscriptions)FixedLast 3 months' average14.000 ₺

Budget line items must be the same as the items actuals are recorded under; otherwise you cannot compare. Keep your expense categories simple from the start: eight to ten items are enough, while thirty make both budgeting and tracking harder. For separating fixed costs and setting a payment schedule, see how to create a fixed cost and payment schedule, and for the sales target, how to forecast sales.

The expected result from the budget for this business: 600,000 − 360,000 − 212,000 = ₺28,000 net profit (4.7%). The total of expense items (excluding cost of goods sold) is 54,000 + 30,000 + 28,000 + 62,000 + 24,000 + 14,000 = ₺212,000.

Lesson 3: Where are actual figures collected from?

In short: Collect actuals with the same line items as the budget, the same period boundaries and from a single source. If your sources are scattered, you are making an estimate, not a comparison.

ItemSource
SalesSales invoices and sales report (all channels)
Cost of goods soldInventory cost and sales movements
CommissionMarketplace payout and expense records
ShippingShipping invoices and expense records
Rent, personnel, otherExpense records, cash and bank transactions
AdvertisingAdvertising invoices and expense records

In NetKasam, because expense entries related to transactions are posted to the relevant areas at the same time, expense items can be categorized, and reports can be saved and exported to Excel, actual figures can be taken from one place (reports). Use the same start and end dates of the period for both sales and expenses; an invoice issued at the end of the month that falls into the next month is the most common period error. For how to close month-end records, see the article how to do a month-end close.

Lesson 4: How is variance calculated?

In short: Variance is the difference between actual and budget. It is written as both an amount and a percentage; an increase in revenue counts as favorable, an increase in expenses as unfavorable.

ItemBudgetActualVarianceVariance %
Sales600.000 ₺648.000 ₺+₺48,000 (favorable)+%8,0
Cost of goods sold360.000 ₺405.000 ₺+₺45,000 (unfavorable)+%12,5
Gross profit240.000 ₺243.000 ₺+3.000 ₺+%1,3
Personnel62.000 ₺66.500 ₺+₺4,500 (unfavorable)+%7,3
Shipping30.000 ₺36.200 ₺+₺6,200 (unfavorable)+%20,7
Commission54.000 ₺60.480 ₺+₺6,480 (unfavorable)+%12,0
Advertising24.000 ₺31.000 ₺+₺7,000 (unfavorable)+%29,2
Rent28.000 ₺28.000 ₺0%0,0
Other14.000 ₺13.200 ₺−₺800 (favorable)−%5,7
Total expenses (excluding cost)212.000 ₺235.380 ₺+₺23,380 (unfavorable)+%11,0
Net profit28.000 ₺7.620 ₺−₺20,380 (unfavorable)−%72,8
FormulaFour formulas for budget comparison
  1. Variance = Actual − Budget
  2. Variance percentage = Variance ÷ Budget × 100
  3. Flexible budget = Budget ratio × Actual sales
  4. Net profit margin = Net profit ÷ Sales × 100

Prepared with sample values.

Two things stand out in the table at first glance: while sales rose +8%, gross profit rose only +1.3% (cost grew faster than sales), and net profit fell 72.8%. The net margin was 4.7% in the budget (28,000 ÷ 600,000) and 1.2% in reality (7,620 ÷ 648,000). Expenses grew 11%, more than the 8% increase in sales; this is the arithmetic behind "sales went up but profit went down." For the concept of profit margin, see the article how to calculate profit margin.

Lesson 5: What is a flexible budget, and why is it needed?

In short: Rescaling items that rise with sales to actual sales separates how much of the variance comes from volume and how much from inefficiency.

When sales come in at ₺648,000 instead of ₺600,000, it is natural for shipping and commissions to rise. Counting this as a "variance" would be unfair. The flexible budget applies the budget ratio to actual sales:

ItemBudget ratioFlexible budget (based on ₺648,000)ActualTrue variance
Cost of goods sold%60388.800 ₺405.000 ₺+₺16,200 (unfavorable)
Shipping%532.400 ₺36.200 ₺+₺3,800 (unfavorable)
Commission%958.320 ₺60.480 ₺+₺2,160 (unfavorable)

The standard table had shown the shipping variance as ₺6,200 (20.7%). With the flexible budget, this variance drops to ₺3,800; ₺2,400 of it rose naturally because sales went up. Of the ₺6,480 variance in commissions, ₺4,320 comes from volume and ₺2,160 from the rate. In cost of goods sold, ₺28,800 of the ₺45,000 comes from volume and ₺16,200 from the ratio loss: the cost ratio rose from the budgeted 60% to 62.5% (405,000 ÷ 648,000). So the item that really needs investigating is the ₺16,200 ratio loss; the cause may be a rise in purchase prices, the product mix or discounted sales.

The flexible budget is not applied to fixed costs: rent, personnel and other items are not expected to change with sales. Advertising, on the other hand, is a planned decision; its variance is directly a decision variance. For how to check marketplace commission and shipping rates, see the articles how to calculate marketplace commissions and payouts and how to check a shipping invoice.

Lesson 6: How is the profit gap allocated to line items?

In short: Draw the path from budgeted profit to actual profit as a bridge: first the effect of volume, then each line item's true variance.

ChartNet profit bridge: from the budgeted ₺28,000 to the actual ₺7,620
  1. Budgeted net profit₺28,000
  2. Sales volume effect (flexible budget profit ₺40,480)₺12,480
  3. Cost of goods sold ratio−₺16,200
  4. Shipping−₺3,800
  5. Commission−₺2,160
  6. Personnel−₺4,500
  7. Advertising−₺7,000
  8. Other expenses₺800
  9. Actual net profit₺7,620

Prepared with sample values. Total: 28,000 + 12,480 − 16,200 − 3,800 − 2,160 − 4,500 − 7,000 + 800 = ₺7,620.

The volume effect is found as follows: if sales had been ₺648,000 and the budget ratios had held, net profit would have been 648,000 − 388,800 − 218,720 = ₺40,480 (₺218,720 is the total of flexible and fixed expenses: shipping 32,400 + commission 58,320 + rent 28,000 + personnel 62,000 + advertising 24,000 + other 14,000). Compared with the budgeted ₺28,000, the difference is ₺12,480; this is the profit the sales increase "earned." Actual profit fell ₺32,860 short of this earned profit.

ChartBreakdown of actual expenses: marketplace commission and personnel lead
  • Marketplace commission₺60,48025.7%
  • Personnel₺66,50028.3%
  • Shipping₺36,20015.4%
  • Advertising₺31,00013.2%
  • Rent₺28,00011.9%
  • Other₺13,2005.6%

Prepared with sample values. Cost of goods sold is not included.

The bridge is the most useful visual in a meeting: at a glance it shows that nearly half of the profit gap (₺16,200, about 49% of ₺32,860) comes from the cost ratio. Also note that there is a small "favorable" item: other expenses saved ₺800. Not every variance is bad; the goal is not to eliminate variance but to understand it.

Recommended readingHow to Prepare an Income Statement?

Lesson 7: Which variances are investigated?

In short: Chasing every variance is a waste of time. Investigate the items that exceed both the percentage and the amount thresholds: large percentages on small amounts and small percentages on large amounts will mislead you.

Sample threshold: variance greater than 5% of the budget and above ₺3,000. Below are the true (flexible) variances and the decision:

ChartUnfavorable true variances: the first item to look at is the cost of goods sold ratio
  1. Cost of goods sold ratio₺16,200
  2. Advertising₺7,000
  3. Personnel₺4,500
  4. Shipping₺3,800
  5. Commission₺2,160

Prepared with sample values. Total unfavorable variance ₺33,660; net ₺32,860 after favorable items (other expenses ₺800).

ItemVarianceDoes it exceed the threshold?Question to ask
Cost of goods sold ratio16.200 ₺YesDid purchase prices rise, did the product mix change, or did we discount?
Advertising7.000 ₺YesDid the extra spending bring in extra sales?
Personnel4.500 ₺YesOvertime or additional staff?
Shipping3.800 ₺YesA desi, region or contract difference?
Commission2.160 ₺No (below ₺3,000)Monitor
Other expenses−800 ₺No, favorableMake a note

A check on the ₺7,000 in advertising: the contribution of the ₺48,000 in additional sales at the budgeted gross margin (40%) is about ₺19,200. If this increase really came from the extra advertising, the ₺7,000 appears to have paid for itself; but because the gross margin actually fell to 37.5%, the contribution drops to ₺18,000 (48,000 × 37.5%). It is still above ₺7,000; even so, advertising's contribution to profit cannot be determined by this figure alone, because there is also the cost ratio decline. To monitor this relationship during campaign periods, see the article how to offer discounts without losing money.

Every item investigated should have an owner: the cost ratio goes to the purchasing manager, advertising to marketing, personnel to the team leader. A variance without an owner repeats the next month too. For details on personnel costs, the article how to calculate personnel cost is useful.

Lesson 8: How are the monthly meeting and budget revision done?

In short: The comparison is not a report but the output of a meeting. In a fifteen-minute monthly meeting, three things are decided: the action, its owner and the budget adjustment for next month.

StepDurationOutput
Reading the bridge3 minSource of the profit gap
Items over the threshold5 minReason and owner
Setting actions4 minDated to-dos
Next budget3 minAdjusted ratios

In the monthly meeting, ask these two questions together: "Will this variance recur?" and "Was our budget realistic?" If the variance is a one-off (for example, an expense paid once a year), don't change the budget; if it will recur (such as the purchase cost ratio settling at 62.5%), bring the budget in line with reality and make a pricing decision. If the cost ratio is permanently 62.5%, keeping the budgeted 60% without changing selling prices or purchasing terms is fooling yourself. For how to manage the pricing side, see the article how to plan a product price increase.

Takeaways from the exampleFour figures from the sample month
  • +8%sales above budget (648,000 / 600,000)
  • −72.8%net profit behind budget (7,620 / 28,000)
  • 62.5%actual cost ratio (budget 60%)
  • ₺16,200largest single variance, the cost ratio

Update the budget with a three-month rolling window: every month, rewrite the next three months with the previous month's actuals. That way the budget is not written at the start of the year and forgotten, but lives alongside the reality of the business. To show the cash side of the budget, see the article how to prepare a cash flow statement, and for weekly tracking, how to prepare a weekly management report.

Recommended readingHow to Prepare a Weekly Management Report?

What are the most common mistakes in budget comparison?

  1. Leaving the budget fixed. Expenses that naturally rise when sales increase look like variances; use a flexible budget.
  2. Keeping different line items in the budget and actuals. Comparison becomes impossible.
  3. Mixing up period boundaries. An invoice issued at the end of the month falls into the wrong month.
  4. Looking only at percentages or only at amounts. The two are evaluated together.
  5. No owner for the variance. The same problem repeats every month.
  6. Chasing every variance. Set a threshold and pick the important ones.
  7. Not changing the budget all year. A persistent variance requires bringing the budget in line with reality.

How does NetKasam make budget tracking easier?

  • Expense categories. You categorize expenses, plan payments and manage your budget more effectively (expense management).
  • One entry, multiple areas. Expense entries in transactions are posted to the relevant areas at the same time.
  • Cash and bank records. Cash and bank records are updated at the same time as expense transactions.
  • Cash flow plan. You can plan revenue and expense items separately.
  • Saved reports. You save sales and expense reports with the same criteria and export them to Excel (reports).
  • View by branch and warehouse. In a multi-branch, multi-warehouse setup, you can separate figures by unit (branch and warehouse management).
  • 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. The budget is ₺50,000 and the actual is ₺56,000. What are the variance amount and percentage?
  2. The sales budget is ₺400,000, and the shipping budget is 5% of sales. Actual sales are ₺440,000 and actual shipping ₺21,500. What is the variance against the flexible budget?
  3. Budgeted profit is ₺20,000. The sales volume effect is +₺8,000, the cost ratio −₺5,000 and advertising −₺6,000. What is the actual profit?
  4. With the threshold set at "5% and ₺3,000 together," an item's budget is ₺10,000 and its actual ₺10,600. Is it investigated?
  5. Why can profit fall even though sales rose?

Answer key:

  1. 56.000 − 50.000 = 6.000 ₺; 6.000 ÷ 50.000 = %12.
  2. Flexible budget 440,000 × 5% = ₺22,000; 21,500 − 22,000 = −₺500 (favorable).
  3. 20.000 + 8.000 − 5.000 − 6.000 = 17.000 ₺.
  4. Variance ₺600, 6%; it exceeds the percentage threshold but the amount is below ₺3,000, so it is not investigated.
  5. If the cost ratio has risen, variable expenses that grow with sales have increased, or planned expenses such as advertising have gone up, they can exceed the profit brought in by the sales increase.

Frequently Asked Questions About Comparing Budget and Actuals

How do you compare the monthly budget with actuals?

You build the budget line by line, total the actuals with the same line items at the end of the month, calculate the variance as an amount and a percentage, separate the volume effect with a flexible budget and investigate the items that exceed the threshold.

How is variance calculated?

Variance is found by subtracting the budget from the actual; its percentage is the variance divided by the budget. An increase in revenue is favorable, an increase in expenses unfavorable.

What is a flexible budget?

It is a budget recalculated by applying the budgeted ratio of items that change with sales to actual sales. It separates the part of the variance that comes from volume.

Sales rose but profit fell; why?

The cost ratio may have risen, variable expenses may have grown faster than sales, or planned expenses such as advertising may have exceeded the budget. A variance bridge shows which one had how much impact.

Which variances should be investigated?

Those that exceed both the percentage and the amount thresholds. For example, variances greater than 5% of the budget and above ₺3,000.

How often should the budget be updated?

The monthly budget is written at the start of the month; rewriting the next three months each month with the previous month's actuals keeps the budget realistic.

Is this much detail necessary for a small business?

A simple table with eight to ten line items and a fifteen-minute monthly meeting is enough for most small businesses.

How does NetKasam help with budget tracking?

It offers expense categories, cash and bank records updated together, a cash flow plan and saved reports; bookkeeping is free.

Conclusion: Put last month's budget side by side with actuals

The most useful thing you can do today is produce a table with eight to ten line items for last month: budget, actual, variance. Add the flexible budget for sales-linked items and allocate the profit gap to line items with a bridge. Usually one large item or two small ones explain most of the profit gap. Write down the owner of those items and a dated action. The next step is to turn this table into a template and update it on the same day every month in fifteen minutes.

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 FreeCustomer and Supplier Account Tracking

Read similar articles

19 free tools

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

All tools