Alder Books Reconciliation: General ledger in the European CSV dialect
General ledger in the European CSV dialect for Alder Books Reconciliation. The same 66 ledger lines with a semicolon delimiter, decimal commas, dot thousands separators and dd/mm/yyyy posting dates. This is the shape a ledger export from a European accounting package arrives in.
entry_id;document_id;posting_date;journal;account_code;description;debit;credit;reference
GL-0001;OPEN-2026-08;01/08/2026;GEN;1000;Opening cash balance;5.000,00;0,00;opening
GL-0002;OPEN-2026-08;01/08/2026;GEN;3000;Opening balance equity;0,00;5.000,00;opening
GL-0003;SI-AR-01;02/07/2026;SAL;1100;Invoice to Fictional client 1;750,00;0,00;AR-01
GL-0004;SI-AR-01;02/07/2026;SAL;4000;Service revenue, Fictional client 1;0,00;750,00;AR-01
GL-0005;SI-AR-02;05/07/2026;SAL;1100;Invoice to Fictional client 2;825,00;0,00;AR-02
GL-0006;SI-AR-02;05/07/2026;SAL;4000;Service revenue, Fictional client 2;0,00;825,00;AR-02
GL-0007;SI-AR-03;08/07/2026;SAL;1100;Invoice to Fictional client 3;900,00;0,00;AR-03
GL-0008;SI-AR-03;08/07/2026;SAL;4000;Service revenue, Fictional client 3;0,00;900,00;AR-03
GL-0009;SI-AR-04;11/07/2026;SAL;1100;Invoice to Fictional client 4;975,00;0,00;AR-04
GL-0010;SI-AR-04;11/07/2026;SAL;4000;Service revenue, Fictional client 4;0,00;975,00;AR-04
GL-0011;SI-AR-05;14/07/2026;SAL;1100;Invoice to Fictional client 5;1.050,00;0,00;AR-05
GL-0012;SI-AR-05;14/07/2026;SAL;4000;Service revenue, Fictional client 5;0,00;1.050,00;AR-05
GL-0013;SI-AR-06;17/07/2026;SAL;1100;Invoice to Fictional client 6;1.125,00;0,00;AR-06
GL-0014;SI-AR-06;17/07/2026;SAL;4000;Service revenue, Fictional client 6;0,00;1.125,00;AR-06
GL-0015;SI-AR-07;20/07/2026;SAL;1100;Invoice to Fictional client 7;1.200,00;0,00;AR-07
GL-0016;SI-AR-07;20/07/2026;SAL;4000;Service revenue, Fictional client 7;0,00;1.200,00;AR-07
GL-0017;SI-AR-08;23/07/2026;SAL;1100;Invoice to Fictional client 8;1.275,00;0,00;AR-08
GL-0018;SI-AR-08;23/07/2026;SAL;4000;Service revenue, Fictional client 8;0,00;1.275,00;AR-08
GL-0019;RC-AR-01;01/08/2026;CSH;1000;Receipt from Fictional client 1;650,00;0,00;TXN-001
GL-0020;RC-AR-01;01/08/2026;CSH;1100;Receipt from Fictional client 1;0,00;650,00;TXN-001
GL-0021;RC-AR-02;04/08/2026;CSH;1000;Receipt from Fictional client 2;725,00;0,00;TXN-004
GL-0022;RC-AR-02;04/08/2026;CSH;1100;Receipt from Fictional client 2;0,00;725,00;TXN-004
GL-0023;RC-AR-03;07/08/2026;CSH;1000;Receipt from Fictional client 3;800,00;0,00;TXN-007
GL-0024;RC-AR-03;07/08/2026;CSH;1100;Receipt from Fictional client 3;0,00;800,00;TXN-007
GL-0025;RC-AR-04;10/08/2026;CSH;1000;Receipt from Fictional client 4;875,00;0,00;TXN-010
GL-0026;RC-AR-04;10/08/2026;CSH;1100;Receipt from Fictional client 4;0,00;875,00;TXN-010
GL-0027;RC-AR-05;13/08/2026;CSH;1000;Receipt from Fictional client 5;950,00;0,00;TXN-013
GL-0028;RC-AR-05;13/08/2026;CSH;1100;Receipt from Fictional client 5;0,00;950,00;TXN-013
GL-0029;RC-AR-06;16/08/2026;CSH;1000;Receipt from Fictional client 6;1.025,00;0,00;TXN-016
GL-0030;RC-AR-06;16/08/2026;CSH;1100;Receipt from Fictional client 6;0,00;1.025,00;TXN-016
GL-0031;RC-AR-07;19/08/2026;CSH;1000;Receipt from Fictional client 7;1.100,00;0,00;TXN-019
GL-0032;RC-AR-07;19/08/2026;CSH;1100;Receipt from Fictional client 7;0,00;1.100,00;TXN-019
GL-0033;RC-AR-08;22/08/2026;CSH;1000;Receipt from Fictional client 8;1.175,00;0,00;TXN-022
GL-0034;RC-AR-08;22/08/2026;CSH;1100;Receipt from Fictional client 8;0,00;1.175,00;TXN-022
GL-0035;PV-EXP-01;02/08/2026;PUR;5000;Facilities expense;52,00;0,00;TXN-002
GL-0036;PV-EXP-01;02/08/2026;PUR;1000;Facilities expense;0,00;52,00;TXN-002
GL-0037;PV-EXP-02;03/08/2026;PUR;5100;Supplies expense;59,00;0,00;TXN-003
GL-0038;PV-EXP-02;03/08/2026;PUR;1000;Supplies expense;0,00;59,00;TXN-003
GL-0039;PV-EXP-03;05/08/2026;PUR;5200;Services expense;73,00;0,00;TXN-005
GL-0040;PV-EXP-03;05/08/2026;PUR;1000;Services expense;0,00;73,00;TXN-005
GL-0041;PV-EXP-04;06/08/2026;PUR;5000;Facilities expense;80,00;0,00;TXN-006
GL-0042;PV-EXP-04;06/08/2026;PUR;1000;Facilities expense;0,00;80,00;TXN-006
GL-0043;PV-EXP-05;08/08/2026;PUR;5100;Supplies expense;94,00;0,00;TXN-008
GL-0044;PV-EXP-05;08/08/2026;PUR;1000;Supplies expense;0,00;94,00;TXN-008
GL-0045;PV-EXP-06;09/08/2026;PUR;5200;Services expense;101,00;0,00;TXN-009
GL-0046;PV-EXP-06;09/08/2026;PUR;1000;Services expense;0,00;101,00;TXN-009
GL-0047;PV-EXP-07;11/08/2026;PUR;5000;Facilities expense;115,00;0,00;TXN-011
GL-0048;PV-EXP-07;11/08/2026;PUR;1000;Facilities expense;0,00;115,00;TXN-011
GL-0049;PV-EXP-08;12/08/2026;PUR;5100;Supplies expense;122,00;0,00;TXN-012Specifications
- Document Set
- accounting
- Industry
- finance
- Source Kit
- accounting-reconciliation
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 66
- Delimiter
- semicolon
- Decimal Mark
- comma
- Date Format
- dd/mm/yyyy
- Encoding
- UTF-8
Testing contract
Expected to pass- Scenario
- Import the ledger with the European dialect configured and check that it still balances.
- Expected result
- Read with a semicolon delimiter and a comma decimal mark, the 66 lines give debits and credits of 22464.00 each, the same totals as general-ledger-export.csv.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Alder Books Reconciliation: General ledger in the European CSV dialect” is a deterministic Testaroo fixture for Data import. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 66 rows · UTF-8. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("general-ledger-eu-dialect.csv")
print(df.head())
print(df.dtypes)Generated by generation/industry_documents.py. Free for any use, no attribution required, license.
Related files
- csvAlder Books Reconciliation: Aged creditors summaryAged creditors summary for Alder Books Reconciliation. The 3 suppliers behind the 16 operating payments, grouped by expense category. The amounts due are 774.00, 617.00, 673.00 and they sum to 2064.00, which is the total of the three actual columns on the budget report.
- csvAlder Books Reconciliation: Aged debtors reportAged debtors report for Alder Books Reconciliation. 8 open receivables aged at 2026-09-08, each with 100.00 outstanding against an invoice of between 750.00 and 1275.00. The ageing buckets hold 0.00 current, 500.00 at 31 to 60 days and 300.00 at 61 to 90 days, summing to 800.00, the receivables line of the trial balance.
- csvAlder Books Reconciliation: Balanced manual journal batchBalanced manual journal batch for Alder Books Reconciliation. 3 month-end journals of 2 lines each, 6 lines in total: an accrual, a reclassification and a prepayment release. Each batch_id balances on its own and the batch as a whole posts 339.75 of debits and the same of credits.
- csvAlder Books Reconciliation: Bank reconciliationBank reconciliation for Alder Books Reconciliation. All 24 statement transactions matched one for one to a cash-account ledger line, with a difference column that is 0.00 on every row. There are no unpresented items and no deposits in transit, so the book balance 10236.00 equals the statement balance 10236.00 and the reconciling difference is 0.00.
- jsonAlder Books Reconciliation: Bank reconciliation JSONBank reconciliation JSON for Alder Books Reconciliation. The same 24 matches as bank-reconciliation.csv with the reconciliation summary at the top: statement closing 10236.00, book closing 10236.00, nothing outstanding or unpresented and a reconciling difference of 0.00.
- csvAlder Books Reconciliation: Bank statement CSVBank statement CSV for Alder Books Reconciliation. 24 transactions from 2026-08-01 to 2026-08-24 in separate debit and credit columns, with a running balance. The statement opens at 5000.00 and closes at 10236.00; 8 credits total 7300.00 and 16 debits total 2064.00.
