Task inventory · 187 desk · 20 build

Tasks

Every task is public in the repository with its generator, workspace, checks, and reference solution. The ask is written the way a non-technical owner would type it; the files are messy on purpose. Author notes and planted traps are kept out of these pages, but they are in the repo.

This is an exposed task set, not a sealed holdout. Each generator takes a seed, so a re-rolled variant with different names and amounts can be produced for a private evaluation. See the contamination note.

Desk track

"Passes" counts frozen-scorer passes across 2 systems × three repetitions in the complete desk comparison.

Spreadsheet · 41 tasks · reconciled, calculated, or reshaped workbook

Task	Deliverables	Checks	Passes / 6
Spring no-show rates by tutor under the 24-hour policy appointment-no-shows	no_show_rates.csv	4	6
Material cost per product from the bill of materials bom-cost-rollup	assembly_costs.xlsx	8	4
First-half budget vs actual, line by line budget-vs-actual	variance.xlsx	9	6
Normalize the catalog sizes for the new POS catalog-normalize-units	catalog_clean.csv	6	6
Fall to spring enrollment, adds and drops by course class-roster-changes	roster_changes.csv	6	6
Q3 hours per client project, billable and not client-hours-by-project	client_hours.csv	7	6
Weekly hours audit from time-clock punches clock-punch-audit	hours_audit.csv	4	6
August sales commissions with refund recoveries commission-calculation	commissions.xlsx	7	5
Lifetime value per customer from the shop export customer-value-summary	customer_value.csv	6	6
Per-donor giving totals for 2024 and 2025 donor-totals-by-year	donor_totals.csv	5	6
Find bills that were entered twice before the check run duplicate-invoice-finder	possible_duplicates.csv	7	6
Door list for the author evening event-attendee-merge	attendees.csv	7	5
Monthly miles per van for the insurer fleet-mileage-monthly	mileage.csv	4	6
Final weighted grades for the bookkeeping course gradebook-weighted	grades.xlsx	4	5
Reconcile the physical count against the system stock inventory-count-reconcile	variances.csv	5	4
Stock valued at cost by department for the accountant inventory-valuation	valuation.xlsx	8	6
Q2 leads and won revenue by marketing source lead-source-rollup	lead_sources.csv	5	6
October renewal letters and the lapsed list membership-renewals	renewals.csv	5	6
Cost out the fall menu, plate by plate menu-cost-sheet	menu_costs.xlsx	6	6
First-half sales in dollars across three currencies multi-currency-sales	sales_usd.xlsx	7	6
What is still coming on our purchase orders open-purchase-orders	open_po_lines.csv	5	6
Apply the supplier's price letter to our master price list price-list-update	price_list_2026.xlsx	6	6
How the August promo codes did promo-code-analysis	promo_summary.csv	6	5
October rent roll for the bank rent-roll-build	rent_roll.xlsx	5	5
Days out per machine per month for the insurer rental-utilization	utilization.csv	5	6
This week's reorder list for the bike shop reorder-list	reorder.csv	4	6
Rep by month sales table from the invoice export sales-pivot-by-rep	sales_by_rep.xlsx	7	4
Sales tax on each September order sales-tax-by-address	orders_tax.csv	5	6
How short the published week is against minimum coverage shift-coverage-gaps	coverage_gaps.csv	4	6
Work out what the carrier should charge per order shipping-rate-lookup	orders_shipping.csv	6	5
Move the shop inventory onto the new SKUs sku-crosswalk-migration	catalog_new.csv	6	6
One staff directory from HR and IT staff-directory-merge	directory.csv	6	6
September billable utilization per person staff-utilization	utilization.xlsx	9	2
Active subscribers and cancellations by month subscription-status-monthly	subscriptions.xlsx	5	3
Metric supplier price list into our inch-and-pound catalog supplier-catalog-imperial	catalog_us.csv	7	6
Member survey scores per question survey-tally	survey_summary.csv	5	6
Find double-booked tables in the reservations table-double-bookings	conflicts.csv	5	6
Consolidate the crew timesheets for payroll timesheet-consolidate	hours.csv	5	6
Merge the purchasing and accounting vendor lists vendor-contact-merge	vendors.csv	6	6
Year-to-date spend by vendor and category vendor-spend-categories	vendor_spend.xlsx	8	3
Equipment warranties running out in the next 90 days warranty-expiry-list	expiring_warranties.csv	4	6

