Payroll Processing, History, and Tax Worksheet Reports

The following is a list of reports available for MIP, along with a brief description of each report. Click each report to view more detailed information.

Report Name

Description

Payroll>Reports>Processing>

 

Quick Timesheets

This Payroll report used during a payroll cycle, verifies which payroll codes are being used to calculate an employee's pay, as well as the time and amounts entered on the timesheet for a pay date range. This report provides you with information about the timesheets entered using Timesheets>Enter Default Timesheets and Enter Regular/Supplemental Timesheets. Note that this is a fixed-format report. You cannot customize the columns in the report; the system has already determined them. However, you can arrange the data using sort order on the Report Body and Available Filters.

Timesheets

This Payroll report reviews default, regular, and supplemental timesheets for your employees. This data was generated using Timesheets>Enter Default Timesheets and Enter Regular/Supplemental Timesheets.

Calculated Check Register

This Payroll report, used during a payroll cycle, verifies paycheck information and amounts prior to printing paychecks. It is recommended that you print this report prior to printing checks for each pay cycle. Note that this is a fixed-format report. You cannot customize the columns in the report; the system has already determined them. However, you can arrange the data using sort order on the Items by Page and Available Filters. The Calculated Check Register provides information about the payrolls that were calculated using Activities>Payroll>Calculate Payroll.

Quick Calculated Check Register

This Payroll report used during a payroll cycle, verifies paycheck information and amounts prior to printing paychecks. It is recommended that you print this report prior to printing checks for each pay cycle. Note that this is a fixed-format report. You cannot customize the columns in the report; the system has already determined them. However, you can arrange the data using sort order on the Items by Page and Available Filters. The Calculated Check Register provides information about the payrolls that were calculated using Activities>Payroll>Calculate Payroll.

Pre-Transfer Register

This Payroll report prints the transaction entries prior to transferring to Accounting. The totals for this report were calculated using the Activities>Payroll>Transfer to Accounting form. You should have entered the session information and selected the groups to transfer, and then clicked the Pre-Transfer button. Once the report has been calculated, a message notifies you if there were any errors or if it calculated successfully.

Voucher Register

This Payroll report determines which direct deposit entries to make if you are not using the Direct Deposit module. The report prints the information to a printer or if the Data Import/Export module is installed, you can export the data to a file type of your choice.

Payroll>Reports>History>

 

Pay Codes

This Payroll report reviews an employee's pay codes history in summary or detail. The totals provided by this report only include the activity defined by the date range selected on the Setup tab.

Earnings

This Payroll report reviews an employee's gross earning history in summary or detail based on Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) amounts. Additional items, columns, and filters are available if any user defined fields were created.

Benefits

This Payroll report reviews an employee's benefit history in summary or detail based on Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) amounts.

Deductions

This Payroll report reviews an employee's deduction history in summary or detail based on Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) amounts.

Workers' Compensation

This Payroll report reviews an employee's workers' compensation history in summary or detail based on Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) amounts.

Taxes

This Payroll report reviews an employee's federal, state, and other withholding tax history in summary or detail based on Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) amounts. This report includes tax amounts as well as subject and gross taxable earnings. Additional items, columns, and filters are available if any user defined fields were created.

Leave

This Payroll report reviews an employee's leave history in summary or detail. The totals provided by this report only include the activity defined by the date range selected on the Setup tab. This report is an activity report not a balance report. The system automatically displays the last column of this report; it does not need to be selected on the Setup tab. This column does not have a heading, but prints Opening Balance or Current Balance each time the report changes from one employee name to the next or the leave code changes.

Opening Balance - If the Show Total check box is selected next to a column on the Setup tab, and the employee name/leave code changes from one name/code to next one, and it is the beginning balance, the label displays Opening Balance. The Opening Balance always prints an amount, even when it is zero. Opening balances print for the Net Hours column.

Current Balance - If the Show Total check box is selected next to a column on the Setup tab, and the employee name/leave code changes from one name/code to next one, and there is no detail to be printed related to the beginning balance, the balance label displays Current Balance. The Current Balance always prints an amount, even when it is zero.

Ending Balance - If the Show Total check box is selected next to a column on the Setup tab, the label displays Balance {Leave Code}. This is calculated by taking the opening balance plus the activity total amount.

Quick Check/Transaction Register

This Payroll report prints a detailed listing of check, voucher, and adjustment information. It is a fixed-format report, making it easier and quicker for you to run the report. You cannot customize the columns in the report; the system has already determined them. However, you can: Change the order in which the data is arranged by sorting (ascending or descending order) on the columns displayed in the Report Body group box on the Content tab and determine the way information is printed by changing criteria on the Filter tab. Finally, enter the date to filter on in the Criteria 1 column. The system only prints data that has the same pay date that is entered. Additional filters are available if any user defined fields were created.

Summary Check/Transaction Register

This Payroll report prints a summarized listing of checks, vouchers, and adjustments in a register style.

Quick Employee Payroll Summary

This Payroll report reviews an employee's payroll balances which includes columns for Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) amounts. You can also include associated employer amounts on your report by selecting "Employer Amounts" on the Options tab. Employee Payroll Summary is a fixed-format report. You cannot customize the columns in the report; the system has already determined them. However, you can arrange the data using sort order on the Items by Page and Available Filters.

Labor Distribution

This Payroll report displays a break down of labor hours and earnings by segment codes which was entered on the Timesheets>Regular/Supplemental Timesheets form.

Leave Liability

This Payroll report calculates the leave liability (a monetary amount) based on accrued leave hours and employee hourly rates (or equivalent hourly rates for salaried employees).

Direct Deposit File Register

This Direct Deposit report prints the history for the direct deposit files, during a pay cycle.

Payroll>Reports>Payroll Tax Worksheets>

 

Federal

This Payroll report summarizes federal tax employee amounts, employer amounts, subject and gross taxable earnings in Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) columns.

Other

This Payroll report summarizes other withholding tax employee amounts, employer amounts, subject and gross taxable earnings in Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) columns.

941 Worksheet

This Payroll report summarizes federal tax amounts and tax liabilityexcept for Federal Unemployment Tax. This report helps when completing the Form 941 and the Schedule B (Form 941). The 941 Worksheet is a fixed-format report. You cannot customize the columns in the report; the system has already determined them.

Earning Codes with Contribute to Net Pay Only check box selected, are excluded from the amounts. These Earning Codes were set up to process Employee Reimbursement and Advances through regular payroll processing (Maintain>Earning Codes).

Calculate W-2 Information

This Payroll report calculates W-2 information for your employees. You must first enter the appropriate tax year, and then select the employees for which you want to calculate W-2s. Once you click the Start button, the system calculates the amount of wages paid and taxes withheld for each employee for the selected tax year. Once this calculation process is completed, you can run and review records using the Reports>Payroll Tax Worksheet>W-2 Information report. Earning Codes with Contribute to Net Pay Only check box selected, are excluded from the amounts. These Earning Codes were set up to process Employee Reimbursement and Advances through regular payroll processing (Maintain>Earning Codes). You are required to file a Form W-2 for each employee from whom income, social security, or Medicare taxes have been withheld.

W-2 Information

This Payroll report displays all W-2 information for your employees. Prior to running this report, you must calculate the W-2 totals for the tax year using Reports>Payroll Tax Worksheets>Calculate W-2 Information. Once it has been successfully calculated, you can access the W-2 Information report. In the header of the report, the system prints the Preliminary W-2 Count. This is the number of W-2 records; however, the actual W-2s that are printed may vary. For example, you could have multiple W-2s if you have more than four Box 12 Items. The remaining Box 12 Items will print on the additional W-2 Forms.