Chapters0/35 ▾
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 →