Skip to main content
Cash flow is the organization’s money in and out, period by period, with what QuickBooks recorded and what is forecast side by side. Everyone can read it; each person sees the programs their role allows.

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:
An example, not a screenshot. The week of November 9 has closed, so its figures are actuals; the later weeks are forecast. With a $50,000 reserve, the week of November 16 ends below it. In the console a projected figure from a forecast is tinted and italic, and a week that ends below the cash reserve is marked. Figures are whole dollars with money in positive, and zero shows as a dash.

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.
The view, period, program and By program are kept in the page address, so you can send a link to exactly what you are looking at.

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 and finance can choose Add a forecast here, prefilled with the period, category and program.

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?