Pine Assembly Workshop: Quarterly interest accrual
Quarterly interest accrual for Pine Assembly Workshop. The first 4 quarters of the facility rolled up from the monthly schedule. Each row opening balance is the opening balance of the first month in the quarter and each closing is the closing of the last, so closing equals opening less capital repaid and the quarters chain without a gap.
csv
text/csv
- Document Set
- banking
- Industry
- finance
- Source Kit
- accounting-reconciliation
- Entity
- Pine Assembly Workshop
- Synthetic
- true
- As Of
- 2026-09-08
Binary csv: no in-browser preview. Download it above to open in a compatible application.
Specifications
- Document Set
- banking
- Industry
- finance
- Source Kit
- accounting-reconciliation
- Entity
- Pine Assembly Workshop
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 4
- Months Per Row
- 3
- Chains Without Gap
- true
Testing contract
Expected to pass- Scenario
- Check that each quarter closing balance is the next quarter opening balance, and that the interest column matches the sum of the three monthly rows it covers.
- Expected result
- The 4 quarters chain exactly, and each interest figure equals the three monthly interest amounts in loan-amortisation-schedule.csv added. Interest is not a constant per quarter because the balance falls every month.
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
“Pine Assembly Workshop: Quarterly interest accrual” is a deterministic Novus Examples fixture for Data import, CSV parsing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 4 rows. 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("interest-accrual.csv")
print(df.head())
print(df.dtypes)Related files
- csvAlder Books Reconciliation: Trade credit referencesTrade 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.
- csvFieldnote Supply Shop: Chargeback evidence indexChargeback evidence index for Fieldnote Supply Shop. 8 evidence items with the file and record each one points at and what it proves. Seven of the eight resolve into the wave-one ecommerce document set by filename and record identifier, so the packet is not a self-contained story but a set of pointers that either resolve or do not.
- csvFieldnote Supply Shop: Chargeback reason code referenceChargeback reason code reference for Fieldnote Supply Shop. 5 reason codes with the category, the representment window and the evidence each one expects. The two codes the wave-one chargeback register uses, 10.4 and 13.1, are both here, so that register can be joined to this table to find out what evidence each open case needs.
- csvFieldnote Supply Shop: Chargeback timelineChargeback timeline for Fieldnote Supply Shop. 7 events in date order from the order on 2026-08-06 to the representment deadline on 2026-09-11. Three rows carry an empty amount because dispatch, evidence submission and a deadline move no money, so a reader that treats the amount column as always numeric has three rows to handle.
- csvHarbour Kitchen Group: Direct debit collection scheduleDirect debit collection schedule for Harbour Kitchen Group. 8 collections under mandate DDM-2026-0007, each 5 days after its invoice date with advance notice three days before that. The amounts are the supplier invoice totals the restaurant purchase ledger holds and sum to 4,077.58 CAD. The first collection carries sequence type FRST and the other 7 carry RCUR, which is the distinction a scheme rejects a file for getting wrong.
- csvHarbour Kitchen Group: Direct debit mandate registerDirect debit mandate register for Harbour Kitchen Group. Two mandates for the same debtor account, one active and one cancelled. The active mandate has taken 8 of its 8 collections by the 2026-09-08 snapshot, 4,077.58 CAD of the 4,077.58 authorised. The cancelled mandate still shows the three collections it took before it was cancelled, because cancelling a mandate does not reverse what it already collected.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.