They won’t change during the payroll process. The information in red ink is only the description for you to understand as a note. Also you may use Excel menu to do a few test print pages to make sure the information printed properly at the right positions on your check. To do this, selection “Customize” and click on :Īfter you clicked the button, (see figure 3) what you need to do is to drag and move the selected information you want to where you want to print on your computer check.Īfter you selected, moved, or formatted the information you prefer, please make sure you select and set the Print Area, under “Page Layout”=> “Print Area” => “Set Print Area”. You can print out your check any way you prefer. You may even make adjustments after your selection if the print-outs do not match the positions on your check.Ĭustomize Check: You can design your own brand-new check layout by clicking this button. You may select one of them to print your check. Standard Check: Check format preset for QuickBook, Quicken, Peachtree, SBT, Great Plains, Platinum, and other self-design check formats. It has nothing to do with when and how often you pay your employees. This is for payroll tax computation purpose only. Payroll Period: You may select different payroll periods from weekly, bi-weekly, monthly quarterly, or annually. In the “Order” column line 1, the entry 1 for the 1 st year of service accruing 40 hours after one year, starting the 2 nd year ( 2in order line 2), accruing 80 hours per year until the 5 th year (after the 4 th anniversary) starting the 5 th year of service, 120 hours and so on… Vacation accrual: the first green column “Yr of Srv” stands for “Year of Service” from the date of hired. The right column shows the maximum amount for each employee can deduct during the payroll year. If you check a tax item the deduction is not subjected to that tax when such a deduction incurred. The pink areas (cells) are to be computed by Excel macro.ĭeduction: please note that there is no need to enter the deduction items if you don’t have any. You can only enter information in the green areas. Please see the sample company information entered in the default setting. Enter information in the green area s,Ĭlick the return sign or to return to previous page when finish. Open the program file from your folder: PayrollBook.xlsm (see figure 1)
That’s all you need to do! No installation is needed!
You may change the folder name or path but do not change the names of the files. Unzip the Excel Payroll.zip file and copy all the four Excel files into a folder where you like to store your Excel Payroll Program in your C: Drive.
One (1) PDF file: Excel Payroll Instruction.pdf (this instruction menu) These four files must be in the same folder.ī. Excel Payroll.zip includes Four (4) Excel files: PayrollBook.xlsm, Payroll Record.xlsm, PRRecord.xlsm, and Payroll Time Card.xlsm.
Instruction (Or Click here to download Instruction here)Ī.
Offline Payroll Excel Program for Everyone