FREE · NO ACCOUNT NEEDED
Service Business Financial Projections
Model consecutive service-business months with billed revenue, incurred expense and cash movements. Keep principal, funding and withdrawals distinct.
Enter your own assumptions, calculate and keep a backup. Load the fictional example to see a filled-in report.
Set up your worksheet
Your report
Enter your details, then calculate to review results.
Save or download your work
Work stays in this page until you choose Save on this device. Device saves belong to this browser and can be removed by clearing browser data. JSON keeps an editable backup; CSV and PDF keep a report.
Service Business Financial Projections: complete guide
What this worksheet does
Operating result = billed service revenue − incurred operating expenses − noncash depreciation. Closing cash = prior cash + collections + new funding − operating cash paid − debt principal − owner withdrawals. Months must be consecutive and start on day 1. Excludes inventory, tax, a balance sheet and loan approval; include applicable interest within operating expense and cash-paid inputs.
Keep up to 12 editable entries. The worksheet runs in your browser and does not send its entries to another service. The calculations use the inputs you provide; currency selectors label amounts without conversion.
How to use it
- Set a descriptive worksheet name and complete the settings for your planning period.
- Add one entry per record. Use consistent units and keep the evidence behind your assumptions.
- Calculate and inspect the report, including any review notes. Change an input and calculate again to replace the old result.
- Save an editable backup before changing a scenario. Use the related guide below for the wider operating workflow.
Inputs and units
| Field | Rule |
|---|---|
| Worksheet name | Required for calculation. Up to 160 characters. |
| Currency | Required for calculation. Choose USD, GBP, CAD, AUD, EUR, NZD. |
| Opening cash | Required for calculation. 0–1000000; up to two decimal places. |
| Month starting (first day) | Required for calculation. Valid calendar date, 1900–2200; no timezone shift. |
| Billed service revenue | Required for calculation. 0–1000000; up to two decimal places. |
| Operating expense incurred | Required for calculation. 0–1000000; up to two decimal places. |
| Noncash depreciation | Required for calculation. 0–1000000; up to two decimal places. |
| Cash collected | Required for calculation. 0–1000000; up to two decimal places. |
| Operating cash paid | Required for calculation. 0–1000000; up to two decimal places. |
| Debt principal paid | Required for calculation. 0–1000000; up to two decimal places. |
| New loan / owner capital received | Required for calculation. 0–1000000; up to two decimal places. |
| Owner cash withdrawal | Required for calculation. 0–1000000; up to two decimal places. |
Calculation and scope
Operating result = billed service revenue − incurred operating expenses − noncash depreciation. Closing cash = prior cash + collections + new funding − operating cash paid − debt principal − owner withdrawals. Months must be consecutive and start on day 1. Excludes inventory, tax, a balance sheet and loan approval; include applicable interest within operating expense and cash-paid inputs.
Fictional worked example
Load the fictional example to reproduce this report. The sample is an original illustration, not a customer result or a market benchmark. The dollar figures below use USD.
| Result | Sample value |
|---|---|
| Modeled operating result | $3,900.00 |
| Closing cash | $2,200.00 |
| Lowest opening / month-end cash | $1,500.00 |
| Projection months | 2 |
| Month | Billed revenue | Incurred operating expense | Depreciation | Operating result | Cash collected | Operating cash paid | Debt principal | New funding | Owner withdrawal | Closing cash |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-01 | $6,000.00 | $4,000.00 | $200.00 | $1,800.00 | $5,000.00 | $4,200.00 | $300.00 | $0.00 | $1,000.00 | $1,500.00 |
| 2026-11-01 | $6,500.00 | $4,200.00 | $200.00 | $2,100.00 | $6,000.00 | $4,000.00 | $300.00 | $0.00 | $1,000.00 | $2,200.00 |
Save, restore and export
Save on this device writes an explicit save to this browser; it does not download a file or sync across devices. Clearing browser storage can remove it. Download backup keeps an editable JSON file for this exact worksheet. Import previews the backup before replacing current entries; save again if you want to replace the device save. CSV contains the calculated report, not an editable import format. Print / Save PDF opens the browser print dialog; choose Save as PDF where available.
Questions and limits
Is the example my result?
No. It is fictional data. Replace its assumptions with your own records, then calculate again.
Does saving share my worksheet?
No. Device saves belong to this browser. Move an editable worksheet with its JSON backup and keep sensitive information out of a shared device.
Does a report establish that my plan is correct?
No. Arithmetic can be consistent while the input assumptions are wrong. Keep evidence, review the scope described above and check any decisions against your real records.
Continue the workflow
SaaS Business Plan Template: Runway and Subscription Math. Business Plan Financial Projections: Service Business Example.
Choose your next planning step
- one-page business plan builder: Document the customer and offer assumptions that drive the projection.
- invoice collection schedule: Track the evidence behind expected collection dates.
Review the runway behind your service plan
Review Business Runway / Burn Rate OS for its documented runway workflow and compare its scope with this monthly projection. Business Runway & Burn Rate OS — Offline Cash Runway Planner. Paid products are separate; the free JSON backup is not a paid-product import file.