Alder Books Reconciliation: Fixed-width GL feed with one record a byte short
Fixed-width GL feed with one record a byte short for Alder Books Reconciliation. The same 66 records as gl-feed-fixed-width.txt except that record 5 is 119 characters instead of 120: the final character of the 4-character currency field has been lost. Every other record is correct, so a reader that splits on newlines and slices by position reads USD as US on that one record and carries on silently.
GL-0001 2026-08-011000 Opening cash balance 0000000050000000000000000000USD
GL-0002 2026-08-013000 Opening balance equity 0000000000000000000000500000USD
GL-0003 2026-07-021100 Invoice to Fictional client 1 0000000007500000000000000000USD
GL-0004 2026-07-024000 Service revenue, Fictional client 1 0000000000000000000000075000USD
GL-0005 2026-07-051100 Invoice to Fictional client 2 0000000008250000000000000000USD
GL-0006 2026-07-054000 Service revenue, Fictional client 2 0000000000000000000000082500USD
GL-0007 2026-07-081100 Invoice to Fictional client 3 0000000009000000000000000000USD
GL-0008 2026-07-084000 Service revenue, Fictional client 3 0000000000000000000000090000USD
GL-0009 2026-07-111100 Invoice to Fictional client 4 0000000009750000000000000000USD
GL-0010 2026-07-114000 Service revenue, Fictional client 4 0000000000000000000000097500USD
GL-0011 2026-07-141100 Invoice to Fictional client 5 0000000010500000000000000000USD
GL-0012 2026-07-144000 Service revenue, Fictional client 5 0000000000000000000000105000USD
GL-0013 2026-07-171100 Invoice to Fictional client 6 0000000011250000000000000000USD
GL-0014 2026-07-174000 Service revenue, Fictional client 6 0000000000000000000000112500USD
GL-0015 2026-07-201100 Invoice to Fictional client 7 0000000012000000000000000000USD
GL-0016 2026-07-204000 Service revenue, Fictional client 7 0000000000000000000000120000USD
GL-0017 2026-07-231100 Invoice to Fictional client 8 0000000012750000000000000000USD
GL-0018 2026-07-234000 Service revenue, Fictional client 8 0000000000000000000000127500USD
GL-0019 2026-08-011000 Receipt from Fictional client 1 0000000006500000000000000000USD
GL-0020 2026-08-011100 Receipt from Fictional client 1 0000000000000000000000065000USD
GL-0021 2026-08-041000 Receipt from Fictional client 2 0000000007250000000000000000USD
GL-0022 2026-08-041100 Receipt from Fictional client 2 0000000000000000000000072500USD
GL-0023 2026-08-071000 Receipt from Fictional client 3 0000000008000000000000000000USD
GL-0024 2026-08-071100 Receipt from Fictional client 3 0000000000000000000000080000USD
GL-0025 2026-08-101000 Receipt from Fictional client 4 0000000008750000000000000000USD
GL-0026 2026-08-101100 Receipt from Fictional client 4 0000000000000000000000087500USD
GL-0027 2026-08-131000 Receipt from Fictional client 5 0000000009500000000000000000USD
GL-0028 2026-08-131100 Receipt from Fictional client 5 0000000000000000000000095000USD
GL-0029 2026-08-161000 Receipt from Fictional client 6 0000000010250000000000000000USD
GL-0030 2026-08-161100 Receipt from Fictional client 6 0000000000000000000000102500USD
GL-0031 2026-08-191000 Receipt from Fictional client 7 0000000011000000000000000000USD
GL-0032 2026-08-191100 Receipt from Fictional client 7 0000000000000000000000110000USD
GL-0033 2026-08-221000 Receipt from Fictional client 8 0000000011750000000000000000USD
GL-0034 2026-08-221100 Receipt from Fictional client 8 0000000000000000000000117500USD
GL-0035 2026-08-025000 Facilities expense 0000000000520000000000000000USD
GL-0036 2026-08-021000 Facilities expense 0000000000000000000000005200USD
GL-0037 2026-08-035100 Supplies expense 0000000000590000000000000000USD
GL-0038 2026-08-031000 Supplies expense 0000000000000000000000005900USD
GL-0039 2026-08-055200 Services expense 0000000000730000000000000000USD
GL-0040 2026-08-051000 Services expense 0000000000000000000000007300USD
GL-0041 2026-08-065000 Facilities expense 0000000000800000000000000000USD
GL-0042 2026-08-061000 Facilities expense 0000000000000000000000008000USD
GL-0043 2026-08-085100 Supplies expense 0000000000940000000000000000USD
GL-0044 2026-08-081000 Supplies expense 0000000000000000000000009400USD
GL-0045 2026-08-095200 Services expense 0000000001010000000000000000USD
GL-0046 2026-08-091000 Services expense 0000000000000000000000010100USD
GL-0047 2026-08-115000 Facilities expense 0000000001150000000000000000USD
GL-0048 2026-08-111000 Facilities expense 0000000000000000000000011500USD
GL-0049 2026-08-125100 Supplies expense 0000000001220000000000000000USD
GL-0050 2026-08-121000 Supplies expense 0000000000000000000000012200USD Specifications
- Document Set
- accounting
- Industry
- finance
- Source Kit
- accounting-reconciliation
- Synthetic
- true
- As Of
- 2026-09-08
- Records
- 66
- Declared Record Length
- 120
- Short Record Number
- 5
- Short Record Length
- 119
- Intentionally Invalid
- true
Testing contract
Expected to fail- Scenario
- Parse the feed by column position and check every record length before slicing it.
- Expected result
- Record 5 is 119 characters where the layout declares 120. A length check rejects it; a reader that slices without checking returns a currency of US for that record and correct values for all the others, which is exactly the class of truncation that survives into a posted ledger.
What is a .txt file?
TXT is a plain-text file containing unformatted character data with no styling or structure beyond line breaks. Its interpretation depends on character encoding, most commonly UTF-8, and on line-ending convention. It is the most universal and portable text container.
How to use this file
Use an example TXT to test encoding detection, line-ending (LF versus CRLF) handling, and any tool that reads or streams raw text input.
How to use this file for testing
“Alder Books Reconciliation: Fixed-width GL feed with one record a byte short” is a deterministic Testaroo fixture for Data import, Error handling. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 66 records. 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.
Generated by generation/industry_documents.py. Free for any use, no attribution required, license.
Related files
- xmlAlder Books Reconciliation: camt.053 whose entry count does not match its entriescamt.053 whose entry count does not match its entries for Alder Books Reconciliation. Well-formed XML with the same header, balances and TxsSummry as bank-statement-camt053.xml, but the final Ntry, TXN-024 for 206.00 on 2026-08-24, has been dropped. NbOfNtries still declares 24 while only 23 Ntry elements are present, and the entries now sum to 10442.00 against a CLBD balance of 10236.00.
- csvAlder Books Reconciliation: Journal batch with one entry out by 45.00Journal batch with one entry out by 45.00 for Alder Books Reconciliation. The same 3 journals as journal-batch.csv except that line 2 of JB-2026-08-02 credits 19.50 where its debit line is 64.50. That one journal is out by 45.00; the other two balance exactly, which is what makes this the realistic case: a batch-level check catches it only because nothing else offsets it.
- txtAlder Books Reconciliation: MT940 whose :62F: closing balance is out by 100.00MT940 whose :62F: closing balance is out by 100.00 for Alder Books Reconciliation. Identical to bank-statement-mt940.txt in every tag except :62F: and :64:, which state C260824USD10336,00 where the 24 :61: movements applied to the :60F: opening balance give C260824USD10236,00. The file is out by exactly 100.00 and nothing inside the statement explains the difference.
- csvAlder Books Reconciliation: Trial balance out by 1250.00Trial balance out by 1250.00 for Alder Books Reconciliation. Identical to trial-balance.csv except that account 5200 Services expense is stated as 1923.00 instead of 673.00. Debits therefore come to 14350.00 against credits of 13100.00, a difference of exactly 1250.00. The TOTAL row is recalculated and agrees with the account rows, so the file is internally consistent and only the double-entry rule is broken.
- jsonAlder Books Reconciliation: Intentionally invalid semantic test recordsIntentionally invalid semantic test records for Alder Books Reconciliation. Three independent cases report duplicate-primary-key, schema-type and foreign-key errors. JSON syntax remains valid.
- csvAlder Table Bistro: Allergen matrix missing a menu itemAllergen matrix missing a menu item for Alder Table Bistro. Intentionally incomplete. 3 rows where the recipes cost 4 menu items. MENU-04 (Potato gratin) has no row, although it has costed recipe lines in plate-costs.csv and sales in sales-mix-pmix.csv. Its correct row would declare: milk: Cream.
