Demonstration data · Management Consulting · as of November 19

Brightpath Consulting

Thirteen weeks of cash, built from 55 open invoices and 40 open bills, plus the patterns and trailing averages behind them.

What needs you

Cash goes below zero in the week of November 30.

It is below zero from Nov 30 to Feb 14, and lowest in the week of January 11 at -$60,511. Covering the whole shortfall takes $60,511; staying at your caution line of $79,000 takes $139,511, and cash is under that line from Nov 16 to Feb 14. See the lowest week, or work out what closes the gap.

These weeks combine invoices and bills already raised with estimates of this business’s usual receipts and spending. The share that is documents is shown week by week in the Cash Pulse.

What you could do about it
Collect from these first
  1. Emberly Foods owes $12,809 past due (oldest: over 90 days). In the forecast: $24,013 from Nov 16 to Dec 20.
  2. Farrowdale Utilities owes $3,306 past due (oldest: 1 to 30 days). In the forecast: $15,840 from Nov 16 to Jan 10.
  3. Dovecote Senior Living owes $3,193 past due (oldest: 1 to 30 days). In the forecast: $13,968 from Nov 23 to Jan 10.
See everyone who owes you
Bills that could wait, if the vendor allows it

These are past due, and the forecast counts them as paid this week because nobody has said otherwise.

  • Marlin Associate Network, $5,221, 10 days past due.
  • Anchor Court Reporting, $5,150, 11 days past due.
  • Marlin Associate Network, $4,255, 2 days past due.
Say when you will actually pay them

See what a delay does before you ask for one: “Delay the $5,221 Marlin Associate Network bill that was due November 9” 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.

You have $27,766 in bills past due. When will you pay them?

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 -$60,511, in the week of January 11. With none of them paid in these 13 weeks it would be -$32,746. 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.

6 past due bills dated: $15,785, paying Nov 24 to Dec 12.
Needs your answer

$12,809 from Emberly Foods (invoice BC-5648) is counted this week. It is 136 days past due, later than any invoice this business has been paid on, so there is no history to place it by. When do you expect it?

Your best guess:

Demonstration company: signed in, a founder’s answer is saved and the forecast is recorded again with it.

Next payroll Monday, November 30: $47,120, twice a month, from your books. Projected cash at the end of that week: -$10,997, below zero. A weekly forecast cannot show the balance on payday itself.

QuickBooks balance
$55,268
As of 4:01 AM today.
What your books say, which can differ from what the bank shows: entries not yet cleared are already counted.
Lowest point ahead
-$60,511
week of January 11
Assumes $27,766 of past due bills are paid this week. With none of them paid in these 13 weeks: -$32,746. Say when you will pay them.
This week
-$11,496
$34,339 in, $45,835 out
Includes $12,809 already later than any invoice this business has been paid on.
Without the past due bills: +$16,270, closing at $71,537.
Overdue receivables
$40,127
of $162,528 outstanding

Cash Pulse

Today’s balance is a fact. Every point after it is projected cash at the end of that week.Every week in detail →
$50k$0-$50kCaution$79ktodayNov 22Nov 29Dec 6Dec 13Dec 20Dec 27Jan 3Jan 10Jan 17Jan 24Jan 31Feb 7Feb 14
$50k$0-$50k$79ktodayNov 22Dec 6Dec 20Jan 3Jan 17Jan 31Feb 14

What if?

Open the Scenario Planner →

Cash is forecast to go below zero in the week of November 30, to $10,997 below. The largest bill in that week is $5,031, Marlin Associate Network 20261104-40.

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.

