PDF Reports in TRAXPayroll
What PDF payroll reports are available in TRAXPayroll?
Purpose: This help guide will show you which payroll reports are available in PDF format by pay cycle and date range.
Table of Contents
Some of the following approved payroll reports can also be found in BambooHR. Click here for more information.
Pay Cycle Reports
The Pay Cycle tab in TRAXPayroll allows you to run reports for the selected pay cycle. You can sort PDF reports by branch, class, department, division, or alphabetically.
The following PDF 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 summarized or broken down by employee.
The Total to be Electronically Transmitted is the amount that will come out of your bank account to fund the payroll.
This report is also available within Payroll Reports in BambooHR.
The Payroll Summary report sums wages, taxes, deductions, and payroll fees for a pay period. This report is a great option in helping you to reconcile and verify the data, i.e., custom reports. You can run this report for a specific payroll or by a date range.
- Payroll Summary report by specific payroll: For example, let's say I wanted to see a data summary for a specific payroll. I would select the payroll (this will highlight it in gray) and then click on the Payroll Summary report. When running the report, the data within the report will be for the selected payroll only.
-
Payroll Summary report by date range: If running the report by a date range, i.e., paycheck date, the data within the report will total all payrolls within the date range criteria. For example, let's say I wanted to see the summary of the data for a specific paycheck date. I would follow the same steps as shown in the Date Range PDF Reports help guide.
- It is important to note the Date From and the Date To fields should be actual paycheck dates. For example, my company's paycheck dates are August 2, 16, and 30 of 2019. I want to see the payroll summary for both the 2nd and 16th, so I will set the Date From field as 8/2/2019 and the Date To field as 8/16/2019. This will ensure the respective payroll data for these actual pay dates is the only data included.
- On the other hand, what happens if you put 8/1/2019 to 8/30/2019 as the date range? This would result in any payroll data with a pay date within the range appearing in the report. For example, maybe there is a pending payroll for a pay date of 8/23/2019 or a manual payroll for one person on 8/1/2019. Consequently, this would result in the report providing data that may not be what is wanted or accurate for the specific one-time purpose of pulling the specific date range.
- Header & Wages: The report will contain all the pertinent client and payroll-specific data at the top of the page. The report will show a breakdown of the gross wages and then the total for the gross wages. It is important to note that taxes and deductions are included in the gross wages.
- Net Check & Direct Deposits: The report will show a breakdown between the Direct Deposits and Net Checks. This section will show the total amount of direct deposits that will be collected from BambooHR Payroll and the total amount of checks to be printed from your company's printer. In other words, if the Net Check in this section has a dollar value, these checks must be printed from your company's check stock and will not be collected by BambooHR Payroll to fund the payroll.
- Deductions: The report will show a list of the Employee (EE) Deductions and if they are being "Collected" by BambooHR Payroll. If the deduction is collected by Payroll, it will be included in the total amount withdrawn from your company's bank account to fund the payroll. However, if the deductions are "Uncollected," your company will be responsible for the physical movement of the money, i.e. paying the liability.
- Employee Taxes: The report will show a list of the Employee (EE) Taxes and if they are being "Collected" by BambooHR Payroll. If the tax is collected by Payroll, it will be included in the total amount withdrawn from your company's bank account to fund the payroll. Generally, EE taxes are collected by BambooHR Payroll. However, if the taxes are "Uncollected," your company will be responsible for the physical movement of the money, i.e. paying the liability. For example, NY-FLI-EE, and NY-SDI are not collected in the screenshot above. These taxes would be paid by your company and are not included in the amount of money withdrawn by BambooHR Payroll to fund the payroll.
- Employer Taxes: The report will show a list of the Employer (ER) Taxes and if they are being "Collected" by BambooHR Payroll. If the tax is collected by Payroll, it will be included in the total amount withdrawn from your company's bank account to fund the payroll. Generally, ER taxes are collected by BambooHR Payroll.
- Report Summary: The report summary will be at the bottom of the report. This section will list each of the section totals and sum them together to add to the total Payroll withdrawn amount from your company's bank account under the "Collected" header. If there is any amount of money that isn't collected, it will be listed under the "Uncollected" header and will be the responsibility of your company.
These reports are also available within Payroll Reports in BambooHR.
The Payroll Register report summarizes each employee's hours and wages, taxes by employee and employer, and employee and employer deductions.
If you are using Project Tracking to track hours for employees with multiple pay rates, a breakdown of hours spent on specific approved Projects/Tasks will display as well.
Payroll Register with Hours
The Payroll Register With Hours report will show regular hours details for the current pay period as well as an hours total. Additionally, this report will summarize each individual employees wages, taxes by employee and employer, as well as employee and employer deductions.
If you are using Project Tracking to track hours for employees with multiple pay rates, a breakdown of hours spent on specific approved Projects/Tasks will display.
This report is also available within Payroll Reports in BambooHR under the report name "Extra Pay".
The Payroll Additional Pay/Expense report shows you a list of all additional payments and expenses for the selected pay cycle. This report also shows extra recurring pay and extra pay entered or uploaded in payroll. This includes the pay type and amount for each payment and the grand total.
This report is also available within Payroll Reports in BambooHR.
The Payroll Hours Input Sheet lists all hours for the employee for the selected pay cycle. This includes regular hours, Project Tracking hours, overtime hours, holiday hours, time off hours, and other hours.
This report is also available within Payroll Reports in BambooHR.
This report shows you a list of employees excluded from the specified payroll run. The employee's name, hire date, and termination date will show in this list.
This report is also available within Payroll Reports in BambooHR under the report name "Fee Details".
The Company Fee Details report lists all of the fees associated with the payroll run included in the selected pay cycle. This can include the base month fee, payroll fee per employee, timesheet fee per employee, garnishment fees, etc. The report also shows you the grand totals for each fee type in the selected pay cycle.
The Paper Checks report lists all employees who will receive paper checks. This report includes the employee's name, employee number, SSN, pay cycle ledger ID, check number, and check amount. Additionally, you will see a grand total amount at the bottom for all checks during the selected pay cycle.
It is important to remember that the client is responsible for cutting the checks.
This report is also available within Payroll Reports in BambooHR.
The Deductions reports allow you to run a report for each deduction type. 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.
This report is also available within Payroll Reports in BambooHR.
The Company Other Collection Details* report is used to show any tax adjustments your team has made that were collected within the payroll.
*Some company-specific information has been hidden in the example report above. The report in your account will display more information.
Date Range PDF 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 PDF reports available when using a date range. All employee data reports include active and terminated employees for the specified date range. Date Range reports with asterisks next to them (PDF and Excel) run by the Date From field.
The Termination List report shows you all employees terminated during the specified date range. The report includes the employee's name, SSN, employee number, hire date, and termination date.
The New Hire List shows you all employees hired during the specified date range. The report includes the employee's name, SSN, employee number, birth date, hire date, annual base salary, and termination date.
This report is also available within Payroll Reports in BambooHR.
The Worker's Comp Salary List includes the wages paid in the date range selected.
You can only use this report if you have your workers' compensation classification codes and rates set up under the Company tab. Employees can only be under one workers' compensation code.
This report is also available within Payroll Reports in BambooHR.
This report takes the employee's salary and multiplies it by the workers' compensation rate to give you an estimated premium amount for the specified time frame. This helps you refer back to audits with your workers' compensation carrier to true up anything (terminations and additions).
You can only use this report if you have your workers' compensation classification codes and rates set up under the Company tab. Employees can only be under one workers' compensation code.