Bookkeeping · 36 tasks · reconciliation, schedule, transaction classifications

Task	Deliverables	Checks	Passes / 6
Payables aging by vendor for the line of credit review ap-aging	ap_aging.xlsx, memo.md	12	2
August bank reconciliation for the checking account bank-reconciliation	reconciliation.xlsx	6	5
Code August company-card charges to the ledger by item type card-expense-coding	coded.csv, review.csv	7	6
August cash drawer variance by day cash-drawer-variance	drawer_variance.csv	6	6
Chargeback tracker with evidence deadlines chargeback-tracker	chargebacks.csv	7	4
Commission clawbacks on refunded deals since June commission-clawbacks	clawbacks.csv	6	6
Turn September returns into credit notes and apply them credit-notes-apply	credit_notes.csv, invoice_balances.csv	6	6
2026 deferred revenue schedule for the annual plans deferred-revenue-schedule	deferred_revenue.xlsx	9	4
2026 depreciation schedule from the fixed asset register depreciation-schedule	depreciation.xlsx	9	6
Find supplier payments we made twice duplicate-payments	duplicate_payments.csv	6	6
Categorize card transactions per policy, with thread overrides expense-categorize	categorized.csv	3	5
Audit August expense reports against the travel policy expense-report-audit	violations.csv	5	6
First-half FIFO cost of goods sold fifo-cogs	cogs.xlsx	9	4
Realized FX gain or loss on the euro invoices fx-invoice-gains	fx_results.csv	5	4
Gift card liability per card at year end gift-card-liability	gift_cards.csv	6	6
Grant budget tracking for the board packet grant-budget-tracking	grant_tracking.xlsx	8	6
Shrinkage by department from the Sunday floor count inventory-shrinkage	shrinkage.xlsx	9	6
Check the gym loan's interest and principal split loan-schedule-check	loan_check.xlsx	6	6
Apply today's lockbox checks to open invoices lockbox-apply	applied.csv, unapplied.csv	6	6
August mileage reimbursement for the field staff mileage-reimbursement	reimbursement.csv	5	6
August accrual entry for the theatre month-end-accruals	accruals.csv	5	6
Match bank payments to open invoices payments-match	unpaid.csv	4	6
Match bank payments to open invoices, with card fees, short wires, and a wrong reference payments-match-v2	unapplied.csv, unpaid.csv	6	6
Journal entry for the 4 September payroll payroll-journal-entry	payroll_je.csv	5	6
Federal payroll tax deposits and due dates since the provider stopped payroll-tax-deposits	deposits.csv	5	6
Reconcile the front desk petty cash and code the top-up petty-cash-reconcile	petty_cash.xlsx	8	6
Catch-up prorations for February to April plan changes plan-change-proration	prorations.csv	5	6
2026 prepaid expense amortization schedule prepaid-amortization	prepaids.xlsx	8	6
West Gallery budget burn for the capital committee project-budget-burn	burn.xlsx	9	6
Reconcile August refunds to the card processor refund-reconciliation	refund_recon.csv	6	5
Second-quarter sales tax due by local jurisdiction sales-tax-liability	tax_liability.csv	6	6
Allocate August overhead to departments shared-cost-allocation	allocation.xlsx	9	6
August resident balances with late fees tenant-ledger-balances	tenant_balances.csv	5	6
Split last week's tip pool by shift tip-pooling	tip_distribution.csv	4	5
2025 reportable totals per vendor, cards and corporations out vendor-1099-totals	vendor_totals.csv	5	3
Tie out the Keystone supply statement to our books vendor-statement-reconcile	vendor_recon.csv	6	6

