Consolidated Wealth Reporting

One trusted report of everything the family owns and owes: a full account map, valuation rules for private assets, a monthly reconciliation, a quarterly pack, and views each family member can read.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Consolidated Wealth Reporting, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

🏰 Family Office & Private Wealth

Consolidated Wealth Reporting

Seeing all family assets in one report: custodians and accounts, private holdings, property and collectibles, performance and liquidity, and reporting software.

  1. Master list of every account and holding
  2. Reporting perimeter and family units
  3. Ownership chart with percentages for look-through
  4. Base currency and reporting conventions
  5. Asset classification scheme for the family report
  6. Statement and data feed collection set-up
  7. Opening family balance sheet at a fixed date
  8. Valuation policy for private and illiquid holdings
  9. Reporting roles, reviewers and access tiers
  10. Monthly statement reconciliation routine
  11. Quarterly consolidated family report cycle
  12. Private fund and direct stake valuation updates
  13. Property value register and yearly refresh
  14. Collections and personal assets on the balance sheet
  15. Liabilities, credit lines and guarantees register
  16. Private commitments and capital call tracker
  17. Liquidity profile page in the family report
  18. Data quality exceptions log
  19. Secure report delivery and version archive
  20. Year-end consolidated wealth statement
  21. Reading a custodian statement line by line
  22. Time-weighted and money-weighted returns explained
  23. Private fund metrics, IRR, TVPI and DPI
  24. Total cost picture across every relationship
  25. Benchmarks for the performance pages
  26. Gross, net of fees and after-tax figures
  27. Currency effects in a multi-currency report
  28. Choosing a consolidated reporting platform or service
  29. Moving the report from spreadsheets to the platform
  30. One-page family wealth summary
  31. Views by branch, generation and entity
  32. Cost basis and tax lot records for the report
  33. Alert thresholds for the monthly figures
  34. First consolidated report presented to the family
  35. Annual reporting review with advisers
  36. Date-of-death valuation and reporting pack
  37. Bringing business sale proceeds into the report
  38. Personal financial statement for a lender
  39. Simple report for a retired couple
  40. Individual reports for adult children
  41. Report access as children reach adulthood
  42. Surviving spouse taking over the report
  43. Report review for an attorney or carer
  44. Reporting through a separation or divorce
  45. Look-through concentration and counterparty exposure
  46. Performance attribution across managers
  47. Operating business at fair value in the family total
  48. Report history and long-run net worth series
  49. Reporting provider due diligence and data security
  50. Independent review of reporting controls

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Master list of every account and holding

Families with more than a few relationships nearly always discover forgotten items when they first try to list everything: a custody account opened for one deal, a dormant trust bank account, a pension abroad, a small private company stake. A consolidated report is only as complete as this list, so it comes before any software or design work.

First tasks

  • List every institution that sent the family a statement in the last twelve months
  • Ask each adult family member for accounts held in their own name only
  • Add private fund interests, direct stakes, loans made, property and collections
  • Send the draft list to the lead adviser and ask what is missing

Reporting perimeter and family units

Before adding anything up, the family has to decide whose wealth the report covers: the founding couple only, each branch, every trust, the operating business, assets held for children. Getting this wrong produces totals that double count a trust and its underlying company, or that show one sibling another sibling's affairs.

First tasks

  • Draft a list of people and entities that could sit inside the report
  • Ask each trustee how their trust should appear in a family report
  • Group the list into family units by branch, trust and entity
  • Record the agreed perimeter with its effective date

Ownership chart with percentages for look-through

Consolidation needs to know who owns what share of each entity, so that a holding company owned 60 and 40 by two branches shows the right slice in each branch's view. An ownership chart with percentages turns a tangle of companies and trusts into rules the reporting system can apply.

First tasks

  • Collect the latest share registers for every family company
  • Draw the chart from the individuals at the top to the operating entities below
  • Mark where voting rights and economic rights differ
  • Ask the company secretary to check each percentage

Make it yours.

Install Consolidated Wealth Reporting, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.