Ember Lane Pizza: Procure-to-pay workbook
Procure-to-pay workbook for Ember Lane Pizza. 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.
Rendered preview of the xlsx file (25.4 KB). Download above for the original.
Specifications
- Kit
- restaurant-pizzeria
- Schema Version
- 1
- Synthetic
- true
- As Of
- 2026-09-08
- Currency
- CAD
- Tax Name
- GST
- Tax Rate
- 0.05
- Sheets
- 9
- Rows
- 134
- Money Cells
- number, format 0.00
- Frozen Header Row
- true
Testing contract
Expected to pass- Scenario
- Read procure-to-pay workbook into a procure-to-pay import, three-way match and reconciliation workflow for Ember Lane Pizza.
- Expected result
- 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.
What is a .xlsx file?
XLSX is the default Microsoft Excel format, an Office Open XML spreadsheet stored as a ZIP archive containing worksheet XML, shared strings, styles, and formulas. It supports multiple sheets, cell formatting, charts, and calculated values. It is the standard for editable tabular workbooks.
How to use this file
Use an example XLSX to test spreadsheet parsing, formula and multi-sheet handling, shared-string extraction, and pipelines that read or generate Excel workbooks.
How to use this file for testing
“Ember Lane Pizza: Procure-to-pay workbook” is a deterministic Novus Examples fixture for Data import, Spreadsheet testing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 134 rows · 9 sheets. 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.
This template ships filled with realistic sample content and documented fields and formulas. Download it as a starting point, or point a converter/parser at it, format twins (for example DOCX↔PDF) let you diff conversion fidelity.
Code examples
from openpyxl import load_workbook
wb = load_workbook("procure-to-pay.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- xlsxAlder Table Bistro: Procure-to-pay workbookProcure-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.
- xlsxCedar Street Tacos: Procure-to-pay workbookProcure-to-pay workbook for Cedar Street Tacos. 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.
- xlsxCopper Oven Bakery: Procure-to-pay workbookProcure-to-pay workbook for Copper Oven Bakery. 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.
- xlsxHarbour Kitchen Group: Procure-to-pay workbookProcure-to-pay workbook for Harbour Kitchen Group. 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.
- xlsxJuniper Corner Cafe: Procure-to-pay workbookProcure-to-pay workbook for Juniper Corner Cafe. 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.
- xlsxWillow Event Kitchen: Procure-to-pay workbookProcure-to-pay workbook for Willow Event Kitchen. 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.
Generated by generation/restaurant_procurement.py. Free for any use, no attribution required, license.