Payroll Preview in Excel

The Payroll Preview report is available in Excel format.

To provide greater insight into the next payroll run, Payroll Preview results are available in Excel format. Payroll administrators may sort, filter, and compare payroll preview spreadsheets to gain a better understanding of costs and variances before the payroll is submitted for processing.

Benefits:

  • Easily download, sort, filter, and analyze Payroll Preview data.

  • Quickly identify any unexpected values and cross-reference them to Powerpay for correction.

  • A familiar format to be leveraged in other reports and systems.

  • Can be shared or archived without manual transcription or copy/paste work.

Features:

Company Totals & Payroll Summary

  • Displays gross pay, employee and employer contributions, and net pay for the current pay period.

  • Displays payroll number, pay period date, total employees paid, and report generation date/time.

Payroll Details by Employee

  • Payroll totals are broken down into rows representing each employee and payment type.

  • Includes gross and net pay (current & YTD), deductions (current & YTD), contributions (current & YTD), and total garnishees.

Tasks

Generate Excel Payroll Preview Report

  1. Go to the Payroll Preview page.Closed From the Process menu, select Payroll Preview.

  2. Click Request.

    Powerpay generates the preview.

  3. Click the Spreadsheet button.

    Powerpay downloads the report. The report displays the results based on payment type: reversal, manual, regular payment, and second payment.

Note: This feature will deploy automatically to customers in a phased approach between October 29 – December 31, 2025.

Note: If an error occurs with the preview, after this feature is deployed to your payroll, the Spreadsheet button does not display. Resolve the error displayed and resubmit your request.