Skip to main content

Statement of Revenues & Expenditures - Forecast

This will give you a picture of the Revenues & Expenditures up to the end of the year. The month entered in the Selection page will be use as the cut-off month for the report. Anything before this month will contains the Actual data while the remaining will be based on the budget data.

Key metrics at a glance:​

  • Full Year Actual: This column shows the Total Acutal for the entire Year.
  • Full Year Forecast: This column shows the Total Forecasted for the entire Year.
  • Full Year Actual + Forecast: This column show the Total of the Forecast + Actual. All the values before the current period will be Actuals and all the other period will be Forecast value. The total of both will give a more real prevision for the entire year.
  • Full Year Variance: This column show the variance between the Forecast and Actual value.
  • YYYY-MM Actual/Forcast: All the YYYY-MM column will display the Actual or Forecast depending

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
  • Fund
  • Book
  • Department
  • Projects