🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Business & Cross-Cutting › Bookkeeping / Office Administration › Payroll: Calculation, Compliance, and Processing › Lesson 9
BUS-BOOK55-03 · Lesson 9 · 20.5 clock hours · lab

Processing Payroll in QuickBooks: Setup, Runs, and Reports

Objective. Students will set up a company payroll file in QuickBooks, enter employee records and W-4 data, run a complete payroll cycle, generate required payroll reports, and record payroll transactions in the QuickBooks register.

⚠ 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.

Processing Payroll in QuickBooks: Setup, Runs, and Reports

QuickBooks is one of the most widely used payroll platforms in small and mid-sized businesses. Knowing how to configure it correctly, run a payroll cycle, and produce accurate reports is a core competency tested by the QuickBooks Certified User credential and valued by employers across every industry. This lesson walks you through the full workflow: company setup, employee records, running payroll, and generating the reports that support tax compliance.

Setting Up the Company Payroll File

Before you can pay a single employee, QuickBooks must know your company's identity and tax obligations. The setup wizard (Desktop: Payroll Setup; Online: Payroll Settings) collects the following:

Accuracy at setup prevents cascading errors. A wrong deposit schedule will misdate every tax liability reminder QuickBooks generates.

Entering Employee Records

Each employee record stores two categories of data: personal/identity data and payroll data.

Personal/identity data includes legal name, address, Social Security Number, and hire date. Handle SSNs carefully — limit screen visibility and never read them aloud in a shared workspace.

Payroll data comes directly from documents the employee has submitted:

After entering all eight employees, run the instructor setup checklist before proceeding. A single transposed digit in a pay rate or a wrong W-4 filing status will cause every payroll calculation to be off.

Running a Bi-Weekly Payroll Cycle

With setup complete, navigate to Pay Employees (Desktop) or Run Payroll (Online) and select the correct pay period end date and check date.

1. Enter hours for hourly employees. Double-check regular versus overtime hours — federal law (FLSA) requires overtime at 1.5× the regular rate for hours over 40 in a workweek.

2. Approve salary amounts for salaried employees. QuickBooks pre-populates these; confirm no manual adjustments are needed.

3. Review the payroll preview. Before finalizing, inspect each employee's gross pay, federal and state income tax withheld, Social Security (6.2% of taxable wages up to the annual wage base), Medicare (1.45%), and all voluntary deductions. If a withholding amount looks wrong, stop and trace it to the W-4 entry or deduction setup rather than overriding it manually without documented justification.

4. Submit/finalize the run. QuickBooks records journal entries automatically: a debit to Payroll Expense accounts and credits to Payroll Liabilities (taxes owed) and Cash or Checking (net pay).

5. Print or export pay stubs for distribution. Pay stubs show gross pay, each deduction, and net pay — employees rely on these to verify their pay and for loan applications.

Generating and Interpreting Payroll Reports

Two reports are essential after every run:

Run both reports immediately after the payroll cycle closes. Compare the Payroll Summary against your manual payroll register (from Lesson 6). Differences may arise from rounding, overtime miscalculation, or a data-entry error in employee setup. Document every difference in a reconciliation note that states the source of each variance and how it was corrected.

Data Security and Accuracy Obligations

Payroll files contain sensitive personally identifiable information (PII). Follow your organization's data security policy: lock your workstation when stepping away, do not share login credentials, and never print payroll reports to shared or unsecured printers. Under federal and state law, employers must retain payroll records for specified periods — consult current IRS guidance for exact retention requirements.

Accuracy is a professional and legal obligation. Errors in withholding can result in IRS penalties to the employer and unexpected tax bills for employees. The bookkeeper's role is to be the last line of defense before funds leave the account.

Key terms9

