Define what each number means before adding it up
A signed project, an invoice, and a payment describe different events. If you add them together as revenue, you may count the same work several times. Start with three separate columns. Booked work records a confirmed client commitment under your chosen booking rule. Invoices issued records the amounts billed. Cash received records payments that actually arrived.
For a simple management scoreboard, define booked work as the agreed fee for confirmed scope when the written agreement is accepted. Exclude optional phases and unsigned proposals. Use another clear rule if your business needs it, but write it down and apply it consistently. This is an operating definition for pipeline coaching, not a prescription for accounting revenue recognition or tax reporting.
Choose one weekly boundary, such as Monday through Sunday in your local time zone. Choose a currency for each view. If clients pay in different currencies, keep currency totals separate or document the conversion rule you use; do not add dollars and euros as though they were the same unit. Consistent definitions matter more than a visually impressive dashboard.
Build a small ledger that can be checked
Use one row per event, with date, client or project identifier, event type, amount, currency, and a reference back to the agreement, invoice, or payment. A booking event and a later payment event can refer to the same project, but they go into different weekly totals. You need enough detail to trace a number without turning the scoreboard into a second bookkeeping system.
For example, on Monday you confirm a $3,000 project. On Tuesday you issue a $1,000 deposit invoice. On Thursday the $1,000 payment arrives. That week shows $3,000 booked, $1,000 invoiced, and $1,000 cash received. It does not show $5,000 in sales. The remaining agreed fee is not another new booking when you invoice it later.
Use records you control and reconcile against the actual source. If a payment processor reports a gross payment and a smaller bank settlement after fees, choose and label which amount the cash column uses. Keep fees identifiable instead of switching between gross and net depending on the week. Outstanding invoices should still reconcile with your invoice records.
Make the weekly scoreboard small enough to use
A practical weekly view can contain net new booked work, invoices issued, cash received, and outstanding invoices at the cutoff. The first three are events during the week. The last is a balance at a point in time. Label that distinction so someone reading the sheet does not add all four numbers into a single total.
Here is an example week: $3,000 new booked work, a $500 reduction to previously booked scope, $1,000 invoiced, and $1,000 cash received. Net new booked work is $2,500: the new commitment minus the reduction. If there were $800 outstanding before the week, and the only new invoice was fully paid, the ending outstanding balance stays $800. Check the arithmetic against the underlying rows.
Record cancellations and reductions as adjustments when confirmed, with a reference to the original booking. Do not delete old rows and lose the history. A payment refund is a cash adjustment; a scope cancellation can also affect booked work. Track each event in the right column rather than assuming every refund changes every number by the same amount.
Choose one primary metric for the current bottleneck
There is no single business number that answers every question. If your immediate problem is an empty future calendar, net new booked work can be a useful primary metric because it records confirmed selling outcomes. If your problem is late payment, cash received or overdue invoices may need the attention first. Write the reason for your choice beside the metric.
Keep the other checks visible. A booking target does not make cash irrelevant, and cash from an old project does not prove that next month’s pipeline is healthy. The purpose of one primary metric is to focus the next action, not to hide information that could change that action. Review the choice when the bottleneck changes.
Add one activity measure only if it helps explain the result. For example, count decision-stage proposal follow-ups completed that week. Label it as activity, not income. A sent message can create a conversation without producing a booking that day. Avoid crediting a sale to the latest message automatically when several earlier actions and the buyer’s own process contributed.
Run a short weekly review and choose the next move
Set aside a small block at the same time each week. First reconcile the totals with your records. Second compare them with your current operating target. Third identify the specific obstacle: no suitable opportunities, proposals awaiting decisions, invoices not yet sent, or overdue payments. These problems require different actions even if the weekly cash number looks identical.
Suppose the scoreboard shows no new bookings but three proposals with agreed review dates next week. Your next move might be preparing the clarification one buyer requested. If work is confirmed but a milestone invoice was never issued, the next move is billing according to the agreement. If an invoice is overdue, verify the details and send the appropriate payment reminder.
Write the next action with a person or record, a deadline, and a clear finish. “Improve revenue” cannot be completed today. “Send the agreed milestone invoice for [project] before noon” can. OneMove can help choose one move a day from the context you supply, then record the outcome through an evening check-in and a weekly scoreboard.
Read several weeks without turning examples into forecasts
Weekly results can be uneven for project businesses. A large booking may land in one week while delivery and payments span several weeks. Keep the individual totals and look at a rolling view alongside them. For example, review the last four weeks of booked work as context, without assuming the next four weeks will repeat the same pattern.
Do not divide a monthly target by four and treat it as a precise calendar model. You can use a rough weekly planning target if it helps, but months differ in length and buying decisions do not arrive evenly. Check future commitments and due dates as well as historical totals. A good week should not conceal a large upcoming delivery obligation or overdue balance.
Start with the smallest sheet you can reconcile. Keep formal bookkeeping separate and use it as a source where appropriate. If the scoreboard takes too long, remove decorative metrics before removing source references or definitions. The goal is an honest answer to three questions: what changed, what needs attention, and what concrete action should happen next.