Testaroo, Real, documented example files for testing

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.

File: TXT · Accounting Ledgers · 66 records
Use case: Data importError handling

Alder Books Reconciliation: General ledger export

General ledger export for Alder Books Reconciliation. 66 ledger lines in four journals: GEN carries the opening balance, SAL the 8 sales invoices, CSH the 8 cash receipts and PUR the 16 supplier payments. Debits total 22464.00 and credits the same, and every document_id posts a balanced pair of lines.

File: CSV · Accounting Ledgers · 66 rows
Use case: Data import

Alder Books Reconciliation: General ledger export JSON

General ledger export JSON for Alder Books Reconciliation. The same 66 lines as general-ledger-export.csv with a totals object declaring 22464.00 of debits and the same of credits. The period runs from the earliest invoice date 2026-07-02 to the last bank movement 2026-08-24.

File: JSON · Accounting Ledgers · 66 rows
Use case: Data import

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.

File: CSV · Accounting Ledgers · 66 rows
Use case: Data import

Alder Books Reconciliation: General ledger with parenthesised credits and grouped thousands

General ledger with parenthesised credits and grouped thousands for Alder Books Reconciliation. The same 66 lines collapsed into one signed_amount column in accounting presentation: credits appear as (1,234.50) rather than -1234.50 and thousands carry comma separators. The first credit line reads (5,000.00). Summing the column requires stripping the separators and reading the parentheses as a negative sign.

File: CSV · Accounting Ledgers · 66 rows
Use case: Data import

Alder Books Reconciliation: Generic primary records CSV

Generic primary records CSV for Alder Books Reconciliation. 24 generic records with stable primary keys. Map the documented fields before importing into another platform.

File: CSV · Business Kits · 24 rows
Use case: Data import

Alder Books Reconciliation: Intentionally invalid semantic test records

Intentionally 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.

File: JSON · Business Kits
Use case: Data importError handling

Alder Books Reconciliation: ISO 20022 pain.001 payment initiation

ISO 20022 pain.001 payment initiation for Alder Books Reconciliation. A pain.001.001.03 CustomerCreditTransferInitiation paying the 3 suppliers on aged-creditors.csv. GrpHdr declares NbOfTxs 3 and CtrlSum 2064.00; the single PmtInf block repeats those figures and contains 3 CdtTrfTxInf blocks for 774.00, 617.00, 673.00, each with a creditor IBAN and BIC.

File: XML · Accounting Ledgers · UTF-8
Use case: Data import

Alder Books Reconciliation: Journal batch with one entry out by 45.00

Journal 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.

File: CSV · Accounting Ledgers · 6 rows
Use case: Data importError handling

Alder Books Reconciliation: Ledger reconciliation assertions

Ledger reconciliation assertions for Alder Books Reconciliation. The six identities this set claims with their figures: ledger totals 22464.00, trial balance 13100.00 each side, cash 10236.00, receivables 800.00, a 0.00 bank reconciliation and a pain.001 control sum of 2064.00. It also records the exact size and cause of all five deliberate defects in the set.

File: JSON · Accounting Ledgers · UTF-8
Use case: Data import

Alder Books Reconciliation: Linked operating model

Linked operating model for Alder Books Reconciliation. 102 records across 6 linked tables; no duplicate primary keys or missing references. Net cash change=5,236.00 USD; Journal debits=9,364.00 USD; Journal credits=9,364.00 USD.

File: JSON · Business Kits · 102 records
Use case: Data import

Alder Books Reconciliation: MT940 bank statement

MT940 bank statement for Alder Books Reconciliation. A SWIFT MT940 customer statement with tags :20:, :25:, :28C:, :60F:, 24 :61:/:86: pairs, :62F: and :64:. Amounts use the MT decimal comma and dates the YYMMDD form, so the opening balance reads C260801USD5000,00 and the closing balance C260824USD10236,00. Line endings are CRLF, as the MT message format requires.

File: TXT · Accounting Ledgers · ASCII
Use case: Data import

Alder Books Reconciliation: MT940 whose :62F: closing balance is out by 100.00

MT940 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.

File: TXT · Accounting Ledgers
Use case: Data importError handling

Alder Books Reconciliation: Numeric expected results