Employer Identification Number (EIN)A nine-digit number assigned by the IRS that identifies a business entity for federal tax purposes; required in QuickBooks payroll setup before any payroll can be processed.
W-4 (Employee's Withholding Certificate)The IRS form employees complete to declare their filing status and any additional federal income tax withholding; the bookkeeper enters these elections exactly as written into each employee's QuickBooks record.
Pay ScheduleThe frequency at which employees receive paychecks (e.g., weekly, bi-weekly, semi-monthly, monthly); a bi-weekly schedule results in 26 pay periods per year and must be configured in QuickBooks before running payroll.
Tax Deposit ScheduleThe IRS-assigned timetable (monthly or semi-weekly) that tells an employer when payroll taxes must be deposited; QuickBooks uses this setting to calculate liability due dates automatically.
Payroll Summary ReportA QuickBooks report that lists each employee's gross wages, individual deductions, taxes withheld, and net pay for a selected period; the primary document used to reconcile QuickBooks payroll against a manual payroll register.
Payroll Tax Liability ReportA QuickBooks report showing the total tax amounts owed to each taxing authority and their due dates; used to ensure timely deposits and avoid IRS penalties.
Pre-Tax DeductionA voluntary deduction such as a traditional 401(k) contribution or health insurance premium that reduces the employee's gross wages before federal income tax and, in some cases, FICA taxes are calculated.
Payroll LiabilityAmounts withheld from employee paychecks or owed by the employer (e.g., employee and employer FICA, federal and state income tax withheld) that have not yet been remitted to the appropriate agency; recorded as a credit in QuickBooks until paid.
Reconciliation NoteA written document that identifies and explains each difference found when comparing two payroll records (e.g., QuickBooks Payroll Summary vs. manual payroll register), including the source of the variance and the corrective action taken.

Worked examples4

1. An hourly employee earns $18.00/hour and worked 44 hours during a bi-weekly pay period (all in one workweek of 44 hours, 0 in the other). Calculate gross pay.
  1. Step 1 – Identify regular hours: The FLSA overtime threshold is 40 hours per workweek. Regular hours = 40.
  2. Step 2 – Identify overtime hours: 44 − 40 = 4 overtime hours.
  3. Step 3 – Calculate regular pay: 40 hours × $18.00 = $720.00.
  4. Step 4 – Calculate overtime rate: $18.00 × 1.5 = $27.00 per overtime hour.
  5. Step 5 – Calculate overtime pay: 4 hours × $27.00 = $108.00.
  6. Step 6 – Calculate gross pay: $720.00 + $108.00 = $828.00.
Answer: Gross pay = $828.00. Enter 40 regular hours and 4 overtime hours in QuickBooks; the software calculates both lines if the overtime pay item is configured correctly.
2. A salaried employee earns $52,000 per year and is paid bi-weekly. What is the gross pay per paycheck, and what is the employee share of Social Security tax withheld from that paycheck (use the 6.2% rate)?
  1. Step 1 – Calculate gross pay per period: $52,000 ÷ 26 pay periods = $2,000.00.
  2. Step 2 – Calculate employee Social Security withholding: $2,000.00 × 0.062 = $124.00.
Answer: Gross pay per paycheck = $2,000.00; Social Security withheld = $124.00. QuickBooks applies these calculations automatically once the annual salary and pay schedule are entered correctly.
3. An employee has a gross pay of $1,600.00 for the period. She has a pre-tax health insurance deduction of $75.00 and contributes $60.00 to a traditional (pre-tax) 401(k). What is her federal taxable wage for income tax withholding purposes?
  1. Step 1 – Identify pre-tax deductions that reduce federal taxable wages: health insurance $75.00 (Section 125 cafeteria plan, pre-tax) and traditional 401(k) $60.00 (pre-tax).
  2. Step 2 – Total pre-tax reductions: $75.00 + $60.00 = $135.00.
  3. Step 3 – Calculate federal taxable wage: $1,600.00 − $135.00 = $1,465.00.
Answer: Federal taxable wages = $1,465.00. In QuickBooks, when deductions are marked as pre-tax, the software automatically reduces the taxable wage base before calculating federal income tax withholding.
4. After running payroll, the QuickBooks Payroll Summary shows total net pay of $14,823.47. Your manual payroll register shows $14,822.51. The difference is $0.96. Identify whether this passes the lab's reconciliation standard and describe what to do next.
  1. Step 1 – Calculate the total difference: $14,823.47 − $14,822.51 = $0.96.
  2. Step 2 – Check against the lab standard: the lab requires net pay for all eight employees to match within $1.00 total.
  3. Step 3 – $0.96 < $1.00, so the totals are within tolerance for the lab pass standard.
  4. Step 4 – However, a difference still exists. Investigate employee by employee to locate the source: compare each employee's individual net pay line in QuickBooks against the manual register.
  5. Step 5 – Document the variance in the reconciliation note: state the amount, which employee(s) it relates to, the likely cause (e.g., rounding in manual calculation), and whether a correction is needed.
Answer: The $0.96 difference is within the $1.00 lab tolerance, so it meets the pass threshold. You must still document the variance in a reconciliation note and trace it to a specific employee line to confirm it is rounding rather than a systematic setup error.
In class: Set up a new payroll file in QuickBooks (Desktop or Online) for a fictional company with eight employees: enter company EIN, pay schedule, tax deposit schedule, and each employee's personal data, pay rate, W-4 elections, and voluntary deductions; verify setup against an instructor checklist. · Process a full bi-weekly payroll run for all eight employees, entering hours for hourly workers, approving salary amounts, reviewing the payroll preview for withholding accuracy, and completing the run; print or export pay stubs and the payroll summary report. · Generate the QuickBooks payroll liability report and payroll tax liability report, reconcile them against the manual payroll register from Lesson 6 using the same data set, and document any differences in a written reconciliation note.
Materials: Computers with QuickBooks Desktop or QuickBooks Online access, QuickBooks Payroll subscription (school license), employee setup data packet matching prior lessons, payroll register from Lesson 6, QuickBooks Payroll user guide
Check: QuickBooks payroll summary report compared against manual register; net pay for all eight employees must match within $1.00 and all payroll liability balances must reconcile. Pass = 90% of figures match, instructor signs off on setup checklist.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

QuickBooks Certified User – Payroll Setup
1. When setting up a new company payroll file in QuickBooks, which number is required to identify the business to the IRS?
AIPB Certified Bookkeeper – Payroll Fundamentals
2. A bi-weekly payroll schedule produces how many pay periods per year?
AIPB Certified Bookkeeper – Payroll Compliance
3. An employee's W-4 shows she is Married Filing Jointly with no additional withholding. The bookkeeper disagrees with her election and changes the filing status to Single to withhold more tax. This action is:
AIPB Certified Bookkeeper – Payroll Compliance
4. An hourly employee worked 42 hours in a single workweek. Under the FLSA, how many of those hours must be paid at the overtime rate of at least 1.5× the regular rate?
QuickBooks Certified User – Payroll Setup
5. In QuickBooks, when a traditional (pre-tax) 401(k) employee contribution is set up correctly, it will:
QuickBooks Certified User – Payroll Reports
6. After running payroll in QuickBooks, which report would you use to find the total amounts owed to the IRS and state tax agencies and their due dates?
AIPB Certified Bookkeeper – Payroll Recordkeeping
7. You are reconciling your QuickBooks Payroll Summary against your manual payroll register and find a $2.50 difference in one employee's net pay. The lab standard requires a match within $1.00 per employee. What is the correct next step?
Microsoft Office Specialist – Data Security and Professional Practices
8. Which of the following best describes a data security best practice when working with QuickBooks payroll records containing employee Social Security Numbers?
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.
← Previous lessonProgram planNext lesson →