How do you choose an ERP for an agency that bills fixed fees?

On a $12,000 job, eight hours charged to the wrong project can inflate margin by $440. Can your team find the error during an ERP demo?

A hand points to a technical drawing on a table with an orange pencil.

Article content

Give each ERP vendor the same fixed-fee agency job. Hand over the signed quote, timesheets, a subcontractor bill and a client invoice. By the end of the demo, your project lead should be able to explain the job margin, show where the estimate slipped and open the records behind the numbers. A dashboard total alone is difficult to check.

Start with the decision your project lead has to make

A job can be delivered, half invoiced and still unpaid. None of those facts tells a design studio whether to quote the same fee next time. If someone has to reconcile a time tracker, a project board and the accounting system every time a job closes, that reconciliation makes a good selection test for an enterprise resource planning system (ERP).

Give both vendors the same fixed-fee job

In this fictional example, an industrial design studio agrees to design an enclosure for CA$12,000 before tax. An outside shop makes the prototype. Put one job number on the quote, timesheets and bills. Keep a copy of the approved budget. The CA$55 hourly rate below represents the studio’s assumed labour cost. All amounts are in Canadian dollars.

ItemApproved budgetAt completion
Fixed fee$12,000$12,000
Labour at $55/hr100 hr · $5,500112 hr · $6,160
Outside prototype$1,500$1,800
Margin after direct costs$5,000 · 41.7%$4,040 · 33.7%

Ask for a demo environment where your own project lead and bookkeeper can work with fictional records. Ask the vendor to price the roles they need, migration of open jobs, the accounting connection and ongoing support. The cost of getting your first live job out the door can include all four.

Run the quote, time and billing through the system

  1. Set up the fixed-fee job. Enter the $12,000 fee, a 100-hour labour budget and a $1,500 estimate for the prototype. Once the job closes, ask to see that original budget alongside the actuals.
  2. Approve 112 hours. The labour cost should be $6,160. The extra 12 hours cost the studio $660. Without an agreed change order, the client still owes the original $12,000 fee over the life of the job.
  3. Post the supplier bill to the job. Use a bill for $1,800 against the prototype estimate. Trace it back to its document number. The actual outside cost should appear once. A $3,300 charge would include both the estimate and the bill.
  4. Separate billing from cash. Assume the client has accepted the finished work. The first $6,000 invoice has been issued and is unpaid. Find the $6,000 invoiced, the $6,000 still to invoice and the $0 collected. Then check that the job costs are the same.

Ask for evidence that fits each ERP

In Odoo 19, project profitability draws on entries linked to the project and its analytic account. Employee settings determine the cost of recorded time. Ask the presenter to open the timesheets and the supplier bill from the job and show how they would trace a bill assigned to the wrong account. Odoo’s project profitability documentation.

In Dynamics 365 Business Central, project planning lines can track budget, billable amounts or both. Ask to see the line that carries the fixed fee, the budgeted costs and the actual usage recorded in the project journal. The extra time should increase the cost without generating an extra customer charge. Microsoft’s guide to project budgets.

Give the project lead one mistake to find

In a test copy, move eight of the 112 hours to another job. The first job will appear to earn $4,480. Ask the project lead to trace the $440 difference, have the entry corrected with the appropriate permissions and export the job detail. Your independent check is $12,000 − $6,160 − $1,800 = $4,040. That is $960 below budget, explained by $660 in extra labour and a $300 prototype overrun.

This margin measures a completed, accepted job against its direct costs. For work in progress, add an estimate to complete. Track overhead, cash and accounting revenue recognition separately. We checked the arithmetic on the fictional records. The vendor documentation describes the product capabilities. Your team still needs to run the workflow in the configuration being quoted.

What to check before you sign

  • The approved budget survives alongside the actual costs.
  • Your team can trace the labour, the purchase and the correction.
  • The fee, invoiced amount and cash collected are separately visible.
  • Your bookkeeper can reproduce the $4,040 margin from an export.

If your time tracker and accounting package can already pass this test using a shared job number, get a price for connecting them. Our guide to eliminating double entry explains how to assign ownership of each field. For help connecting project time to job costing, see our custom application and integration services.

Explore more articles

Let’s discuss your project.

Tell us what you would like to improve. We’ll help you decide on the next steps.

Start the conversation