Stillwater Staffing Group
Thirteen weeks of cash, built from 83 open invoices and 44 open bills, plus the patterns and trailing averages behind them.
What needs you
The lowest is $285,433 in the week of November 16, $14,567 under it. See what is in that week.
This is the line you set.
- Grantham Electronics owes $99,858 past due (oldest: 61 to 90 days). In the forecast: $140,364 from Nov 30 to Jan 24.
- Allerton Food Processing owes $67,093 past due (oldest: 1 to 30 days). In the forecast: $119,423 from Nov 16 to Jan 3.
- Hollis Plastics owes $48,611 past due (oldest: 1 to 30 days). In the forecast: $76,306 from Nov 16 to Jan 3.
These are past due, and the forecast counts them as paid this week because nobody has said otherwise.
- Carrow Courier, $30,514, 1 day past due.
- Beechwood Uniform Service, $23,419, 1 day past due.
- Dunmere Timeclock Systems, $19,296, 11 days past due.
See what a delay does before you ask for one: “Delay the $30,514 Carrow Courier bill that was due November 18” in the what if box.
These are the names and amounts already on this page, put in order. RunVera does not know which client will pay if asked or which vendor will wait, and it does not say any of this is enough: the what if shows what a change does.
Until you say, the forecast counts all of them as paid this week, because a past due bill has no later date in your books. On that basis the lowest point ahead is $285,433, in the week of November 16. With none of them paid in these 13 weeks it would be $408,415. The truth is between the two, and only you know where.
Spread pays the oldest first, an equal number of bills each week. Not sure leaves them in this week and asks again in two weeks. Answers are recorded on your own books, not on a demonstration company.
Next payroll Friday, November 20: $32,378, every week, as you set it. Projected cash at the end of that week: $285,433, under your caution line. A weekly forecast cannot show the balance on payday itself.
Cash Pulse
What if?
Open the Scenario Planner →Cash stays above zero in all 13 weeks, but its lowest point, $285,433 in the week of November 16, is below your $300,000 caution line.
Describe a change in your own words. RunVera fills in what it can from this company’s books, asks for anything it still needs, and shows you every figure before it runs. Nothing you type here is kept.
Who owes you, and how late
Aged as of November 19. How each client usually pays comes from its own settled invoices; the last column is where this forecast has their open invoices arriving, so you can see which ones it is counting on.
| Client | Overdue | Oldest | Usually pays | In this forecast | Total owed |
|---|---|---|---|---|---|
| Grantham Electronics | $99,858 | 61 to 90 days | about 52 days after the due date (63 paid invoices) | $140,364 from Nov 30 to Jan 24 | $169,597 |
| Allerton Food Processing | $67,093 | 1 to 30 days | about 8 days after the due date (62 paid invoices) | $119,423 from Nov 16 to Jan 3 | $119,423 |
| Hollis Plastics | $48,611 | 1 to 30 days | about 13 days after the due date (64 paid invoices) | $76,306 from Nov 16 to Jan 3 | $76,306 |
| Bridgepoint Distribution | $46,286 | 31 to 60 days | about 11 days after the due date (62 paid invoices) | $156,713 from Nov 23 to Jan 24 | $156,713 |
| Freeport Cold Storage | $39,306 | 1 to 30 days | about 7 days after the due date (65 paid invoices) | $112,716 from Nov 30 to Jan 24 | $112,716 |
| Kemper Textiles | $29,481 | 1 to 30 days | about 16 days after the due date (7 paid invoices) | $84,539 from Nov 23 to Jan 24 | $84,539 |
| All 8 clients with money past due | $360,864 | $818,719 | |||
and 2 more, $30,229 past due
- Jarrow Steel (1 to 30 days)$15,723 past due of $74,452
- Tidewater Freight Lines (1 to 30 days)$14,506 past due of $24,975
One thing about these books affects the forecast below
None of these stops a projection being useful. Each one says which part of it to trust less, and by how much.
4 transactions dated in the future
$86,337 across 4 transactions is dated later than today, so it is already included in the current balances even though it has not happened yet.
How to fix it in QuickBooks
You can do this yourself in QuickBooks.
- In QuickBooks, go to Reports and find a report that lists transactions by date (it is usually called Transaction List by Date). Set the date range to start tomorrow and end a year or two out.
- Open each transaction listed. If the date is a typing mistake (the wrong year is the usual one), correct it and save.
- If the date is meant, for example a post dated check or a payroll entered ahead, leave it. RunVera keeps entries dated ahead out of the cash balance it starts from.
RunVera reads QuickBooks again every night, or straight away if you press Refresh on the Forecast, and this clears on the first read that finds it fixed.
QuickBooks has more than one layout in use and moves its menus from time to time, so a name may differ slightly from what you see. These steps are for QuickBooks Online.
How this forecast is built: what it can see, week by week, and what it cannot know
How much of this can we actually see
Each bar is the share of that week’s money that comes from an invoice or a bill with a due date, rather than from a pattern or a trailing average. Week 1 is 78% documents we can read. By week 13 it is 0%. That decline is the truth about forecasting, not a flaw in this one.
Week by week
Seen is a real invoice or bill, in the week we expect it to be paid. Expected is something this business does every month, like payroll or a retainer. Average is whatever is left of your usual weekly pace once those two are accounted for. The three always add to the total.
| Week | In: seen | In: expected | In: average | Out: seen | Out: recurring | Out: average | Ending |
|---|---|---|---|---|---|---|---|
| 1 November 16 | $48,281 | $0 | $0 | $188,304 | $33,762 | $34,837 | $285,433 |
| 2 November 23 | $318,936 | $0 | $0 | $125,082 | $32,378 | $34,837 | $412,072 |
| 3 November 30 | $330,199 | $0 | $0 | $105,515 | $40,979 | $34,837 | $560,941 |
| 4 December 7 | $46,448 | $0 | $0 | $146,062 | $32,378 | $34,837 | $394,112 |
| 5 December 14 | $118,560 | $0 | $0 | $94,426 | $33,762 | $34,837 | $349,648 |
| 6 December 21 | $142,465 | $0 | $0 | $0 | $52,856 | $34,837 | $404,420 |
| 7 December 28 | $110,646 | $12,404 | $0 | $28,099 | $40,979 | $34,837 | $423,555 |
| 8 January 4 | $174,706 | $37,387 | $0 | $0 | $33,903 | $34,837 | $566,908 |
| 9 January 11 | $51,050 | $37,509 | $0 | $0 | $60,631 | $34,837 | $560,000 |
| 10 January 18 | $166,666 | $122,901 | $0 | $0 | $57,906 | $34,837 | $756,824 |
| 11 January 25 | $0 | $131,482 | $0 | $0 | $32,865 | $34,837 | $820,604 |
| 12 February 1 | $33,848 | $180,395 | $0 | $0 | $41,587 | $34,837 | $958,423 |
| 13 February 8 | $0 | $131,341 | $0 | $0 | $33,295 | $34,837 | $1,021,632 |
What this forecast cannot know
- On average 49% of the money shown comes from patterns and trailing averages rather than from documents with due dates.
- The trailing average uses 12 months of history. Baseline built from money collected (revenue less the change in receivables) and money out (collected less the change in the bank, with any loan received or money put in by owners added back, so borrowing is not counted as spending). Money out includes distributions, loan payments and equipment that never touch the profit and loss.
- Every open invoice and bill has a due date, so nothing is left unplaced.
- Payroll lands on the pay dates you gave, weekly, at $32,378 a run. The forecast takes your word for the amount and the dates, not the books’.
- Open invoices are placed where invoices that were already as late have been paid before, from each client’s own history when it has one, not on their due dates. Of $360,864 overdue, $312,583 is expected after this week.
- Clients’ usual billing lands on each client’s own invoice days plus how long they take to pay. Clients without enough history use the business’s own pace: half of its invoices are paid within 50 days of being sent.
- Not read yet. Built with version 12 of the forecast method.
From Reports to this forecast: money out
Reports show net money out, which a loan received or money put in by owners lowers. This forecast adds that back before averaging, so borrowing is not read as spending that did not happen. Over November 2025 to October 2026:
| Net money out in Reports (cash flow) | $6,670,593 |
| Money that arrived through borrowing or from owners, added back | +$0 |
| Money out this forecast averages | $6,670,593 |
| A month, over 12 months | $555,883 |
| A week, at 4.33 weeks a month | $128,281 |
That weekly figure is not normal operating spending. It is everything that left, spread evenly, before bills, payroll and other named payments are placed on their own dates. Inside it, from the cash flow report: $48,524 of loan repayments and distributions to owners, each net within its month.
Demonstration data, generated by RunVera. Not a real company. Excluded from the accuracy record and from billing by the schema itself.