Blog · Board and management reporting · Investment management
Reconcile opening assets, contributions, withdrawals, supplied valuation changes and fees to each client's closing balance. Use a worked asset-management report to separate an explainable movement from an unresolved difference.
Client reporting in asset management should reconcile what a client held at the start of a period, what moved during it and what remained at the end. Use supplied holdings, flows, valuation changes and fees to build that bridge before sharing the figures. A balanced report still needs source checks; a difference needs an explanation and an owner.
The purpose is client-specific accountability. Firm-wide asset management reporting answers a broader management question. Keep those views connected through reconciled totals without assuming that an internal management summary contains every disclosure or detail needed for a client report.
Record the client, included accounts, valuation date, reporting currency and period. Identify who supplied the balances and valuation changes. Capture the fee convention alongside them: a valuation movement can be supplied before fees or after fees, and the bridge must follow that convention.
For this example, a fictional US asset-management firm reports in USD for the quarter ended September 30, 2026. Opening assets are the preceding quarter-end balances. Contributions and withdrawals are external client flows during the quarter. Supplied valuation changes exclude the separately recorded fees.
An internal transfer between included accounts is neither a new client contribution nor a withdrawal from that client's reporting group. Reconcile transfers at the account level first, then eliminate matching internal movements when preparing the client total. Preserve the source transaction IDs so someone else can repeat the check.
The report's owner should approve its account list before anyone calculates totals. An omitted account can produce a perfectly balanced bridge for an incomplete reporting scope.
Under the stated fee convention:
Expected closing assets = Opening assets + Contributions - Withdrawals + Supplied valuation change - Fees
Reconciliation difference = Reported closing assets - Expected closing assets
Prepare a worksheet with one row per client. Columns A through G hold client name, opening assets, contributions, withdrawals, supplied valuation change, fees and reported closing assets. Calculate expected closing assets in H and the difference in I.
The following source rows are a draft, before resolving the exception. All monetary columns are USD.
| Client | Opening | Contributions | Withdrawals | Supplied valuation change | Fees | Reported closing | Expected closing | Difference |
|---|---|---|---|---|---|---|---|---|
| Mason Foundation | 1,200,000 | 100,000 | 40,000 | 45,000 | 5,000 | 1,300,000 | 1,300,000 | 0 |
| Harbor Pension | 800,000 | 0 | 50,000 | 20,000 | 3,000 | 767,000 | 767,000 | 0 |
| Cedar Endowment | 500,000 | 50,000 | 0 | -10,000 | 2,000 | 540,000 | 538,000 | 2,000 |
| Total | 2,500,000 | 150,000 | 90,000 | 55,000 | 10,000 | 2,607,000 | 2,605,000 | 2,000 |
In H2 and I2, enter these formulas and fill down through row 4:
=B2+C2-D2+E2-F2
=G2-H2
Sum each amount column in row 5. For example, opening assets use:
=SUM(B2:B4)
Google Sheets documents SUM as adding numbers or ranges. Use the underlying values rather than numbers copied from a rounded presentation. This example uses whole dollars throughout; a production report should state its display precision and retain the source precision for checks.
Mason and Harbor reconcile. Cedar does not: $500,000 + $50,000 - $10,000 - $2,000 gives $538,000, while the draft shows $540,000. The draft therefore overstates Cedar's closing assets by $2,000 under the stated convention.
In this worked example, review of the draft finds that its closing figure omitted the fee deduction already present in the source records. The reporting owner corrects the draft to $538,000 after confirming the source closing balance. This is a correction to the draft, not a new withdrawal or an adjustment to investment performance.
After correction, client closing assets sum to $2,605,000. The proof across all clients is $2,500,000 + $150,000 - $90,000 + $55,000 - $10,000 = $2,605,000. Each client difference is zero.
Count unresolved rows separately from their dollar total:
=COUNTIF(I2:I4,"<>0")
COUNTIF counts cells matching a condition. The draft has one nonzero difference; the corrected version has none. Equal positive and negative errors could cancel in the total, so a zero total alone is insufficient. Covirage is not affiliated with Google.
The corrected closing balance exceeds opening assets by $105,000. Net external flows explain $60,000 of that movement: $150,000 contributed less $90,000 withdrawn. Supplied valuation changes of $55,000, less fees of $10,000, explain the remaining $45,000.
That is an asset bridge, not a return. Do not divide the balance increase by opening assets and label the result investment performance. Where a report includes returns, preserve the approved supplied figures, their period, their fee basis and their provider's method description. Leave an unavailable return unresolved rather than manufacture it from closing balances.
The client-service lead owns the scope and narrative; operations owns transaction and balance exceptions; the designated reporting reviewer approves the final figures. A separate net flows by client and strategy review can investigate relationship growth. The firm's management reporting package can then use the reconciled totals for its own purpose.
Bring a sample of your own client balances, flows, supplied valuation changes and fees to Covirage; it maps the columns, and its tools compute and check the asset bridge. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.
See Covirage for asset managers for the supporting business-reporting context.
No. A balance reconciliation explains how opening assets became closing assets, including external flows and fees. A return calculation also requires a defined performance method and appropriate timing information. Use an approved return supplied by the responsible provider rather than deriving one from this bridge.
They can appear separately when the source conventions support that treatment. Establish whether supplied valuation changes already include the fees. Subtracting them again would understate closing assets; omitting fees excluded from valuation changes would overstate them. Document the convention for each report.
Assign the difference to an owner and check transaction dates, transfers, fee treatment and valuation coverage. Preserve the original inputs and the correction. Do not fill the difference with an unexplained adjustment merely to make the report total agree.