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.
Numeric expected results JSON for Alder Table Bistro. The exact numbers a test asserts: document counts, per-order and per-invoice totals, both tax conventions for every invoice, declared and true ageing for both statements, the remittance reconciliation identity, the 5 three-way match outcomes and all 6 deliberate defects with the assertion that detects each one. The correct purchase order net at list price is 1452.72 CAD.
Overtime computed on the wrong week boundary for Alder Table Bistro. Intentionally inconsistent. The same 74 shift segments are grouped into Sunday-start work weeks where the declared policy, and labour-hours-overtime.xlsx, start each week on Monday. The correct grouping yields 5.00 payable overtime hours and 51.50 CAD of premium; this file yields 3.00 hours and 31.50 CAD. The hours that disappear belong to EMP-01 in the week beginning 2026-08-24, whose 46.00 hours the Sunday grouping splits across two weeks.
Plate costing document for Alder Table Bistro. A nested JSON document with 4 dishes and 12 recipe lines, an ingredient block carrying the pack and reference purchase for every price, and an explicit roundingRules object naming the decimal places used at each step.
Plate costing lines for Alder Table Bistro. 12 recipe lines across 4 menu items, 17 columns. Recipe quantities are in grams, millilitres or each; the as-purchased quantity divides by the yield, so the line cost is not a naive multiplication. Plate costs run 1.01 to 3.07 CAD.
Product mix carrying items the menu does not have for Alder Table Bistro. Intentionally inconsistent. 6 rows where sales-mix-pmix.csv has 4. MENU-90 and MENU-91 are not in the shared menu table, and the first row renames MENU-01 to "Roast chicken plate (lunch)", which has a doubled space and a suffix the menu does not carry. The remaining rows are correct.
Product mix report for Alder Table Bistro. 4 menu items across 12 columns for 2026-08-20 to 2026-09-02: quantity sold, mix percent, gross, discount, net, share of net, plate cost, item cost, item margin and item food-cost percent. Quantities and net sales match the shared sales table row for row; total net is 15780.80 CAD.
Purchase order lines CSV for Alder Table Bistro. 12 lines across 4 purchase orders dated 2026-08-05 to 2026-08-26. Each line repeats its order's net, tax and gross totals, so a reader can check that the line values sum to the header without a second file. Order PO-BST-1002 totals 329.53 CAD including GST.
Purchase pack to recipe unit conversions for Alder Table Bistro. 6 ingredients across 16 columns. Each row carries the purchase pack, the pack price, the cost per stock unit to six decimal places, the cost per recipe unit to eight, and the purchase id, date and supplier the price came from. 0 row(s) report a non-zero rounding residual because the pack size is not a whole number of stock units.
Remittance advice lines CSV for Alder Table Bistro. 13 lines, one for every document on both statements, each marked paid or withheld with a reason. 1120.68 CAD is settled and 1765.18 CAD is withheld against statement balances of 2885.86 CAD; the first two figures sum to the third.
Statements of account CSV for Alder Table Bistro. 13 transaction rows across 2 month-end statements dated 2026-08-31. STM-BST-6001 closes at 1326.11 CAD and its four declared ageing buckets sum to exactly that. STM-BST-6002 closes at 1559.75 CAD while its declared buckets sum to 1566.76 CAD.
Supplier invoice lines CSV for Alder Table Bistro. 14 lines across 5 invoice documents that carry only 4 distinct invoice numbers: INV-BST-5002 appears twice, dated 2026-08-14 and 2026-08-17. invoice_number is therefore not a key; the pair of invoice_number and invoice_date is. invoice_stated_tax_total is the figure printed on the document, which for INV-BST-5003 is one cent above the sum of its line tax amounts.
Supplier price list CSV for Alder Table Bistro. 48 rows covering 2 suppliers, 6 items and 4 effective dates (2026-08-05, 2026-08-12, 2026-08-19, 2026-08-26). Each row carries the list unit price, the case pack quantity, the price per case and a contract tier price that applies only at 250 units. Every purchase order line in this set is priced from the row matching its supplier, item and order date.
Supplier price list CSV, semicolon and decimal comma for Alder Table Bistro. The same 48 price rows re-exported the way a European supplier portal writes them: UTF-8 with a byte-order mark (EF BB BF), semicolon field separators, CRLF line endings, and decimal commas in list_unit_price, price_per_case and contract_tier_unit_price. Column names, column order and every value are identical to price-list.csv; only the encoding and the separators differ.
Three-way match report CSV for Alder Table Bistro. 14 rows joining every invoice line to its purchase order line and its goods-received line. 9 rows match on item, quantity and price; the remaining 5 carry a match_result of duplicate-invoice-number, item-substituted, matched-credit-expected, quantity-variance and a note giving the exact variance.
Till import for Alder Table Bistro. 21 rows and 6 columns in the shape a point of sale ingests: item_code, item_name, category, price, tax_code, modifier_group. 4 dishes, 8 modifier options across 4 groups, 8 drink lines and one stored value line. Item codes are letter prefixed so a spreadsheet cannot eat a leading zero, and two tax codes are present so a mapping has something to map.
Till import in the European dialect for Alder Table Bistro. The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "é", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
Till import with a duplicate item code for Alder Table Bistro. Intentionally invalid. 22 rows where pos-import.csv has 21. item_code MENU-02 appears on line 3 at 11.50 CAD and again on line 23 at 12.50 CAD, which is the proposed price in the shared menu_price_changes table. It is the only repeated code in the file, so an importer that keeps the last row it reads silently ships the later price.
Tip pool distribution for Alder Table Bistro. 4 allocation rows and one total row for 2026-08-28. The declared pool of 138.14 CAD is 95.39 charged to card plus 42.75 declared cash, split 30 percent to back of house, then allocated within each group by hours times a role weight. Whole cents are assigned by largest remainder, so the rows sum to 138.14 CAD, which equals the pool exactly.
Tip pool that is one cent short for Alder Table Bistro. Intentionally inconsistent. The last allocation row (EMP-04) reads 36.25 where the exact largest-remainder share is 36.26. The allocation rows therefore sum to 138.13 CAD while the total row still declares the pool as 138.14 CAD, a shortfall of exactly 0.01 CAD.
Waste and spoilage log for Alder Table Bistro. 15 dated waste entries across 11 columns, totalling 37.87 CAD at standard cost. The quantities per ingredient are exactly the recorded waste that inventory-variance.xlsx and cogs-report.xlsx deduct.
Whole procure-to-pay chain JSON for Alder Table Bistro. One object holding the buyer, both suppliers, all 6 items, the 48-row price list, 4 purchase orders, 4 goods-received notes, 5 invoice documents, 2 credit notes, 2 statements, the remittance advice, the 14-row three-way match and the 6 deliberate defects. Every monetary value is a JSON string with exactly two decimal places.
Yield test results for Alder Table Bistro. 5 yield tests across 17 columns: raw weight, trim waste, trimmed weight, trim yield percent, cooked weight, cooking loss percent and the overall yield factor. All 5 rows report matches_recipe=yes, meaning each measured trim yield equals the yield percent that plate-costs.csv applies to the same ingredient.
