Three Ways to Do Investment Accounting.
Only One Was Built for It.

Most organizations manage investment portfolios with tools that weren’t designed for it. Here’s how the approaches compare – and why it matters at tax time.

chart 1
chart 2
chart 3

How Do They Stack Up?

When your portfolio includes corporate actions, multiple custodians, and Canadian tax obligations — the details matter.

Spreadsheet Approach
Middleware Approach
Wealth Write.Up
Transaction Coverage

Custom formulas for every corporate action. Breaks when it gets complex.

Handles standard trades. Complex transactions need manual fixes or complex mapping rules.

41 transaction types built in. Validated automatically.

General Ledger

Excel and QuickBooks live in separate worlds. Never fully reconciled.

One-way data push into the GL. No link back to investment detail.

True GL + subledger in one platform. Auto-posts with drill-through.

Tax & Audit
Reporting

Hand-built reports. ACB in formulas. Audit prep takes weeks.

Basic trade summaries. Detailed tax reporting still manual.

30+ tax-ready reports in minutes. One-click Taxprep export.

Multi-Custodian

One spreadsheet per custodian. Consolidation is copy-paste.

Aggregates data, but consolidation happens in a GL that wasn’t built for it.

Single source of truth. Consolidated and entity-level views are native.

Multi-Currency & FX

Manual conversions. Inconsistent rates. FX gains are untraceable.

Some automated FX. Complex gain/loss tracking falls back to spreadsheets.

Automated FX with rate tracking. Realized and unrealized gains posted automatically.

Key Person Risk

Everything lives in one person’s spreadsheet. They leave, it leaves.

Less manual work, but mapping logic still depends on tribal knowledge.

Knowledge is in the system. Role-based access. Full audit trail.

Scalability

Every new entity or asset class = another tab, another risk.

Scales extraction, not accounting. More complexity = more workarounds.

Add entities, currencies, custodians. Workflow stays the same.

50%+ less time. Zero spreadsheet risk.
Audit-ready from day one.

200+ organizations across Canada have made the switch. Their auditors noticed.

Watch A 2-Minute Overview