Back to the journal
Studio life3 min read

Why your project numbers are wrong, and it is not the spreadsheet's fault

Check time records, invoice dates, recorded payments and cost definitions before trusting a project total. Revenue and effort do not, by themselves, establish profit.

Designer sketching in a notebook beside floor plans and material swatches
Photography by Antoni Shkraba
In this article

When a project total looks wrong, start by asking what it measures. Invoiced value, recorded payments, time valued at billing rates and profit are different figures. A perfectly calculated report can still answer a different question from the one you intended.

Software can keep records connected. It cannot make incomplete time entries complete or turn a billing rate into a labor cost.

One project can have four different numbers

An illustrative snapshot
MeasureAmountWhat it means
Invoices issued$6,000Documents raised for the client.
Payments recorded$3,000Money recorded against those invoices.
40 billable hours at $150$6,000Value of time at the stored billing rate.
Project profitNot establishedCosts and a consistent revenue basis are still needed.

The matching $6,000 totals do not make invoiced revenue and time value equivalent. A fixed phase can consume more or fewer hours without changing its agreed fee. Payments can also arrive in a different period from the invoice.

Check the inputs before the formula

Look for missing time, the wrong project or phase, incorrect billable status and an unexpected rate. Then inspect cancelled or duplicate invoices, manual adjustments and payments that have not been recorded.

Be especially careful with changes made after an invoice was issued. A corrected time record and a historic client document need an explicit reconciliation; changing one does not mean the other has changed appropriately.

Align the periods and the scope

An invoice-period report may include a payment received later against an invoice issued during the selected period. A cash-period report instead asks which payments arrived within that period. Neither can be substituted for the other without checking the definition.

In Rizqo, invoiced totals follow non-cancelled invoices issued within the selected dates. Collected amounts relate to those invoices. Hours follow the dates of the time entries. This is why the report documentation matters when reconciling figures.

Revenue and effort are not profit

A profit measure needs a defined revenue basis and the corresponding costs. Those may include direct labor, employer costs, consultants, expenses and an agreed overhead allocation. State what is included before comparing projects or periods.

Rizqo does not hold staff costs or calculate gross margin, profit or a cost-based effective rate. Its existing “project profitability” report displays revenue and effort. Use it to investigate records; use the appropriate accounting process to establish financial profit.

Similarly, billable hours do not establish utilization without a defined denominator. A share of recorded hours can conceal missing time.

Make the review repeatable

  1. Choose the project, period and question.
  2. Confirm which date each metric uses.
  3. Review time completeness, classification and rates.
  4. Compare agreed phase progress with issued invoices.
  5. Reconcile recorded payments with the underlying records.
  6. Bring in the defined costs if the question is profitability.

This sequence helps distinguish a data problem from a definition problem. Fixing the former needs corrected records; fixing the latter needs a clearer question.

Read the project-profitability guide and manual time workflow. In a Rizqo demo, ask to trace one report figure back to its invoices or time entries.

From the Rizqo journal

Essential storage remembers your choice and supports bookings. Optional analytics help us understand which pages and resources are useful. They include page visits, downloads, calculator use and demo starts, without form contents.

You can change this choice here at any time. Read our Privacy Policy.