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.
Contract register JSON for Tern Client Services. The same 11 agreements as an object with a contracts array. Empty CSV cells become empty strings rather than null, so a reader that treats the two as the same thing and one that does not will both produce the same record count.
Execution and signature log for Tern Client Services. 19 signature rows covering every executed document in this set. 2 rows have an empty signed_date and an empty method because the counterparty has not signed yet, and their status column says so, so a reader that treats an empty date as a parse failure and one that treats it as unsigned reach different conclusions about the same file.
Expense claim whose mileage was paid at a superseded rate for Tern Client Services. The same 6 lines as expense-claim.csv, but the three mileage amounts were computed at the superseded 0.58 per kilometre while the rate column still reads 0.62. The mileage subtotal is 136.88 where 236 km at the stated rate is 146.32, so the claim is 9.44 light and totals 212.13 instead of 221.57.
Expense claim with mileage for Tern Client Services. 6 claim lines for August: 3 mileage lines worth 146.32 and 3 receipted lines worth 75.25, 221.57 in total. amount equals quantity times rate on every line, including the mileage lines where quantity is kilometres. Each line carries the project it belongs to and a receipt reference.
Generic primary records CSV for Tern Client Services. 4 generic records with stable primary keys. Map the documented fields before importing into another platform.
Hubspot profile CSV for Tern Client Services. 8 unique records follow the documented Hubspot field subset. Strict local specification checks pass; account import and stored results are not verified.
Hubspot profile schema for Tern Client Services. 8 unique records follow the documented Hubspot field subset. Strict local specification checks pass; account import and stored results are not verified.
Intentionally invalid semantic test records for Tern Client Services. Three independent cases report duplicate-primary-key, schema-type and foreign-key errors. JSON syntax remains valid.
Invoice register JSON for Tern Client Services. The same 3 invoices as invoice-register.csv with the settlement rule stated: the retainer is drawn while a balance remains and the remainder is billed. totals.outstanding is 3200.00.
Invoice register with retainer draws for Tern Client Services. 3 invoices totalling 7200.00, which is the whole of the August timesheet. 4000.00 of it was settled by drawing the retainer to nil and 3200.00 is outstanding on SVCINV-3. amount equals retainer_applied plus cash_due on every row, and every invoice is dated 2026-09-30, 22 days after the 2026-09-08 snapshot, so all three sit in the not yet due bucket.
Linked operating model for Tern Client Services. 98 records across 9 linked tables; no duplicate primary keys or missing references. Total deal value=34,500.00 USD; Weighted deal value=15,825.00 USD; Recorded activity time=720.00 minutes.
Mileage log for Tern Client Services. 3 client trips totalling 236 km. amount equals distance_km times rate_per_km on every row at the 0.62 per kilometre MIL rate from fee-schedule.csv, and the column sums to 146.32. Each trip names the project it was made for, so the mileage allocates cleanly to the three projects.
Obligation register for Tern Client Services. 14 obligations pulled out of the three agreements, each naming the contract, the exact clause it comes from, who owns it, what triggers it and when it falls due. Every clause_ref resolves to a row of contract-clause-index.csv.
Payee register for Tern Client Services. All 3 contractor payees with the certificate each has on file and the information return each one gets. Payments sum to 4,320.00 USD, which is every recorded hour at 60.00 USD, but they split 2,880.00 to 1099-NEC shaped slips and 1,440.00 to a 1042-S shaped statement, so no single information return file totals the ledger.
Professional fee schedule for Tern Client Services. Five rate codes. STD at 100.00 per hour is the only billing rate any time entry uses, which is why every row of timesheet-export.csv carries 100.00; OOH and TRV are defined but unused in this period and carry used_this_period false. MIL at 0.62 per kilometre is the mileage rate mileage-log.csv applies and COST at 58.00 per hour is the internal rate project-profitability.csv uses.
Professional services reconciliation assertions for Tern Client Services. The six identities this set claims with the figure each must produce: 7200.00 of billable time, the same amount invoiced, a retainer closing at 0.00, a work-in-progress roll-forward closing at 0.00, 221.57 of expenses and 9000.00 of won deals. It also records the 9.44 size of the deliberate defect.
Project profitability for Tern Client Services. 3 projects and a TOTAL row. revenue_billed is the invoiced value, labour_cost is hours times the 58.00 internal COST rate, expenses is the claim allocated by project, and gross_margin is revenue minus the two costs. Total revenue 7200.00 less total cost 4397.57 gives 2802.43, a margin of 38.92 percent.
Quote export for Tern Client Services. 12 quotes, one per deal, each for the deal amount. 3 are accepted and total 9000.00, the same figure as the won deals on pipeline-export.csv; the remaining 9 are open. Every quote expires on 2026-09-30, 30 days after it was issued.
Rate card and caps for Tern Client Services. 5 priced terms drawn from the agreements in this set: the 100.00 USD client billing rate, the 60.00 USD contractor pay rate, both expense caps with the dates that separate them, and the 9,000.00 USD liability cap. Every row names the clause it comes from.
Renewal and notice diary for Tern Client Services. 8 dated events in ascending order, each with the number of days from the fixed snapshot of 2026-09-08. The first is 2026-09-18 at 10 days and the last is 2028-11-09 at 793 days. Every date also appears in contract-register.csv, so the diary can be rebuilt from the register and compared.
Retainer ledger for Tern Client Services. A three-line retainer account: a 4000.00 deposit received on 2026-07-28 and two draws of 1600.00 and 2400.00 applied when SVCINV-1 and SVCINV-2 were raised. The running balance closes at 0.00, which is why SVCINV-3 is billed for payment rather than drawn.
Sales activity export for Tern Client Services. 24 logged activities over 2026-08-01 to 2026-08-24 across three types. Minutes total 720, which is 12 hours, and every deal_id resolves in pipeline-export.csv. This is recorded sales effort and is deliberately separate from the billable time in timesheet-export.csv, which none of it appears in.