Skip to main content

What is the Budget to Actual report?

Explains the report that compares actual income and expenses with your published budget for a date range, its columns, and how to run it.

You will need the Full Read Accounting permission to run this report. If your account has more than one organization, the report reads one organization's books, chosen in the Accounting for: strip.

The Budget to Actual report compares your actual income and expenses with your budget for a date range, line by line. Use it to see which ministries are on track, over budget or still have room to spend.

The Budget to Actual report with Actual, Budgeted $, Remaining and Budget % columns

Note: The report reads budgets whose Status is Published. A draft budget does not appear. See How do I create a budget?


Run the report

  1. Go to Accounting > Reports in the left-hand menu.

  2. In the Reports widget on the Accounting Dashboard, click Budget to Actual.

  3. Choose a Date Range, such as Fiscal Year To Date, then click Refresh.

The columns

  • Actual - what was actually received or spent in the date range.

  • Budgeted $ - the budget for the same date range.

  • Remaining - the budget minus the actual amount. A negative number means the line has gone over budget, or, for income, has received more than budgeted.

  • Budget % - the actual amount as a percentage of the budget.

Income and expense lines are grouped by category with subtotals. The TOTAL line at the bottom nets income against expenses, so it compares your actual net result with your budgeted one.

The header shows the funds included, the accounting method, the date range and the campuses. A red PRELIMINARY label means the report includes periods that are not closed yet. See Why does my accounting report say PRELIMINARY?

Report options

Click additional options below the Date Range, make your changes, click Done, then click Refresh.

The Budget to Actual Report Options panel showing the Formatting and Columns settings
  • Accounting Method - Accrual or Cash Basis.

  • Funds and Tags - All, or Specific to choose which to include. To compare a department's spending with its own budget, see How do I budget by tag?

  • Options - Include draft entries? adds entries that have not been posted yet.

  • Formatting - Only budgeted line items (on by default) shows only the accounts that are part of your budget. Don't show zero amounts is off by default, and Color negative numbers in red is on.

  • Columns - choose which columns to show. Actual, Budgeted $, Remaining and Budget % are on by default. Add Annual Budget $, Annual Budget Remaining and Annual Budget % to compare against the whole year's budget instead of just the date range.

To download the report as a PDF or CSV file, see How do I export an accounting report?

Other Helpful Articles

Did this answer your question?