NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping  →
← All data sets
PRACTICE DATA · FREE SPREADSHEET

10,000-Row Bi-Weekly Payroll and Benefits Matrix

Fictional payroll records with gross pay, federal and state withholding, FICA, benefits, retirement deductions, and net pay for testing.

10000verified rowsJuly 29, 2026last checkedStaticrefresh schedule
#Employee IDPayroll IDPay dateGross payFederal withholdingState withholdingFICABenefitsRetirementNet payCurrencyData typeChecked
01EMP-00001PAY-0000012024-01-011800.00144.000.00137.7075.0072.001371.30USDSynthetic2026-07-29
02EMP-00002PAY-0000022024-02-021825.00182.5018.25139.6195.0073.001316.64USDSynthetic2026-07-29
03EMP-00003PAY-0000032024-03-031850.00222.0037.00141.53115.0074.001260.47USDSynthetic2026-07-29
04EMP-00004PAY-0000042024-04-041875.00262.5056.25143.44135.0075.001202.81USDSynthetic2026-07-29
05EMP-00005PAY-0000052024-05-051900.00304.0076.00145.35155.0076.001143.65USDSynthetic2026-07-29
06EMP-00006PAY-0000062024-06-061925.00154.0096.25147.2675.0077.001375.49USDSynthetic2026-07-29
07EMP-00007PAY-0000072024-07-071950.00195.000.00149.1895.0078.001432.83USDSynthetic2026-07-29
08EMP-00008PAY-0000082024-08-081975.00237.0019.75151.09115.0079.001373.16USDSynthetic2026-07-29
09EMP-00009PAY-0000092024-09-092000.00280.0040.00153.00135.0080.001312.00USDSynthetic2026-07-29
10EMP-00010PAY-0000102024-10-102025.00324.0060.75154.91155.0081.001249.34USDSynthetic2026-07-29
11EMP-00011PAY-0000112024-11-112050.00164.0082.00156.8275.0082.001490.17USDSynthetic2026-07-29
12EMP-00012PAY-0000122024-12-122075.00207.50103.75158.7495.0083.001427.01USDSynthetic2026-07-29
13EMP-00013PAY-0000132024-01-132100.00252.000.00160.65115.0084.001488.35USDSynthetic2026-07-29
14EMP-00014PAY-0000142024-02-142125.00297.5021.25162.56135.0085.001423.69USDSynthetic2026-07-29
15EMP-00015PAY-0000152024-03-152150.00344.0043.00164.47155.0086.001357.53USDSynthetic2026-07-29
16EMP-00016PAY-0000162024-04-162175.00174.0065.25166.3975.0087.001607.36USDSynthetic2026-07-29
17EMP-00017PAY-0000172024-05-172200.00220.0088.00168.3095.0088.001540.70USDSynthetic2026-07-29
18EMP-00018PAY-0000182024-06-182225.00267.00111.25170.21115.0089.001472.54USDSynthetic2026-07-29
19EMP-00019PAY-0000192024-07-192250.00315.000.00172.13135.0090.001537.88USDSynthetic2026-07-29
20EMP-00020PAY-0000202024-08-202275.00364.0022.75174.04155.0091.001468.21USDSynthetic2026-07-29
21EMP-00021PAY-0000212024-09-212300.00184.0046.00175.9575.0092.001727.05USDSynthetic2026-07-29
22EMP-00022PAY-0000222024-10-222325.00232.5069.75177.8695.0093.001656.89USDSynthetic2026-07-29
23EMP-00023PAY-0000232024-11-232350.00282.0094.00179.78115.0094.001585.22USDSynthetic2026-07-29
24EMP-00024PAY-0000242024-12-242375.00332.50118.75181.69135.0095.001512.06USDSynthetic2026-07-29
25EMP-00025PAY-0000252024-01-252400.00384.000.00183.60155.0096.001581.40USDSynthetic2026-07-29
26EMP-00026PAY-0000262024-02-262425.00194.0024.25185.5175.0097.001849.24USDSynthetic2026-07-29
27EMP-00027PAY-0000272024-03-272450.00245.0049.00187.4295.0098.001775.58USDSynthetic2026-07-29
28EMP-00028PAY-0000282024-04-282475.00297.0074.25189.34115.0099.001700.41USDSynthetic2026-07-29
29EMP-00029PAY-0000292024-05-012500.00350.00100.00191.25135.00100.001623.75USDSynthetic2026-07-29
30EMP-00030PAY-0000302024-06-022525.00404.00126.25193.16155.00101.001545.59USDSynthetic2026-07-29
31EMP-00031PAY-0000312024-07-032550.00204.000.00195.0775.00102.001973.93USDSynthetic2026-07-29
32EMP-00032PAY-0000322024-08-042575.00257.5025.75196.9995.00103.001896.76USDSynthetic2026-07-29
33EMP-00033PAY-0000332024-09-052600.00312.0052.00198.90115.00104.001818.10USDSynthetic2026-07-29
34EMP-00034PAY-0000342024-10-062625.00367.5078.75200.81135.00105.001737.94USDSynthetic2026-07-29
35EMP-00035PAY-0000352024-11-072650.00424.00106.00202.72155.00106.001656.28USDSynthetic2026-07-29
36EMP-00036PAY-0000362024-12-082675.00214.00133.75204.6475.00107.001940.61USDSynthetic2026-07-29
37EMP-00037PAY-0000372024-01-092700.00270.000.00206.5595.00108.002020.45USDSynthetic2026-07-29
38EMP-00038PAY-0000382024-02-102725.00327.0027.25208.46115.00109.001938.29USDSynthetic2026-07-29
39EMP-00039PAY-0000392024-03-112750.00385.0055.00210.38135.00110.001854.63USDSynthetic2026-07-29
40EMP-00040PAY-0000402024-04-122775.00444.0083.25212.29155.00111.001769.46USDSynthetic2026-07-29
41EMP-00041PAY-0000412024-05-132800.00224.00112.00214.2075.00112.002062.80USDSynthetic2026-07-29
42EMP-00042PAY-0000422024-06-142825.00282.50141.25216.1195.00113.001977.14USDSynthetic2026-07-29
43EMP-00043PAY-0000432024-07-152850.00342.000.00218.03115.00114.002060.97USDSynthetic2026-07-29
44EMP-00044PAY-0000442024-08-162875.00402.5028.75219.94135.00115.001973.81USDSynthetic2026-07-29
45EMP-00045PAY-0000452024-09-172900.00464.0058.00221.85155.00116.001885.15USDSynthetic2026-07-29
46EMP-00046PAY-0000462024-10-182925.00234.0087.75223.7675.00117.002187.49USDSynthetic2026-07-29
47EMP-00047PAY-0000472024-11-192950.00295.00118.00225.6795.00118.002098.32USDSynthetic2026-07-29
48EMP-00048PAY-0000482024-12-202975.00357.00148.75227.59115.00119.002007.66USDSynthetic2026-07-29
49EMP-00049PAY-0000492024-01-213000.00420.000.00229.50135.00120.002095.50USDSynthetic2026-07-29
50EMP-00050PAY-0000502024-02-223025.00484.0030.25231.41155.00121.002003.34USDSynthetic2026-07-29
51EMP-00051PAY-0000512024-03-233050.00244.0061.00233.3275.00122.002314.68USDSynthetic2026-07-29
52EMP-00052PAY-0000522024-04-243075.00307.5092.25235.2495.00123.002222.01USDSynthetic2026-07-29
53EMP-00053PAY-0000532024-05-253100.00372.00124.00237.15115.00124.002127.85USDSynthetic2026-07-29
54EMP-00054PAY-0000542024-06-263125.00437.50156.25239.06135.00125.002032.19USDSynthetic2026-07-29
55EMP-00055PAY-0000552024-07-273150.00504.000.00240.97155.00126.002124.03USDSynthetic2026-07-29
56EMP-00056PAY-0000562024-08-283175.00254.0031.75242.8975.00127.002444.36USDSynthetic2026-07-29
57EMP-00057PAY-0000572024-09-013200.00320.0064.00244.8095.00128.002348.20USDSynthetic2026-07-29
58EMP-00058PAY-0000582024-10-023225.00387.0096.75246.71115.00129.002250.54USDSynthetic2026-07-29
59EMP-00059PAY-0000592024-11-033250.00455.00130.00248.63135.00130.002151.38USDSynthetic2026-07-29
60EMP-00060PAY-0000602024-12-043275.00524.00163.75250.54155.00131.002050.71USDSynthetic2026-07-29
61EMP-00061PAY-0000612024-01-053300.00264.000.00252.4575.00132.002576.55USDSynthetic2026-07-29
62EMP-00062PAY-0000622024-02-063325.00332.5033.25254.3695.00133.002476.89USDSynthetic2026-07-29
63EMP-00063PAY-0000632024-03-073350.00402.0067.00256.27115.00134.002375.72USDSynthetic2026-07-29
64EMP-00064PAY-0000642024-04-083375.00472.50101.25258.19135.00135.002273.06USDSynthetic2026-07-29
65EMP-00065PAY-0000652024-05-093400.00544.00136.00260.10155.00136.002168.90USDSynthetic2026-07-29
66EMP-00066PAY-0000662024-06-103425.00274.00171.25262.0175.00137.002505.74USDSynthetic2026-07-29
67EMP-00067PAY-0000672024-07-113450.00345.000.00263.9395.00138.002608.07USDSynthetic2026-07-29
68EMP-00068PAY-0000682024-08-123475.00417.0034.75265.84115.00139.002503.41USDSynthetic2026-07-29
69EMP-00069PAY-0000692024-09-133500.00490.0070.00267.75135.00140.002397.25USDSynthetic2026-07-29
70EMP-00070PAY-0000702024-10-143525.00564.00105.75269.66155.00141.002289.59USDSynthetic2026-07-29
71EMP-00071PAY-0000712024-11-153550.00284.00142.00271.5775.00142.002635.43USDSynthetic2026-07-29
72EMP-00072PAY-0000722024-12-163575.00357.50178.75273.4995.00143.002527.26USDSynthetic2026-07-29
73EMP-00073PAY-0000732024-01-173600.00432.000.00275.40115.00144.002633.60USDSynthetic2026-07-29
74EMP-00074PAY-0000742024-02-183625.00507.5036.25277.31135.00145.002523.94USDSynthetic2026-07-29
75EMP-00075PAY-0000752024-03-193650.00584.0073.00279.23155.00146.002412.78USDSynthetic2026-07-29
76EMP-00076PAY-0000762024-04-203675.00294.00110.25281.1475.00147.002767.61USDSynthetic2026-07-29
77EMP-00077PAY-0000772024-05-213700.00370.00148.00283.0595.00148.002655.95USDSynthetic2026-07-29
78EMP-00078PAY-0000782024-06-223725.00447.00186.25284.96115.00149.002542.79USDSynthetic2026-07-29
79EMP-00079PAY-0000792024-07-233750.00525.000.00286.88135.00150.002653.13USDSynthetic2026-07-29
80EMP-00080PAY-0000802024-08-243775.00604.0037.75288.79155.00151.002538.46USDSynthetic2026-07-29
81EMP-00081PAY-0000812024-09-253800.00304.0076.00290.7075.00152.002902.30USDSynthetic2026-07-29
82EMP-00082PAY-0000822024-10-263825.00382.50114.75292.6195.00153.002787.14USDSynthetic2026-07-29
83EMP-00083PAY-0000832024-11-273850.00462.00154.00294.52115.00154.002670.47USDSynthetic2026-07-29
84EMP-00084PAY-0000842024-12-283875.00542.50193.75296.44135.00155.002552.31USDSynthetic2026-07-29
85EMP-00085PAY-0000852024-01-013900.00624.000.00298.35155.00156.002666.65USDSynthetic2026-07-29
86EMP-00086PAY-0000862024-02-023925.00314.0039.25300.2675.00157.003039.49USDSynthetic2026-07-29
87EMP-00087PAY-0000872024-03-033950.00395.0079.00302.1895.00158.002920.82USDSynthetic2026-07-29
88EMP-00088PAY-0000882024-04-043975.00477.00119.25304.09115.00159.002800.66USDSynthetic2026-07-29
89EMP-00089PAY-0000892024-05-054000.00560.00160.00306.00135.00160.002679.00USDSynthetic2026-07-29
90EMP-00090PAY-0000902024-06-064025.00644.00201.25307.91155.00161.002555.84USDSynthetic2026-07-29
91EMP-00091PAY-0000912024-07-074050.00324.000.00309.8275.00162.003179.18USDSynthetic2026-07-29
92EMP-00092PAY-0000922024-08-084075.00407.5040.75311.7495.00163.003057.01USDSynthetic2026-07-29
93EMP-00093PAY-0000932024-09-094100.00492.0082.00313.65115.00164.002933.35USDSynthetic2026-07-29
94EMP-00094PAY-0000942024-10-104125.00577.50123.75315.56135.00165.002808.19USDSynthetic2026-07-29
95EMP-00095PAY-0000952024-11-114150.00664.00166.00317.47155.00166.002681.53USDSynthetic2026-07-29
96EMP-00096PAY-0000962024-12-124175.00334.00208.75319.3975.00167.003070.86USDSynthetic2026-07-29
97EMP-00097PAY-0000972024-01-134200.00420.000.00321.3095.00168.003195.70USDSynthetic2026-07-29
98EMP-00098PAY-0000982024-02-144225.00507.0042.25323.21115.00169.003068.54USDSynthetic2026-07-29
99EMP-00099PAY-0000992024-03-154250.00595.0085.00325.13135.00170.002939.88USDSynthetic2026-07-29
100EMP-00100PAY-0001002024-04-164275.00684.00128.25327.04155.00171.002809.71USDSynthetic2026-07-29
SOURCE STANDARD

What counts as verified?

Deterministically generated fictional records; contains no real employees, tax IDs, bank accounts, or employers. Third-party list posts can help discover candidates, but they do not qualify as the final source for a retained row.

USE IT IN GOOGLE SHEETS

Paste without cleanup

Choose Copy to spreadsheet, select cell A1 in Google Sheets, and paste. Column headers and filtered rows are included automatically.