SynthGL - Book1
B2
fx=SYNTHGL("saas", seed:=42, months:=6, exports:={"netsuite","qbo_iif","strongbox_excel"})
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
SynthGL
Synthetic accounting test data for fintech engineering teams.
Deterministic synthetic GL, financials, and ERP exports that pass import validation.
The problem
Teams hand-roll accounting mock data to build integrations (QuickBooks, NetSuite, Xero). It doesn’t follow real accounting rules, so bugs only show up in production when customers connect real books.
The solution
Define a scenario, pick a seed, and generate a complete bundle of journals, trial balances, and financial statements. Same seed always produces identical output, bit for bit.
How it works
1. Generate business events (contracts, invoices, payments, payroll, accruals).
2. Compile posting policies (YAML DSL) and execute them into balanced journal entries.
3. Export bundles in real ERP shapes and validate invariants (double-entry, schedule tie-outs, roll-forward checks).
Built by someone who lived the pain
Background in PwC Deals and financial due diligence. Started building SynthGL to test accounting pipelines without touching confidential client data. Now: a working engine with export fidelity, determinism, and explain traces.
ReadySheet: Overview