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.
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.
Month-end close pack PDF for Alder Books Reconciliation. A two-page close pack: page one carries the 10-row trial balance totalling 13,100.00 on each side and the receivables ageing summing to 800.00; page two states the bank reconciliation and the budget variance of 2,136.00.
Month-end ledger pack workbook for Alder Books Reconciliation. Five worksheets: Chart of accounts (9 rows), General ledger (66), Trial balance (10), Bank statement (24) and Aged debtors (9). The trial balance sheet totals 13100.00 on each side and the bank statement sheet closes on the same cash figure.
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.
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.
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.
Operating report PDF for Alder Books Reconciliation. Three readable pages summarize the same model, chart, source tables and usage instructions. Net cash change=5,236.00 USD; Journal debits=9,364.00 USD; Journal credits=9,364.00 USD.
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.
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.
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.
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.
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.
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.
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.
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.
Allergen menu for Alder Table Bistro. A landscape page carrying 4 dishes against the 14 declarable allergens, Y for declared and a hyphen for not declared, with a second table naming the ingredient behind every Y. The grid reproduces allergen-matrix.csv in the costing folder cell for cell.
Allergen menu as data for Alder Table Bistro. 4 rows and 21 columns: the menu item id, the printed section, the menu price, the 14 allergen columns, the declared count and the ingredient sources. 2 of 4 dishes declare at least one allergen. Joins to printed-menu.pdf and to plate-costs.csv on menu_item_id.
Allergen menu missing a dish on the menu for Alder Table Bistro. Intentionally incomplete. 3 rows where allergen-menu.csv has 4. MENU-02 Tomato soup is printed on printed-menu.pdf at 11.50 CAD and declares 1 allergen in the costing folder, and it has no row here. The remaining rows are correct.
ANSI X12 810 invoice for Alder Table Bistro. Version 004010 transaction set 810 for invoice INV-BST-5002, control number 810002. 3 IT1 segments, a TXI segment stating GST of 15.69, and a TDS segment of 32953 in implied-decimal cents, which is 329.53 CAD. SE declares 13 segments and 13 are present.
ANSI X12 810 invoice with a wrong SE segment count for Alder Table Bistro. Identical to edi-810-invoice.edi except for one element: SE declares 11 segments where 13 are present between ST and SE inclusive. The ISA, GS, GE and IEA control numbers, every data segment and the TDS total of 32953 are unchanged, so a parser that checks only syntax accepts the file and only a parser that recounts segments rejects it.
