Quibank app: now on the App Store — free, works offline. Get the app ↗

Chapters0/35 ▾
  1. 1.Worker Status & New-Hire Forms0/5
    1. Employee or independent contractor: the common-law test
    2. Statutory employees and the cost of misclassification
    3. Who is the employer: agencies, PEOs, agents and joint employers
    4. Form W-4 for employees, Form W-9 for contractors
    5. Form I-9, new-hire reporting and protecting employee data
  2. 2.Employment Taxes & Taxable Pay0/5
    1. Social security, Medicare and the Additional Medicare Tax
    2. FUTA and how wage bases follow the employer
    3. Cafeteria plans, 401(k) deferrals and Roth contributions
    4. Fringe benefits and special payments
    5. Withholding on bonuses and other supplemental wages
  3. 3.Calculating the Paycheck0/5
    1. The gross-to-net order
    2. Creditor garnishments and disposable earnings
    3. Child support, tax levies, student loans and priority
    4. Voluntary deductions, the minimum wage floor and tipped pay
    5. Draws, overpayments and gross-ups
  4. 4.Deposits, Returns & Year-End0/5
    1. The lookback period and depositor status
    2. Monthly and semiweekly deposit deadlines
    3. The $100,000 next-day rule, the $2,500 rule and how to pay
    4. FUTA deposits and the annual Form 940
    5. Quarterly returns, Forms W-2 and corrections
  5. 5.Compliance & Recordkeeping0/5
    1. How long to keep payroll records
    2. Form I-9 retention and inspections
    3. Unclaimed wages and escheat
    4. Penalties for late deposits, late returns and bad Forms W-2
    5. Which agency runs which rule, and how to weigh guidance
  6. 6.Audits, Controls & Reconciliation0/5
    1. Internal control and segregation of duties
    2. Preventive, detective and corrective controls
    3. Reconciliations that prove the payroll
    4. Recording payroll: expenses and liabilities
    5. Accruals, reversing entries and agency examinations
  7. 7.Payroll Systems & Administration0/5
    1. The master file and effective-dated changes
    2. The payroll processing cycle and interfaces
    3. New systems, conversions and direct deposit
    4. Business continuity and disaster recovery
    5. Policies, procedures, service agreements and employee service
Saved in this browser. Move it to another device →
← Payroll Systems & Administration

Chapter 7 · Lesson 1 of 5

The master file and effective-dated changes

1 min read

Payroll systems hold two kinds of data. Master file data is standing information the system reads every cycle: pay rate, pay frequency, tax setup, recurring voluntary deductions, direct deposit accounts, and year-to-date wage and tax accumulators.

Transaction data is entered for one period and used once, such as the hours on this period's time sheet or a one-time bonus. Exam items often list four fields and ask which is not part of the master file; the one-period item is the answer.

Because the master file drives every calculation, changes to it are the highest-risk input. The best protection against a ghost employee is to separate the authority to approve master file changes from control over pay distribution; putting all update rights in one administrator raises the risk.

A corrupted year-to-date accumulator is serious because those totals feed the wage-base tests each cycle and the figures on Form 941 and Form W-2, so the error spreads far beyond one paycheck.

Master file changes are effective-dated: each hour is paid at the rate in force on the day it was worked. Example: a raise from $20 to $22 an hour takes effect halfway through an 80-hour period.

Pay 40 hours x $20 = $800 plus 40 hours x $22 = $880, for $1,680. Paying all 80 hours at either rate is wrong.

Check yourself

1. A clerk overwrites an employee's year-to-date taxable wage accumulator with an incorrect figure. What is the MOST significant consequence?

2. All of the following are components of the employee payroll master file EXCEPT:

Facts checked 2026-11-15 · Sources: PayrollOrg: Fundamental Payroll Certification (FPC), NIST SP 800-34 Rev. 1, Contingency Planning Guide for Federal Information Systems, IRS Publication 15 (Circular E), Employer's Tax Guide (2026)

FPC Payroll Certification cheat sheet: every key fact on one page →