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.
Printed menu as a Word document for Alder Table Bistro. The same 4 dishes and 3 sections as printed-menu.pdf, laid out as 3 two column Word tables with the price cell right aligned, so the identical layout can be read through a different parser. Core properties are stamped to 2026-09-08 and the package timestamps are fixed, so two runs produce identical bytes.
Printed menu with a price the costing denies for Alder Table Bistro. Intentionally wrong. MENU-02 Tomato soup is printed at 12.50 CAD where plate-costs.csv carries 11.50 CAD, a difference of 1.00. The printed figure is the proposed_price in the shared menu_price_changes table, effective 2026-09-15, so this is the shape a menu takes when it is reprinted early. Every other price matches printed-menu.pdf.
Procure-to-pay chain README for Alder Table Bistro. Names all 28 files in this folder, tabulates the seven-step chain from price list to remittance advice, and states all 6 deliberate disagreements with the exact numbers and the assertion that detects each. It also separates those defects from three traps that are modelling rather than errors: case price against unit price, the unreachable contract tier at 250 units, and the two legitimate tax-total conventions.
Procure-to-pay workbook for Alder Table Bistro. 9 worksheets holding the same rows as the CSV exports plus a 'Deliberate defects' sheet naming all 6: Price list 48 rows; Purchase orders 12 rows; Goods received 12 rows; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.
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 order PDF for Alder Table Bistro. Purchase order PO-BST-1002 dated 2026-08-12 to Harbour Food Supply: 3 lines, net 313.84, GST 15.69 and 329.53 CAD payable. Line 2 orders 20 kg of ING-03, which is the line the delivery note and the invoice later disagree about.
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.
Recipe costing as an OpenDocument spreadsheet for Alder Table Bistro. Three tables. PlateCosts holds 12 recipe lines with the as-purchased quantity and line cost as live ODF formulas; Summary rolls each dish up with SUMIF and computes margin and food-cost percent. The same figures in value form are in plate-costs.csv.
Recipe costing workbook with live formulas for Alder Table Bistro. Four sheets. Ingredients converts 6 purchase packs to a cost per recipe unit; PlateCosts holds 12 recipe lines; Summary uses SUMIF to roll each dish up and computes margin and food-cost percent; Notes records the provenance. Exactly 73 cells are live formulas with no cached value, so a values-only reader sees them empty and a recalculating reader reproduces plate-costs.csv exactly.
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.
Remittance advice PDF for Alder Table Bistro. Remittance advice REM-BST-8001 dated 2026-09-05, covering all 13 documents on both statements. 1120.68 CAD is paid and 1765.18 CAD is withheld, against statement balances of 2885.86 CAD. Every withheld document is listed again below the table with the reason it was not paid.
Scheduled hours and overtime workbook for Alder Table Bistro. Three sheets. WeeklyHours carries 24 employee-weeks over 3 Monday-start work weeks, with weekly overtime above 44 hours, payable overtime as the greater of the daily and weekly figures, and the premium at half the base rate. DailyHours breaks the same segments down into 59 employee-days with a daily overtime formula above 8 hours. The period carries 5.00 payable overtime hours and 51.50 CAD of premium.
Set lunch for Alder Table Bistro. A fixed price page at 31.00 CAD covering 2 dishes that are already on the printed menu. The same items ordered separately come to 35.50 CAD, so the page states a saving of 4.50 CAD. Plate cost for the bundle is 4.33 CAD.
Statement of account PDF for Alder Table Bistro. Statement STM-BST-6002 for Harbour Food Supply at 2026-08-31: 8 transactions closing at 1559.75 CAD. The printed ageing analysis totals 1566.76 CAD, which is 7.01 CAD more, because credit note CN-BST-7001 is listed in the transactions but was never applied to the buckets.
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 invoice PDF for Alder Table Bistro. Invoice INV-BST-5002 dated 2026-08-14, due 2026-09-13: 3 lines, net 313.84, GST 15.69 and 329.53 CAD due. Line 2 bills the ordered quantity even though the goods-received note records a short delivery of 4 kg.
Supplier invoice PDF reusing an invoice number for Alder Table Bistro. A second document issued under invoice number INV-BST-5002, dated 2026-08-17 with 2 lines totalling 294.46 CAD. The first document of that number is dated 2026-08-14 with 3 lines totalling 329.53 CAD. Both are listed on statement STM-BST-6002 and both are inside its closing balance.
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.
