P A Y R O L L
Payroll Overview
The Payroll module provides selections for:
|
Payroll 9-1 |
ProBooks Payroll handles both after-the-fact payroll and automatic payroll
calculation and check-printing. Daily, weekly, bi-weekly, semi-monthly,
and monthly pay periods are supported.
Each paycheck can include an unlimited number of hours entries. Each hours entry can have its own:
Paychecks are modifiable and can be printed on tractor, preprinted laser
or plain-stock laser forms.
Reports include 940, 941’s, W-2’s, federal and state unemployment insurance and state disability insurance reports, as well as a complete earnings history for each employee.
Tax tables can be updated by users and federal and state tax table updates are available annually from PC Accountant.
Before running the first payroll of the new calendar year.
Before running the first payroll of a new calendar year you must complete
the following steps.
Select, Payroll, Setup/Utilities, Close Payroll Year. This process copies current year payroll data to the prior year payroll file and empties the current year payroll file.
You can continue to run any payroll report from your prior year payroll file at any time during the new year. To run reports from your prior year payroll file select [P]rior year when running reports.
Update Federal & State tax tables. This process loads the latest Federal and State withholding tax tables from PC Accountant tax update file.
|
9-2 Payroll |
State and Federal Income tax withholding tables
The file ATAX95.PCA which is installed during updating contains the latest Federal and State Tax tables as of the date your program or update was shipped.
If your locality has a local withholding tax, you must update these tables
manually from the information provided by your local taxing authority.
For details please see the section Payroll Tables in this chapter.
To Update Tax Tables
To Update Tax Tables select [Payroll Tables], then [Update]. This process updates only Federal and State tax tables and does not change any Local Tax table entries.
If you have multiple sets of books in your system, Tax Tables must be updated
for EACH set of books in your system.
You can use the [Import] option in Payroll Tables to import the tax tables from one set of books to another.
Always compare the rates in the tables with the tables provided by your
state government.
Manual changes to the tables can also be made, when necessary, to adjust for more recent changes in federal or state tax tables.
ProBooks uses annualized formulas for computing withholding taxes. The
amounts calculated may vary slightly from the amounts shown in daily, weekly,
or monthly tables in your state withholding tax guide.
|
Payroll 9-3 |
EMPLOYEES
Entering Employee Information
Before you can enter payroll you will need to enter basic information about each employee into the employee file. To access your Employee cards select Employees from the Payroll menu.
Employee cards store information on your employee. When you select [Employees] from the Payroll menu the first employee in your file will be displayed.
Using Card Files
You can find a more detailed description of how ProBooks Card Files work, and the various features available in all card files, in the Using ProBooks chapter of your manual.
Lookup mode and Edit Mode
Card files have two modes, lookup mode and edit mode.
When the first employee card is displayed, you will initially be in lookup mode.
When you want to add a new card or change an existing card, activate Add or Edit mode by selecting [Add], [Edit], or clicking on one of the fields in the card screen.
|
9-4 Payroll |
Finding the card you want
Think of your ProBooks card files as rotating card files.
UpArrow/DownArrow
You can flip through the cards by using the [UpArrow]/[DownArrow] keys on your keyboard, or selecting one of the arrow buttons on the control panel, much like turning the wheel on a rotating card file.
You can also lookup up a particular Employee in several other ways:
Lookup Buttons
To lookup an Employee by Employee number or Employee name, select the appropriate button in the Employee card.
Home/End
You can quickly skip to the first or last card by pressing [Home] or [End] on your keyboard, or by double-clicking on one of the arrow buttons on the control panel and holding it down until the first or last record is found.
PgUp/PgDn
You can skip through several cards at a time by pressing [PgUp] or [PgDn] on your keyboard, or by double-clicking on one of the arrow buttons on the control panel and holding it down.
Find
Select [Find] to locate an Employee on additional fields in the Employee record.
Filter
Select [=Filter] to select an Employee or Employees using an expression or search string.
Multi-screen cards
Some cards files keep more information than will fit in one screen. The files use tabbed multi-screen cards to provide several screens for each record in the card file.
To access the hidden screens click on the tabs for each screen, or select [Screen].
Adding New Employees
Select [Add] to create a blank file card to add a new employee.
Changing Employee Information
Select [E]dit or click on one of the fields in the card screen to activate Edit mode.
When you’re in edit mode pressing [Tab]/[Shift]+[Tab] will move the cursor through the various fields and buttons in the card screen.
Enter the appropriate changes in the desired field or fields.
To save or cancel the changes you’ve made and return to lookup mode, select [Edit] again, or press [Esc], [PgDn] or [Ctrl]+[W].
|
Payroll 9-5 |
Deleting Employee Records
Normally you should not delete employee records. You will need information
on past employees to print payroll forms, and for future reference. If
an employee is no longer active, enter a date in the Date Left field.
Select [Delete] to delete an employee.
When you confirm deletion of an employee card, the card will be marked deleted and ‘Deleted’ will appear at the bottom of the control panel. Deleted cards are not removed from the employee file until you select [Done].
FIELD DEFINITIONS
EmpNmbr
A three digit alphanumeric employee ID number.
Name
The employee’s name.
Position
The job title or type of job which this employee holds in your organization.
Date Hired
The date when the employee began work.
Last Raise
The date of the most recent raise given to this employee.
Date Left
The date of the last day worked. If this field has a date, you won’t be able to enter hours or pay checks for this employee. If an employee is rehired, use the space bar to blank the field.
Pay Basis
The basis on which the employee is paid. Select:
Pay Period
The pay period Select:
Reg Hrs/Period
The default number of regular time hours per pay period.
|
9-6 Payroll |
OT Hrs/Period
The default number of overtime time hours per pay period.
PT Hrs/Period
The default number of premium time hours per pay period.
PayCode
If a Paycode is entered for an employee, rates and SDI code setup for the
paycode will override pay rates and SDI codes in the employee record.
The paycode for this employee corresponding to a paycode setup in your payroll tables.
Group
A group code, from group codes you’ve designated to identify workgroups. The group code can be used when loading payroll hours, and in user defined reporting.
Job
An optional default Job number for the employee. When a job number is entered in hours entries or pay checks, the job cost files are updated with payroll information when pay checks are posted.
Employees Screen 2
|
Payroll 9-7 |
Earnings
Reg Rate
If a Paycode has been entered for an employee, rates and SDI code setup
for the paycode will override pay rates and SDI codes in the employee record.
The rate will depend on what the Basis for this employee is.
If the pay basis is hourly (H), enter the rate per hour.
If the pay basis is salaried, enter the rate per pay period.
For example, if you have an employee who is paid $24,000 per year, and the pay period is S (Semi-Monthly - 24 pay periods), enter 1000.00. If the employee is paid $24,000 per year and the pay period is monthly, enter 2000.00.
If there is a fixed commission rate per pay period, enter the amount in the Other Pay field.
OT Rate
If an employee is hourly, enter the default Overtime rate for the employee.
PT Rate
If an employee is hourly enter the default Premium rate for the employee.
Other Pay
If an employee receives a fixed other pay amount each pay period, enter the amount of other pay per pay period.
Other Type
If an employee receives a fixed other pay amount each pay period, enter a code that’s been designated for the type of other pay.
Other Payments
Allowance
If an employee receives a fixed allowance each pay period, enter the amount of allowance per pay period.
Expenses
If an employee receives a fixed amount for expenses each pay period, enter the amount per pay period.
AdvEIC
If an employee receives a fixed advanced earned income credit (AdvEIC) payment each pay period, enter the amount per pay period.
Dep Care
If an employee receives a fixed dependent care allowance each pay period, enter the amount per pay period.
Sick Plan
If an employee receives a fixed sickness plan payment each pay period, enter the amount per pay period.
|
9-8 Payroll |
Taxes
Status
These status categories are used to calculate payroll tax deductions.
ProBooks maintains tables for Single, Married and Head of Household.
Some states have different tables for Married persons filing separately and Married filing jointly.
Status N and O are used for married persons from these states. Married persons filing separately from these states should select N or O depending on which table, Single or Head of Household is used for the state.
Fed. Exempt
The number of Federal Exemptions which the employee is claiming. The default is 0.
FWT Adj.
An amount up to $9999 which is withheld for federal income tax in addition to the amount calculated by the program.
Tax State
The tax state for state income withholding taxes.
Dollar Exemp
An amount up to $9999 which some states use instead of, or in addition to, a number of exemptions. How you will use this field will depend on which state you live in.
State Exempt
This is the number of State Exemptions which the employee is claiming. The default is zero.
SWT Adj.
An amount up to $9999 which is withheld for state income tax in addition to the amount calculated by the program.
Locality
If you have a local withholding tax, assign a two digit code to each employee who is to be taxed by the locality. The tax tables use this code to locate the correct table to use for the locality.
SDI Code
The Workman’s Compensation/State Disability Insurance (SDI) code.
If a Paycode is entered for this employee, the SDI Codes entered in the
PayCodes table for the selected paycode will override the SDI code entered
in the employee record.
Union
If the employee belongs to a union, enter a code for the union which corresponds to a union code in your payroll tables.
|
Payroll 9-9 |
SDI Exempt
If an employee is exempt from state disability insurance (SDI) enter [T]rue, otherwise enter [F]alse.
SUT Exempt
If an employee is exempt from state unemployment tax (SUT) enter [T]rue, otherwise enter [F]alse.
FUT Exempt
If an employee is exempt from federal unemployment tax (FUTA) enter [T]rue, otherwise enter [F]alse.
Misc1-Misc6
ProBooks provides six general purpose miscellaneous deduction fields. An amount can be entered here which will be deducted every time a payroll is run.
You can set up Names for your Miscellaneous fields which will appear in
most screens, on checks, and in reports.
Names for Miscellaneous fields
are set up in Company Setup in the Payroll defaults screen.
Insurance
A flat rate deduction for insurance. This field may be used for employee paid insurance, or for any user designated miscellaneous deduction if desired.
DCPlan1-2 are used for Deferred Compensation Plan deductions like 401K plans, or Cafeteria plans, or SEP’s.
DCPlan1 Type
If the DCPlan1 deduction is a flat amount enter [$]. If the deduction is a percentage of gross pay, enter [%].
DCPlan1 Rate
If the DCPlan1 deduction is a flat amount enter the amount of the deduction. If the deduction is a percentage of gross pay, enter the percentage of gross pay to be deducted.
DCPlan1 Limit
The annual limit for the DCPlan1 deduction.
DCPlan2 Type
If the DCPlan2 deduction is a flat amount enter [$]. If the deduction is a percentage of gross pay, enter [%].
DCPlan2 Rate
If the DCPlan2 deduction is a flat amount enter the amount of the deduction. If the deduction is a percentage of gross pay, enter the percentage of gross pay to be deducted.
DCPlan2 Limit
The annual limit for the DCPlan2 deduction.
Garnish
An amount to be deducted for garnishment each pay period.
GarnAcct
The account to which garnishment deductions are to be posted. A different garnishment account can be set up for each employee if desired.
Advance
This field provides a means to set up an automatic installment deduction. Enter the total amount to be deducted from each pay check for payment against the advance balance.
When pay checks are posted, the amount of the advance deduction will be deducted from the amount in the advance Balance field.
|
9-10 Payroll |
When the amount in the advance Balance field is 0.00 the amount in the Advance field will be changed zero.
Balance
The amount of the advance balance. When an amount is entered for advance payment on a paycheck, the amount in the advance balance field will be increase when pay checks are posted.
Advance Account
The account to which advance payments and deductions are to be posted. A different advance account can be set up for each employee if desired.
Employees Screen 3
VacRate
The number of Vacations Hours to be accumulated for each hour worked.
VacHrs Accumulated
The number of Vacation Hours accumulated.
VacHrs Paid Ytd
The number of Vacation Hours paid this year.
SickRate
The number of Sick Hours to be accumulated for each hour worked.
The number of Sick Hours accumulated.
|
Payroll 9-11 |
SickHrs Paid Ytd
The number of Sick Hours paid this year.
Spouse and Emergency Information
Name and address information on spouse and an emergency contact.
Employees Screen 4
User Defined Fields
User1 - User6
These fields are user defined memo type fields you can use for whatever you choose. Each field can hold an unlimited amount of information.
|
9-12 Payroll |
Entering Payroll Hours
The first step in preparing pay checks is to enter your payroll hours. Hours can be entered on an ongoing basis during the pay period, or when you’re ready to prepare pay checks.
You can enter hours individually or in groups. It’s also possible to import a payroll hours file you’ve created using ProBooks or a custom application.
Hours can only be entered for employees who have not previously been terminated. You can make as many entries as are needed for each employee. Each entry can have a different paycode, workstate and job.
From the Payroll Hours screen, select [A]dd to add an hours entry.
|
Payroll 9-13 |
Date
The work date for these hours. If you enter hours only once per pay period this would normally be the last day of the pay period. If you enter hours by day or by job, enter the date the work was performed.
PayCode
The Paycode for these hours.
If a paycode is entered, the rate per hour, SDI code and cost account will be taken from information for this paycode set up in your payroll tables.
If no paycode is entered, rate per hour and SDI code will be taken from the employee record, and the default payroll expense account from your company setup file will be used.
Reg. Hours
Next, enter the actual hours worked (or in the case of piece goods, the number of pieces), accept or change the default rate and the overtime hours.
OT Hours
The number of overtime hours.
If a paycode is entered, the rate per hour will be taken from information for this paycode set up in your payroll tables.
If no paycode is entered, rate per hour from the employee record will be used.
PT Hours
The number of premium time hours.
If a paycode is entered, the rate per hour will be taken from information for this paycode set up in your payroll tables.
If no paycode is entered, rate per hour from the employee record will be used..
Other Pay
Enter the amount of other pay, if any. For example, commissions.
|
9-14 Payroll |
OtherPay Code
The optional code you have designated for this other pay category.
Job
The optional Job number for these hours. If a Job number is entered, job cost files will be updated when pay checks are posted.
Select [Edit] to highlight the hours entries list, locate the entry to edit using the arrow keys and press [Enter]. Or double-click on the entry you want to edit with the mouse.
The same screen is used for both adding and editing.
Clear
Select [Clear] to clear all hours entries from the payroll hours list.
Report
Select [Report] to print a payroll hours register.
Always print an hours register and review your hours entries for accuracy
before calculating pay checks.
|
Payroll 9-15 |
Loading Hours for a Group of Employees
From the Payroll Hours screen select [Load] to quickly load hours for a group of employees.
Load hours for employees paid
Select the pay period for the employees you want to load hours for.
Whose pay basis is
Select the pay basis’ to be included.
For the period ending
Select the pay period ending date to be recorded on these hours entries. When you Load hours, the work date for these hour entries will be the same as the period ending date.
Select hours for
Paycode
If you enter a paycode, only hours for employees with the selected paycode will be loaded.
Group
If you enter a group code, only hours for employees with the selected group code will be loaded.
Job
If you enter a Job number, only hours for employees with the selected default Job number will be loaded.
Load default hours
If Load default hours is checked, the default number of hours in each employee record will be loaded.
|
9-16 Payroll |
Select [Load] to load hours entries for the selected group of employees
Select [Done] when you’re finished loading hours.
PAY CHECKS
If this is the first pay date in the calendar year, remember to close the
payroll file for the calendar year BEFORE running pay checks.
You can continue
to run payroll reports for the prior calendar year by specifying (P)rior
Year when running reports.
Preparing to Print Pay Checks
After payroll hours have been entered, select Pay Checks from the Payroll menu.
|
Payroll 9-17 |
Calculating Payroll Checks
Select [Calc]ulate to calculate earnings, payments, taxes and deductions for a selected group of hours entries.
Calculate payroll for employees paid
Select Employees who are paid
Select the pay period for which pay checks are to be calculated.
Whose pay basis is
Select the pay basis for which pay checks are to be calculated.
For pay period ending
Select the period ending date for which pay checks are to be calculated.
Calculate these deductions
Uncheck [ ] Taxes if you don’t want taxes to be calculated.
Uncheck [ ] Deductions if you don’t want default deductions from the employee records to be loaded.
Calculate
If there are already Pay Checks in the Pay Checks list, these entries will be overwritten when you calculate pay checks for a new group.
|
9-18 Payroll |
If you don’t want these pay checks entries to be overwritten, select [Print/Post] to print paychecks and post payroll, before calculating pay checks for a new group.
If there are hours entries for the group you’ve selected, ProBooks will calculate a pay check for each employee in the selected group. When calculations are complete, the pay check entries will appear in the pay checks list.
Report
Print the pay checks register and check each pay check for accuracy.
Pay Check
Editing Pay Check Entries
Select [Edit] to highlight the pay checks list, locate the pay check to edit using the arrow keys and press [Enter]. Or double-click on the entry you want to edit with the mouse.
Clear
Select [Clear] to clear all pay checks from the pay checks list.
Report
Select [Report] to print a pay checks register.
|
Payroll 9-19 |
Always print a pay checks register and review your pay checks entries for
accuracy before printing pay checks.
If hours entries from which these pay checks were calculated are changed,
pay checks must be recalculated. When payroll is recalculated, any changes
you made to the deductions fields will be overwritten.
After calculating, edit individual pay checks if required.
After you’ve printed your pay checks register and verified the accuracy of your entries, select [Print/Post] to print pay checks and post payroll information.
When you’ve reviewed your pay check entries for accuracy and you’re ready to print pay checks select [Print/Post]
Post Wages & Salaries to
Select the period payroll expense is to be posted to.
|
9-20 Payroll |
Post Pay Checks to
Select the period paychecks are to be posted to.
If both payroll period and pay checks period are the same, all entries will be posted to the same period.
If the period paychecks are posted to is greater than the period payroll expense is posted to, entries increasing payroll expense and Accrued Payroll will be made in the payroll expense period. Entries reducing cash and Accrued Payroll, and increasing tax liabilities and expenses, will be posted to the pay checks period.
Cash Account
Select the account number on which pay checks are drawn.
Division/Dept
Salaries and Wages will be posted to the division/dept specified by the account number set up for each paycode. Other amounts will be posted to division/dept 000 unless you select a different division/department here.
Don’t Update Ledger
If you are posting prior pay check entries when you setup ProBooks, or paychecks which are being entered to make adjustments to the payroll file, without affecting the general ledger, check [X] Don’t Update Ledger.
OK/Cancel
When the options in the Posting Payroll dialog are correct, select [OK]. If you don’t want to continue with printing checks and posting payroll, select [XCancel].
Printing Pay Checks
Beginning Check Number
|
Payroll 9-21 |
The next check number in the selected bank account will be displayed. If checks have been written that have not yet been entered into ProBooks, this may not be the correct check number. Check the number on the next check, and correct the number that’s displayed if necessary.
Check Date
Enter the check date that is to appear on these pay checks. The check date must be a date that’s within the period selected for Pay Checks in the Post Payroll dialog.
Form Name
Select the pay check form name for the type of checks you will be printing.
ProBooks provides for these standard pay check forms:
You can select a default pay check form name in the Company Setup, Forms & Numbers screen. Select Forms & Numbers from the Payroll, Setup & Utilities menu to access the Company Setup, Forms & Numbers screen.
Reprint
Check [X] Reprint if you have already printed these checks, then canceled before posting.
Align
Select Align to print a test check to test the alignment of your tractor feed checks. Once you’ve determined the correct positioning of your tractor feed checks in the printer, mark the printer, or make a note describing how to position the checks in the printer for proper alignment.
Modify
You can modify the selected check form, but if you do, be sure you select [Align] to print a test check before proceeding.
You shouldn’t try to modify the check forms unless you’re familiar with
using the report form designer, and with the special requirements for modifying
payables check forms. For more information see topic Modify Check Forms
in the section Setup & Utilities in this chapter.
OK/Cancel
Select [OK] if you’re ready to print your checks. Select [XCancel] if you don’t want to continue.
Did These Checks Print Properly?
Wait until all checks have printed before continuing. If your checks don’t print properly, select [No]. You can correct the printer or problem, and restart the Print/Post procedure.
If all of your checks printed properly, select [Yes].
When the ‘Print Report/Post’ dialog appears, put plain paper in your printer, or select an alternate printer to print your pay check register on, and select [Print].
A pay checks register and posting register will be printed, and your files will be updated.
|
9-22 Payroll |
Save these reports with your permanent records.
What happens when payroll checks are printed
Voiding a Payroll Check
Please refer to topic Void Payroll Check in the Setup & Utilities section of this chapter.
MANUAL CHECKS
|
Payroll 9-23 |
This function allows you to enter manual payroll checks, or ‘after the fact’ payroll. Entering a manual check is a three step process. First, the information is entered into a temporary file and a printout of the entry is made. Next, if there are any errors, the temporary file can be changed. Finally, the entry is posted to the payroll file and the Ledger.
Enter or look up an Employee code
PayCode
The Paycode for this employee.
If a paycode is entered, the rate per hour, SDI code and cost account will be taken from information for this paycode set up in your payroll tables.
If no paycode is entered, rate per hour and SDI code will be taken from the employee record, and the default payroll expense account from your company setup file will be used.
Pay Period
The last day of the pay period for this payroll check.
Check Date
Enter the actual date of payment. Pay period and paydate will not necessarily be the same.
Check No
The check number that was issued for this paycheck.
Job
Optional job number. You can:
|
9-24 Payroll |
State
Next, you will either accept the default state (from the employee file) or enter a new state (in case these hours were worked in a different state).
Sick/Vacation
If this check was for sick or vacation hours, check the appropriate box.
Earnings & Payments
Reg Hours
Next, enter the actual hours worked (or in the case of piece goods, the number of pieces), accept or change the default rate and the overtime hours.
OT Hours
The number of overtime hours.
If a paycode is entered, the rate per hour will be taken from information for this paycode set up in your payroll tables.
If no paycode is entered, rate per hour from the employee record.
PT Hours
The number of premium time hours.
If a paycode is entered, the rate per hour will be taken from information for this paycode set up in your payroll tables.
If no paycode is entered, rate per hour from the employee record.
Reg Pay
Regular pay is the calculated result of regular hours x regular rate.
OT Pay
Over time pay is the calculated result of OT hours x OT rate.
PT Pay
Premium pay is the calculated result of PT hours x PT rate.
Other Pay
Enter the amount of other pay, if any. For example, commissions or tips.
Other Payments
Allowance
If an employee receives an allowance, enter the amount of allowance this pay period.
Expenses
Enter the amount of expenses reimbursed this period.
AdvEIC
If an employee receives an advanced earned income credit (AdvEIC) payment, enter the amount for this pay period.
|
Payroll 9-25 |
Dep Care
If an employee receives a dependent care allowance, enter the amount for this pay period.
Sick Plan
If an employee receives a sickness plan payment each pay period, enter the amount for this pay period.
DCPlan1
Payment from deferred compensation plan 1.
DCPlan2
Payment from deferred compensation plan 2.
Advance
If this check included an employee advance, enter that amount here.
Taxes
Taxes can either be entered manually, or calculated by Probooks.
See Calculating
manual checks in this chapter.
Deductions
If automatic deductions have been set up in the employee file, they will be displayed in the manual check entry, accept or change as necessary.
You can set up Names for your Miscellaneous fields which will appear in
most screens, on checks, and in reports.
Insurance
If an insurance deduction has been set up in the employee file, it will be shown here, accept or change as necessary.
Garnish
If a garnishment has been set up in the employee file, it will be shown here, accept or change as necessary.
Advance
Enter the amount to be deducted from this pay check for payment against the advance balance.
Balance
The remaining amount of the advance balance.
When you are finished with your entries, print a Report and check your entries for accuracy prior to posting.
The report shows the hours, deductions, pay amounts and a Summary Distribution.
|
9-26 Payroll |
Pay Check Tax Calculations
Calculating Manual Checks
Select [Calc] to calculate this manual check. If you have manually calculated this check, Probooks will show you the amounts you entered and the amounts the program has calculated. Select whether to save manual amounts or calculated amounts.
Editing Manual Pay Check Entries
After manual entries are made and placed in a temporary database, they can be changed before posting them to the permanent records. The same screen is used as in entering manual checks. Refer to the preceding section for details.
When you are finished with your entries, print a Report and check your entries for accuracy prior to posting.
The report shows the hours, deductions, pay amounts and a Summary Distribution.
|
Payroll 9-27 |
Posting Manual Pay Check Entries
When you have checked your entries for accuracy, select [Print/Post] to post your entries.
Enter the dates and periods for this payroll. During posting, a payroll register will be printed, as well as a summary distribution report.
What happens when payroll checks are posted
Please refer to topic Void Payroll Check in the Setup & Utilities section of this chapter.
|
9-28 Payroll |
Employee
Select an employee or leave the employee field blank to include all employees.
Brief/Summary/Detail
A detail report will list every entry for the employee, as well as Period-to-date and Year-to-date totals. The summary report will show only subtotals and totals.
Current/Prior Year
Select whether the report is to be compiled from the current or prior year payroll file.
From/To
Enter the beginning and ending dates for the report.
Form
Select Form to access the report writer setup for this report. The report writer has provisions for reporting using additional options, and for modifying the report format. Please refer to the Report Writer chapter of your manual for more information.
Select Print to print the report with the selected options.
|
Payroll 9-29 |
PAYROLL REPORTS
|
9-30 Payroll |
Employee List loads a basic Report Writer setup for printing Employee lists.
You can use the features of ProBooks report writer to:
For more information on modifying user defined report and label forms,
and other Report Writer options, please refer to the Report Writer chapter
in your manual.
|
Payroll 9-31 |
Employee Labels
Employee Labels loads a basic Report Writer setup for printing Employee labels.
You can use the features of ProBooks report writer to:
For more information on modifying user defined report and label forms,
and other Report Writer options, please refer to the Report Writer chapter
in your manual.
|
9-32 Payroll |
Employee Inserts
Employee Inserts loads a basic Report Writer setup for printing Employee address inserts. An address insert is simply an address printed on a plain sheet of paper so that when it’s folded it can be used to address a window envelope.
You can use the features of ProBooks report writer to:
For more information on modifying user defined report and label forms,
and other Report Writer options, please refer to the Report Writer chapter
in your manual.
|
Payroll 9-33 |
Vacation Status
Vacation Status report loads a basic Report Writer setup for printing Employee vacation status.
You can use the features of ProBooks report writer to:
For more information on modifying user defined report and label forms,
and other Report Writer options, please refer to the Report Writer chapter
in your manual.
|
9-34 Payroll |
Sick Status
Sick Status Report loads a basic Report Writer setup for printing Employee sick pay status.
You can use the features of ProBooks report writer to:
For more information on modifying user defined report and label forms,
and other Report Writer options, please refer to the Report Writer chapter
in your manual.
|
Payroll 9-35 |
Payroll Tables
Payroll tables report loads a basic Report Writer setup for printing a list of the payroll tables.
You can request the table for a particular state, all states or FE for the federal table. If you have more than one locality for a given state, you will receive a printout of each of the localities.
You can use the features of ProBooks report writer to:
For more information on modifying user defined report and label forms,
and other Report Writer options, please refer to the Report Writer chapter
in your manual.
|
9-36 Payroll |
Paycodes
Paycodes report loads a basic Report Writer setup for printing a list of paycodes.
You can use the features of ProBooks report writer to:
For more information on modifying user defined report and label forms,
and other Report Writer options, please refer to the Report Writer chapter
in your manual.
|
Payroll 9-37 |
PAYROLL TAX FORMS
Most of these payroll tax forms can be printed from either current or prior year payroll information.
Many of ProBooks payroll tax forms utilize user modifiable report forms which can be updated by users if necessary, or to conform to specialized reporting requirements of your state or locality.
Annual payroll tax table and forms updates are available from PC Accountant.
Contact PC Accountant Customer Support for information.
|
9-38 Payroll |
941 FWH/FICA/Medi
Reporting Period
Select whether the report should be run from the current or prior year payroll file, and for which quarter.
Enter the appropriate amounts in the following fields.
Semi Monthly Report
Check [X] Semi Monthly Report if you report semi-monthly, and need the second page of the 941 report.
Plain Paper Form
Check [X] Plain paper form if you want to print amounts only.
|
Payroll 9-39 |
940 FUTA
The form 940 report calculates the wages taxable for FUTA and amounts used on the form 940 federal unemployment tax return.
|
9-40 Payroll |
W-2 forms for a single employee or all employees can be printed any time during the year.
Employees
All employees will be selected unless you select a beginning and ending employee.
Current/Prior year.
You can print W-2’s from the current or prior year payroll file. Select current year or prior year.
Recalculate totals
If [X] Recalculate totals is checked, YTD totals will be recalculated before printing. If you are printing multiple copies, or printing for selected employees, it is not necessary to recalculate YTD totals before printing each copy or employee.
Edit totals before printing
If [X] Edit totals before printing is checked, you will have the opportunity to edit the amounts ProBooks calculated before printing.
ProBooks standard W-2 formats provide for tractor feed or Laser W-2’s which print one across, two forms per page.
ProBooks for Windows also has forms for printing W-2’s on plain paper.
W-2 report forms are modifiable, allowing you to update the forms if the
format changes, or change the information that prints in various boxes
in the form.
Optional W-2 formats may be available from PC Accountant.
Annual
Federal and State Tax table and tax form updates are also available from
PC Accountant.
Contact PC Accountant Customer Support for information.
|
Payroll 9-41 |
SUT Unemployment
The state unemployment report is a generic report that includes information used in most state unemployment returns.
The first page of the report provides summary information. Subsequent pages will list the employees, their social security numbers and their gross wages and hours.
A subtotal is provided for each page, as well as a place for your signature. Check with your state to see if you can use these forms as alternate forms. If you cannot, transfer the information to the state required form.
|
9-42 Payroll |
These reports provide information which may be required for preparing state or local withholding tax reports or state disability insurance (SDI) reports.
The options allow you to report summary or detailed information on any or all employees for a specified time period. The report will provide subtotals by state, locality or insurance category (WCCode), depending on the selected options.
|
Payroll 9-43 |
The Generic DE3 style report prints state tax information in a generic format modeled on the California DE3 report. In addition, the listing of employees reports SDI and SUT taxable amounts for each employee, as required in some states.
The report is printed using user modifiable forms allowing for customization of the report format to conform with reporting formats used in other states.
The sample report form includes information on weeks worked, and taxable SDI and SUT wages for each employee.
|
9-44 Payroll |
The State Taxes report for California produces a report modeled on the California DE3 report.
A DE3B is printed when there are more than seven employees in the report period.
The program uses the Percentage field in the SDI Payroll Table for California for the default Training Tax percentage used in the report.
|
Payroll 9-45 |
PAYROLL TABLES
The Payroll Tables are used to maintain information on tax rates, paycodes, pay rates, account, tax status, and other information for payroll income and deduction items.
Proper calculation of payroll and payroll taxes is dependent upon proper
set up and maintenance of the Payroll Tables.
Federal and State tax tables supplied were up-to-date at the time your program was shipped, however, tax rates may have changed between the time your program was shipped, and the time you begin using ProBooks for your payroll.
You should compare the amounts calculated by ProBooks to the amounts shown
in your Federal, State, and Local tax guides.
Because ProBooks uses annualized tables, small variations between the withholding
calculated by ProBooks and the amounts shown in the tables is normal. Generally,
these variations will be insignificant on an annual basis.
|
9-46 Payroll |
Federal, State, and Local tax Tables are user maintainable. When adjustments are necessary, you can enter these changes yourself.
Annual Federal and State income tax table updates are also available annually from PC Accountant.
Call PC Accountant Customer Support for information.
Local income tax tables must be entered and maintained by the user.
Tax Table Update
|
Payroll 9-47 |
You must close the payroll file for the calendar year before entering payroll
for the new calendar year. The current year payroll file will become the
prior year payroll file. You will be advised that all YTD payroll figures
will be reset to zero. You can continue to run payroll reports for the
prior calendar year by specifying (P)rior Year when running reports.
Annual Federal and State income tax table updates are available from PC Accountant.
When you update your tax tables, a backup of your existing payroll table file will be made in a file named ATAX.BAK in your data files directory, and Federal and State withholding tax tables in your payroll tables file will be updated with information from the tax table update file.
If you have multiple companies/sets of books in your system, you must update
tax tables for each client in your system.
You will need to update any local withholding tax tables from information obtained from your local taxing authority.
Importing Payroll Tables from another Set of Books
If you have more than one company/set of books, you can import the payroll table from one set of books to another.
This can eliminate the need to update the payroll tables for each set of books individually.
Select [*Import] to import the payroll tables from another set of books. Next, select the company/set of books from which payroll tables are to be imported.
ProBooks will load the payroll tables from the selected company into the payroll tables for the active company.
|
9-48 Payroll |
Payroll Table Header
Field
The payroll field which this table controls.
Description
The long name for the table.
Account Number
The general ledger account number to be updated with amounts for this table when payroll is posted.
For tables that have a Company and Employee component:
For example:
For Employee SUT you would enter the account number for State
Unemployment Tax Payable.
For Company SUT you would enter the account number for State Unemployment Tax Expense.
Payable Vendor
A payable item can be created for liabilities created when payroll is posted.
|
Payroll 9-49 |
This allows you to use Payables Checks to issue checks in payment of your payroll taxes, like Federal Income Tax, SUT, SDI, etc.
If a Vendor is selected, a payable will be created for the selected vendor.
Your Payables Aging will report payables grouped by general ledger account number.
While the payables created during posting of payroll will appear in your Accounts Payable Aging report, they will appear in the general ledger in the specified account. For example, Federal Withholding Tax payable, and not in the Accounts Payable account.
For tables that have an Employee and a Company component:
For example:
For Employee SUT you would enter the Vendor code for your state’s
unemployment tax authority.
For Company SUT you would leave vendor code blank, as this is an expense item.
Our Payer ID
Your Payer ID number, if applicable, for this taxing authority or vendor.
Locality Name
For Local Withholding tax tables, this field is used for the locality name.
For Washington State SDI (state industrial insurance) this field is used
for the Industrial Insurance category number.
Exempt
