Transaction reports allow you to review a variety of payroll information such as employee earnings and hours and electronic funds transfer (EFT or direct deposit) transactions.
Sage 300 Payroll includes the following Transaction reports:
| Report Name | Report Description |
|---|---|
| For posted paychecks and entries made in transaction history, you can generate this report to display the hours and amounts that have been accrued and paid or as an accrual carry-over log that displays the accrual amounts or hours that were carried over to the start of a new accrual period. | |
| Earnings and Hours | Displays employee hours and totals. The information Sage 300 Payroll displays on this report varies according to your selected report options. |
| Earnings/Deductions Summary | Displays earning/deduction codes and their descriptions. The information Sage 300 Payroll displays on this report varies according to your selected report options. |
| Earns/Deds Summary for T4A/R2 |
Lists employees who are assigned earnings and deductions with T4A and/or R2 Reporting settings. The report summarizes amounts for each earning and deduction. Tip: You can also produce T4As, either as printed forms or files that you can submit to the Canada Revenue Agency (CRA) electronically. For more information, see Using the T4s Report or the T4As Report or Using Electronic Filing for T4s. |
| EFT Combine History | Lists the EFT combine files created after using the Combine EFT File process. |
| EFT Direct Deposit |
Lists details of direct deposit (EFT) transactions that have been processed. If you use |
| EFT Transactions | Print this report to verify the details of paychecks that have been directly deposited. This report includes information about each direct deposit transaction such as the employee’s number and name, bank account information, paycheck number, and amount deposited. |
| Employee Timecards | Lists employee timecards and provides the opportunity to ensure the timecards are complete and accurate before you calculate payroll. |
| Hours Analysis | Displays the hours (regular, overtime, shift) that were paid for each earning on an employee’s paycheck and the hours that were paid and accrued for each accrual on the paycheck. |
| Jobs | This report is available only if you use Sage 300 Project and Job Costing. Print this report to review details or summarized Job information related to payroll. |
| Manual Checks |
Lists payroll information specific to manual checks and manual check payroll runs. |
| Payroll G/L Transactions | Print this report before using Generate G/L Batch. This report includes only G/L transactions created on request using Generate G/L Batch. It does not include G/L transactions created during payroll posting. |
| Payroll Processing Exceptions | Lists error conditions that Sage 300 Payroll encounters during processing. |
| Payroll Job Register | This report is available only if you use Sage 300 Project and Job Costing. Print this report to verify the accuracy of posted job-related information after processing payroll, and use it as the audit trail for the payroll run. |
| Payroll Register | Lists payroll information for posted payroll. This report includes the check date, amount of checks, calculation sequence, posting sequence, employee numbers, names, , times late, employee earnings/deductions and tax lists, and more. |
| Pre-Check Payroll Job Register | This report is available only if you use Sage 300 Project and Job Costing. Print this report to verify the accuracy of payroll job-related information before printing and posting your payroll checks |
| Pre-Check Payroll Register | Lists payroll information for calculated payroll. You can use it to review payroll details before printing and posting payroll checks. |
| Tax Calculation Analysis | Allows you to review tax information and totals by employee. The information Sage 300 Payroll displays on this report depends on the report style you choose to generate. |
| Timecards | Allows you to review employee timecard information. This report includes employee numbers, names, timecard numbers, descriptions, statuses, earning/deduction information entered for the pay period, tax overrides for the pay period, total hours for regular and shift earnings, total amounts for vacation, sick, and compensatory time paid and more. |
| Workers' Compensation | Allows you to review workers' compensation information. The information Sage 300 Payroll displays on the report includes worker's compensation group, code, description, rate, employee total pay, excess earnings, assessable earnings, worker's compensation code totals, company totals and more. The information Sage 300 Payroll displays on this report depends on the report style you choose to generate. |