Introduction of Look Back Data Comparison Report

Prev Next

"Look Back Data Comparison" Report 

Users require a comprehensive tool to compare historical data within the RMS module for identifying trends, gaps, and discrepancies over selectable time frames. The "Look Back Data Comparison" report addresses this need by providing dynamic, multi-parameter spreadsheet reporting tailored for detailed financial and operational comparisons.

Key Functionality

  • Report Characteristics:
    • Name: Look Back Data Comparison
    • Display Location: RMS Module
    • Type: Spreadsheet report for detailed tabular data analysis.
    • Description: Facilitates comparison of data across multiple factors and options within selected parameters.

Report Parameters:

Field NameField TypeRequiredDefault Value

Date Type

Dropdown

Yes

Accounting Period Date


(Values: Pay Period End Date, Accounting Period Date)



Start Date

Date Picker

Yes

Blank

End Date

Date Picker

Yes

Blank

Company

Multi-select

No

Blank

Office

Multi-select

No

Blank (filtered by Company)

Column to Compare

Multi-select (Options include ERTaxes, Gross, GrossProfit, PayrollCost, Sales, TotalBill, TotalBillHours, TotalPay, TotalPayHours, WCCost, WCWage)

Yes

Gross

Compare By

Dropdown (Options: Yearly, Quarterly, Monthly, Weekly)

Yes

Yearly

Roll Up to Root Customer

Dropdown (True/False)

Yes

False

 

Report Output Columns:

Column NameDescription

Company

Name of the Company

Office

Name of the office under the company

Customer

Customer name

CustomerID

Customer ID associated with customer

Label

Label to display for compared data

Year

Displays data for selected year

 

Additional Note:

Columns are dynamically generated based on parameters; therefore, monetary fields are not summed in a grand total to maintain data integrity.