MosoFin skill · multi-entity-forecast-dashboard · learning guide

From one company's month to a six-month group projection

This page shows how the skill builds a group cash view, one level at a time. It starts with one month of one company file. It ends with the report that the owner gets. The page quotes every rule from the skill and works every number in front of you.

The rules are the skill's ownThe page quotes each rule word for word, with the file and section it comes from.
Outside sources back the factsThey are an OpenStax textbook, two IFRS standards, an SEC release and a Federal Reserve page. Each one has a number and a link.
The page shows the mathOpen "Check it yourself" on any level. Follow every line on a calculator.
Your numbers, your checkAt the end, enter up to four companies and six months. The page adds them and projects six months with the skill's rules.
Rule: quoted from the skill Fact: from a cited authority, numbered like 1 Example: made-up figures, calculated in full
How it thinks

Nine rules the whole skill runs on

Every level below applies one or more of these rules. The examples use one made-up group, Northbrook Trading Group. It keeps its books in US dollars on the accrual basis, with a calendar year. Its MosoFin workspace holds three QuickBooks company files. The run is on Thursday 1 October 2026.

Learning path

Six levels, from simple to complex

Check it yourself

Six-month group projection

Enter up to four companies and up to six months each, or load an example. The page adds the companies month by month and projects six months with the rules in references/forecast-method.md and the template. The page sends nothing anywhere.

The range
The projection

The page uses the template's rules. The base rate is the operating cash flow of the last month. P10 uses the lower of the conservative rate and the base rate. P90 uses the higher of the upside rate and the base rate. The monthly change compounds each month, and the one-off spend applies in month 1 only. The page starts the projection from the net cash increase since the range start. That figure is the template's "cash", and it is not a bank balance. If the companies have different numbers of months, the page uses only the common months. The first preset gives 129,100, then 402,100, 441,700 and 441,700 after six months.

Using it

What it asks, needs and gives back

Asks firstUse your MosoFin connection, or supply the data yourself? Which workspace, by name? One company file, each file, or consolidated? It does not ask for the months. It uses 1 January of this year to the end of this month, unless you ask for another range.
NeedsOn the MosoFin path, it needs the monthly cash flow statement of each file and the receivables aging where it exists. It also needs balances from the balance sheet report when the range does not start at zero. On the manual path, one CSV row for each company and month.
Gives backOne HTML file with four tabs: Overview, Accounts, Forecast and Report. Then a short summary in prose and one "Data sources" line.
NeverThe skill never writes to QuickBooks or MosoFin. It never supplies a figure of its own, never hides intercompany balances or test data, and never changes the fixed look.
Sources

Where every fact on this page comes from

The rules are the skill's own. The facts below come from five outside sources. They are an OpenStax textbook, two IFRS standards, an SEC release and a Federal Reserve page. MosoFin checked each one on 28 October 2026 from search results and did not open the pages. Follow the link for today's wording.

    Not backed by an outside authority. The three scenario rates, the six-month horizon and the P10 and P90 names are the skill's own. So are the test-data signs, the four tabs and the "quiet analytics" style. P10 and P90 are presets, not statistical percentiles. MosoFin made up Northbrook Trading Group, its companies and every figure in the examples.