Track time. Get paid.
Client pipeline revenue forecast
See how much work you have agreed and what could still come through. Compare fees from the two groups by expected start month.
Editable Excel workbook · free without signup
Download workbook (XLSX)Plan the next three months
- Choose your starting month.
Set the first day of that month and enter one currency code for the workbook.
- Replace the example work.
Use up to 16 rows. Add one short reference per opportunity, the expected start date and the full fee before tax.
- Set status and odds.
Use Agreed for confirmed work, Open for undecided work and Lost for work that fell through. Enter a whole percentage only for Open work.
- Review the monthly totals.
Fix any marked rows first. Revisit the expected dates and odds after each client decision.
You edit the figures in your own spreadsheet app. TimeLodge receives none of the figures you enter.
Example for December 2026
Your design studio has an agreed website refresh worth $4,000 USD. A separate $3,000 brand audit has a 50% chance of going ahead. Both could start in December.
- Agreed fees
- USD 4,000
- Open fees
- USD 3,000
- Open weighted
- USD 1,500
The weighted figure is $3,000 × 50%. Use it to compare months while leaving room for proposals to slip or fall through. The client still agrees to the whole fee if the work goes ahead.
Questions about your pipeline forecast
- Which dates count?
- The workbook puts the whole fee in the expected start month, even if delivery spans several months. Lost work and dates outside the three-month window contribute zero.
- How do I pick the odds?
- Use your experience with similar proposals and what the client has confirmed so far. Keep the full open fee visible so you can see how much rests on that judgement.
- Which currencies can I use?
- Choose AUD, CAD, EUR, GBP, NZD or USD. Enter all fees in that currency. The workbook rounds each weighted fee to cents and applies no exchange rates.
- When will the money reach my bank?
- Start dates help you plan work. Use expected payment dates in the 13-week cash flow forecast to map when cash may arrive.
Turn agreed work into invoices
When your client agrees to the work, track your hours in TimeLodge and use them to prepare the invoice.
Start freeFree for 14 days — every feature, no credit card, no automatic charge.