Reports · 30 tasks · data summary and source-grounded memo

Task	Deliverables	Checks	Passes / 6
Receivables aging at month end for the bank ar-aging-report	aging.xlsx, memo.md	9	4
Cost per lead by channel for the quarter campaign-cpl-report	cpl.xlsx	9	6
Money in and out by month for the bank meeting cash-flow-monthly	cashflow.xlsx, memo.md	10	4
Visits per provider and the no-show rate for Q1 clinic-visits-summary	visits.xlsx	8	3
First-half complaints by category and month complaints-summary	complaints.xlsx, memo.md	8	6
On-time delivery by hub, and why the late ones were late delivery-performance	delivery.xlsx	8	4
Q2 expenses by department against budget dept-expense-report	dept_expenses.xlsx, memo.md	10	4
FY2026 fundraising figures for the board donor-annual-figures	annual_figures.xlsx, memo.md	10	2
Monthly electricity by building from meter reads energy-usage-sites	energy.xlsx, memo.md	10	4
Wrap-up numbers for the summit event-postmortem	event_summary.xlsx, memo.md	10	6
Cost per mile per vehicle for the first half fleet-cost-per-mile	fleet_costs.xlsx	9	6
May helpdesk tickets by category and SLA breaches helpdesk-tickets-report	memo.md, tickets_report.xlsx	8	3
Half-year safety incidents by site and type incident-summary	incidents.xlsx, memo.md	9	5
August menu items ranked by sales and margin menu-item-performance	menu_performance.xlsx	7	5
Monthly revenue report by region from a messy sales export monthly-report	memo.md, report.xlsx	11	5
Monthly revenue report by region from a messy sales export monthly-report-v9	memo.md, report.xlsx	11	4
MRR by month and churn for the first half mrr-report	memo.md, mrr.xlsx	9	2
Q1 occupancy per cabin per month occupancy-report	occupancy.xlsx	8	6
2025 payroll by quarter for the accountant payroll-quarterly-summary	payroll_q.xlsx	9	6
First-half purchasing savings by category procurement-savings	savings.xlsx	8	6
August yield and scrap by production line production-yield	yield.xlsx	9	3
Margin by job, with the loss-makers flagged project-margin	margins.xlsx, memo.md	10	6
Q3 wholesale sales by product, with the odd things called out quarterly-sales-report	memo.md, q_report.xlsx	10	5
Q2 sales by territory from the monthly exports regional-sales-monthly	memo.md, regional.xlsx	9	5
Customer cohort retention table for the first half retention-cohorts	cohorts.xlsx	8	4
Q2 return rate by product and reason returns-analysis	returns.xlsx	10	4
Spring tuition collected and outstanding by program tuition-collections	collections.xlsx	8	4
Volunteer hours per program for the county volunteer-hours	volunteer_hours.csv	7	6
Spring website traffic by month, crawler taken out web-traffic-summary	memo.md, traffic.xlsx	8	6
One-page weekly KPIs from five system exports weekly-kpi-dashboard	kpi.xlsx	8	3

Reformatting · 26 tasks · destination-compatible import file

