Income (date spread) reporting

Schoolworks generates income - or ‘date spread’ - reporting in real time by creating records in the Finance Statistics object.

There is a corresponding Finance Statistics report type which is the basis of the income reports in the reports system.

By creating income records in real time we can display this information in reports and dashboards; and we can also automate the scheduling of reports for management reporting.

There are a number of standard reports installed with Schoolworks and can be found by searching for the word ‘income’ in the report search.

Data structure

Income records are created in a very efficient way in order to minimise the creation of the number of records (and therefore minimises the amount of data storage and related data storage costs) by storing one years information in ONE record.

A single (row) record holds the data spread information by:

• Calendar Week

  • W1,W2,W3…W53

• Calendar Month

  • Jan, Feb, Mar…Dec

• Calendar Quarter

  • Q1,Q2,Q3,Q4

• Calendar Year

  • CY

Also if you have the Salesforce ‘fiscal year' configured, the income is also calculated for fiscal periods:

• Fiscal Week

  • FW1,FW2,FW3…FW53

• Fiscal Period

  • FP1, FP2,FP3…FP13

• Fiscal Quarter

  • FQ1,FQ2,FQ3,FQ4

• Calendar Year

  • FY

Each Year record is differentiated by a ‘Year’ field - this makes if very easy to report, group and sum totals by any of the above fields.