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 Section | Account Group |
|---|---|
| Grant Revenue | 1424 |
| Contributions | 1426 |
| Tuition | 1547 |
| Member Fees | 1427 |
| Sales | 1281 |
| Service Fees | 1288 |
| Investment Earnings | 1495 |
| Other Revenue | 1897 |
| Personnel Expenses | 1494 |
| Professional Fees | 1381 |
| Program Expenses | 1435 |
| Occupancy | 1433 |
| General and Administrative Expenses | 1201 |
Filtering
Selection Page:
- Company (Tenant ID)
- Year
- Month
- Parent Fund
- Budget
- Fund
- Book
- Department
- Projects