The following information is covered in this chapter:
After your employees are set up, you are ready to process an actual payroll. To do so, click the Process Payroll tab to access Process Payroll tab window.
The Process Payroll tab window displays the Employee Paysheet. When you select an employee, the paysheet itemizes the income, deductions, and employer contributions that you assigned to the selected employee. The program totals the amounts and displays them at the top of the paysheet.
If needed, you can enter or change many of the values in an Employee Paysheet without permanently changing the settings in the employee's file. Refer to Editing Employee Paysheets .
Once the employee's paysheet is correct, you can either print the paycheck, record it into Pay History without printing, or send it to the Check Queue where you can print it later with all the paychecks. We recommend that you print/record your paychecks from the Check Queue. For details on using the check Queue feature, refer to The Check Queue .
Please read the following information before processing your first payroll.
Some of the issues are purely informational while others require you to perform
some action.
Print out an Employee Data Summary report using your Master List.
Use this report to verify the correctness of your employee settings for such things as deductions, pay rate, limit amounts, and filing status. You can avoid a lot of frustration by making sure your employees are set up correctly at the start.
Decide how you want your payroll data stored.
Paychecks are stored in Pay History with the date printed on the check. If you want your payroll data stored with the pay period ending date, select Edit > Preferences, then click the Payroll button. In the Payroll window, select the Pay period ending date option.
Decide how you would like to generate reports.
Reports are generated based on the date on which the payroll is recorded. For example, if you want the payroll data reported in the 1st quarter, make sure you record it using a date within the 1st quarter.
Make sure you have the right checkform template.
If you intend to print your paychecks, you must have a checkform template that matches the checks you will be using. For more information, refer to Sample checkform templates .
Know how you are going to import employee hours.
If you want to import the employees' hours from a file (e.g., text file), refer to Importing employee hours .
If you are using Time Card, you will want to review the instructions for importing employee hours. See Importing Time Card hours into payroll .
When needed, you can easily add payroll items from an employee's paysheet. Instructions for the Add Pay Item feature are detailed in Adding pay items to paychecks.
As Report
The Print As Report button prints the paycheck stub data as a report.
Print Check
Sends the currently selected employee's paycheck directly to the printer.
Record Check
Records the currently selected employee's paycheck without printing it.
Queue Check
Adds the currently selected employee's check to the printer queue so you can print them all at once.
Print Queue
Prints all the checks you have added to the queue.
Send/Post
Opens the Send/Post dialogue, in which you export or import data to or from your accounting application.
After making changes to the hours or amounts in the paysheet, you can always reset the paysheet back to its original amounts by clicking the Revert button.
QuickCalc™ is a real-time check calculating process used by the program. The program automatically calculates the employee's deductions and contributions if you change an Income value. The checkbox for it is located in the upper right of the Process Payroll tab window. QuickCalc™ is active by default; however, you may unmark the checkbox it if you do not wish to use this feature.
If QuickCalc™ is not selected in Payroll Preferences, a Calculate button is displayed at the top of the paysheet. When you are in Calculate mode and change an Income value, the program does not update the deductions or contributions until you click the Calculate button or print the paycheck.
If you change the value of a deduction or employer paid without clicking the Calculate button, a window will appear asking whether you want to calculate or use the changed amounts.
Job Costing
Job Costing is an important function of the payroll process and is described in detail in the next section.
To access the Job Costing dialogue from within the Process Payroll tab window, locate the Job Costing column on the employee paysheet and then click the Allocate button next to the appropriate Income item.
Below are short descriptions of the options displayed in this dialogue.
Allocate by
Choose to allocate amounts by dollar amount or percentage.
Gross Amount
Displays the gross amount for the income item
Total Unallocated
Displays the amount left to be allocated
Total Allocated
Displays the amount that has been allocated.
Job Title
Displays the assigned jobs.
Allocation Amount
Enter the dollar or percentage amount in this column.
Enter percentages as whole numbers, example 15% would be entered as 15.
Assign Jobs
Click this button to access the Add Jobs window to assign jobs.
The gross amount for the income item will display if the Allocate by Dollar radio button is selected.
You can also add jobs in this window by tabbing into a blank field.
The assigned jobs will display.
The Total Unallocated and Total Allocated amount fields will update as you tab to the next Allocate Amount field.
Any unallocated amounts will be allocated to the Regular Pay income item.
Allocate by
Choose to allocate amounts by dollar amount or percentage.
Gross Amount
Displays the gross amount for the income item
Total Unallocated
Displays the amount left to be allocated
Total Allocated
Displays the amount that has been allocated.
Job Title
Displays the assigned jobs.
Allocation Amount
Enter the dollar or percentage amount in this column.
Enter percentages as whole numbers, example 15% would be entered as 15.
Assign Jobs
Click this button to access the Add Jobs window to assign jobs.
The gross amount for the income item will display if the Allocate by Dollar radio button is chosen.
You can also add jobs in this dialogue by tabbing into a blank field.
The assigned jobs will display in the Job Title column of the Job Costing dialogue.
The Total Unallocated and Total Allocated amount fields will update as you tab to the next Allocate Amount field.
Any unallocated amounts will be allocated to the Regular Pay income item.
You will be returned to the employee's paysheet.
Now that you've completed the tasks discussed in the first section and have an understanding of the various commands and features such as QuickCalc™ and Job Costing, we're ready to process paychecks. Because the program automatically calculates the payroll items for you, processing payroll takes very little effort.
We recommend that you use the Master List for processing payroll. You can, however, use different lists for processing payroll (e.g., Part Time and Full Time). Just be careful that an employee is not assigned to more than one employee list.
Are you rewriting an earlier check?
If you select an employee on the same day that a paycheck has already been recorded, a alert dialogue will appear asking if you are rewriting an earlier check. Click the Yes button if you want to replace the existing check with a new one.
Typically you will not need to enter any payroll information for salaried employees because their payroll data is the same each pay period. However, if necessary you can change the Pay Rate and Hours fields as needed.
The Amount field for salaried employees will be the same as the amount in the Pay Rate field and will not be affected by entering different hours. This is the nature of salaried employees whose paycheck is the same every pay period and is not based upon hours worked.
Enter the number of hours worked for Regular Pay, Overtime, and Double Overtime fields. The number of hours displayed for Regular Pay-Hours corresponds to the pay period you selected for this employee (e.g., semi-monthly equals 86. 67 hours). The Overtime and Double Overtime rates are calculated using the rates the employee was set up with. For information on displaying different hours, refer to Time Card preferences.
Commission and bonus amounts are generally simple dollar amounts. A bonus may have a special tax rate applied to it. If so, refer to Processing bonus checks .
If you are using the Jobs feature, select the appropriate job for each extra income item from the pop-up menus located to the right of the item. This feature allows you to track your jobs for reporting purposes. For more information, refer to Creating jobs .
Selecting this option adds the employee's paycheck to the Check Queue. This is the recommended method for printing/recording your payroll because it allows you to print all your employee paychecks at the same time.
When you are ready to print your queued paychecks, refer to Printing paychecks from the Check Queue .
Selecting this option allows you to print paychecks for selected employees now. For more information, refer to Printing checks from the Process Payroll tab window .
Selecting this option will record or save the paycheck information of the selected employee directly into Pay History without printing it. For more information, refer to Recording checks .
If you do not need to pay a particular employee, you can skip over the employee by pressing ( Command + ). The program will display the next employee in the list without doing anything to the employee you skipped. The skipped employee will remain on the list for subsequent payrolls. Terminated employees are automatically skipped over.
If you try to print or record a paycheck with a pay period date that already exists in Pay History, a window will appear giving you the option of replacing the paycheck that is already in Pay History, leaving the paycheck in Pay History and recording the new one, or not to do anything with either paycheck.
You can change a value in the Employee Paysheet by clicking the mouse pointer directly on the field you wish to change. Once the field is selected, you can type in the new value. Any changes you make in the paysheet (e.g., change a pay rate) will not alter the settings that were established when you set up the employee.
You can edit the components of each section (Income, Deductions, Employer Paid) but not the section totals.
Be careful to change all fields as necessary because changing one field does
NOT automatically affect the other fields. For example, changing Federal wages
does not change the Federal Tax amount.
You MUST hit the tab or return key to enter a change, however you do not have to wait for a change to calculate before entering the next value.
Depending on what you need to do, there may be times in which printing a single check from the Process Payroll tab window is simply more convenient.
If this is the first time you are printing a check from your payroll application, you can select Utilities > Check Designer from the File menu to preview your checkform before you actually print with it.
Printing a check from the Process Payroll window
If your checkform needs to be adjusted, you may move the fields by selecting Utilities > Checkform from the menu and adjust the form as necessary.
If the paycheck printed correctly, click the Record button to save the paycheck into Pay History and the selected check register.
If you need to reprint the check, enter the appropriate check number, then click the Reprint button.
Click Exit if you do not want to record or reprint the check.
There may be times when you want to record a single paycheck into Pay History without printing the paycheck. For example, if the paycheck was handwritten, or you are entering prior pay history upon initial use of the program.
Recording a check from the Process Payroll window
Enter the date that was written on the check and the date that represents the pay period for this payroll. If the date you enter is at least a week earlier than today's date, the program assumes you are entering prior pay history data and will display the Record Check Options window each time you click Record Check.
The program will record the paycheck into Pay History and the selected check register.
Once your company and direct deposit employees are set up and you have verified the setup with an ACH Prenotification file, you can use the Direct Deposit feature to pay your direct deposit employees. If this has not yet been set up, please see the sections on Direct Deposit in Chapter Two - Company and Chapter Four - Employees before attempting to follow the instructions in this section.
Processing direct deposit payroll
Notes about direct deposit checks
Selecting a form from the Direct Deposit form pop-up menu allows you to print a pay stub for any employee who is marked for direct deposit.
When you record a direct deposit check, the letters DD are inserted in the Check Number field of the Pay History window.
If you ever need to print regular paychecks for your direct deposit employees, select the For this payroll, instead of direct deposit, print checks... option.
When you quit the program or switch to a different company, the program will create a file called ACH Transmit File.txt in the Employee Files ü folder ƒor this company.
Your financial institution will take the file and credit the deposits of employees who bank there and then forward the remainder of the paychecks to the ACH network.The ACH will sort the records and immediately distribute them to the appropriate financial institutions designated by your employees, crediting employee accounts with their payroll amounts on payday.
You can quit processing payroll at any time and finish later. To end the payroll process, either exit out of the Process Payroll tab window or quit the payroll program all together. Any checks that have been recorded or added to the Check Queue will remain there. When you return to finish processing your payroll, continue where you left off by selecting the next employee from the Employee List, or you can go to the File menu and select Print/View Check Queue to print your checks.
After processing and recording payroll, the next step would be to post it to your accounting program. You should have already linked your payroll items to the corresponding accounting applications Chart of Accounts. This is very important for the payroll to process accurately. For details on designating account links, see Chapter 9 - Posting Data .
From the Employee List pop-up menu, select the employee list whose payroll you want to post.
Enter the payroll date you wish to post. This field defaults to your computer's system date. The date must exist in your Pay History records and be entered in this format: 8/24/04 (month/day/year). Note that the program sends by date and not by employee.
(Optional) If you want to post payroll using a different payroll date, click the Override date with checkbox and enter the date you wish the checks to appear within the accounting program.
A dialogue box will inform you that there is payroll information ready to export.
You will see another dialogue indicating that your payroll information was successfully exported.
The employee names and liability payee names may appear in your Other Names list in QuickBooks®.
Besides using the Process Payroll tab window to process your payroll, there are other features this window provides such as the Print as Report feature. This section details these other features.
Click the As Report button to print an employee's paycheck information exactly as it appears in the Employee Paysheet.
The payroll program provides different methods for calculating bonuses into the paychecks. The following instruction set covers three possible scenarios.
Bonus included in regular paycheck
If you want to include a bonus in the regular paycheck, enter the amount of the bonus in the Bonus field on the employee's paysheet.
If you want to print a bonus check separate from a regular paycheck (e.g., Christmas Bonus), zero out all the values in the employee's paysheet except for the Bonus field. The changes you make in the paysheet will not alter the employee's default setup.
Bonus pay that is taxed differently than regular income
Bonus pay may be taxed differently than the regular income. Check your state and federal laws for the current rates. If you need to change the tax rate for bonus pay from the normal default tax rate, access the Employee tab window or the Payroll Items tab window, highlight the employee, then choose Edit > Bonus Tax Rates.
In the Bonus Tax Rates window, enter the tax rate for the Federal and/or State taxes to a different percentage than the regular withholding. The rate you enter here will override the normal withholding rate and will only affect the Regular Pay Bonus of the selected employee.
You can use the Import Hours feature to import a file that contains the hours your employees have worked. The file you create must conform to the following specifications.
The import file can be created in any word processor or text editor providing it is saved in TEXT format. However, it is best to use a program like Microsoft Excel™.
The information must be typed in sequence for each employee using all of the following information, even if it may be zero.
Employee name<press TAB key >Regular hours<press TAB key >Overtime hours<press TAB key >Double-Overtime hours<press TAB key >Commission amount<press TAB key >Bonus amount<press RETURN key >
The names in the text file must match the names in the Employees tab window. For example, if an employee's name is entered into the program as John E Johnson, you must enter it in the text file as John E Johnson.
The text file may look different on your screen. This is fine. The important thing is that you put a Tab between each field and a Return after each employee's line of data.
Once you have your data file ready to import, open the Process Payroll tab window, then select File > Import Hours. An Open dialogue will appear allowing you to locate the file and import the data. The data is then placed into each employee's paysheet.
The Check Queue (pronounced "Q") feature is the preferred method for printing/recording your payroll because it allows you to print/record all your paychecks at the same time.
If you have employees with Direct Deposit, you will have to queue the payroll into the check queue and Print or Record the payroll from the Check Queue. This will record all the check numbers as "DD" for employees with Direct Deposit.
Because the Check Queue is a file that is saved to your hard disk, you can add your employee paychecks to the Check Queue when you process payroll, quit the program and then return at a later time to print/record the paychecks. To do so, select File > Print/View Check Queue after you have restarted the payroll application.
If you are setting up the payroll program mid-year, the "record" buttons allow you to enter your employees' prior paychecks into Pay History without having to print the paychecks.
There are two ways in which you can access the Check Queue window:
You cannot access the Check Queue window unless it contains at least one queued paycheck.
There are times when you may want to view a paycheck before sending it to the printer. The Preview command allows you to preview your queued paychecks just as they will appear when printed.
Previewing a paycheck before printing
The Preview button is grayed out if more than one employee is selected in the
list.
Printing your paychecks from the Check Queue is a convenient way of printing an entire batch of checks at one time.
Printing paychecks from the Check Queue
If you want to choose only certain paychecks to print, select the employee(s) whose paycheck(s) you want to print, then click the Print button.
If you want to print all the paychecks listed in the Check Queue, click the Print All button.
From the Checkform pop-up menu, select the checkform you want to use for printing the paychecks.
From the Check Register pop-up menu, select the register you want the paychecks posted to. Note: This register is only used in the payroll program and is completely separate from the registers in your accounting program.
Enter the starting check number. If all employees have Direct Deposit, type "DD" as the starting check number.
Enter the date you want printed on the paychecks and the pay period ending date. The program automatically fills in both fields with today's date. You can enter a date to be printed on the paycheck (usually the actual date the checks are handed out), and a date that represents the pay period for this payroll.
If any of the paychecks in the Check Queue are for direct deposit employees, select a form from the Direct Deposit form pop-up menu. The form that you select will be used to print a "pay stub" for any employee who is marked direct deposit. If you do not have any direct deposit employees, the program will disregard whatever form you select.
If you ever need to print regular paychecks for your direct deposit employees, select the For this payroll, instead of direct deposit, print checks... option.
When a direct deposit check is recorded into Pay History, the letters DD are inserted in the Check Number field.
If you chose to Print All the paychecks in Step 3, the Print Check Options dialogue will appear after you click the OK button in the Print dialogue.
The Print Check Options dialogue provides you the opportunity to print an
After Queue Summary report. You can print, view, or export this report
in the format of a text file by marking the radio button next to your choice,
and clicking the View button. If you do not want to view the
report, click the Cancel button to exit the window.
Select this option if your checks printed correctly. The program will record the paychecks into the Pay History and selected check register, then remove them from the Check Queue.
Select this option if you want to reprint some or all the paychecks you printed.
To reprint only those you need to reprint, select the Reprint selected checks option, select the employees whose paychecks need to be reprinted, enter the starting check number, then click the Reprint Checks button.
To reprint all the paychecks, select the Reprint all checks option, enter the starting check number, then click the Reprint Checks button.
After reprinting the checks, you will again be allowed to record or reprint the paychecks, or exit the Check Queue window.
If you decide that you do not want to record or reprint any of the paychecks, click Exit to return to the Check Queue window. The paychecks will stay in the queue--it will be as if you never printed anything--and your Pay History will not reflect these checks.
There may be times when you need to process payroll without actually printing the paychecks, such as when you need to enter prior paychecks into the Pay History records.
Recording queued paychecks without printing
Record only selected paychecks
If you want to choose only certain paychecks to record without printing, select the employee(s) whose paycheck(s) you want to record, then click the Record Check button.
If you want to record all the paychecks listed in the Check Queue, click the Record All button.
From the Check Register pop-up menu, select the register you want the paychecks posted to.
Enter the starting check number.
The program automatically fills in both fields with today's date. Enter the date that was written on the check and the date that represents the pay period for this payroll.
If the date you enter is at least a week earlier than today's date, the program
assumes you are entering prior pay history data and will display the Record
Checks Options window each time you click the Record Check button.
If you are set up to process Direct Deposit payroll and any of the employees are direct deposit, a Direct Deposit Dates dialogue appears after clicking the OK button. Please refer to Processing Direct Deposit Payroll in this chapter.
If you chose to Record All the paychecks, the following occurs:
If you chose to record only selected paychecks, the following occurs:
There may be times when you need to edit a paycheck before it is printed and/or recorded.
An alert dialogue will prompt you to Save, Don't Save or Cancel. Make the choice appropriate for your situation.
There may be times during the course of processing your payroll that you need to remove one, two, or perhaps even several checks from the Check Queue.
Removing paychecks from the Check Queue
If you want to remove only certain paychecks, select the employee(s) whose paycheck(s) you want to remove and click the Remove Check button. The following will occur:
These checks will appear in gray and will stay in the queue until you remove all of the checks from the queue following the steps outlined below.
If you want to remove all the paychecks from the Check Queue, click the Remove All button. The following will occur:
We recommend that you check the user's guide that accompanied your printer to determine the correct placement of checks in the paper tray or the manual document feed.
See Test printing checkforms to determine the correct alignment of fields on your check (either preprinted or blank),