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.
Page 50 of 53; 24 results per page.
Donation receipts JSON for Willow Community Fund. The same 9 receipts as donation-receipts.csv with the receipt rule written out. totals.deductible is 1669.50, which is 1800.00 of gifts less 130.50 of benefits.
Donation receipts that treat a quid pro quo gift as fully deductible for Willow Community Fund. The same 9 receipts, but on the 6 rows with a benefit the deductible_amount was copied from gross_amount while value_of_benefits and benefit_description were left correct. The deductible column totals 1800.00 against the correct 1669.50, overstating the deductible amount by 130.50, which is precisely the value of benefits the same file reports.
Donation receipts with benefit split for Willow Community Fund. 9 receipts for the gifts actually received. 3 are pure gifts where deductible_amount equals gross_amount; 6 were made at a fundraising event and carry a benefit, so their deductible_amount is the gross less the fair market value of what the supporter received. Gross totals 1800.00, benefits 130.50 and deductible 1669.50. Getting this split wrong is the single most common error on a charitable receipt.
Donor summary export for Willow Community Fund. 8 supporters with their year-to-date position. pledged_total equals received_total plus outstanding_total on every row, and received_total less value_of_benefits equals deductible_total. The columns total 2850.00 pledged, 1800.00 received, 130.50 of benefits and 1669.50 deductible.
Donor summary export JSON for Willow Community Fund. The same 8 supporters as donor-export.csv, with a privacy note recording that the export deliberately carries no contact or payment data. totals.deductible is 1669.50.
Fair market value of donor benefits for Willow Community Fund. The 2 goods and services supporters received in return for a gift, with the fair market value used to reduce the deductible amount on their receipt: Workshop lunch at 18.00 on 6 receipts and Garden tote bag at 7.50 on 3. No de minimis exception is applied: every benefit is deducted, however small.
Fund balance roll-forward by restriction class for Willow Community Fund. The same money as restricted-funds-report.csv collapsed to two restriction classes and a TOTAL row. Nothing was released from restriction in the period, so the unrestricted class does not move: it opens and closes at 1200.00. The restricted class opens at 0.00, receives 6300.00, spends 4395.25 and closes at 1904.75.
Fundraising event attendance for Willow Community Fund. 4 events with attendance against a 30-person capacity, the volunteer effort behind each and the gifts received at it. Attendance runs 60.00 to 80.00 percent of capacity, no event is oversubscribed, and the benefits_given column totals 130.50, exactly the value of benefits deducted on the receipts.
Generic primary records CSV for Willow Community Fund. 3 generic records with stable primary keys. Map the documented fields before importing into another platform.
Grant budget against actual for Willow Community Fund. 10 rows: four budget lines and a Grant total for each of the 2 awarded grants. Each grant's budget lines sum to the amount awarded, 2000.00 and 2500.00, and actual spend of 4395.25 leaves 104.75 unspent. Two lines are overspent and carry a negative variance; the grant totals are still positive, which is how an overspend hides inside a grant that looks fine.
Grant register for Willow Community Fund. 3 grant applications, one per campaign. 2 were awarded in full and total 4500.00; the third is still pending and carries an awarded amount of 0.00 with no award date and no report date. Requested totals 7500.00, so 3000.00 of the ask is still undecided.
In-kind gift register for Willow Community Fund. 3 gifts of goods and services valued at 285.00 in total, each with the basis its value was arrived at. counted_as_cash is false on every row and no in-kind gift appears in restricted-funds-report.csv, donation-receipts.csv or campaign-summary.csv. That separation is the point of the file.
Intentionally invalid semantic test records for Willow Community Fund. Three independent cases report duplicate-primary-key, schema-type and foreign-key errors. JSON syntax remains valid.
Linked operating model for Willow Community Fund. 58 records across 8 linked tables; no duplicate primary keys or missing references. Pledged support=2,850.00 USD; Received support=1,800.00 USD; Outstanding pledges=1,050.00 USD.
Nonprofit reconciliation assertions for Willow Community Fund. The seven identities this set claims with the figure each must produce: 1669.50 of deductible giving, 2850.00 of scheduled pledges, 1050.00 outstanding, 4500.00 of grants, 3104.75 of closing funds, 6300.00 raised and 285.00 of in-kind value that touches no cash total. It also records the 130.50 size of the deliberate defect.
Numeric expected results for Willow Community Fund. Exact table counts, metric formulas, 3 chart points and three negative-test outcomes. Pledged support=2,850.00 USD; Received support=1,800.00 USD; Outstanding pledges=1,050.00 USD.
Operating model JSON Schema for Willow Community Fund. Draft 2020-12 schema accepts the paired operating model. Relational rules additionally require unique keys and existing foreign references.
Pledge aging at 2026-09-08 for Willow Community Fund. The 9 unpaid instalments bucketed by how overdue they are at the 2026-09-08 snapshot. Each of the three outstanding pledges has one instalment in each of the 1-30, 31-60 and 61-90 buckets, so the buckets hold 350.02, 349.99, 349.99 and total 1050.00. The bucket amounts are not round numbers because the instalment rounding put an extra cent in the youngest bucket.
Pledge instalment schedule for Willow Community Fund. 18 instalments across 12 pledges. The 9 settled pledges are single paid instalments; the 3 outstanding pledges are split into three monthly instalments due 2026-06-30, 2026-07-31, 2026-08-31. The instalments of a pledge always sum to its pledge_total: 325.00 splits 108.33, 108.33 and 108.34, so the final instalment absorbs the rounding. The schedule totals 2850.00 and the unpaid part is 1050.00.
Restricted and unrestricted fund report for Willow Community Fund. 4 funds and a TOTAL row. The general fund carries 1200.00 without donor restrictions and moves not at all in the period; the 3 campaign funds are restricted and receive 1800.00 of donations and 4500.00 of grants. Every row satisfies opening + receipts - expenditure = closing, and the funds close at 3104.75, of which 1904.75 is restricted.
Restricted fund report JSON for Willow Community Fund. The same 4 funds as restricted-funds-report.csv with the balancing rule stated and the closing balance split by restriction: 1904.75 with donor restrictions and 1200.00 without.
Volunteer hours by person for Willow Community Fund. 8 volunteers with 47 hours across 16 shifts at 4 events. Every volunteer worked exactly 2 shifts. Volunteer time is recorded in hours and is never valued in money anywhere in this set, which is deliberate: donated time is not a cash receipt and must not reach the fund report.
Allergen matrix for Willow Event Kitchen. 4 menu items across 18 columns: the fourteen listed allergens plus a count and a sources column naming the ingredient behind every Y. Derived from the recipe lines, so a dish whose recipe contains a dairy ingredient reads Y under milk. 3 of 4 dishes declare at least one allergen.
Allergen matrix missing a menu item for Willow Event Kitchen. Intentionally incomplete. 3 rows where the recipes cost 4 menu items. MENU-04 (Reception plate) has no row, although it has costed recipe lines in plate-costs.csv and sales in sales-mix-pmix.csv. Its correct row would declare: milk: Yogurt.
