What the grid shows
Each period has three columns:
Rows are your QuickBooks categories, grouped into sections with a Total for each. Every
category shows, even with nothing in it, so there is always a row to forecast into. Cash at
start and Cash at end frame the grid, and the lowest period is tagged lowest.
An example, three weeks of Harborlight Institute’s operating cash:
Change the view
- Weekly, Monthly, Quarterly or Annual sets the period. Weekly is the default.
- Earlier, Later and Today move through time; the strip of periods jumps to one.
- Show N periods chooses how many sit side by side, up to what fits on the screen.
- Program narrows the grid to one program and its sub-programs. By program splits the grid into a block per program, each with Income less spending.
- Hide empty rows folds away categories with nothing in the periods shown.
See what is behind a figure
Select any figure to open what makes it up:- Actual lists each QuickBooks transaction by date, type and number (for example Bill 1042), name and amount.
- Forecast lists each forecast occurrence. Select its payee to open the forecast.
Program managers see a net, not cash
If you see some programs rather than the whole organization, the grid shows your programs’ net: their money in less their money out from the first period shown. The top and bottom rows read Net to date, start and Net to date, end. The organization’s cash is for owners and finance.Credit cards and postdated checks
Spending on a credit card shows in its category and is offset on the card, so it moves cash when the card is paid. A QuickBooks transaction dated after today, such as a postdated check, uses up the forecasts of the same category, program and month in Projected, so the money is not counted twice. Forecast still shows the full forecast.Ask your assistant
Show the Youth Mentoring cash flow by month for the rest of the year.
Which weeks in the next quarter end below the reserve, and why?
What is behind the Salaries figure for the week of November 16?