BUS-BOOK55-02 · Lesson 7 · 12 clock hours · lab
Payroll Setup in QuickBooks
Objective. Students will set up payroll preferences, create at least three employee records with pay schedules and withholding information, and run a sample payroll, producing a paycheck register that matches a provided gross-to-net calculation.
⚠ Pending professional review
This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.
VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.
Payroll Setup in QuickBooks
Payroll is one of the most regulated tasks in bookkeeping. Errors affect employees' paychecks, trigger IRS penalties, and create legal liability. This lab walks you through enabling payroll in QuickBooks, building employee records, and running a sample payroll so you can verify every net-pay figure before a real check is ever printed.
Why Accuracy and Security Matter
Payroll data is highly sensitive. Employee Social Security numbers, bank routing numbers, and wages are protected under federal and state privacy rules. Always work on a password-protected workstation, log out when you step away, and never share login credentials. In a live environment, restrict payroll access to authorized users only through QuickBooks' user-permission settings. In this lab you are using a sample or test file, but practice the same habits now.
Step 1 – Enable Payroll and Configure Pay Schedules
In QuickBooks Online (QBO), navigate to Payroll Settings under the gear icon. In QuickBooks Desktop, go to Edit > Preferences > Payroll & Employees. Enable the payroll feature and confirm you are in sample or test mode so no live tax filings are submitted.
A pay schedule tells QuickBooks how often employees are paid and what dates to use for tax deposits. Create at least two schedules for this lab:
- Weekly – employees paid every Friday; 52 pay periods per year.
- Bi-weekly – employees paid every other Friday; 26 pay periods per year.
Pay period frequency affects how federal income tax (FIT) withholding tables are applied, so setting it correctly is not optional.
Step 2 – Create Payroll Items
A payroll item is a named earnings or deduction category that QuickBooks uses to track wages and liabilities. For this lab you will set up three:
1. Hourly Wage – an earnings item linked to the appropriate expense account (e.g., Wages Expense). Enter the default hourly rate if all employees share one, or leave it blank to enter it per employee.
2. Salary – an earnings item for fixed annual compensation; QuickBooks divides the annual amount by the number of pay periods automatically.
3. Health Insurance Deduction – an employee-paid deduction; select the correct deduction type so QuickBooks knows whether it is pre-tax (Section 125 cafeteria plan) or post-tax. A pre-tax health deduction reduces taxable wages for FIT and FICA before withholding is calculated.
Map each item to the correct Chart of Accounts category so your financial statements stay accurate.
Step 3 – Enter Employee Records
Use the scenario employee data sheets provided. For each employee, complete every required field:
- Legal name and address – must match Social Security Administration records.
- Social Security Number – double-check digit by digit.
- Filing status and withholding allowances (W-4 information) – use the employee's most recent Form W-4. Post-2020 W-4 forms use a different structure (no allowances box); enter the amounts from Steps 2–4 as directed by the form.
- State – determines which state income tax table applies.
- Pay schedule and pay rate – assign each employee to the correct schedule created in Step 1.
- Direct deposit banking – enter the bank routing number and account number from the data sheet. In a live setting, verify a voided check before entering these numbers; a single transposed digit sends the deposit to the wrong account.
Save each record and review the summary screen before moving on.
Step 4 – Run the Payroll
From the payroll center, select Run Payroll, choose the pay schedule and pay period end date, and confirm all three employees appear. QuickBooks calculates:
- Gross pay from hours worked (hourly) or salary allocation.
- Federal income tax (FIT) using the IRS withholding tables in IRS Publication 15 (Circular E).
- Social Security tax – employee share at the current rate applied to gross wages up to the annual wage base.
- Medicare tax – employee share at the current rate with no wage base cap.
- State income tax using the applicable state table.
- Health insurance deduction per the payroll item.
- Net pay = Gross pay − all taxes and deductions.
Review the paycheck preview screen carefully before clicking Submit or Create Paychecks.
Step 5 – Print or Export the Paycheck Register and Verify
Generate the Paycheck Register report for the pay period. This lists each employee, gross pay, each tax withheld, each deduction, and net pay. Export it to PDF or print it.
Now compare each employee's net pay against your hand-calculated gross-to-net worksheet (provided). The tolerance for this lab is within $1.00 of the calculated amount. Differences greater than $1.00 indicate a setup error — wrong filing status, wrong pay frequency, or a misclassified deduction. Find and correct the error before submitting.
Reference: IRS Circular E
IRS Publication 15 (Circular E), Employer's Tax Guide, is the authoritative source for federal withholding tables, deposit schedules, and employer tax rates. Always use the edition for the current tax year. Bookmark the IRS website (irs.gov) for the most current version, as rates and tables can change annually.
Good Habits to Carry into the Field
- Reconcile payroll liabilities every pay period before the deposit due date.
- Keep payroll records for at least four years per IRS guidelines.
- Never process payroll on a shared or public computer.
- If a check is voided, document it immediately in QuickBooks and notify HR.
Key terms10
Pay ScheduleA QuickBooks setting that defines how often employees are paid (e.g., weekly, bi-weekly) and the associated pay period dates; it controls which withholding tables are applied.
Payroll ItemA named earnings or deduction category in QuickBooks (such as hourly wage, salary, or health insurance deduction) that tracks compensation and liabilities in the Chart of Accounts.
Gross PayTotal employee compensation before any taxes or deductions are subtracted; the starting figure for all gross-to-net calculations.
Net PayThe amount an employee actually receives after all mandatory taxes and voluntary deductions have been subtracted from gross pay.
IRS Publication 15 (Circular E)The IRS Employer's Tax Guide that provides annual federal income tax withholding tables, FICA rates, and employer deposit rules.
Pre-tax DeductionAn employee deduction, such as a Section 125 health insurance premium, subtracted from gross pay before federal income tax and FICA are calculated, reducing the employee's taxable wages.
FICAFederal Insurance Contributions Act taxes, consisting of the Social Security tax and Medicare tax, which are withheld from employee wages and also matched by the employer.
Paycheck RegisterA QuickBooks report listing each employee's gross pay, itemized taxes withheld, deductions, and net pay for a selected pay period.
Direct DepositElectronic transfer of an employee's net pay directly into their bank account using the employer's bank routing number and the employee's account number.
W-4IRS Form Employee's Withholding Certificate, completed by the employee, that tells the employer how much federal income tax to withhold from each paycheck.
Worked examples4
1. Employee A is paid bi-weekly (26 pay periods/year) with an annual salary of $39,000. She is single with no additional withholding adjustments. Her employer offers a pre-tax health insurance deduction of $85.00 per pay period. Using hypothetical flat rates for illustration (FIT = $95.00 for this wage/filing status per the withholding table, Social Security = 6.2%, Medicare = 1.45%, no state tax), calculate her net pay for one pay period.
- Step 1 – Calculate gross pay per period: $39,000 ÷ 26 = $1,500.00.
- Step 2 – Subtract the pre-tax health insurance deduction to find taxable wages for FICA and FIT: $1,500.00 − $85.00 = $1,415.00.
- Step 3 – Calculate Social Security tax: $1,415.00 × 0.062 = $87.73.
- Step 4 – Calculate Medicare tax: $1,415.00 × 0.0145 = $20.52.
- Step 5 – Apply the FIT withholding from the table for this scenario: $95.00.
- Step 6 – Sum all deductions: $85.00 + $87.73 + $20.52 + $95.00 = $288.25.
- Step 7 – Net pay = Gross pay − total deductions: $1,500.00 − $288.25 = $1,211.75.
Answer: Net pay = $1,211.75
2. Employee B is hourly, paid weekly (52 pay periods/year), and worked 40 regular hours at $18.00/hour this week. He has a pre-tax health deduction of $42.00 per week. Using hypothetical rates (FIT = $48.00 per withholding table, Social Security = 6.2%, Medicare = 1.45%, state income tax = 3.07% of taxable wages), calculate his net pay.
- Step 1 – Gross pay: 40 hours × $18.00 = $720.00.
- Step 2 – Taxable wages after pre-tax deduction: $720.00 − $42.00 = $678.00.
- Step 3 – Social Security tax: $678.00 × 0.062 = $42.04.
- Step 4 – Medicare tax: $678.00 × 0.0145 = $9.83.
- Step 5 – State income tax: $678.00 × 0.0307 = $20.82.
- Step 6 – FIT from table: $48.00.
- Step 7 – Total deductions: $42.00 + $42.04 + $9.83 + $20.82 + $48.00 = $162.69.
- Step 8 – Net pay: $720.00 − $162.69 = $557.31.
Answer: Net pay = $557.31
3. Employee C is paid bi-weekly with a gross pay of $2,200.00. She has no pre-tax deductions and no state income tax. Her FIT withholding from the table is $210.00. Calculate her net pay using Social Security = 6.2% and Medicare = 1.45%.
- Step 1 – Gross pay: $2,200.00 (no pre-tax deductions, so taxable wages = $2,200.00).
- Step 2 – Social Security tax: $2,200.00 × 0.062 = $136.40.
- Step 3 – Medicare tax: $2,200.00 × 0.0145 = $31.90.
- Step 4 – FIT: $210.00.
- Step 5 – Total deductions: $136.40 + $31.90 + $210.00 = $378.30.
- Step 6 – Net pay: $2,200.00 − $378.30 = $1,821.70.
Answer: Net pay = $1,821.70
4. After running payroll in QuickBooks, the paycheck register shows Employee A's net pay as $1,212.50 but your hand-calculated worksheet shows $1,211.75. Is this within the $1.00 tolerance, and what should you do?
- Step 1 – Find the absolute difference: |$1,212.50 − $1,211.75| = $0.75.
- Step 2 – Compare to tolerance: $0.75 < $1.00.
- Step 3 – Conclusion: The difference is within the $1.00 rounding tolerance.
- Step 4 – Document the comparison result on the verification worksheet and note that the discrepancy is due to rounding in the withholding table calculation; no correction is required.
Answer: The $0.75 difference is within tolerance; no correction needed. Record the comparison and note rounding as the cause.
In class: Enable QuickBooks Payroll (sample/test mode) and configure pay schedules (weekly, bi-weekly); set up three payroll items (hourly wage, salary, health insurance deduction). · Enter employee records including filing status, allowances, state, and direct-deposit banking using the scenario employee data sheets. · Run a single-period payroll for all three employees; print or export the paycheck register; compare net pay for each employee against a hand-calculated gross-to-net worksheet.
Materials: QBO Payroll test mode or QuickBooks Desktop Payroll sample file, employee data scenario sheets, gross-to-net calculation worksheet, IRS Circular E (Employer's Tax Guide) reference (current edition)
Check: Paycheck register net-pay figures match hand-calculated amounts within $1.00 rounding; all three employee records complete; pass = 100% employee records complete and net pay within tolerance.
Practice check8
Answer each question, then check it. Nothing is recorded; this is your own practice.
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.