Maintainers
Current maintainers:
This module is part of the ecosoft-odoo/budgeting project on GitHub.
You are welcome to contribute.
Budget Control
This module is the main module from a set of budget control modules. This module alone will allow you to work in full cycle of budget control process. Other modules, each one are the small enhancement of this module, to fullfill additional needs. Having said that, following will describe the full cycle of budget control already provided by this module,
Budget Control Core Features:
Budget Commitment (base.budget.move)
Probably the most crucial part of budget_control.
- Budget Balance = Budget Allocated - (Budget Actuals - Budget Commitments)
Actual amount are from account.move.line from posted invoice. Commitments can be sales/purchase, expense, purchase request, etc. Document required to be budget commitment can extend base.budget.move. For example, the module budget_control_expense will create budget commitment expense.budget.move for approved expense. Note that, in this budget_control module, there is no extension for budget commitment yet.
Budget Template (budget.template)
A Budget Template in the budget control system serves as a framework for controlling the budget, allowing for the budget to be managed according to the pre-defined template. The budget template has a relationship with the accounting, and is used to control spending based on pre-configured accounts.
Budget Period (budget.period)
Budget Period is the first thing to do for new budget year, and is used to govern how budget will be controlled over the defined date range, i.e.,
- Duration of budget year
- Template to control (budget.template)
- Document to do budget checking
- Analytic account in controlled
- Control Level
Although not mandatory, an organization will most likely use fiscal year as budget period. In such case, there will be 1 budget period per fiscal year, and multiple budget control sheet (one per analytic).
Budget Control Sheet (budget.control)
Each analytic account can have one budget control sheet per budget period. The budget control is used to allocate budget amount in a simpler way. In the backend it simply create budget.control.line, nothing too fancy. Once we have budget allocations, the system is ready to perform budget check.
Budget Checking
By calling function – check_budget(), system will check whether the confirmation of such document can result in negative budget balance. If so, it throw error message. In this module, budget check occur during posting of invoice and journal entry. To check budget also on more documents, do install budget_control_xxx relevant to that document.
Budget Constraint
To make the function – check_budget() more flexible, additional rules or limitations can be added to the budget checking process. The system will perform the regular budget check and will also check the additional conditions specified in the added rules. An example of using budget constraints can be seen from the budget_allocation module.
Budget Reports
Currently there are 2 types of report.
- Budget Monitoring: combine all budget related transactions, and show them in Standard Odoo BI view.
- Actual Budget Moves: combine all actual commit transactions, and show them in Standard Odoo BI view.
Budget Commitment Move Forward
In case budget commitment is being used. Sometime user has committed budget withing this year but not ready to use it and want to move the commitment amount to next year budget. Budget Commitment Forward can be use to change the budget move’s date to the designated year.
Budget Transfer
This module allow transferring allocated budget from one budget control sheet to other
Extended Modules:
Following are brief explanation of what the extended module will do.
Budget Move extension
These modules extend base.budget.move for other document budget commitment.
- budget_control_expense
- budget_control_purchase
- budget_control_purchase_request
- budget_control_sale
Budget Allocation
This module is the main module for manage allocation (source of fund, analytic tag and analytic account) until set budget control. and allow create Master Data source of fund, analytic tag dimension. Users can view source of fund monitoring report
- budget_allocation
Tier Validation
Extend base_tier_validation for budget control sheet
- budget_control_tier_validation
Analytic Tag Dimension Enhancements
When 1 dimension (analytic account) is not enough, we can use dimension to create persistent dimension columns
- analytic_tag_dimension
- analytic_tag_dimension_enhanced
Following modules ensure that, analytic_tag_dimension will work with all new budget control objects. These are important for reporting purposes.
- budget_allocation
- budget_allocation_expense
- budget_allocation_purchase
Important
This is an alpha version, the data model and design can change at any time without warning. Only for development or testing purpose, do not use in production. More details on development status
Table of contents
Usage
Before start using this module, following access right must be set.
- Budget User for Budget Control Sheet, Budget Report
- Budget Manager for Budget Period
Followings are sample steps to start with,
Create new Budget KPI
To create budget KPI using in budget template
Create new Budget Template
- Add new template for controlling Budget following kpi-account
Create new Budget Period
- Choose Budget template
- Identify date range, i.e., 1 fiscal year
- Plan Date Range, i.e., Quarter, the slot to fill allocation in budget control will split by quarter
- Control Budget = True (if not check = not check budget for this period)
Create Budget Control Sheet
To create budget control sheet, you can either create manually one by one or by using the helper, Action > Create Budget Control Sheet
- Choose Analytic budget_control_purchase_tag_dimension
- Check All Analytic Account, this will list all analytic account in selected groups
- Uncheck Initial Budget By Commitment, this is used only on following year to init budget allocation if they were committed amount carried over.
- Click “Create Budget Control Sheet”, and then view the newly created control sheets.
Allocate amount in Budget Control Sheets
Each analytic account will have its own sheet. Form Budget Period, click on the icon “Budget Control Sheets” or by Menu > Budgeting > Budget Control Sheet, to open them.
- Based on “Plan Date Range” period, Plan table will show all KPI split by Plan Date Range
- Allocate budget amount as appropriate.
- Click Control button, state will change to Controlled.
Note: Make sure the Plan Date Rang period already has date ranges that covers entire budget period. Once ready, you can click on “Reset Plan” anytime.
Budget Reports
After some document transaction (i.e., invoice for actuals), you can view report anytime.
- On Budget Control sheet, click on Monitoring for see this budget report
- Menu Budgeting > Budget Monitoring, to show budget report in standard Odoo BI view.
Budget Checking
As we have checked Control Budget = True in third step, checking will occur every time an invoice is validated. You can test by validate invoice with big amount to exceed.
Bug Tracker
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
Authors
- Ecosoft
Contributors
- Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
- Saran Lim. <saranl@ecosoft.co.th>