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

10,000-Row Synthetic General Ledger

A dense, fictional general ledger with balanced debit and credit fields, account numbers, departments, projects, and tracking IDs for spreadsheet and AI testing.

10000verified rowsJuly 29, 2026last checkedStaticrefresh schedule
#Transaction IDDateAccount numberDescriptionDebitCreditDepartmentProjectData typeChecked
01GL-0000012024-01-011100Synthetic transaction 15.000.00DEPT-1PROJECT-1Synthetic2026-07-29
02GL-0000022024-02-021200Synthetic transaction 20.005.37DEPT-2PROJECT-2Synthetic2026-07-29
03GL-0000032024-03-032000Synthetic transaction 35.740.00DEPT-3PROJECT-3Synthetic2026-07-29
04GL-0000042024-04-044000Synthetic transaction 40.006.11DEPT-4PROJECT-4Synthetic2026-07-29
05GL-0000052024-05-054100Synthetic transaction 56.480.00DEPT-5PROJECT-5Synthetic2026-07-29
06GL-0000062024-06-065000Synthetic transaction 60.006.85DEPT-6PROJECT-6Synthetic2026-07-29
07GL-0000072024-07-076100Synthetic transaction 77.220.00DEPT-7PROJECT-7Synthetic2026-07-29
08GL-0000082024-08-086200Synthetic transaction 80.007.59DEPT-8PROJECT-8Synthetic2026-07-29
09GL-0000092024-09-097000Synthetic transaction 97.960.00DEPT-9PROJECT-9Synthetic2026-07-29
10GL-0000102024-10-101100Synthetic transaction 100.008.33DEPT-10PROJECT-10Synthetic2026-07-29
11GL-0000112024-11-111200Synthetic transaction 118.700.00DEPT-11PROJECT-11Synthetic2026-07-29
12GL-0000122024-12-122000Synthetic transaction 120.009.07DEPT-12PROJECT-12Synthetic2026-07-29
13GL-0000132024-01-134000Synthetic transaction 139.440.00DEPT-1PROJECT-13Synthetic2026-07-29
14GL-0000142024-02-144100Synthetic transaction 140.009.81DEPT-2PROJECT-14Synthetic2026-07-29
15GL-0000152024-03-155000Synthetic transaction 1510.180.00DEPT-3PROJECT-15Synthetic2026-07-29
16GL-0000162024-04-166100Synthetic transaction 160.0010.55DEPT-4PROJECT-16Synthetic2026-07-29
17GL-0000172024-05-176200Synthetic transaction 1710.920.00DEPT-5PROJECT-17Synthetic2026-07-29
18GL-0000182024-06-187000Synthetic transaction 180.0011.29DEPT-6PROJECT-18Synthetic2026-07-29
19GL-0000192024-07-191100Synthetic transaction 1911.660.00DEPT-7PROJECT-19Synthetic2026-07-29
20GL-0000202024-08-201200Synthetic transaction 200.0012.03DEPT-8PROJECT-20Synthetic2026-07-29
21GL-0000212024-09-212000Synthetic transaction 2112.400.00DEPT-9PROJECT-21Synthetic2026-07-29
22GL-0000222024-10-224000Synthetic transaction 220.0012.77DEPT-10PROJECT-22Synthetic2026-07-29
23GL-0000232024-11-234100Synthetic transaction 2313.140.00DEPT-11PROJECT-23Synthetic2026-07-29
24GL-0000242024-12-245000Synthetic transaction 240.0013.51DEPT-12PROJECT-24Synthetic2026-07-29
25GL-0000252024-01-256100Synthetic transaction 2513.880.00DEPT-1PROJECT-25Synthetic2026-07-29
26GL-0000262024-02-266200Synthetic transaction 260.0014.25DEPT-2PROJECT-26Synthetic2026-07-29
27GL-0000272024-03-277000Synthetic transaction 2714.620.00DEPT-3PROJECT-27Synthetic2026-07-29
28GL-0000282024-04-281100Synthetic transaction 280.0014.99DEPT-4PROJECT-28Synthetic2026-07-29
29GL-0000292024-05-011200Synthetic transaction 2915.360.00DEPT-5PROJECT-29Synthetic2026-07-29
30GL-0000302024-06-022000Synthetic transaction 300.0015.73DEPT-6PROJECT-30Synthetic2026-07-29
31GL-0000312024-07-034000Synthetic transaction 3116.100.00DEPT-7PROJECT-31Synthetic2026-07-29
32GL-0000322024-08-044100Synthetic transaction 320.0016.47DEPT-8PROJECT-32Synthetic2026-07-29
33GL-0000332024-09-055000Synthetic transaction 3316.840.00DEPT-9PROJECT-33Synthetic2026-07-29
34GL-0000342024-10-066100Synthetic transaction 340.0017.21DEPT-10PROJECT-34Synthetic2026-07-29
35GL-0000352024-11-076200Synthetic transaction 3517.580.00DEPT-11PROJECT-35Synthetic2026-07-29
36GL-0000362024-12-087000Synthetic transaction 360.0017.95DEPT-12PROJECT-36Synthetic2026-07-29
37GL-0000372024-01-091100Synthetic transaction 3718.320.00DEPT-1PROJECT-37Synthetic2026-07-29
38GL-0000382024-02-101200Synthetic transaction 380.0018.69DEPT-2PROJECT-38Synthetic2026-07-29
39GL-0000392024-03-112000Synthetic transaction 3919.060.00DEPT-3PROJECT-39Synthetic2026-07-29
40GL-0000402024-04-124000Synthetic transaction 400.0019.43DEPT-4PROJECT-40Synthetic2026-07-29
41GL-0000412024-05-134100Synthetic transaction 4119.800.00DEPT-5PROJECT-1Synthetic2026-07-29
42GL-0000422024-06-145000Synthetic transaction 420.0020.17DEPT-6PROJECT-2Synthetic2026-07-29
43GL-0000432024-07-156100Synthetic transaction 4320.540.00DEPT-7PROJECT-3Synthetic2026-07-29
44GL-0000442024-08-166200Synthetic transaction 440.0020.91DEPT-8PROJECT-4Synthetic2026-07-29
45GL-0000452024-09-177000Synthetic transaction 4521.280.00DEPT-9PROJECT-5Synthetic2026-07-29
46GL-0000462024-10-181100Synthetic transaction 460.0021.65DEPT-10PROJECT-6Synthetic2026-07-29
47GL-0000472024-11-191200Synthetic transaction 4722.020.00DEPT-11PROJECT-7Synthetic2026-07-29
48GL-0000482024-12-202000Synthetic transaction 480.0022.39DEPT-12PROJECT-8Synthetic2026-07-29
49GL-0000492024-01-214000Synthetic transaction 4922.760.00DEPT-1PROJECT-9Synthetic2026-07-29
50GL-0000502024-02-224100Synthetic transaction 500.0023.13DEPT-2PROJECT-10Synthetic2026-07-29
51GL-0000512024-03-235000Synthetic transaction 5123.500.00DEPT-3PROJECT-11Synthetic2026-07-29
52GL-0000522024-04-246100Synthetic transaction 520.0023.87DEPT-4PROJECT-12Synthetic2026-07-29
53GL-0000532024-05-256200Synthetic transaction 5324.240.00DEPT-5PROJECT-13Synthetic2026-07-29
54GL-0000542024-06-267000Synthetic transaction 540.0024.61DEPT-6PROJECT-14Synthetic2026-07-29
55GL-0000552024-07-271100Synthetic transaction 5524.980.00DEPT-7PROJECT-15Synthetic2026-07-29
56GL-0000562024-08-281200Synthetic transaction 560.0025.35DEPT-8PROJECT-16Synthetic2026-07-29
57GL-0000572024-09-012000Synthetic transaction 5725.720.00DEPT-9PROJECT-17Synthetic2026-07-29
58GL-0000582024-10-024000Synthetic transaction 580.0026.09DEPT-10PROJECT-18Synthetic2026-07-29
59GL-0000592024-11-034100Synthetic transaction 5926.460.00DEPT-11PROJECT-19Synthetic2026-07-29
60GL-0000602024-12-045000Synthetic transaction 600.0026.83DEPT-12PROJECT-20Synthetic2026-07-29
61GL-0000612024-01-056100Synthetic transaction 6127.200.00DEPT-1PROJECT-21Synthetic2026-07-29
62GL-0000622024-02-066200Synthetic transaction 620.0027.57DEPT-2PROJECT-22Synthetic2026-07-29
63GL-0000632024-03-077000Synthetic transaction 6327.940.00DEPT-3PROJECT-23Synthetic2026-07-29
64GL-0000642024-04-081100Synthetic transaction 640.0028.31DEPT-4PROJECT-24Synthetic2026-07-29
65GL-0000652024-05-091200Synthetic transaction 6528.680.00DEPT-5PROJECT-25Synthetic2026-07-29
66GL-0000662024-06-102000Synthetic transaction 660.0029.05DEPT-6PROJECT-26Synthetic2026-07-29
67GL-0000672024-07-114000Synthetic transaction 6729.420.00DEPT-7PROJECT-27Synthetic2026-07-29
68GL-0000682024-08-124100Synthetic transaction 680.0029.79DEPT-8PROJECT-28Synthetic2026-07-29
69GL-0000692024-09-135000Synthetic transaction 6930.160.00DEPT-9PROJECT-29Synthetic2026-07-29
70GL-0000702024-10-146100Synthetic transaction 700.0030.53DEPT-10PROJECT-30Synthetic2026-07-29
71GL-0000712024-11-156200Synthetic transaction 7130.900.00DEPT-11PROJECT-31Synthetic2026-07-29
72GL-0000722024-12-167000Synthetic transaction 720.0031.27DEPT-12PROJECT-32Synthetic2026-07-29
73GL-0000732024-01-171100Synthetic transaction 7331.640.00DEPT-1PROJECT-33Synthetic2026-07-29
74GL-0000742024-02-181200Synthetic transaction 740.0032.01DEPT-2PROJECT-34Synthetic2026-07-29
75GL-0000752024-03-192000Synthetic transaction 7532.380.00DEPT-3PROJECT-35Synthetic2026-07-29
76GL-0000762024-04-204000Synthetic transaction 760.0032.75DEPT-4PROJECT-36Synthetic2026-07-29
77GL-0000772024-05-214100Synthetic transaction 7733.120.00DEPT-5PROJECT-37Synthetic2026-07-29
78GL-0000782024-06-225000Synthetic transaction 780.0033.49DEPT-6PROJECT-38Synthetic2026-07-29
79GL-0000792024-07-236100Synthetic transaction 7933.860.00DEPT-7PROJECT-39Synthetic2026-07-29
80GL-0000802024-08-246200Synthetic transaction 800.0034.23DEPT-8PROJECT-40Synthetic2026-07-29
81GL-0000812024-09-257000Synthetic transaction 8134.600.00DEPT-9PROJECT-1Synthetic2026-07-29
82GL-0000822024-10-261100Synthetic transaction 820.0034.97DEPT-10PROJECT-2Synthetic2026-07-29
83GL-0000832024-11-271200Synthetic transaction 8335.340.00DEPT-11PROJECT-3Synthetic2026-07-29
84GL-0000842024-12-282000Synthetic transaction 840.0035.71DEPT-12PROJECT-4Synthetic2026-07-29
85GL-0000852024-01-014000Synthetic transaction 8536.080.00DEPT-1PROJECT-5Synthetic2026-07-29
86GL-0000862024-02-024100Synthetic transaction 860.0036.45DEPT-2PROJECT-6Synthetic2026-07-29
87GL-0000872024-03-035000Synthetic transaction 8736.820.00DEPT-3PROJECT-7Synthetic2026-07-29
88GL-0000882024-04-046100Synthetic transaction 880.0037.19DEPT-4PROJECT-8Synthetic2026-07-29
89GL-0000892024-05-056200Synthetic transaction 8937.560.00DEPT-5PROJECT-9Synthetic2026-07-29
90GL-0000902024-06-067000Synthetic transaction 900.0037.93DEPT-6PROJECT-10Synthetic2026-07-29
91GL-0000912024-07-071100Synthetic transaction 9138.300.00DEPT-7PROJECT-11Synthetic2026-07-29
92GL-0000922024-08-081200Synthetic transaction 920.0038.67DEPT-8PROJECT-12Synthetic2026-07-29
93GL-0000932024-09-092000Synthetic transaction 9339.040.00DEPT-9PROJECT-13Synthetic2026-07-29
94GL-0000942024-10-104000Synthetic transaction 940.0039.41DEPT-10PROJECT-14Synthetic2026-07-29
95GL-0000952024-11-114100Synthetic transaction 9539.780.00DEPT-11PROJECT-15Synthetic2026-07-29
96GL-0000962024-12-125000Synthetic transaction 960.0040.15DEPT-12PROJECT-16Synthetic2026-07-29
97GL-0000972024-01-136100Synthetic transaction 9740.520.00DEPT-1PROJECT-17Synthetic2026-07-29
98GL-0000982024-02-146200Synthetic transaction 980.0040.89DEPT-2PROJECT-18Synthetic2026-07-29
99GL-0000992024-03-157000Synthetic transaction 9941.260.00DEPT-3PROJECT-19Synthetic2026-07-29
100GL-0001002024-04-161100Synthetic transaction 1000.0041.63DEPT-4PROJECT-20Synthetic2026-07-29
SOURCE STANDARD

What counts as verified?

Deterministically generated fictional records; contains no real people, companies, or financial accounts. 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.