Harmony P (CA) - Reports

Harmony P (CA) - Reports

Note: This article is only for the reports found in the Canadian version of Harmony’s Payroll module.

There are two (2) classes of reports that are available within the Payroll module of Harmony: In-Progress and Historical. In-progress reports refer to the reports that are only available while a payroll is in progress. These are the ones that you download/review in step 6 of the payroll wizard, such as the Payroll Journal, Deposit Register, and the Posting Balance Sheet. Historical reports are your on-demand reports that can be run at any time, whether you have a payroll in progress or not. Each historical report will have its own parameters, such as a date range or other filters.

There are also two (2) types of reports that Harmony provides for you: Standard and Dynamic. Standard reports can be found in the Reports > Reports section and are formatted in a way that is better for PDF or printing. Dynamic reports can be found in the Reports > Dynamic Reports section and are formatted in a way that is better for Excel or spreadsheet exports.

Standard Reports

Types of Standard Reports

Below, you will find the name of the report and a brief description on what the standard report contains.

In-Progress Reports

In-progress reports refer to the reports that are only available while a payroll is in progress. These are the ones that you download/review in step 6 of the payroll wizard, such as the Payroll Journal, Deposit Register, and the Posting Balance Sheet.

Name of Report

Description

Name of Report

Description

Payroll Journal

Provides details on employees' pay for the current pay run. A company total is provided at the end of the report.

Tip: This report is nearly identical to the Employee History Detail Journal historical report.

Deposit Register

Commonly used for bank reconciliation. Provides details on the employee, their banking details, and the net amount that is to be deposited. A total and employee count are included at the end of the report.

Cheque Register

Commonly used for cheque reconciliation. Provides details on the employee, their cheque/voucher number, and the net amount that is to be paid. A total and employee count are included at the end of the report.

Posting Balance Sheet

Commonly used for GL reconciliation. Identifies the dollar values for each payroll category before, during, and after the payroll is posted. Also includes the number of employees and their payment method.

Control / Approval Sheet Before Posting

Commonly used for payroll approval, if required within your organization. Includes elements from the Posting Balance Sheet in-progress report and the Government Remittance (Federal) historical report. A memo section and signature line are provided at the end of the report.

Adjustment Report

Identifies any manual adjustments made to the paycards in the current pay run, that were done in step 3 of the payroll wizard (process payroll).

Historical Reports

Unlike in-progress reports, historical reports are your on-demand reports that can be run at any time, whether you have a payroll in progress or not. Each historical report will have its own parameters, such as a date range or other filters.

Name of Report

Description

Name of Report

Description

Accrual Category (Employee)

Used to track accrual payroll category classes, separated by employee. This includes any opening balances, total accrued, total paid, and the outstanding balance.

Note: The Year-to-Date section of this report is year-specific. Please ensure you’re logged into the correct payroll year to view this report.

Accrual Category (Summary)

Used to track accrual payroll category classes, separated by department. This includes any opening balances, total accrued, total paid, and the outstanding balance.

Note: The Year-to-Date section of this report is year-specific. Please ensure you’re logged into the correct payroll year to view this report.

Government Remittance (Federal)

Used for federal source deductions or remittances (federal income tax, provincial income tax, CPP, CPP2, and EI). Also referred to as the DAS Report (Deduct At Source Report). This report will provide you with the total remittance, including total reported gross and total reported earnings & benefits, as well as the number of employees.

Government Remittance (Quebec)

Used for source deductions or remittances to Revenu Quebec. This report will provide you with the total remittance, including total report gross and number of employees for Quebec Income Tax, QPP, QPP2, and QPIP.

Statutory Holiday Pay

Calculates statutory holiday pay for employees according to the provincial minimums. Refer to this article for more information.

Payroll Summary

Summarizes the pay runs within the specified date range.

Employee History Summary Journal

Provides details on employees' pay, summarized within the date range you entered. A company total is provided at the end of the report.

Employee History Detail Journal

Provides details on employees' pay, separated with each run within the date range you entered. A sequence number is provided to identify multiple runs in a single pay period. A company total is provided at the end of the report.

Tip: This report is nearly identical to the Payroll Journal in-progress report.

Employee Year to Date Journal

Provides year-to-date totals on each employees' pay. A company total is provided at the end of the report.

Note: This report is year-specific. Please ensure you’re logged into the correct payroll year to view this report.

Payroll Categories Setup

Provides details on how your payroll categories are set up, including which payroll categories are being taxed (and by which tax) and any script that is defined.

Payroll Category (Summary)

Provides details on a specified payroll category within your selected date range, summarized by department. If selecting a tax, such as income tax, CPP/CPP2, or EI, a ‘gross’ and ‘taxable’ column will be available to identify the gross/taxable amounts for the selected tax.

Payroll Category (Pay Card)

Provides details on a specified payroll category within your selected date range, per pay card. If selecting a tax, such as income tax, CPP/CPP2, or EI, a ‘gross’ and ‘taxable’ column will be available to identify the gross/taxable amounts for the selected tax.

Payroll Category (Employee)

Provides details on a specified payroll category within your selected date range, per employee. If selecting a tax, such as income tax, CPP/CPP2, or EI, a ‘gross’ and ‘taxable’ column will be available to identify the gross/taxable amounts for the selected tax.

Multiple Payroll Category (Summary)

Provides details on specified payroll categories (up to five) within your selected date range, summarized by department.

Multiple Payroll Category (Month)

Provides details on specified payroll categories (up to five) within your selected date range, summarized by month.

Multiple Payroll Category (Pay Card)

Provides details on specified payroll categories (up to five) within your selected date range, per pay card.

Multiple Payroll Category (Employee)

