Alder Table Bistro: Remittance advice lines CSV
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_number,payment_date,payment_method,payment_reference,line_no,supplier_id,supplier_name,document_type,document_number,document_date,document_amount,settled_amount,status,reason,remittance_total,currency
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,1,SUP-01,Alder Wholesale,invoice,OPN-BST-9001,2026-05-20,87.19,87.19,paid,Settled in full.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,2,SUP-01,Alder Wholesale,invoice,OPN-BST-9002,2026-06-18,119.89,119.89,paid,Settled in full.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,3,SUP-01,Alder Wholesale,invoice,OPN-BST-9003,2026-07-21,152.59,0.00,withheld,Not yet due under Net 30 terms.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,4,SUP-01,Alder Wholesale,invoice,INV-BST-5001,2026-08-07,217.98,217.98,paid,Settled in full.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,5,SUP-01,Alder Wholesale,invoice,INV-BST-5003,2026-08-21,748.46,0.00,withheld,"Price query: line 2 bills a substituted item at a price that is not on the purchase order, and the stated tax total does not agree with the line tax amounts.",1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,6,SUP-02,Harbour Food Supply,invoice,OPN-BST-9004,2026-05-28,148.29,148.29,paid,Settled in full.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,7,SUP-02,Harbour Food Supply,invoice,OPN-BST-9005,2026-06-25,197.72,197.72,paid,Settled in full.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,8,SUP-02,Harbour Food Supply,invoice,OPN-BST-9006,2026-07-15,247.15,0.00,withheld,Not yet due under Net 30 terms.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,9,SUP-02,Harbour Food Supply,invoice,INV-BST-5002,2026-08-14,329.53,0.00,withheld,Quantity in dispute: 4 kg billed but recorded short on GRN-BST-2002.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,10,SUP-02,Harbour Food Supply,invoice,INV-BST-5002,2026-08-17,294.46,0.00,withheld,Rejected as a duplicate of invoice number INV-BST-5002 dated 2026-08-14.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,11,SUP-02,Harbour Food Supply,credit note,CN-BST-7001,2026-08-21,-7.01,0.00,withheld,Credit held until the disputed invoice it relates to is settled.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,12,SUP-02,Harbour Food Supply,invoice,INV-BST-5004,2026-08-28,390.51,390.51,paid,Settled in full.,1120.68,CAD
REM-BST-8001,2026-09-05,EFT,EFT-BST-20260905,13,SUP-02,Harbour Food Supply,credit note,CN-BST-7002,2026-08-29,-40.90,-40.90,paid,Settled in full.,1120.68,CAD
Specifications
- Kit
- restaurant-bistro
- Schema Version
- 1
- Synthetic
- true
- As Of
- 2026-09-08
- Currency
- CAD
- Tax Name
- GST
- Tax Rate
- 0.05
- Rows
- 13
- Columns
- 16
- Delimiter
- comma
- Encoding
- UTF-8
- Byte Order Mark
- false
- Line Endings
- LF
- Decimal Separator
- .
Testing contract
Expected to pass- Scenario
- Read remittance advice lines csv into a procure-to-pay import, three-way match and reconciliation workflow for Alder Table Bistro.
- Expected result
- 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.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Alder Table Bistro: Remittance advice lines CSV” is a deterministic Testaroo fixture for Data import, CSV parsing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 13 rows · 16 columns · UTF-8 · LF. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("remittance-advice.csv")
print(df.head())
print(df.dtypes)Generated by generation/restaurant_procurement.py. Free for any use, no attribution required, license.
Related files
- csvAlder Table Bistro: Credit note lines CSVCredit note lines CSV for Alder Table Bistro. 2 credit lines, one per note. CN-BST-7001 credits 4 units for the short delivery and agrees with the goods-received note. CN-BST-7002 credits 5 units where GRN-BST-2004 records only 3 returned, an overstatement of 15.58 CAD net.
- csvAlder Table Bistro: Goods-received note lines CSVGoods-received note lines CSV for Alder Table Bistro. 12 received lines across 4 goods-received notes. Three lines are exceptions: a short delivery of 4 units on GRN-BST-2002, an item substitution on GRN-BST-2003 where the delivered ingredient id differs from the ordered one, and a part return of 3 units on GRN-BST-2004. accepted_quantity equals delivered_quantity minus returned_quantity on every row.
- csvAlder Table Bistro: Purchase order lines CSVPurchase 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.
- csvAlder Table Bistro: Statements of account CSVStatements 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.
- csvAlder Table Bistro: Supplier invoice lines CSVSupplier 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.
- csvAlder Table Bistro: Supplier price list CSVSupplier 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.
