Product Menu
Product Menu
Home
MAS 90
MAS 90 Small Business
MAS 200
MAS 200 SQL
MAS Enhancements
EDI
Crystal Reports
FRx
Citrix
Receive Our Demo CD
Viewable Demos
About Us
Price Lists
Contact Us


Payroll - Custom Crystal Reports PDF Print E-mail
Payroll Custom Crystal Reports





401 K Deductions Report - click to view report
This report provides the user with employees?s contributions to their 401K-Retirement program for a specific time period. It includes YTD Hours, Gross Wages and Taxable Wages. Note: YTD Totals are based on the ending date for the date parameter. This report only shows info for those employees who have a 401K contribution for the inputted period.

401K Plan Contributions - click to view report
Produces report for plan administrator to use to fund the 401K plan for each employee. The report computes employee and employer contribution to the plan and shows the applicable contribution rates. Sorted and totaled by department.

Check History Report - click to view report
This report produces a listing of Payroll Checks by a specified date range. The report is sorted by check number and shows Check Date, Employee Name and Check Amount.

Current Quarter Deduction Report - click to view report
This report provides a listing by Employee, of the Current Quarter Deductions based on a specified deductions code. The report is sorted by department and shows Department Number, Social Security Number, Employee Name & Address, Deductions Code and Quarterly Deductions.

Current Quarter Earnings Report - click to view report
This report provides a listing, by Employee of the Current Quarter Earnings based on a specified earnings code. The report is sorted by department and shows Department Number, Social Security Number, Employee Name & Address, Earnings Code and Quarterly Earnings.

Employee Advance Listing - click to view report
This report was designed to act as a subsidiary ledger to the Employee Advance General Ledger Account. It provides the Employee name, Original Advance, Deductions against the Advance and the Balance Remaining. If Employee Advances are posted to a single General Ledger account, the total of this report should agree with the General Ledger. The report asks for the deduction code before the report is run so you can use this report for deductions other than just Employee Advances.

Employee Anniversary Date - click to view report
Produces a report of employees who have an anniversary date with the company in the month selected. Data is sorted by year hired and department and includes department, employee number, employee name and hire date.

Employee Birthday Report - click to view report
Produces a report of employees whose birthday is in the month selected. The report shows department number, employee number, employee name and birth date.

Employee Listing - click to view report
This report prints an alphabetical listing of employees and includes the Employee Name, Employee Address, Department (if applicable), Employee Number, Pay Rates, Social Security Number, Birth Date, Hire Date and Termination Date (if applicable).

Employee Reviews by Month - click to view report
This report will select all employees who are coming up for their annual review in the month requested. Employees are sorted by employee number by department.

Employee Reviews Scheduler by Review Date - click to view report
This report establishes a schedule of employment reviews based on time employed. The report also shows Hire Date, Employee Name, Current Pay Rate, Old Rate and Date of Pay Rate Change. A formula within this report establishes reviews at 3 months of employment and then every six months thereafter. The report lists employees by their review date (6 Month, 1 year, 11/2 Year etc.) The report is very handy for planning reviews of employees.

Gender Count - click to view report
This report is run by a check date range entered by the user. It is grouped by the labor code and then by employee number. The report displays totals of all earnings associated with the grouped Labor Codes. It also includes a pie chart broken down by labor code.

Labor Code Report
This report is run by a check date range entered by the user. It is grouped by the labor code and then by employee number. The report displays totals of all earnings associated with the grouped Labor Codes. It also includes a pie chart broken down by labor code.

Payroll Check Report for Reversals - click to view report
This report shows all payroll checks (no date input parameters) that were reversed by Bank Code. The report includes Check Date, Employee Number, Employee name and Check amount.

Payroll Deduction History Report - click to view report
This report can be used only if the client has the payroll option set to retain perpetual history. The report will return a list of employees who had a particular deduction taken out during a user-defined date range. It provides the Employee Name, Address, Social Security, Department, the Deduction Code, Deduction Description and the Total Deduction Amount. The report also prints a grand total for all employees.

Payroll Input Sheet - click to view report
This report is used as a data input sheet for Payroll. The report includes an input line for hours worked, other earnings and miscellaneous deductions. The report is sorted by Department and Employee number.

Payroll SDI (California) Report
The Payroll SDI Report (CA) breaks down the portion of SUI that is due as SDI. This particular report must be run after Payroll entry is done and before the check register is updated.

Pension Report Based on # of Weeks Worked - click to view report
This report computes a Pension Contribution of $40.00 per week for all weeks the employee worked in excess of 15 hours. The report computes the number of weeks each employee worked over 15 hours based on a given beginning and ending date. The number of weeks worked (with 15 hours or more) is then multiplied by the Pension Rate of $40.00 to arrive at the Pension Contribution. The pension rate and the eligibility hours can be edited within the formulas.

Quarterly State Tax Report With All Hours - click to view report
Some states require that hours worked should reflect holiday, vacation, sick as well as regular and overtime hours. Standard MAS 90 report only shows regular and overtime and sick. This report allows the entry (by using parameters) of the state, annual limit, and date range for that quarter. A previous quarter cannot be run with the report. The user must have perpetual history checkbox checked in the options. That is, you must be tracking history for it to be reading the hours. This is due to the fact that the hours are being pulled from the perpetual history file PR_22.

Schedule of Earnings by Earnings Code - click to view report
This report shows QTD and YTD hours and dollar amounts per earnings code per employee. The report includes Quarter to date hours and amounts and Year to date hours and amounts and is sorted by division and earnings code.

Total Number of Employees per Pay Period - click to view report
This report sorts employees by division and shows Total Number of Employees, Gross Wages, Regular Hours and Overtime Hours by division. The report is run based on a beginning and ending period date.

Unused Vacation Time Liability by Department - click to view report
This report identifies those employees who have not used accrued vacation time. The cost of the unused time is calculated for each department and the company.

Weekly Hours Report By Department - click to view report
This report is used with the MAS 90 Time Card Module. It sorts by employee and pulls weekly time card entry information based on a beginning and ending date entry. The report warns you if the number of hours is less that a stipulated minimum. You can edit the formulas to establish different minimum hours worked by Department.

Work Comp earnings by month and comp code - click to view report
This report groups employees by worker's compensation code. It includes employees with earnings between the check dates selected and calculates gross wages, overtime, and workmen's comp taxable wages. The report can be edited to handle multiple states and excess overtime wages. Earnings codes are associated with specific workmen's compensation codes.

Yearly State Withholding Report - click to view report
This is a YTD State Tax Withholding report by specified state and year. The report shows Employee Name and Address, Social Security Number, Taxable Wages and Taxes Withheld.
   Home arrow Crystal Reports arrow Payroll - Custom Crystal Reports