Profitability per project

One row per interior project: the value sold, revenue invoiced, and cost so far split into OPEX and CAPEX. Also what is committed, the margin and how much of the budget is used. Filters show the jobs losing money or over budget.
PLANSScale only

The problem it solves

  • You learn a kitchen job lost money only after the accounts are closed.
  • The value sold and the money invoiced drift apart after change orders.
  • Nobody can compare margins across designers or project managers.

How it works

  1. Open Interiors > Projects > Reporting > Profitability. Running projects show to start with.
  2. Each row reads the project's budget ledger: revenue from posted payment milestone and design fee invoices, cost from purchase bills, subcontractor bills and expenses.
  3. Margin is revenue less cost, and Margin % is margin divided by revenue. Budget Used % is cost plus committed, divided by the budget.
  4. Filter Losing Money or Over Budget, group by project manager or client, or switch to the pivot and the bar chart.
  5. From a row, open the project, or open the ledger rows behind the figures.

Everything it does

Columns

  • Value Sold: the Project Value, moved by approved estimates and agreed change orders
  • Budget: the approved budget's total (hidden to start with)
  • Revenue: posted customer invoices that carry the project
  • Cost, OPEX Cost and CAPEX Cost, by each row's category
  • Cost of Labour and Committed (hidden to start with)
  • Margin, Margin % and Budget Used %; a row losing money shows red

Views and filters

  • List with totals, pivot and a bar chart
  • Filters: Running (on to start with), Losing Money, Over Budget
  • Group by project manager, client, status or entity

What it does not count

  • Invoices without the project; milestone and design fee invoices carry it by themselves
  • Designer time, since Interiors has no timesheets; Cost of Labour stays at zero unless rows are added by hand
  • Advances until they are settled

Who uses it

OwnerSees which jobs, designers and managers make money.
Finance headChecks revenue and cost against the ledger.
Project managerWatches the margin and budget used of their jobs.

Where you use it

  • Web: Interiors > Projects > Reporting > Profitability (managers)
  • Not in the Interiors apps

What you control

Settings

  • Nothing to set on the report itself
  • Budget categories decide what is OPEX and what is CAPEX

Questions

Why is a project's revenue zero?

Revenue counts only posted invoices with the project. Without Accounting, or before the first milestone invoice is posted, it stays at zero.

Does it include the furniture we sell with a markup?

The cost side counts the purchase orders and bills of the project. The client side counts what is invoiced through payment milestones, including proposal deposits.

Does it forecast the final margin?

No. It shows what is invoiced, spent and committed so far, against the budget and the value sold.

Which plan has it?

Scale.

Related features

See your next quote on it.

Tell us what you design and build, how many enquiries and jobs you have in a month and how you quote today. We will set up your packages and rates with you and send your first instant quote.