Task	Deliverables	Checks	Passes / 6
Clean the catalog mailing list for the mail house address-standardize	addresses_clean.csv	5	6
Build the Amazon inventory upload from the product sheet amazon-inventory-loader	amazon_inventory.csv	8	6
Restate this year's GL lines on the new chart of accounts chart-of-accounts-remap	remapped.csv	6	6
2025 1099-NEC recipients into the e-file service's import file contractor-1099-list	1099_vendors.csv	6	6
Clean a legacy customer export for HubSpot import customer-dedupe	hubspot_import.csv	5	6
Load the concert sign-ups into Eventbrite eventbrite-attendee-import	eventbrite_attendees.csv	6	6
Move the office phone list into Google Contacts google-contacts-import	google_contacts.csv	7	6
Build the Gusto employee upload from the HR roster gusto-employee-import	gusto_employees.csv	8	6
Import the roofing pipeline into HubSpot deals hubspot-deals-import	hubspot_deals.csv	7	6
Fall attendance grid for the district grant long-to-wide-attendance	attendance_grid.csv	5	6
Summer signups into one Mailchimp audience import mailchimp-audience-import	mailchimp_import.csv	6	6
Split the tracker notes into Pipedrive activities notes-to-activities	activities.csv	5	4
Convert the CRM contact phones to the new phone system's import file phones-to-e164	contacts_e164.csv	7	6
Load the fall menu into the new POS with modifiers pos-menu-import	pos_menu.csv	6	6
CRM accounts into a QuickBooks Online customer import quickbooks-customer-import	qbo_customers.csv	9	6
Turn the Q3 leads sheet into a Salesforce lead import salesforce-lead-import	sf_leads.csv	8	6
Fall class schedule as a calendar file for the website schedule-to-ics	schedule.ics	5	6
Fall catalog into Shopify's product import shopify-product-import	shopify_products.csv	10	5
Load the stock count into Square's item import square-inventory-import	square_items.csv	7	6
Build the Stripe customer import from the old billing export stripe-customer-import	stripe_customers.csv	7	6
Flatten the nested fall catalog into the inventory platform's variant import variants-flatten	variants_flat.csv	7	6
Reshape the by-month sales report for the planning tool upload wide-to-long-sales	sales_long.csv	5	6
Turn August web store orders into journal entries woocommerce-orders-to-journal	journal.csv	5	6
August job invoices into Xero's sales invoice import xero-sales-invoices-import	xero_invoices.csv	6	5
September checking transactions into YNAB ynab-transactions-import	ynab.csv	6	6
Import client contacts as Zendesk users zendesk-users-import	zendesk_users.csv	6	6

Extraction · 26 tasks · structured records extracted from documents

Task	Deliverables	Checks	Passes / 6
Key the July and August bank statements into the transactions file bank-statement-pdf	transactions.csv	7	6
CRM contacts from the scanned expo business cards business-cards-scanned	contacts.csv	8	5
August transactions from the company card statements card-statements-pdf	card_transactions.csv	7	6
Side-by-side table of the anniversary dinner catering quotes catering-quotes-table	quote_comparison.csv	9	6
Pull key terms from our service contracts into a register contract-key-terms	contracts.csv	8	6
Applicant list from the operations coordinator resumes cv-batch-extraction	candidates.csv	7	6
Log this year's grant award letters into the tracker grant-award-letters	grants.csv	8	6
Open findings from this season's inspection reports inspection-findings	findings.csv	7	6
Log vendor insurance certificates and flag lapsed policies insurance-certificates	coi.csv	8	6
Abstract the plaza leases for the lender lease-abstracts	lease_abstracts.csv	10	5
Match this week's packing slips to the open POs packing-slips-vs-po	receipts.csv	7	6
Key the August pay stubs for the CPA pay-stubs-extraction	pay_stubs.csv	9	6
Match the scanned field trip slips to the class roster permission-forms-scanned	consents.csv	9	4
Log this year's property tax bills property-tax-bills	tax_bills.csv	8	6
Key this week's customer POs into order entry purchase-orders-pdf	po_lines.csv	8	6
Compare three laptop quotes (USD/EUR, hidden fees) and recommend one quote-comparison	comparison.xlsx, recommendation.md	7	6
Expense table from scanned trip receipts receipts-scanned	expenses.csv	7	6
Shipment weights and costs from last week's manifests shipment-manifests	shipments.csv	7	6
Key this week's superbills for charge entry superbill-codes	superbill_lines.csv	8	6
Key August supplier bills into the AP import file supplier-invoices-to-csv	invoice_lines.csv	9	2
Third-quarter ledger from the landlord statements tenant-statements	tenant_ledger.csv	7	0
Daily hours from the scanned caregiver time sheets timesheets-scanned	timesheet_hours.csv	6	6
Monthly usage and charges from the utility bills utility-bills-extraction	utility_usage.csv	8	6
Load the fall supplier price sheets for the ordering guide vendor-price-sheets	prices.csv	8	4
Log new vendors' tax forms with masked TINs vendor-tax-forms	vendor_tax.csv	10	5
Key the September venue invoices into job costing venue-invoices	venue_lines.csv	10	6