ClientOverdueOldestUsually paysIn this forecastTotal owed
Hallmoor Manufacturing
Oldest is 383 days past due. $15,370 is more than a year past due and is not counted as coming in.
$15,370over 90 daysabout 29 days after invoicingNot counted in the 13 weeks$15,370
Emberly Foods
Oldest is 136 days past due. $12,809 is over 120 days past due and still counted as coming in.
$12,809 is later than any invoice this business has been paid on, so it is counted this week with no history behind the date.
$12,809over 90 daysabout 6 days after the due date (111 paid invoices)$24,013 from Nov 16 to Dec 20$24,013
Farrowdale Utilities$3,3061 to 30 daysabout 8 days after the due date (112 paid invoices)$15,840 from Nov 16 to Jan 10$15,840
Dovecote Senior Living$3,1931 to 30 daysabout 4 days after the due date (111 paid invoices)$13,968 from Nov 23 to Jan 10$13,968
Belcourt Insurance Group$2,8601 to 30 daysby the due date (114 paid invoices)$15,540 from Nov 16 to Dec 13$15,540
Castellan Freight$2,5891 to 30 daysby the due date (114 paid invoices)$10,579 from Nov 30 to Dec 27$10,579
All 6 clients with money past due$40,127$95,309

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.

Transactions are parked in a holding account

$2,581 sits in an "ask my accountant" style account, which is where transactions wait when nobody was sure where they belonged. Until they are moved, they are counted but not attributed.

How to fix it in QuickBooks

This one needs whoever keeps your books.

  1. Some transactions are parked in a holding account (often called Ask My Accountant, or Suspense) waiting for someone to say what they were.
  2. To see them: open the gear menu at the top right and choose Chart of accounts, find the holding account, and choose Account history (or Run report) beside it.
  3. Tell whoever keeps your books what each one was. They move it to the account it belongs in. If you already know the right account, open the transaction, change its category, and save.

Until then RunVera cannot tell what those amounts were for. 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.

Illustration. Not a measured result.

Example accuracy record

How the record looks once a business has been forecast for a few months: one week’s actual ending cash against the forecasts made one, four, eight and thirteen weeks before it, never blended, misses included. These figures are an example, not this company and not a result. Demonstration companies are never measured.

Illustrative results, not measured
DistanceWeekWe saidCash in the bank that SundayMissComparisons
One week outNov 9$103,208$97,0006.4%Example13Example
Four weeks outNov 9$79,637$97,00017.9%Example12Example
Eight weeks outNov 9$120,377$97,00024.1%Example11Example
Thirteen weeks outNov 9$54,320$97,00044.0%Example10Example
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

27% average

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 86% documents we can read. By week 13 it is 0%. That decline is the truth about forecasting, not a flaw in this one.

86
75
40
77
40
20
2
11
0
0
0
0
0

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.

WeekIn: seenIn: expectedIn: averageOut: seenOut: recurringOut: averageEnding
1 November 16$30,709$0$3,629$38,033$1,706$6,096$43,771
2 November 23$19,878$0$3,629$13,144$1,455$6,096$46,584
3 November 30$28,138$0$3,629$20,263$62,990$6,096-$10,997
4 December 7$25,025$2,534$3,629$15,525$0$6,096-$1,429
5 December 14$26,802$1,744$3,629$11,694$47,120$6,096-$34,164
6 December 21$9,387$25,229$3,629$0$3,161$6,096-$5,176
7 December 28$1,613$22,622$3,629$0$62,990$6,096-$46,399
8 January 4$5,605$28,757$3,629$0$9,237$6,096-$23,741
9 January 11$0$30,275$3,629$0$64,579$6,096-$60,511
10 January 18$0$37,938$3,629$0$7,367$6,096-$32,408
11 January 25$0$27,827$3,629$0$48,575$6,096-$55,622
12 February 1$0$33,815$3,629$0$18,278$6,096-$42,552
13 February 8$0$34,278$3,629$0$6,829$6,096-$17,570

What this forecast cannot know

  • On average 73% 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 your pay dates, semimonthly, at $47,120 a run including employer taxes as your books record them. The last run on file is November 15.
  • 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 $40,127 overdue, $8,642 is expected after this week. $15,370 more than a year past due is not counted as coming in.
  • 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 31 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)$2,048,778
Money that arrived through borrowing or from owners, added back+$0
Money out this forecast averages$2,048,778
A month, over 12 months$170,731
A week, at 4.33 weeks a month$39,400

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: $24,163 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.