Provides details on specified payroll categories (up to five) within your selected date range, per employee.

General Ledger (Department)

Provides the GL account codes and amounts for each account, separated by department.

Note: GL records must be created within the same date range first for this report to function.

General Ledger

Provides the GL account codes and amounts for each account, as a company total.

Note: GL records must be created within the same date range first for this report to function.

Worker’s Compensation (Canada)

Provides the total amount and assessable earnings for the selected WCB payroll category for each employee, with a total at the end of the report. If you have multiple provinces/territories/rates, ensure that you run the report for each WCB payroll category.

Employee Master Paycard

Details the employee’s default values found in the employee master paycard (Payroll Employees > Assign Payroll Category).

Employee Note

Lists all employee notes entered into the “Employee Notepad” field found in the employee’s payroll profile (Payroll Employees > Employee List).

Dimension List

List of current dimensions, as set up in the Labor & Equipment Costing sub-module.

Note: This report requires adding the Labor & Equipment Costing sub-module to your license.

Dimension Org Chart

List of current dimensions, as set up in the Labor & Equipment Costing sub-module, in an organized hierarchy tree, identifying parent-child relationships between dimensions.

Note: This report requires adding the Labor & Equipment Costing sub-module to your license.

Employee History Detail Journal with Labor

Similar to the Employee History Detail Journal, but also includes breakdowns of labor records, if any, per dimension.

Note: This report requires adding the Labor & Equipment Costing sub-module to your license.

Union Agreement

Identifies the union agreement with rates as set up in the Union sub-module.

Note: This report requires adding the Labor & Equipment Costing and Union sub-modules to your license.

How to Generate a Standard Report

  1. In Harmony’s Payroll module, go to Reports > Reports.

  2. From the list, use the three (3) dots button to select the standard report that you’d like to generate.

    1. Note: If you’d like to generate a labor or union report, select the different type at the top of the page.

      image-20251105-214703.png
  3. Identify the parameters on the right side of the report if required, such as a date range or any filters. You may click the “Refresh” button to reset your parameters.

    image-20251105-214432.png
    The parameters and filters that can be set is different for each report. This screenshot only depicts the parameters and filters for the Government Remittance (Federal) report. Your report may require different parameters and allow for different filters.
  4. Click “Open” to open the report with your parameters. The report viewer window will open.

  5. At the top of the report viewer, you may download, export, or email the report.
    Warning: As standard reports are formatted in a specific way, exporting them to a CSV or Excel file may result in empty rows or columns that can be removed before any data manipulation can take place.

    image-20251105-214415.png

Dynamic Reports

Types of Dynamic Reports

Below, you will find the name of the report and a brief description on what the dynamic report contains.

In-Progress Reports

Name of Report

Description

Name of Report

Description

Labor Report

Provides details on each employee’s labor record in the current pay period. Additional dimensions may be added by clicking ‘Columns’ on the right-side of the report.

Note: This report requires adding the Labor & Equipment Costing sub-module to your license.

Labor Cost Report

Provides details on each employee’s labor records in the current pay period, with additional costing payroll categories as per the union (i.e. union remittances).

Note: This report requires adding the Labor & Equipment Costing and Unions sub-modules to your license.

Historical Reports

Name of Report

Description

Name of Report

Description

GL Payroll History

Provides the GL account codes and amounts for each account, grouped by GL account code by default. Employee details are also included in the report.

Note: GL records must be created within the same date range first for this report to function.

Multiple Payroll Categories

Provides details on specified payroll categories within your selected date range, per employee. Additional fields can be included in the report, such as Date of Birth, SIN, Start Date, tax province, and many more.

Bank Service

Similar to the Deposit Register, this report can be used for bank reconciliation. Identifies the employee, transaction date, posting date, and the net amount.

Labor Report

Provides details on each employee’s labor records within your specified date range. Additional dimensions may be added by clicking ‘Columns’ on the right-side of the report.

Note: This report requires adding the Labor & Equipment Costing sub-module to your license.

Labor Cost Report

Provides details on each employee’s labor records within your specified date range, with additional costing payroll categories as per the union (i.e. union remittances).

Note: This report requires adding the Labor & Equipment Costing and Union sub-modules to your license.

Cost Allocation Report

Identifies allocation of costs per dimension and employee within your specified date range.

Note: This report requires adding the Labor & Equipment Costing sub-module to your license.

How to Generate a Dynamic Report

  1. In Harmony’s Payroll module, go to Reports > Dynamic Reports.

  2. Click “Open” for the report you’d like to generate.

    1. Note: If you’d like to generate a labor or union report, select the different type at the top of the page.

      image-20251105-214219.png
  3. Enter the parameters at the top of the page.

    image-20251105-214317.png
  4. Click the ‘refresh’ button to select your parameters. The report will populate at the bottom of the page.

  5. Click ‘Columns’ on the right side of the report. Add additional fields/columns if needed.

    image-20251105-214256.png
  6. Drag and drop the columns into the desired order.

    image-20251105-214341.png
  7. Drag and drop fields/columns into the ‘Row Groups’ section to group by the selected field. Please note that this will not work for the Multiple Payroll Categories report.
    Tip: If this is a report that you generate often with these fields, you can click the ‘save’ button at the top-right corner (next to the report name) to save this report. Next time, you may select this report instead of adjusting the report each time.

    image-20251105-214234.png
  8. For each field/column, hover over the header and click the hamburger icon button to enter additional filters or sorting options.

    image-20251105-214138.png
  9. Click the “Export” or ‘print’ button at the top-right corners of the page to download the report as a CSV/Excel file or print the report.
    Warning: As dynamic reports are built as spreadsheets, printing them may result in a very small print.

    image-20251105-214154.png