Skip to main content

Statement of Revenues & Expenditures - Actual vs Budget

This version of the report is critical to see if the budget is respected, you can see the Monthly and Yearly budget versus the Actual.

Key metrics at a glance:

  • Month to Date Actual: This column shows the Actual of each P&L account for the current month of the Current Year.
  • Month to Date Budget: This column shows the Budget of each P&L account for the current month of the Last Year.
  • Month to Date Variance: This column shows the variance in value between the Actual and the Budget for the current Period.
  • Month to Date Variance %: This column shows the variance in percentage between the Actual and the Budget for the current Period.
  • Year to Date Actual: This column shows the Actual of each P&L account for the current Year to date.
  • Year to Date Budget: This column shows the Budget of each P&L account for the Last Year to date.
  • Year to Date Variance: This column shows the variance in value between the Actual and the Budget for the current Year to date.
  • Year to Date Variance %: This column shows the variance in percentage between the Actual and the Budget for the current Year to date.

Mapping and Filtering

Mapping

The following mapping needs to be changed accordingly in the "Mapping" Sheet of each reports

Report SectionAccount Group
Grant Revenue1424
Contributions1426
Tuition1547
Member Fees1427
Sales1281
Service Fees1288
Investment Earnings1495
Other Revenue1897
Personnel Expenses1494
Professional Fees1381
Program Expenses1435
Occupancy1433
General and Administrative Expenses1201

Filtering

Selection Page:

  • Company (Tenant ID)
  • Year
  • Month
  • Parent Fund
  • Budget
  • Fund
  • Book
  • Department
  • Projects