Odoo18 R&D Sneak Peak

May 25, 2024 by
Odoo18 R&D Sneak Peak
ZestyBeanz Technologies


                                                                                                                 

Budget management in Odoo 19 Accounting helps businesses plan their finances, allocate budgets to projects and departments, and monitor actual income and expenses. By comparing budgeted, committed, and achieved amounts, businesses can control spending and make informed financial decisions.

In this guide, we explain how to configure budgets, create budget lines, track purchase orders and vendor bills, monitor revenue, handle currency conversion, and analyze budget performance using the Budget Report.

1. Enable Budget Management in Odoo 19

Before creating a budget, activate the Budget Management feature.

  1. Open the Accounting module.
  2. Go to Configuration → Settings.
  3. Locate the Budget Management option.
  4. Enable the feature and save your changes.

Once enabled, the budget functionality becomes available in the Accounting module.

2. Access the Budget Dashboard

Navigate to Accounting → Analytic Budget to view and manage budgets.

The list view displays the budget name, period, responsible person, activities, and status.

Generate Budgets for Multiple Periods

Click Generate, set the From and To dates, and select Month, Quarter, or Year as the period. Click Split to create separate budgets for each period. Generated budgets are created in Draft status.

Odoo can display combinations of the selected Analytic Plans, helping users create analytic-account combinations without entering every combination manually.

3. Create a New Budget

From the budget dashboard, click New and configure the budget details.

Budget Period and Company

Use the Period field to set the start and end dates. The Company field is populated from the database configuration.

Budget Type

  • Revenue: Tracks income against the planned revenue budget.
  • Expense: Tracks expenditure against the allocated budget.
  • Both: Tracks revenue and expenses within the same budget.

4. Configure Budget Lines

In the Budget Lines tab, click Add a Line to define financial allocations. A line can be associated with analytical dimensions such as Project, Department, or Internal Category.

  • Budgeted Amount: The planned allocation for the selected analytical dimension.
  • Committed Amount: Qualifying commitments, such as confirmed purchase orders, before the related expense is recorded through a posted vendor bill.
  • Achieved Amount: Actual financial results recorded through qualifying posted accounting entries.

After configuring the required details, click Open to activate the budget. Available actions depend on the budget's current status.

5. Understand Budget Performance Percentages

Theoretical Percentage

The Theoretical Percentage indicates the proportion of the budget expected to have been used by the current date if spending occurred evenly throughout the budget period.

Committed Percentage

The Committed Percentage indicates the proportion reserved through qualifying commitments.

Committed % = (Committed Amount ÷ Budgeted Amount) × 100

Achieved Percentage

The Achieved Percentage indicates the proportion represented by actual recorded financial results.

Achieved % = (Achieved Amount ÷ Budgeted Amount) × 100

These indicators help finance teams compare expected progress, actual results, and committed expenditure. Depending on the budget status, available actions may include Revise, Reset to Draft, and Done.

6. Track Purchase Orders Against a Budget

Assume the Active Account project has a budget of $1,000.

  1. Open the Purchase module and create a new purchase order.
  2. On the order line, set Analytic Distribution to the same analytic account used by the budget line, such as Active Account.
  3. Click Confirm Order.
  4. Return to Accounting → Analytic Budget and open the relevant budget.

The qualifying purchase order amount is reflected in the Committed amount of the matching budget line.

7. Track Actual Expenses Through Vendor Bills

After the vendor bill is created and posted, the actual expense is reflected in the Achieved amount of the matching budget line.

Budget MetricAmount
Budgeted Amount$1,000.00
Confirmed Purchase Order$500.00
Posted Vendor Bill$500.00

Committed and Achieved represent different stages of financial activity. Their values depend on the underlying transactions and Odoo's budget calculation rules.

8. Calculate the Theoretical Budget Amount

The Theoretical Amount estimates the portion of the budget expected to have been used by a given date, assuming even spending.

