We run more than one company file. How much cash does the group make, and how much will it have in six months?

Two company files added, one left out, at Northbrook Trading Group

Northbrook Trading Group works in US dollars, on an accrual basis, with a calendar year. Its MosoFin workspace holds three connected QuickBooks files. Northbrook Trading and Northbrook Services LLC keep US dollar books. Northbrook Trading Canada Ltd keeps Canadian dollar books. The run is on Thursday 1 October 2026, and the owner asks for July to September 2026.

For each row, the skill checks one rule. Operating plus investing plus financing equals the net cash increase for the month¹. For Trading in August, 38,500 − 12,000 + 0 = 26,500. For Trading in September, 46,200 + 0 − 5,000 = 41,200.

Why is the Canada file not in the group? The skill adds the files month by month, and it has no step that changes one currency into another. If it added the Canada file, it would add Canadian dollars to US dollars. So the example leaves that file out and says so in a note. Your accountant can choose an exchange rate and supply figures in US dollars. Then the skill can use them on the manual path. The skill has no rule for exchange rates.

This example makes four choices. It uses the July to September range, and it leaves out the Canada file. It takes the balances from the balance sheet report. It uses the label "Net cash increase" for the 129,100.

A total of cash increases is not the money in the bank

The dashboard adds the monthly net cash increases from the first month of the range. It shows the result as "Cash at end of Sep". That figure is the total increase since the range started. It equals the cash balance only when cash was zero at the start of the range¹. The starting cash comes from the balance sheet before the period. Starting cash plus the net cash flow of the period gives the ending cash.

The same rule applies to the receivables and payables. The skill can add up their monthly changes only when the year started at zero. This range starts in July, so the example takes the balances from the balance sheet report on 30 September. The skill's method says to do that when the range does not start at zero.

Services owes Trading $9,500 of the receivables

Services owes Trading 9,500. Trading shows it as a receivable. Services shows it as a payable. In the group total, it looks like money from a customer. It is not money that any outside customer owes.

Group accounts remove all balances and transactions between companies of the same group, on both sides². US accounting rules agree on this point³. The skill does not prepare group accounts. It shows the total and the part inside the group, so that you can see both. If you need group accounts, ask your accountant.

The skill also checks for test data. It looks for the same figure to the cent in two files and for customer names from the QuickBooks sample company. It also looks for the word "Sandbox" in a company name. The example found none, and its report says that.

Three rates, from the last month, for six months

The projection starts from the last actual month, September, and runs from October 2026 to March 2027. It starts from the 129,100. The skill takes three monthly rates from the group's figures. The skill names the edges P10 and P90. They are presets of the skill, not percentiles from a statistical model.

September was the best month. So the upside rate, 48,850, is below the base rate, 52,100. The dashboard sets the P90 edge to the larger of the upside rate and the base rate. So P90 equals base, at 441,700. The range is $402,100 to $441,700. Neither path goes below zero, so the dashboard names no first negative month.

The projection adds no more investing, financing or loan payments. Trading paid back 5,000 of a loan in September, but the projection does not repeat that payment. Why not use an average of all months? The skill's method says that an average mixes in unusual months. In this example, the August equipment purchase is in investing, so it is not in any rate.

Three questions in this order, then a default range

1. Use your MosoFin connection to read the books, or supply the data yourself?
   The skill asks this first. If you say no, or have no connection, it uses the manual path with a file from you.
2. Which workspace?
   If you have more than one, it asks you to choose by name. It never chooses one for you. Northbrook had one, and the owner checked it by name.
3. One company file, each file separately, or consolidated?
   It asks when you connect more than one QuickBooks file. The dashboard always shows each file and the group, so "consolidated" is the usual answer.
4. The months
   The skill does not ask this. It uses 1 January of this year to the end of this month, unless you ask for another range. For Northbrook that is 1 January to 31 October, with an almost empty October last. The projection starts from the last month, so the owner asked for July to September.

If a read stops partway, the skill tells you what it read. It offers the manual path for the rest. It never fills the gap with figures of its own.

Connect once, or supply one CSV file

One dashboard file with four tabs

On the MosoFin path, the file has a Sync button and an Ask panel. They work only when the file runs inside Claude with the MosoFin connection. In other places they show an amber strip. The skill ends with one line that lists the tools it used and the time it read the data.

Six terms, in plain English

Company file

One set of books in QuickBooks, for one company.

Cash flow statement

A report of cash in and out, in three parts: operating, investing and financing. The three parts add up to the net cash increase¹.

Operating cash flow

The cash that day-to-day trading brings in, after the cash it uses.

Intercompany

Money that one company in your group owes another. Group accounts remove it on both sides².

Consolidated

All the companies in the group shown as one. In this skill, it means the files added month by month.

P10 and P90

In this skill, the names of the conservative and upside edges of the projection. They are presets, not statistical percentiles.

Where the facts on this page come from

The sources are an accounting textbook, an international accounting standard and a release of the US securities regulator. We found each one on 28 October 2026 in search results. We did not open the pages, so follow each link for today's wording. What the skill does comes from the skill's own files.

1. OpenStax: Principles of Accounting, Volume 1, 16.4 Prepare the Completed Statement of Cash Flows Using the Indirect MethodThe operating, investing and financing totals add up to the total net cash flow. The beginning cash comes from the balance sheet of the period before. Beginning cash plus the net cash flow gives the ending cash.
2. IFRS Foundation: IFRS 10 Consolidated Financial StatementsGroup accounts remove in full the assets, liabilities, equity, income, expenses and cash flows from transactions between companies of the group.
3. SEC: Final Rule, Disclosure Update and Simplification (Release 33-10532, 2018)The release lists the SEC rule to remove intercompany items in group accounts beside the matching US GAAP guidance in ASC 810.

No outside authority backs the three scenario rates, the six months, the P10 and P90 names or the test-data signs. The same applies to the four tabs and the dashboard style. They are the skill's own rules. We made up Northbrook Trading Group and every figure in the example for this page.