Skip to content
Testaroo

Explore the test library

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.

1255 results

Page 47 of 53; 24 results per page.

Show the canonical directory
Preview of Tern Client Services: Contract register JSON
json
5.9 KB
Actual file preview for Tern Client Services: Contract register JSON

Tern Client Services: Contract register JSON

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.

File
JSON · Contracts Agreements · 11 records
Use case
Data importJSON parsing· Paired fixture
Preview of Tern Client Services: Execution and signature log
csv
2.2 KB
Actual file preview for Tern Client Services: Execution and signature log

Tern Client Services: Execution and signature log

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.

File
CSV · Contracts Agreements · 19 rows
Preview of Tern Client Services: Expense claim whose mileage was paid at a superseded rate
csv
747 B
Actual file preview for Tern Client Services: Expense claim whose mileage was paid at a superseded rate

Tern Client Services: Expense claim whose mileage was paid at a superseded rate

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.

File
CSV · Professional Services Billing · 6 rows
Preview of Tern Client Services: Expense claim with mileage
csv
747 B
Actual file preview for Tern Client Services: Expense claim with mileage

Tern Client Services: Expense claim with mileage

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.

File
CSV · Professional Services Billing · 6 rows
Use case
Data import· Conversion set
Preview of Tern Client Services: Generic primary records CSV
csv
170 B
Actual file preview for Tern Client Services: Generic primary records CSV

Tern Client Services: Generic primary records CSV

Generic primary records CSV for Tern Client Services. 4 generic records with stable primary keys. Map the documented fields before importing into another platform.

File
CSV · Business Kits · 4 rows
Use case
Data import
Preview of Tern Client Services: Hubspot profile CSV
csv
295 B
Actual file preview for Tern Client Services: Hubspot profile CSV

Tern Client Services: Hubspot profile CSV

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.

File
CSV · Business Kits · 8 rows
Use case
Data import
Preview of Tern Client Services: Hubspot profile schema
json
1 KB
Actual file preview for Tern Client Services: Hubspot profile schema

Tern Client Services: Hubspot profile schema

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.

File
JSON · Business Kits · 8 rows
Use case
Data import
Preview of Tern Client Services: Invoice register JSON
json
1.7 KB
Actual file preview for Tern Client Services: Invoice register JSON

Tern Client Services: Invoice register JSON

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.

File
JSON · Professional Services Billing · 3 rows
Use case
Data import· Conversion set
Preview of Tern Client Services: Invoice register with retainer draws
csv
482 B
Actual file preview for Tern Client Services: Invoice register with retainer draws

Tern Client Services: Invoice register with retainer draws

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.

File
CSV · Professional Services Billing · 3 rows
Use case
Data import· Conversion set
Preview of Tern Client Services: Linked operating model
json
23.7 KB
Actual file preview for Tern Client Services: Linked operating model

Tern Client Services: Linked operating model

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.

File
JSON · Business Kits · 98 records
Use case
Data import
Preview of Tern Client Services: Mileage log
csv
298 B
Actual file preview for Tern Client Services: Mileage log

Tern Client Services: Mileage log

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.

File
CSV · Professional Services Billing · 3 rows
Use case
Data import· Conversion set
Preview of Tern Client Services: Numeric expected results
json
2 KB
Actual file preview for Tern Client Services: Numeric expected results

Tern Client Services: Numeric expected results

Numeric expected results for Tern Client Services. Exact table counts, metric formulas, 4 chart points and three negative-test outcomes. Total deal value=34,500.00 USD; Weighted deal value=15,825.00 USD; Recorded activity time=720.00 minutes.

File
JSON · Business Kits
Use case
Data import
Preview of Tern Client Services: Obligation register
csv
1.8 KB
Actual file preview for Tern Client Services: Obligation register

Tern Client Services: Obligation register

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.

File
CSV · Contracts Agreements · 14 rows
Use case
Data importCSV parsing· Conversion set
Preview of Tern Client Services: Operating model JSON Schema
json
21.6 KB
Actual file preview for Tern Client Services: Operating model JSON Schema

Tern Client Services: Operating model JSON Schema

Operating model JSON Schema for Tern Client Services. Draft 2020-12 schema accepts the paired operating model. Relational rules additionally require unique keys and existing foreign references.

File
JSON · Business Kits
Use case
Data import
Preview of Tern Client Services: Payee register
csv
533 B
Actual file preview for Tern Client Services: Payee register

Tern Client Services: Payee register

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.

File
CSV · Tax Filings · 3 rows
Use case
Data importCSV parsing· Conversion set
Preview of Tern Client Services: Professional fee schedule
csv
562 B
Actual file preview for Tern Client Services: Professional fee schedule

Tern Client Services: Professional fee schedule

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.

File
CSV · Professional Services Billing · 5 rows
Use case
Data import
Preview of Tern Client Services: Professional services reconciliation assertions
json
1.8 KB
Actual file preview for Tern Client Services: Professional services reconciliation assertions

Tern Client Services: Professional services reconciliation assertions

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.

File
JSON · Professional Services Billing · UTF-8
Use case
Data import
Preview of Tern Client Services: Project profitability
csv
420 B
Actual file preview for Tern Client Services: Project profitability

Tern Client Services: Project profitability

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.

File
CSV · Professional Services Billing · 4 rows
Use case
Data import
Preview of Tern Client Services: Quote export
csv
873 B
Actual file preview for Tern Client Services: Quote export

Tern Client Services: Quote export

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.

File
CSV · Professional Services Billing · 12 rows
Use case
Data import
Preview of Tern Client Services: Rate card and caps
csv
658 B
Actual file preview for Tern Client Services: Rate card and caps

Tern Client Services: Rate card and caps

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.

File
CSV · Contracts Agreements · 5 rows
Preview of Tern Client Services: Renewal and notice diary
csv
754 B
Actual file preview for Tern Client Services: Renewal and notice diary

Tern Client Services: Renewal and notice diary

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.

File
CSV · Contracts Agreements · 8 rows
Preview of Tern Client Services: Retainer ledger
csv
210 B
Actual file preview for Tern Client Services: Retainer ledger

Tern Client Services: Retainer ledger

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.

File
CSV · Professional Services Billing · 3 rows
Use case
Data import
Preview of Tern Client Services: Sales activity export
csv
1.1 KB
Actual file preview for Tern Client Services: Sales activity export

Tern Client Services: Sales activity export

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.

File
CSV · Professional Services Billing · 24 rows
Use case
Data import