Skip to main content

Statement of Financial Position

In this Statement of Financial Position you can compare the Budget versus the actual in order to determine if everything is under control or if you exceed the budget in some area of your business.

Key metrics at a glance:​

  • Month to Date Actual: This column shows the Actual of each account for the current month of the Current Year.
  • Month to Date Budget: This column shows the Budget of each 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 account for the current Year to date.
  • Year to Date Budget: This column shows the Budget of each 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
Cash & Cash Equivalents1333
Investments1503
Accounts Receivable (Net)1293
Inventory1335
Fixed Assets (Net)1500
Other Assets1501
Short-term Liabilities1253
Long-term Liabilities1256
Other Liabilities1306
Net Assets1219
Operating Revenue1249
Expenditures1438

Filtering​

Selection Page:

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