Theoretical Amount = Budgeted Amount × (Elapsed Days ÷ Total Days)

Example:

  • Budgeted Amount: $1,000
  • Budget Period: January 1 to December 31
  • Total Days: 365
  • Elapsed Days: 280

$1,000 × (280 ÷ 365) = $767.12 (approximately).

If the Committed amount and Achieved amount are each $500:

  • Committed Percentage: ($500 ÷ $1,000) × 100 = 50%
  • Achieved Percentage: ($500 ÷ $1,000) × 100 = 50%

Note: This is a simplified straight-line example. Actual results depend on Odoo's calculation logic, configured dates, and the records included in the budget.

9. Currency Conversion in Budget Management

Budgets are displayed in the company currency. Transactions in another currency are converted using the applicable exchange rate.

  • Company Currency: USD
  • Purchase Order Currency: SAR
  • Purchase Order Amount: SAR 100
  • Exchange Rate: 1 SAR = 0.2179 USD
SAR 100 × 0.2179 = USD 21.79

The qualifying commitment is reflected in the budget in USD. The final amount depends on the applicable rate, transaction date, and currency configuration.

10. Budget Tracking with Analytic Distribution Percentages

The amount assigned to a budget line depends on the Analytic Distribution percentage allocated to the matching analytic account or dimension.

Example 1: Allocate 50% to a Project

For a $100 purchase order line assigned 50% to Asustek - Wood Corner:

$100 × 50% = $50.00

The qualifying $50 allocation is reflected in that account's Committed amount.

Example 2: Allocate a Purchase Across a Project and Department

A $1,000 purchase order line is distributed 50% to the project and 50% to the Administrative department.

Analytical DimensionDistributionAllocated Amount
Asustek - Wood Corner50%$500.00
Administrative50%$500.00
Total100%$1,000.00

The corresponding budget lines reflect $500 for the project and $500 for the department, provided the analytic configuration and budget lines match.

11. Audit Budget Transactions

Each budget line provides an Audit action that opens the Budget Report for that line. It can show records contributing to the Budgeted, Committed, and Achieved amounts, including dates, descriptions, projects, departments, and amounts.

This helps finance teams verify reported figures and trace financial activity to its source transactions.

12. Track Revenue with a Revenue Budget

When the Budget Type is Revenue, qualifying income from posted customer invoices is reflected in the matching budget lines. The Both type can track revenue and expenses together.

Example:

  • Budgeted Revenue: $10,000
  • Posted Customer Invoice: $100
  • Analytic Account: [INT] After-Sales Services

After the invoice is posted, the qualifying $100 appears in the Achieved amount of the matching revenue budget line.

Revenue Achieved % = ($100 ÷ $10,000) × 100 = 1%

Revenue can also be tracked by project, department, or another configured analytic dimension. Analytic Distribution allocates the relevant portion to matching budget lines.

13. Analyze Financial Performance with the Budget Report

The Budget Report, available from the Accounting module's Reports menu, helps users compare planned allocations with committed expenditure and actual financial results.

Depending on the view and available data, the report may include:

  • Date and description
  • Project and department
  • Internal category
  • Budgeted Amount
  • Committed Amount
  • Achieved Amount

Pivot View

The Pivot view summarizes budget data across available dimensions, helping users compare figures across projects and departments.

Graph View

The Graph view visualizes budget information, making spending trends and budget performance easier to compare.

Conclusion

Odoo 19 Budget Management helps businesses plan financial allocations, monitor expenditure, and track revenue across projects, departments, and other analytic dimensions. By connecting budget lines with analytic accounts and distributions, businesses can monitor qualifying purchase commitments, posted vendor bills, and customer invoices.

The Theoretical, Committed, and Achieved indicators provide different perspectives on financial performance, while the Audit action and Budget Report help users investigate transactions and analyze results.

Need Help with Odoo 19?

Contact our team to learn how Odoo can support your company's budgeting and financial reporting requirements.

Contact Us