Shared Lab · Three synthetic cases
Three synthetic finance workflows with every rule and output in view.
The Lab reconstructs expense aging, FX close calculations, and order reporting from a two-week cross-company iResearch assignment. Choose a record or rate to see the source, fixed rule, exception, calculation, and resulting output.
Internal pilot formatCo-developedFully synthetic dataNo production-adoption claim
Build-time results
The bundled fixture produces these three checked outputs.
These numbers come from the bundled synthetic fixture. They are not usage, adoption, or business-impact metrics.
01 · Expense aging and reminders
Why each record is included or excluded.
12-field source→Rule controls→9-field output
Select an included or excluded record to trace status, period scope, aging threshold, ownership, and the exact reminder row emitted. Excluded records show the rule that stopped them.
Included5 records
Excluded4 records
Decision trace
SYN-EXP-101
Workflow complete > 3 days. The record was routed to Avery Chen.
- Source rows
- 1
- Source status
- workflow complete
- Submitted
- 2026-06-21
- Source amount
- 1,240 CNY
- Company
- Northline Studio LLC
- As-of date
- 2026-06-26
Evidence preview
9-column reminder output
| Reminder Target | Owner | Trigger | Record ID | Order Type | Billing Period | Unpaid Amount | Aging | Reminder Message |
|---|---|---|---|---|---|---|---|---|
| Accounting reviewer | Avery Chen | Workflow complete > 3 days | SYN-EXP-101 | Rail travel | — | 1,240 | 5 days stagnant | Please review SYN-EXP-101; the workflow has been complete for 5 days. |
02 · FX close calculation receipt
How was each synthetic close rate recomputed?
Frozen quotes→Normalize→15 populated fields
Choose one of six rows to inspect raw and normalized inputs, conversion direction, path, formula, inverse checks, and the A–P template preview. This is not a live-rate service.
Calculation receipt
CNY→USD · Ending
PathCNY → USD
Formula
0.1388888888888889Unrounded result0.1388888889
Inverse check1
Current synthetic inputs
Raw1 USD = 7.2 CNY
Normalized1 USD = 7.2 CNY
DirectionCNY→USD · reciprocal
Prior synthetic inputs
Raw1 USD = 7.1 CNY
Normalized1 USD = 7.1 CNY
DirectionCNY→USD · reciprocal
Reference format
15 populated fields + visual spacer N
| AFrom Currency | BTo Currency | CCurrent Date | DCurrent Type | ECurrent Rate | FCurrent Inverse | GCurrent Note | HCurrent Check | IPrevious Date | JPrevious Type | KPrevious Rate | LPrevious Inverse | MPrevious Note | NReview spacer | ODelta | PDelta % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CNY | USD | 2026-06-30 | Ending | 0.1388888889 | 7.2 | Synthetic inverse from the USD/CNY close | 1 | 2026-05-29 | Ending | 0.1408450704 | 7.1 | Frozen synthetic prior close | — | -0.001956181534 | -1.388888889% |
03 · Order report automation
How two source files become four reconciled reports.
2 sources→Derive + aggregate→4 report tabs
Signed Orders and Opportunities are validated, deduplicated, derived, aggregated by business unit, and reconciled before the four fixed report views are displayed.
Source 01
2Signed Orders rowsActuals, agency split, and cross-year flagSource 02
5Opportunity rowsPipeline, month normalization, and Q3/H2 riskControl
7Rows reconciledInclusive = excluding agency + agencyReport preview
Net Sales
| Business Unit | Signed Actual | Opportunity Pipeline | Combined View | Q3 High-Risk Pipeline | H2 High-Risk Pipeline |
|---|---|---|---|---|---|
| Fieldstone | 0 | 210 | 210 | 0 | 0 |
| Northline | 720 | 800 | 1,520 | 800 | 480 |
| Westhaven | 460 | 650 | 1,110 | 0 | 650 |
| Grand Total | 1,180 | 1,660 | 2,840 | 800 | 1,130 |
Reconciliation receipt
Inclusive value = excluding agency + agency
- Rows checked
- 7
- Inclusive total
- 3,660,000 CNY
- Excluding agency
- 3,205,000 CNY
- Agency
- 455,000 CNY
- Total difference
- 0 CNY