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
- Worker's Compensation Salary List
- Worker's Compensation Estimate
- Employee Summary
- Estimated Annual Income
- Bank Change
- Deduction Change
- Demographic 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.
This report is also available within Payroll Reports in BambooHR.
The Cash Requirement report provides helpful insight into your payroll debits and liabilities. You can view the total debits, check payments, fees, and outstanding liabilities from your payroll broken down by employee.
This report is also available within Payroll Reports in BambooHR.
This report looks at the payroll selected and compares it to the previous regular payroll run. It ignores manual runs.
This report is also available within Payroll Reports in BambooHR.
The Paycheck Register report is a summary of the employee's paycheck during the specified pay cycle. It details out wages, taxes, deductions, and employees' demographic information.
This report is also available within Payroll Reports in BambooHR.
This report details the checks voided during the specified payroll run.
The Paper Checks report helps you to identify for which employees you need to print a paper check.
This report is also available within Payroll Reports in BambooHR.
The Complete Summary reports sum wages, taxes, and deductions and breaks them out by type. This report can be exported with or without demographic data. Each wage and tax is listed separately and summed up together. These reports are helpful because they house a lot of data from the payroll.
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.
This report is also available within Payroll Reports in BambooHR.
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.
This report is also available within Payroll Reports in BambooHR.
This report provides employee demographic details, workers' compensation codes, and wages paid in the date range selected.
This report is also available within Payroll Reports in BambooHR.
You can use this report to estimate the premium owed by the employer based on the assigned workers' compensation rate of the employee.
This report is also available within Payroll Reports in BambooHR.
These reports summarize the pay types, deductions, and taxes per employee. The above example is the By Pay Type 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.
If you joined BambooHR Payroll after 1/31/2020, you will receive an error message letting you know you cannot see the data in this report. Please contact Payroll Support, so we can assist you with getting the right information.
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:
Rows:
- Month and year
- Total of each column
- Average payroll cost (for all months included in the report)
Columns:
- 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.
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.