Purpose: This help guide will show you which reports are available in Excel format.
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 will help you to identify which employees you need to print a paper check for.
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 that particular 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 individual deduction type so you can easily see who is on each plan. Additionally, you can run the All Deductions report to see all deductions for all employees for that pay cycle.
Each report will include 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 will include totals for each benefit and grand totals for all benefits if you are running the "All Deductions" report.
The available reports will vary based on what deductions are currently being used for each specified pay cycle.
Additional Date Range Reports
The Date Range tab will allow you to run reports for a specific date range instead of by pay cycle. There are a few additional Excel reports that are available when using a date range. Date Range reports with asterisks next to them (both PDF and Excel) are run by the Date From field.
The Employee Census reports details out all of the demographic and work details of each employee.
This report includes Employee 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 completely entail all data needed in order to accurately complete your application.
In addition to this report, you will need the 940 and 941 reports in the TRAXPayroll report library in order to successfully complete your application.
Click here to learn more about the Paycheck Protection Program.
The Paycheck Protection Program Report can be run 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 Cost for 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, in the month that they reach that amount, the excess wages will not be included in the report going forward. Additionally, the applicable taxes and deductions that correspond to the excess wages are excluded.
- It does not include Workers Compensation premiums.
- It does not include contract workers, just full-time and part-time employees.
If you 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 that their W2 is delivered to them? They can choose to have it as a paper form or emailed to them. Employees choose this when setting up their account on their first login and can update this from the employee's payroll login page.