Find files, editable templates and browser test targets by what you need to make or test. The directory below is cut by format; the two collections under it cut the same library by subject and by workflow.
Blank input table templates for Alder Books Reconciliation. 6 header-only CSV templates and one setup guide. No filled sample records or executable content.
Budget versus actual for Alder Books Reconciliation. 3 expense categories for 2026-08 with budget, actual, variance and variance percent. Budgets total 4200.00 against actuals of 2064.00, leaving 2136.00 unspent. Every actual equals the sum of the ledger postings to that expense account.
camt.053 bank statement for Alder Books Reconciliation. An ISO 20022 camt.053.001.02 BankToCustomerStatement carrying the same 24 entries as bank-statement.csv. The OPBD balance is 5000.00 and the CLBD balance 10236.00; TxsSummry declares 8 credit entries totalling 7300.00 and 16 debit entries totalling 2064.00, and Ntry elements are present for all 24.
camt.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.
Chart of accounts for Alder Books Reconciliation. 9 postable accounts covering assets, liabilities, equity, income and expenses, with the normal balance side declared on every row. Codes run 1000 to 5200 and every account code used anywhere in the general ledger export appears here.
Chart of accounts JSON for Alder Books Reconciliation. The same 9 accounts as chart-of-accounts.csv as a JSON array under an accounts key, with the reporting currency declared once at the top level.
COBOL copybook for the GL feed for Alder Books Reconciliation. A COBOL record description for the same 120-character layout, with PIC clauses matching gl-feed-layout.json field for field: X(n) for the alphanumeric fields and 9(12)V99 for the two amount fields, which is where the two implied decimal places are declared. Comment lines carry the column ranges.
Credit application (DOCX) for Alder Books Reconciliation. An unsecured working capital application for 15,000.00 USD. Every figure in the financial summary names the wave-one accounting file and column it comes from, so the whole table is checkable: closing cash 10,236.00, invoiced 8,100.00, received 7,300.00, outstanding 800.00 and expenditure 2,064.00 USD. The PDF twin in the same directory carries the identical text.
Credit application (PDF) for Alder Books Reconciliation. An unsecured working capital application for 15,000.00 USD. Every figure in the financial summary names the wave-one accounting file and column it comes from, so the whole table is checkable: closing cash 10,236.00, invoiced 8,100.00, received 7,300.00, outstanding 800.00 and expenditure 2,064.00 USD. The DOCX twin in the same directory carries the identical text.
Credit application JSON for Alder Books Reconciliation. The same application as an object, with each financial summary row keeping the source string that names the file and column it came from. The connected facility is a nested object rather than a string, so a reader can tell that the existing borrowing belongs to a different entity.
Document set README for Alder Books Reconciliation. 33 files, 5 of them intentionally invalid, with the reconciliation identities and the exact defect in each broken file named in full.
Fixed-width general ledger feed for Alder Books Reconciliation. 66 records of exactly 120 characters each, the shape a legacy banking or ERP feed still arrives in. Amounts are unsigned cents, zero filled and right justified in a 14-character field, so 5000.00 is written as 00000000500000. Text fields are space padded and truncated at their declared width. There is no delimiter and no header row; the column map is gl-feed-layout.json.
Fixed-width GL feed column map for Alder Books Reconciliation. The documented column map for gl-feed-fixed-width.txt: 7 fields with 1-based start position, length, end position and type, adding up to the declared 120-character record. It also states the padding rules and that amounts carry two implied decimal places.
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.
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.
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.
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.
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.
Generic primary records CSV for Alder Books Reconciliation. 24 generic records with stable primary keys. Map the documented fields before importing into another platform.
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.
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.
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.
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.
