When the budget slips away: Carlos's story
Carlos, a project manager at a mid-sized construction company, always started his projects with a detailed budget. But at the end of each month, the numbers didn't add up. Material purchases soared, labor costs spiraled out of control, and revenue wasn't recorded on time. On the last project, a 12-story building, the cost overrun reached 20% and the profit evaporated. The problem: he had no system integrating budgets, purchasing and accounting in real time. Everything was in disconnected spreadsheets. That's when he saw the need for Odoo and a partner like Ganemo.
Project creation and analytic account
In Odoo, from the Projects app you can create multiple projects. It's best to use templates so tasks are generated automatically. When creating a project, it's key to ensure an associated analytic account (cost center) is generated. Without it, there is no cost control.
For example, when Carlos created the Torre Oasis project, he used a construction template. Tasks, owners and deadlines were created automatically. Then, from the project settings, he enabled automatic analytic account creation. In one click, he had the cost center ready. Had he not done so, expenses and income would not have been correctly assigned to the project. Ganemo always recommends verifying this step to avoid headaches.
Defining budget line items
Construction budget line items are analytic plans that group concepts such as materials, labor, fuel, etc. Each company can customize them to its business. In Odoo, they are managed as additional analytic accounts.
Carlos defined his line items: Progress Billing (income), Materials, Direct Labor and Fuel. When creating the April budget, he assigned amounts to each item: 500,000 in income and 350,000 in expenses distributed. Note that he didn't use all available items, only the relevant ones. This gave him flexibility to control what really matters. With Ganemo, you can quickly configure these items and ensure they align with your chart of accounts.
Creating budgets by period
Odoo lets you create budgets by month, quarter or year. In the project, from the dashboard, you add budgets by defining type (income/expense/both) and period.
Carlos created two budgets: one for April and one for May. In each, he repeated the line items with estimated amounts. This gave him a monthly view of what was expected. Had he wanted a single budget for the whole project, he could have done so without dividing by month. The key is the dates: the system uses the period to compare against what was executed. Ganemo stresses the importance of correctly filling in dates so the report works.
Recording income and expenses: the accounting foundation
Budget execution is fed by journal entries. Each sales or purchase invoice, or manual entry, carrying the correct analytic accounts (project + line item) updates the actuals.
Carlos recorded a sales invoice for 480,000 assigned to the Oasis project and the Progress Billing line item. Automatically, the April budget showed 480,000 executed out of 500,000 budgeted. Then, to test expenses, he recorded a purchase invoice for 300,000 in labor, but noticed it exceeded the budget. This led him to implement purchase orders with prior approval.
Purchase control with purchase orders
To avoid cost overruns, it's advisable that all expenses go through a purchase order (PO) following an approval workflow. When creating a PO, Odoo shows an alert if the amount exceeds the remaining budget.
Carlos eliminated the direct invoice and created a PO for 84,000 (net of VAT) for labor. When validating the PO, the system verified that budget was available. Then, upon receiving the invoice, the cost centers were automatically inherited. The result: executed expense stayed at 84,000, within budget. Ganemo recommends setting up approval workflows so each PO is reviewed by the owner before proceeding.
Deferred income and manual journal entries
Not all accounting records are invoices. For example, customer advance payments are recorded as liabilities (control accounts) and don't impact the budget until the income is recognized.
Carlos received an advance of 140,000 that he recorded in a liability account (deferred income) assigned to the project. This amount didn't appear in the income budget, but did appear in an analytic report by financial account. When, months later, he recognized 100,000 as actual income, he made a manual entry debiting the liability account and crediting the income account, assigning the correct line items. This way he could control the conversion from deferred to accrued. With Ganemo, you can automate these analytic distributions so entries are generated without errors.
Reports and dashboards
Odoo offers multiple views for monitoring: from the project dashboard (with execution charts) to accounting budget reports grouped by project, line item and period.
Carlos uses the project dashboard to quickly see progress. He also accesses the budget analytic report in Accounting to compare budgeted vs. actual for all projects. There he sees that in April he has income of 580,000 (including the manual recognition) and expenses of 84,000, with a net of 495,000. If he needs to dig deeper, he clicks the line item and sees the detail of the invoices or entries that originated it. Ganemo trains teams to get the most out of these tools and make informed decisions.
Conclusion: total control with Odoo and Ganemo
Carlos transformed his management. Now every purchase goes through approval, income is recorded correctly, and he can see in real time whether he is deviating from budget. The result: Torre Oasis finished with a cost overrun of less than 2%, thanks to the Odoo integration. If you also want to achieve that level of control, Ganemo is the ideal partner to implement Odoo in your company. We help you configure analytic accounts, budget line items, approval workflows and tailored reports. Contact us and take your projects to the next level.