Skip to Content

Budgets in Odoo: planning, tracking and variance reports

How to build an annual budget in Odoo by branch, department or project, track commitments from purchase orders, review variances monthly and keep forecasts alive during the year.
November 7, 2026

Most companies in the region still budget in spreadsheets: a big file built in December, approved in January and forgotten by March. The problem is not the spreadsheet. It is that the budget lives apart from the actual numbers, so nobody compares the two until it is too late to act. Putting the budget in Odoo, next to the actuals and the commitments, changes how it is used.

FlexCode Middle East is part of FlexCode Systems GmbH, an Odoo Silver Partner. We implement Odoo, so Odoo is the system we describe, next to an honest look at the topic itself.

Key points

  • Budget where the actuals are. Budgets in Odoo are compared with posted entries automatically, by account and analytic dimension.
  • Commitments count. Confirmed purchase orders show as committed spend before the bill arrives.
  • Monthly phasing. Budgets split by month make variances meaningful during the year.
  • Owners see their numbers. Branch and department managers can follow their own budget without waiting for finance.

Why budgets belong in the ERP

A budget is only useful if it changes decisions during the year: slowing spending in a department that is running ahead, investing more in a branch that is outperforming, catching a cost that is drifting. That requires seeing budget, actual and commitment side by side, every month, at the level where decisions are made. In a spreadsheet, that comparison takes days to build. In Odoo, it is a report.

3 columns

Budget, actual and committed

Monthly

Phasing and review cycle

Analytic

Budgets per branch, department or project

Live

Actuals update as entries are posted

Building the budget

Odoo budgets are defined against analytic accounts and, optionally, accounts or account groups. A typical structure has one budget per year with lines per department or branch for each major income and expense heading.

  1. Agree the dimensions: which analytic plans the budget will follow, usually branch or department, and project for contracting companies.
  2. Agree the headings: revenue, cost of sales, salaries, rent, marketing, travel and so on, mapped to account groups.
  3. Prepare figures in an Odoo spreadsheet starting from last year's actuals, then adjust.
  4. Phase each line by month, reflecting seasonality such as Ramadan, summer or year-end peaks.
  5. Import or enter the approved budget in Odoo and lock it as the original version.

Phasing matters more than precision. A budget split evenly over twelve months will show false variances every month for any seasonal business.

Seasonal businesses should read Ramadan stock planning in Odoo for a practical example of phasing.

Tracking budget, actual and committed

  1. Budget approved
  2. Purchase order confirmed
  3. Shown as committed
  4. Bill posted
  5. Moves to actual

Committed spend warns you before the money is gone.

Actuals come from posted journal entries with the matching analytic distribution. Commitments come from confirmed purchase orders not yet billed. Together they show how much of each budget line is already used or promised, which is the number a department head needs before approving the next request.

Purchase approvals can check the budget before a PO is confirmed; see purchase approvals and vendor control in Odoo. Budgets depend on reliable analytics, explained in analytic accounting in Odoo.

Budget planning spreadsheet on a laptop
Prepare in a spreadsheet, track in the ERP.

A monthly review that works

  1. Day 5

    Books for the month are closed enough to report

  2. Day 6

    Variance report by branch and department sent to owners

  3. Day 8 to 10

    Short review meetings: explain variances above a threshold

  4. Quarterly

    Update the forecast for the rest of the year

  • Explain variances above an agreed amount or percentage, not every line.
  • Separate timing differences from real overspending.
  • Keep the original budget unchanged and track forecasts as a separate version.
  • Give managers read access to their own budget lines in Odoo.

Common mistakes

  • Budgeting by account only, so no manager owns any line.
  • Even monthly phasing for seasonal businesses.
  • Analytics missing on actuals, so budget versus actual is meaningless.
  • Overwriting the budget with forecasts, so the original target is lost.

For management reporting beyond budgets, see dashboards and spreadsheet reports in Odoo, and to estimate the value of the whole system, try our Odoo ROI calculator.

FlexCode builds budgeting into Odoo

We design budget structures on your analytics, import your approved budget, set up commitments and variance reports and train your managers.

Book a free call

Frequently asked questions

Does Odoo have budgeting?

Yes. Odoo Accounting includes budgets by analytic account, compared automatically with actual postings and purchase commitments.

Can I budget by branch and department?

Yes, through analytic plans for branches and departments.

What are committed amounts?

Confirmed purchase orders that are not yet billed, shown against the budget so you see spending before it happens.

Can I still prepare the budget in Excel?

Yes. Prepare it in Excel or Odoo spreadsheets and import the approved version.

How do I handle forecasts?

Keep the approved budget unchanged and maintain forecasts as a separate version for comparison.

Talk to us about how Odoo fits your business. Book a free call

Run invoicing, stock and accounts from one system.

FlexCode Middle East implements Odoo in Arabic and English for companies in Egypt, Saudi Arabia and the UAE.