The largest single-category fidelity gap in most wealth-tech mock data is the cross-border layer. A test corpus that's calibrated against US-resident, USD-denominated, single-country households will work fine for a domestic robo-advisor or a single-state RIA platform — and will fail the moment the platform has to handle an expat buyer, an inbound foreign-national customer, an employee on international assignment, or a US household with international holdings. Cross-border wealth is the long tail that turns out to be substantially larger than the head when you count the number of edge cases.
This theme covers what realistic synthetic test data looks like for the cross-border use case: multi-currency portfolios, PFIC tracking, treaty-tier withholding and foreign tax credits, FBAR and FATCA reporting, cross-border equity compensation, and the worldwide-income complications that domestic-only platforms underhandle.
Why cross-border is its own data problem
Cross-border wealth is structurally different from domestic wealth in three ways, each of which independently breaks domestic-only test data:
-
Worldwide income. US citizens and resident aliens are taxed on worldwide income regardless of where it's earned, where the assets are held, or where the income is paid. Non-resident aliens are taxed on US-source income only, but with rules that frequently surprise both the customer and the platform. Domestic-only test data has implicit US-source-only income, which is wrong for any cross-border household.
-
Multi-currency value chains. A non-USD-denominated holding has both a local-currency value and a USD-translated value, and the two move independently. A position-level test corpus that stores only USD values cannot exercise the currency-translation, FX-attribution, or hedge-overlay code paths that any multi-currency platform requires.
-
Reporting overlay. Cross-border households trigger an additional set of US filing obligations — FBAR (Form 114), FATCA (Form 8938), CFC (Form 5471), PFIC (Form 8621), passive foreign company reporting (subpart F, GILTI), foreign tax credit (Form 1116) — that don't exist for domestic-only households. Each form has its own threshold, its own data shape, and its own way of breaking when the underlying data is incomplete.
| Failure class | What breaks | Where it matters | |
|---|---|---|---|
| FX rate consistency | Local-currency price and FX rate generated independently; combined USD value drifts implausibly | Multi-currency reporting, FX-attribution, hedged-position handling | |
| PFIC misclassification | Foreign mutual-fund holdings treated as ordinary investments; wrong tax treatment, wrong forms | Tax software, US-expat advisory platforms, foreign-investment platforms | |
| Treaty-tier withholding | Source-country withholding applied at non-treaty rate; foreign tax credit overstated | Tax-aware reporting platforms, dividend-tracking systems | |
| Reporting threshold tracking | FBAR/Form 8938 filing requirements missed at year-end aggregation | Compliance reporting, expat-tax software | |
| Worldwide income aggregation | Foreign-source income missing from total income calculations; AGI underreported | Tax projection engines, Roth-conversion planners, retirement modeling |
The four pieces under this theme
Multi-currency portfolio modeling
Multi-currency portfolio modeling in synthetic households is the schema-level walkthrough of how to represent non-USD-denominated holdings in test data. Base currency vs. local currency, FX translation logic, the hedge-overlay layer, and the FX-consistency check that mock data routinely fails.
PFIC tracking
PFIC tracking and excess-distribution modeling is the deep dive on the most punitive US tax regime applicable to cross-border holdings. Passive Foreign Investment Companies (foreign mutual funds, ETFs, money-market funds, certain other entities) are taxed under default rules that treat distributions as ordinary income with interest charges, with elective alternatives (QEF, mark-to-market) that require their own data shapes. Domestic-only platforms that ingest a "foreign mutual fund" as if it were a 1099-DIV-issuing US fund produce wrong tax outcomes for every affected customer.
Treaty-tier withholding & FTC
Treaty-tier withholding and foreign tax credit modeling covers the intersection of source-country withholding rates (typically 15-30% on dividends, varying by treaty) with the US foreign-tax-credit machinery (Form 1116, country-by-country sourcing rules, separate baskets for passive and general categories). Test data has to include holdings from at least a few major treaty partners (UK, Canada, Germany, Japan) with realistic withholding patterns and the corresponding FTC tracking.
Cross-border equity compensation
Cross-border equity compensation test data covers RSU and ISO grants for employees on international assignment, where the grant might be issued in one country, vest while the employee is in a second country, and exercise after the employee has moved to a third. The tax treatment fragments by country of vesting, country of exercise, country of sale, and the residency-day-counting that determines which sourcing rule applies. Most domestic equity-comp engines silently break on these cases.
The methodology comparison
Domestic-only vs. cross-border test data is the procurement-side comparison: what changes when a platform expands beyond US-resident, USD-denominated households, and which platforms can defer the cross-border work versus which need it from day one.
Supporting glossary terms
- Foreign Tax Credit (FTC) — the mechanism that prevents double taxation of foreign-source income; structured by Form 1116 with separate baskets and complex sourcing rules.
- Tax treaty — bilateral agreement between the US and a foreign jurisdiction setting reduced withholding rates and tie-breaker rules; ~70 active.
- Form 8938 — the FATCA-driven foreign asset reporting form, with thresholds higher than FBAR and overlapping but not identical scope.
- Non-resident alien (NRA) — a non-citizen who fails the substantial-presence test; subject to US tax only on US-source income.
- GILTI — Global Intangible Low-Taxed Income; a US tax on certain foreign-corporation income flowing through to US shareholders.
- Form 5471 — the foreign-corporation information return required of US persons holding interests in controlled foreign corporations.
Where this connects
Cross-border wealth interlocks with several other content threads:
- International expat FBAR / FATCA: a niche use case — the existing narrow expat-focused article that this theme expands on.
- Multi-state tax engine design for fintech — analogous-but-different complexity at the US state level.
- Modeling corporate actions in synthetic portfolios — corporate actions on foreign issuers add another layer of tax complexity (the ADR ratio, the spinoff cross-jurisdictional issue).
- Generation-skipping tax planning — has cross-border interaction when beneficiaries are non-US persons.
- Aggregator & Custodian Integration — most aggregators have weaker non-US institution coverage; the cross-border platform tends to need direct custodian feeds.