Drafting · 19 tasks · business text preserving required facts and rules

Task	Deliverables	Checks	Passes / 6
Renewal summary for the Wi-Fi services contract contract-renewal-summary	renewal_summary.md	5	5
Announcement for the wine club harvest dinner event-announcement	announcement.md	6	6
Website FAQ from the summer support tickets faq-from-tickets	faq.md	8	6
Fall appeal letter for the Hatch Farm campaign fundraising-appeal	appeal.md	4	6
Formal incident report for the Line 3 injury incident-report	incident_report.md	7	5
Q2 investor update letter from the KPI tracker investor-update	update.md	7	3
Write the front desk coordinator job posting job-posting-from-notes	posting.md	8	6
Water shutoff notices for the riser valve work maintenance-notices	notices/[Aa][Ss][Pp][Ee][Nn], notices/[Bb][Ii][Rr][Cc][Hh], notices/[Cc][Yy][Pp][Rr][Ee][Ss][Ss], notices/[Dd][Oo][Gg][Ww][Oo][Oo][Dd]	5	6
Minutes from the leadership meeting recording minutes-from-transcript	minutes.md	4	3
Welcome email for the new project engineer onboarding-welcome-email	welcome.md	5	5
Write this month's past-due reminders overdue-reminders	reminders/.md, reminders/[Dd][Oo][Rr][Ss][Ee][Yy], reminders/[Rr][Ee][Dd][Ww][Oo][Oo][Dd], reminders/[Yy][Ee][Ll][Ll][Oo][Ww][Tt][Aa][Ii][Ll]*	5	3
Memo to the crews on the 2026 policy changes policy-update-memo	memo.md	7	4
Draft the standing order price increase notice price-increase-notice	notice.md	9	2
Write up the warehouse lighting proposal proposal-from-notes	proposal.md	8	5
Reply to a customer about a cracked skillet refund-apology-letter	response.md	5	2
Request for quotation for the rolling bench parts rfq-email	rfq.md	4	6
Schedule change notices for next week's revised rota schedule-change-notices	notices/[eE][dD][wW][aA][rR][dD][wW][aA][rR][dD], notices/[jJ][oO][sS][hH][uU][aA][sS][cC][oO][tT][tT], notices/[kK][aA][rR][eE][nN][aA][lL][lL][eE][nN], notices/[rR][yY][aA][nN][yY][oO][uU][nN][gG], notices/[sS][tT][eE][pP][hH][aA][nN][iI][eE][rR][aA][mM][oO][sS]*	6	6
Turn the refunds email thread into a counter procedure sop-from-thread	procedure.md	6	4
Dispute letter for a supplier invoice that does not match the PO supplier-dispute-letter	dispute.md	6	3

Tooling · 9 tasks · small file-based tool or static page

Task	Deliverables	Checks	Passes / 6
Conference schedule page for the lobby screen event-schedule-page	index.html	4	5
Boat campaign progress page with top donors fundraiser-progress-page	index.html	5	5
Stock page for the workshop tablet inventory-tracker-page	index.html	5	6
August operations scorecard page kpi-scorecard-page	index.html	5	4
Fall menu page with allergens for the QR code menu-page-allergens	index.html	5	6
This week's orders page for the packing bench orders-status-page	index.html	5	5
Fall wholesale price list page for shop buyers price-list-page	index.html	5	4
Kitchen job task board for the crew wall project-status-board	index.html	5	5
Staff directory page for the backstage screen team-directory-page	index.html	4	5

