Skip to content
Back to documentation

Billing & Cash Projection

Track progress billing, receivables, payables, and a monthly cash projection for a project.

Where to find it

Inside a project → Finance → Billing tab

The Billing tab answers the money-movement questions a margin figure cannot: how much of the contract you have invoiced, how much completed work is still uninvoiced, who owes you, whom you owe, and roughly when cash moves in each direction. It sits under a project's Finance page — the header reads "Progress billing, receivables, payables and cash". Every number traces back to a document: an issued handover certificate, a purchase invoice, an open commitment, or a planned billing row you entered yourself.

Progress billing

Progress billing in ReflectHub is built from issued outbound handover certificates. When a certificate goes out to the customer, its net amount counts toward billed-to-date. Certificates in Draft never count; rejected and cancelled certificates are excluded too. The Progress billing card shows the running position: "Billed €412 000 of €650 000 contract · 63% · net, excl. VAT", with a progress bar against the current contract value (including approved change orders).

The headline of the card is unbilled earned: the value of completed work you have not yet invoiced. Earned value (EV) is the budget value of the work actually done — each task's percent complete times its budget baseline, summed across the project. Unbilled earned is that total minus billed-to-date. The card states it plainly: "€84 000 of completed work not yet invoiced." That is revenue you have earned on site but not yet asked for — usually the strongest prompt on the page to issue the next certificate.

The number can run the other way. If you have invoiced ahead of progress, the card says so: "billed ahead of earned value." And if the forecast engine has no earned-value signal yet (no baselines or percent-complete data), the card falls back to showing billed-to-date alone rather than guessing.

Below the summary, the Issued certificates table lists each certificate with columns Certificate, Status, Issued, Payment, Amount (incl. VAT) and Outstanding. Statuses shown are ISSUED, ACCEPTED and ACCEPTED WITH DEFECTS.

Payment tracking on both sides

Both directions of money carry the same payment fields: a due date and a payment status of Unpaid, Partial or Paid.

  • Payables. Purchase invoices in the Expense Documents view show a payment status chip and a "Due" date, with a text "Overdue" badge once the due date passes. The view can be filtered by payment status — All, Unpaid, Partial or Paid — which is the quickest way to pull up everything still owed on a project. A "Mark paid" action opens a short dialog — paid date, paid amount, an optional payment reference — and records the payment.
  • Receivables. Outbound certificates carry the same status chip in the Issued certificates table; their payment status and due date are recorded on the certificate itself.

Marking documents paid is what keeps the aging tables and the cash projection honest, so it is worth doing promptly.

Aging

Two cards, Receivables and Payables, bucket everything outstanding by how far past its due date it is: Not due, 1–30 days, 31–60 days and 60+ days, each with a total amount and an item count. A document with no due date can never be past due, so it sits in Not due. Under the buckets, a row table lists each document with its due date, status and outstanding amount — outstanding is the gross total minus what has been paid, so partial payments reduce it. When nothing is open, the card simply says "Nothing outstanding."

Planned billing

If you know your invoicing plan ahead of the certificates, the Planned billing card lets you record it: one row per month with a planned amount and an optional note. It is deliberately minimal — Month, Planned, Note — and exists to feed the cash projection with future inflows before the certificates exist. Issued certificates in the same month are counted separately; planned rows are not netted against them. One row per month, amounts must be non-negative, and the card is only shown to users who can edit project finance.

Cash projection

The Cash projection chart pulls the pieces together into a monthly in/out view over a rolling window: three months back and six months forward. For each month:

  • Out — unpaid purchase invoices due that month, plus the remaining amount of open commitments (RFQ awards and manual commitments) with an expected date in that month.
  • In — unpaid issued certificates due that month, plus planned billing rows for that month.

Bars show inflow and outflow; a Cumulative net line runs across the window, starting from zero at the window's left edge. Amounts are gross, VAT included — this is a bank-account view, not an accounting one. For screen readers, the same data is available as a table: the same months, with Inflow, Outflow, Net and Cumulative net columns.

One disclosure matters. A commitment without an expected date, or an invoice or certificate without a due date, cannot be placed in a month — so it is not plotted. The chart says so explicitly in its footer, for example: "not shown: €37 000 committed without expected date." Read that line before trusting the shape of the chart. Dated items outside the window are likewise simply outside the window.

What this is, and is not

This is a simple projection: documents and commitments placed on a calendar by their dates, summed per month. It is not an S-curve or time-phased budget model, and it is not revenue recognition — billed versus earned is shown side by side, never booked. Its accuracy is exactly the accuracy of your due dates, expected dates and payment statuses. Keep those current and the chart earns its keep.

Still have questions?

Our support team is here to help. Reach out directly or browse the FAQ for quick answers.