Excel Reports in TRAXPayroll
What reports are available for download in Excel format in TRAXPayroll?
Purpose: This help guide will show you which reports are available in Excel format.
Table of Contents
- Pay Cycle Reports
Additional Date Range reports
- Employee Census
- Employee Deduction
- Employee Wage
- Employee Bank
- Employee Hour Benefit
- Worker's Compensation Salary List
- Worker's Compensation Estimate
- Employee Summary
- Estimated Annual Income
- Bank Change
- Benefit Detail
- Deduction Change
- Demographic Change
- Hour Type Change
- New Hire
- PPP Estimation Report
- Retirement Plan Audit
- W-2 Delivery Method
- Wage Change
Pay Cycle Reports
The Pay Cycle tab allows you to run reports for the selected pay cycle. The following Excel reports are available on this tab.
The Paper Checks report helps you to identify for which employees you need to print a paper check.
The Wage & Hours reports allocate wages, taxes, and deductions per job by percentages. This is helpful for companies that need everything broken out per job for accounting purposes.
The Bank Direct Deposit report lists employees in the specified payroll run who had direct deposits. The account number will not show for security purposes.
The Deductions reports allow you to run a report for each deduction type so you can easily see who is on each plan. Additionally, you can run the All Deductions report to view all deductions for all employees for that pay cycle.
Each report includes the following for each employee: employee's name, hours worked during the pay cycle, deduction amount, year-to-date total (for employee), employer amount, and employer year-to-date total. Additionally, the report includes the total for each benefit and the grand total of all benefits if running the All Deductions report.
The available reports vary based on the deductions currently used for each specified pay cycle.
Additional Date Range reports
The Date Range tab allows you to run reports for a specific date range instead of by pay cycle. There are a few additional Excel reports available when using a date range. Date Range reports with asterisks next to them (PDF and Excel) run by the Date From field.
The Employee Census reports detail all of the demographic and work details of each employee.
This report includes the employee's name, employee ID, SSN, employee number, job title, birth date, hire date, annual salary, address, email, home phone, work phone, gender, marital status, termination date, position job title, pay grade, EEOC, race/ethnicity, branch, class, department, division, worker comp, manager, and alternate manager.
This report provides insight into the wage, overtime rate, and additional wages for the specified date range.
Please note employees will only appear in this report if they have an active wage in the date range. If you run the report for a date range that is before the employee's wage date, the employee will not show in the report.
The Bank Change report lists all employee bank records added or modified in the date range selected.
The Demographic Change report lists all employee deduction records added or modified in the date range selected.
This provides a listing of new hires during the specified date range.
The information in this report can be useful in your Paycheck Protection Program loan application process. It is your responsibility to determine whether or not you qualify to apply for the PPP loan. You are responsible for all information submitted to the SBA or any lending institution to obtain a loan. It's important to review and confirm the accuracy of the information contained in this report, as well as all information you provide as part of your application. The information in this report is based on gross pay and has exclusions as noted below. Depending on your situation, it may not fully entail all data needed to complete your application accurately.
In addition to this report, you will need the 940 and 941 reports in the TRAXPayroll report library to complete your application successfully.
Click here to learn more about the Paycheck Protection Program.
You can run the Paycheck Protection Program Report for any custom date range using the date range filters at the top of the report. This report is only available in Excel format, not PDF.
This report includes the following information:
- Month and year
- Total of each column
- Average payroll cost (for all months included in the report)
- Gross Pay $ amount for the month
- Employer Taxes State and Local $ amount for the month
- Employer Taxes SS/Med $ amount for the month
Employer Benefit Costfor the month
- Employer-paid amounts for group health care benefits and insurance premiums, including the employer’s share of medical, dental, and vision premiums.
- Employer-paid short-term disability, long-term disability, 401K, and HSA contributions.
- Payroll Cost (sum of all previous columns)
- # of Employees Paid in each month
This report excludes the following information:
- When an employee has over $100,000 in gross pay wages, and in the month they reach that amount, the excess wages will not be in the report. Additionally, the applicable taxes and deductions that correspond to the excess wages get excluded from the report.
- It does not include workers' compensation premiums.
- It does not include contract workers, just full-time and part-time employees.
If you have joined TRAXPayroll after 1/31/2020, you will receive an error message letting you know you will not be able to see the data in this report. Please reach out to a payroll support hero (1-866-872-9123 or firstname.lastname@example.org), so we can assist you with getting the right information.
The Retirement Plan Audit report provides a quick listing of the amounts employees and employers contributed to specific retirement plans by pay date.
Would you like to see how your employees have designated to receive their W-2? This report will display whether or not your employees have chosen to go paperless and when they last updated their delivery method. The delivery method is set to paper by default, but they can choose to have it sent electronically to them through their Pay Info tab in BambooHR. This help guide provides more information on how to change the delivery method.