Build track

Each pack: an owner's requirement, seed CSV exports to import, a binary acceptance checklist that opens with the 14-item enterprise baseline, and three change requests. No build scores are published; the packs are released and validated.

Application	Seed files	Checklist items	Change items
IT asset register with padded tags, assignment history, warranty alerts, disposal rules, and site-scoped access asset-tracking	assets.csv, assignments.csv	26	9
Physiotherapy clinic scheduling app with double-booking rules, no-show tracking, recall list, and utilization clinic-scheduling	patients.csv, roster.csv, appointments.csv	26	9
B2B sales CRM with accounts, contacts, a staged deal pipeline, weighted forecast, and activity log crm-sales-pipeline	accounts.csv, contacts.csv, deals.csv	26	9
Donor management app with household dedupe, pledges and balances, acknowledgement letters, and program-scoped access donor-management	donors.csv, gifts.csv, pledges.csv	26	9
Conference workshop registration with room capacity, waitlist promotion, badges, and chair-scoped access event-registration	rooms.csv, sessions.csv, registrations.csv	26	9
Expense claims app with receipt and policy-limit rules, manager approval, and reimbursement batches expense-claims	employees.csv, expense_policy.csv, claims.csv	26	9
Managed-service helpdesk with client contacts, first-reply promises, escalation, and agent and client scoping helpdesk-tickets	clients.csv, contacts.csv, tickets.csv	26	9
HVAC field-service app with customers, jobs, technicians, parts, and invoicing hvac-field-service	customers.csv, parts.csv	31	9
Multi-warehouse inventory app with transfers, reasoned adjustments, reorder alerts, and stock valuation inventory-multi-location	items.csv, stock.csv	26	9
Leave tracking with team approvals, working-day balances, holidays, and overlap warnings leave-tracking	staff.csv, leave_requests.csv, holidays.csv	26	9
Fitness club memberships with renewals, freezes, door check-ins, and trainer-scoped access memberships-club	members.csv, checkins.csv	26	9
Retail and wholesale order management with tax and shipping rules, stock on ship, and backorders order-management	customers.csv, products.csv, order_lines.csv	26	9
Back office for two cafes with menu items, modifiers, nightly cash-ups, item performance, price-change audit, and a dashboard point-of-sale-backoffice	items.csv, modifiers.csv, daily_takings.csv, item_sales.csv	26	9
Maintenance app for six apartment buildings with work requests, work orders, vendors, approvals, and a dashboard property-maintenance	units.csv, tenants.csv, vendors.csv, work_requests.csv	26	9
School district purchase requests with amount-based two-step approval, budget lines, and PO numbers purchase-requests-approvals	budgets.csv, vendors.csv, requests.csv	26	9
Quoting app for a custom furniture maker with margin floor, discount approval, and quote-to-order conversion quoting-tool	products.csv, materials.csv, quotes.csv	26	9
Hiring app for a growing company with roles, candidates, stages, interviews, offer approvals, and a dashboard recruiting-pipeline	roles.csv, candidates.csv	26	9
Consultancy time tracking with rate cards, rounding, monthly invoicing, and locked entries time-tracking-invoicing	clients.csv, rates.csv, time_entries.csv	26	9
Vendor onboarding app with document checklists, approval stages, and insurance alerts vendor-onboarding	vendors.csv, documents.csv	26	9
Work orders against bills of materials for a small manufacturer, with availability checks, stock moves, WIP, and a dashboard work-orders-bom	parts.csv, boms.csv, work_orders.csv	26	9

Task format and authoring rules: docs/task-format.md, desk authoring guide, build authoring guide.