Numeric expected results for Alder Books Reconciliation. Exact table counts, metric formulas, 24 chart points and three negative-test outcomes. Net cash change=5,236.00 USD; Journal debits=9,364.00 USD; Journal credits=9,364.00 USD.

File: JSON · Business Kits
Use case: Data import

Alder Books Reconciliation: OFX 1.0.3 bank statement

OFX 1.0.3 bank statement for Alder Books Reconciliation. An OFX 1.0.3 bank download in the SGML form: nine colon-delimited header lines, a blank line, then unclosed tags inside <OFX>. It carries 24 STMTTRN records with DTPOSTED in YYYYMMDD form and TRNAMT signed, plus a LEDGERBAL of 10236.00 dated 20260824. Line endings are CRLF, as OFX 1.x files from banks are.

File: OFX · Accounting Ledgers · ASCII
Use case: Data import

Alder Books Reconciliation: Operating model JSON Schema

Operating model JSON Schema for Alder Books Reconciliation. Draft 2020-12 schema accepts the paired operating model. Relational rules additionally require unique keys and existing foreign references.

File: JSON · Business Kits
Use case: Data import

Alder Books Reconciliation: QIF bank statement

QIF bank statement for Alder Books Reconciliation. A Quicken Interchange Format export opening with !Type:Bank and carrying 24 records terminated by a caret on its own line. Dates use the ambiguous mm/dd/yyyy form QIF is notorious for, amounts are signed with no currency, and there is no balance field at all, so the 10236.00 closing figure can only be derived. Line endings are CRLF.

File: QIF · Accounting Ledgers · 24 records
Use case: Data import

Alder Books Reconciliation: SAF-T style ledger extract

SAF-T style ledger extract for Alder Books Reconciliation. An audit-file extract structured after the OECD SAF-T 2.0 element names: Header, MasterFiles with 9 GeneralLedgerAccounts and 8 Customers, then GeneralLedgerEntries declaring NumberOfEntries 33, TotalDebit 22464.00 and TotalCredit 22464.00, with one Transaction per document and 66 Line elements in total.

File: XML · Accounting Ledgers · UTF-8
Use case: Data import

Alder Books Reconciliation: Trade credit references

Trade credit references for Alder Books Reconciliation. 3 trade references with credit limits, highest balance reached and average days to pay. Every highest_balance_usd is below its own credit_limit_usd, so a utilisation check passes on all three, and the two supplier names are the suppliers the inventory-manufacturing model actually buys from.

File: CSV · Banking Credit · 3 rows
Use case: Data importCSV parsing· Conversion set

Alder Books Reconciliation: Trial balance JSON

Trial balance JSON for Alder Books Reconciliation. The same 9 accounts as trial-balance.csv with the totals lifted into their own object: debit 13100.00, credit 13100.00, difference 0.00. The TOTAL row is not repeated inside the accounts array, so summing the array cannot double count.

File: JSON · Accounting Ledgers · UTF-8
Use case: Data import

Alder Books Reconciliation: Trial balance out by 1250.00

Trial 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.

File: CSV · Accounting Ledgers · 10 rows
Use case: Data importError handling

Alder Books Reconciliation: Trial balance that balances

Trial balance that balances for Alder Books Reconciliation. 9 accounts plus a TOTAL row. Debits and credits each come to 13100.00, so the difference is exactly 0.00. Cash carries 10236.00, which is the closing balance of the bank statement; receivables carry 800.00, which is the aged debtors total; and the two accounts with no movement are reported at 0.00 rather than omitted.

File: CSV · Accounting Ledgers · 10 rows
Use case: Data import

Alder Table Bistro: Allergen matrix

Allergen matrix for Alder Table Bistro. 4 menu items across 18 columns: the fourteen listed allergens plus a count and a sources column naming the ingredient behind every Y. Derived from the recipe lines, so a dish whose recipe contains a dairy ingredient reads Y under milk. 2 of 4 dishes declare at least one allergen.

File: CSV · Restaurant Costing · 4 rows
Use case: Data importCSV parsing· Paired fixture

Alder Table Bistro: Allergen matrix missing a menu item

Allergen 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.

File: CSV · Restaurant Costing · 3 rows
Use case: Data importError handling+1· Paired fixture

Explore the test library

Filter the library

1255 results