Skip to main content
Budget vs actual sets what QuickBooks recorded against what was budgeted, by category, for a range of up to twelve months. Everyone can read it for the programs they see.

How it compares

The budget is the forecasts dated through the end of the range, or through today if the range is still running: the budget to date. The actual is what QuickBooks recorded, on the same terms as the cash flow grid. Variance is actual minus budget, so a positive variance is favorable: more income, or less spending, than planned. A bill paid earlier than its forecast shows as a variance until the forecast’s date arrives.

Choose what to report

  • Range: Year to date (the default), This month, Last month, This quarter, Last quarter, Last 12 months, Last year or This year.
  • Program narrows it to one program and its sub-programs.
  • By month adds a budget and an actual column for each month.
  • Hide empty rows folds away categories with nothing in the range.
Each section ends with a Total, and the report with Net. The summary above reads, for example, Net $42,300 against a budget of $38,000: $4,300 better than budget.

Export

Export: CSV, Excel or PDF downloads the report as you see it. The PDF carries the range’s totals. Owners, finance and program managers can make a link anyone can open without signing in, for a board member or a funder.
  1. Under Share links, choose Make a share link, then Make link.
  2. Copy the link straight away: it is shown only once. It works for 30 days.
The link shows the report as its maker may see it today, so it follows your programs and your role. It stops working when it expires, when it is revoked, or when its maker leaves the organization. Each link is listed with its range, its maker, when it expires and when it was last opened. Revoke stops it at once; anyone who opens it afterwards is told it no longer works. The maker, an owner or finance can revoke a link. Share links have no assistant tool; making one takes your own click.

Ask your assistant

Run budget vs actual for Adult Literacy, year to date, by month, and explain the three largest variances.
Export last quarter’s budget vs actual as Excel.