Demonstration data · Specialty Trade Contractors · as of November 19

Quarry Build Services

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

What needs you

2 past due bills dated: $13,735, paying Nov 20 to Nov 28.
Needs your answer

$30,741 from Elverton Retail Parks (invoice QBS-5717) is counted this week. It is 124 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 Friday, November 20: $34,882, every week, from your books. Projected cash at the end of that week: $664,651. A weekly forecast cannot show the balance on payday itself.

QuickBooks balance
$662,584
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
$573,981
week of February 1
Assumes $7,059 of past due bills are paid this week. With none of them paid in these 13 weeks: $581,039.
Includes $6,281 of past due bills you said you will pay this week.
This week
+$2,067
$91,253 in, $89,186 out
Includes $30,741 already later than any invoice this business has been paid on.
Without the past due bills: +$9,126, closing at $671,710.
Overdue receivables
$171,870
of $484,280 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 →
$600k$400k$0Caution$159ktodayNov 22Nov 29Dec 6Dec 13Dec 20Dec 27Jan 3Jan 10Jan 17Jan 24Jan 31Feb 7Feb 14
$600k$400k$0$159ktodayNov 22Dec 6Dec 20Jan 3Jan 17Jan 31Feb 14

What if?

Open the Scenario Planner →

Cash stays above your $159,000 caution line in all 13 weeks. The lowest point is $573,981, in the week of February 1.

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
Barrowfield Homes$76,82531 to 60 daysabout 32 days after the due date (107 paid invoices)$100,736 from Nov 16 to Jan 17$100,736
Hartsmere Housing Authority
Oldest is 415 days past due. $36,896 is more than a year past due and is not counted as coming in.
$36,896over 90 daysNot enough historyNot counted in the 13 weeks$36,896
Elverton Retail Parks
Oldest is 124 days past due. $30,741 is over 120 days past due and still counted as coming in.
$30,741 is later than any invoice this business has been paid on, so it is counted this week with no history behind the date.
$30,741over 90 daysabout 6 days after the due date (120 paid invoices)$59,454 from Nov 16 to Jan 3$59,454
Dovetail Estates$11,7381 to 30 daysabout 3 days after the due date (5 paid invoices)$21,119 from Nov 16 to Jan 10$21,119
Foxley Hospitality$9,4541 to 30 daysabout 8 days after the due date (117 paid invoices)$32,602 from Nov 16 to Dec 27$32,602
Garrison Medical Offices$6,21531 to 60 daysabout 2 days after the due date (28 paid invoices)$31,356 from Nov 23 to Dec 27$31,356
All 6 clients with money past due$171,870$282,164

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.

$90,714 recorded as received but not deposited

Undeposited Funds holds $90,714, roughly 1.2 weeks of typical receipts. Those invoices show as paid while the cash has not reached a bank account, so the cash balance this projection starts from is lower than the money actually collected.

How to fix it in QuickBooks

You can do this yourself in QuickBooks.

  1. These are customer payments QuickBooks has recorded as received and not yet put into a bank account. The account is called Undeposited Funds, or Payments to deposit.
  2. In QuickBooks, choose New (the plus button), then Bank deposit.
  3. Pick the bank account the money went into. Under "Select the payments included in this deposit", tick the payments that made up that deposit so the total matches what the bank shows, set the date the bank shows, and save.
  4. If a payment in the list was never really received, do not deposit it. Tell whoever keeps your books.

Until then that money is not in the cash balance the forecast 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.

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$683,840$642,7076.4%Example13Example
Four weeks outNov 9$527,662$642,70717.9%Example12Example
Eight weeks outNov 9$797,599$642,70724.1%Example11Example
Thirteen weeks outNov 9$359,916$642,70744.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

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

62
68
50
50
52
20
14
12
6
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$91,253$0$0$20,357$45,742$23,086$664,651
2 November 23$94,410$0$0$31,165$34,882$23,086$669,928
3 November 30$63,074$0$0$17,854$58,245$23,086$633,818
4 December 7$51,240$13,049$0$29,609$44,533$23,086$600,879
5 December 14$69,147$0$0$5,678$45,742$23,086$595,520
6 December 21$34,123$74,209$0$0$39,712$23,086$641,053
7 December 28$20,744$43,481$0$0$64,748$23,086$617,445
8 January 4$14,196$43,563$0$0$36,638$23,086$615,480
9 January 11$9,197$76,502$0$0$58,275$23,086$619,818
10 January 18$0$86,757$0$0$47,204$23,086$636,285
11 January 25$0$70,343$0$0$38,250$23,086$645,292
12 February 1$0$16,523$0$0$64,748$23,086$573,981
13 February 8$0$108,157$0$0$50,217$23,086$608,834

What this forecast cannot know

  • On average 74% 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.
  • Over the last three months you collected 25% more and paid out 24% more than the twelve-month average this forecast leans on. Money in and money out beyond your open invoices and bills are both likely understated. Whether that leaves ending cash higher or lower than shown depends on which grew by more in dollars, and this forecast has not measured it.
  • Every open invoice and bill has a due date, so nothing is left unplaced.
  • Payroll lands on your pay dates, weekly, at $34,882 a run including employer taxes as your books record them. The last run on file is November 13.
  • 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 $171,870 overdue, $69,339 is expected after this week. $36,896 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 32 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)$4,134,873
Money that arrived through borrowing or from owners, added back+$0
Money out this forecast averages$4,134,873
A month, over 12 months$344,573
A week, at 4.33 weeks a month$79,517

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: $360,061 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.