Understanding the Cash Plan Report in QuickBooks Business Planner

QuickBooks Business Planner generates a Cash Plan report that serves as a forward-looking roadmap for a company’s liquidity. The report tracks where cash comes from, where it goes, and whether the business projects a surplus or a shortfall over the planning period. For users building forecasts inside the planner, understanding what each row represents — and how the application calculates the totals — is essential for producing numbers that hold up under scrutiny.

How Business Planner Handles Rounding

One detail that catches users off guard: the figures displayed on Business Planner reports are rounded to the nearest dollar or cent, depending on available space. Because of this, totals and subtotals may not perfectly equal the sum of the individual line items shown. The underlying calculations use full precision; only the displayed values are abbreviated.

Cash Coming In

The report begins with cash receipts — the actual cash the business expects to collect from selling products and services. This is distinct from revenue recognized on a profit and loss statement. If a business extends credit terms such as net 30 or longer, the timing of cash receipts will lag behind the timing of sales recorded for accounting purposes.

Operating Cash Expenses

The next section breaks down where cash goes during normal operations:

Inventory purchases — cash paid specifically for inventory stock.
Other costs of sales — cash paid for non-inventory costs tied directly to generating sales.
Operating cash expenses — the broader category covering inventory, supplies, labor, and all other operating outflows.
Other expenses — cash paid for costs not directly tied to sales. These figures pull from the Expenses worksheet within the planner.
Estimated taxes — cash paid for projected federal and state taxes, applicable to C corporations only.

The report sums these into total operating cash expenses.

Cash From Operations

Subtracting total operating cash expenses from cash receipts yields cash from operations. This subtotal represents the cash the business generates through its core activities — money available to cover loan obligations, distribute to owners, or reinvest.

Debt Service and Distributions

Below the operations subtotal, the report accounts for financing activity:

Principal payments — cash applied toward reducing outstanding loan balances.
Interest payments — cash paid as interest on borrowed funds.
Net cash after debt service — the cash remaining after both principal and interest obligations are met. This figure can be distributed to owners or reinvested in the business.
Distributions — cash paid to owners. This line does not apply to C corporations.

Tracking the Cash Position

The bottom portion of the report walks the cash balance through the period:

Change in cash — the net increase or decrease over the timeframe.
Beginning cash — the starting balance for the period.
Cash before borrowing — the projected balance before factoring in any financing needs.
Line of credit activity — additional cash the business requires. Business Planner automatically borrows what is needed to cover shortfalls and repays the line of credit as surplus funds become available.
Ending cash — the total cash on hand at period end. If a minimum cash balance was specified during setup, the ending balance will not fall below that floor. The ending balance will also not rise above the minimum until any outstanding line-of-credit borrowing has been fully repaid.

The Cash Plan draws data from several supporting worksheets within Business Planner, including the Income worksheet and the Expenses worksheet. Users who find discrepancies or need to adjust projections typically work backward through these input sheets rather than editing the report directly.