Skip to content
العربيةLet’s talk

Practical guide

How to reconcile the costs of one contracting project in Odoo

Trace one contracting job in Odoo from a shared subcontractor bill and logged hours to a customer invoice. Compare recorded costs with the original estimate.

Lava Solutions · · 3 minute read

A technician checks industrial equipment while holding a printed checklist.
Illustrative stock photo. Photo: TECNIC Bioprocess Solutions / Unsplash.

A site manager says the installation is halfway through. Finance has issued the first invoice, and a subcontractor has billed for work on two sites. To evaluate Odoo for a contracting company, ask the presenter to open one job and show how much of each transaction belongs to it. Bring the original estimate: you will need it to explain which costs are still ahead.

Prepare a job with a clear boundary

Use a billable project in a test database. Give the job a reference, identify its analytic account, and set a reporting date and currency. Select a fixed-price service with an agreed invoicing policy. Write down the signed contract value, the original cost estimate for the entire job and the work covered by the first invoice. Keep these as three separate entries on the worksheet.

Odoo’s project profitability guide explains how the dashboard draws on records linked to the project and its analytic account. Ask finance to open one linked sales document and the supervisor to open one time entry. Seeing the same customer name on two documents is insufficient when that customer has commissioned several sites.

Work through one fictional fit-out job

In this fictional example, all amounts are in the same currency and exclude tax. The agreed job value is 10,000 and the original estimate for all direct costs is 3,800. At the review date there is a confirmed first customer invoice for 4,000. The test includes two cost records and no others:

  • Subcontracted work. A posted supplier bill has one line for 500 covering two jobs. The site supervisor confirms that 60% belongs to the job under review. In one project analytic plan, assign 60% to this job and 40% to the other. The worksheet should show 300 here and 200 on the second job. Check the split on the bill line using Odoo’s analytic distribution instructions.
  • Site labour. One employee logged four hours against the job. With a test cost rate of 25 per hour, expect 100 of labour cost. Check the person, the job reference and the hourly cost used by the test database. In this fixed-price example, the four hours do not represent a separate customer charge.

Read the figures the way the site team will use them

First reconcile the 4,000 to the confirmed customer invoice. Then explain the remaining 6,000 of contract value using the sales and delivery records. Ask which work is still to be delivered and which work, if any, is ready to invoice. Odoo distinguishes amounts on orders, amounts available to invoice or bill after delivery, and confirmed invoice or bill amounts. For cash received, ask finance to check the payment separately.

Next reconcile the 400 in recorded costs to the supplier’s 300 and the employee’s 100. The difference between 4,000 invoiced and these 400 of costs is 3,600. That arithmetic alone cannot tell the project manager how much the job will earn at completion. Ask for the remaining labour and subcontract work, the expected cost of each, and the date of that forecast. Add the 400 already recorded to the forecast cost of the remaining work, then compare that total with the original estimate of 3,800.

Make one change and repeat the check

For the second test, start from a copy of the test database saved before the supplier bill was posted. Assign 80% of that bill line to this project, then post the bill once. Keep the total bill and hours unchanged. The supplier contribution to this job becomes 400, the other job gets 100, and this job now has 500 of recorded costs. If the figure differs, inspect the bill status, its analytic distribution, the time entry and the reporting date. Record the document reference beside each difference.

The project manager should leave with a worksheet they can reproduce on another job. For a wider finance rehearsal, use the Odoo accounting setup checklist. To plan a demonstration for your contracting team, contact Lava with an anonymised job estimate, the billing milestones and one example of a cost shared between sites.

Sources & further reading

A useful next step

Bring one real workflow.

Share the process you want to improve, the systems involved and the decision you need to make.

Talk to Lava ↗