Book a fit call

Capability template for analytics and reporting

Client report check log

Before a batch of client reports is released, the reporting lead gets a log, report by report, of household membership, periods, totals against the custodian statements, fee figures and missing sections, with every difference marked for correction. Nothing is released or sent.

Listed under

Put this on your planBuild this in a sprint

Add it to a workflow in the Fully Powered Planner, beside the teams and roles that will run it. Book a fit call

The outcome

The batch is checked against the firm's own records before any client sees it. For each report the reporting lead can see which accounts belong to the household and whether each one is on the page, whether the dates are the right dates, whether every account value matches its custodian statement, whether the fee figures match the billing records, and whether every section the firm requires is there and finished.

Each difference arrives in one place, with the report's figure beside the record's figure and the gap between them, marked for correction. Reports with a wrong recipient, a missing account or a total nobody can explain are marked to hold. The reporting lead resolves the differences. The adviser and the designated reviewer approve release. The log does neither, and it says nothing about performance.

Who starts the work, and when

The reporting lead starts it when a batch of draft reports is ready for release review, usually at the end of a quarter, and again after corrections are made to confirm the differences are closed. Reporting operations staff can prepare the inputs.

What they supply

  • The draft reports in the batch, with the batch period and, if there is one, a batch name.
  • The custodian statements for the same period, as exported lists or pasted rows.
  • The account inventory: which accounts belong to which household, their status and who receives the report.
  • The billing records: the fee for each account and fee period.
  • The firm's report checklist: the sections every report must carry.

What comes out

One log in a fixed order: a count of reports by status, then each report with its recipient, membership, period, totals, fees and section checks, then a numbered list of differences, each marked for correction with a blank for the reporting lead's resolution. The log ends with what was not checked and blank sign-off lines for the reporting lead, the adviser and the designated reviewer.

An invented example

Illustrative example with invented data. The firm, households, custodians, accounts and every figure below are made up. The firm is "the firm" throughout; custodians are Custodian X, Y and Z.

The reporting lead at an invented advisory firm is checking a batch of four quarterly reports for the period 1 July 2026 to 30 September 2026. Batch name: Q3 2026 batch. Report checklist: Cover and recipients; Account summary; Allocation; Activity; Fees; Disclosures. Accepted difference on an account value: none, exact to the cent.

What the person supplies

The three record lists use the template's default headers, in the order shown. Each line below is one row.

Account inventory (Household; Account (last four); Account name; Custodian; Status; Opened; Closed; Report recipients)

  • Marlowe; 4410; Joint brokerage; Custodian X; open; blank; blank; A. Marlowe, J. Marlowe.
  • Marlowe; 7782; IRA (A. Marlowe); Custodian X; open; blank; blank; A. Marlowe, J. Marlowe.
  • Marlowe; 3305; IRA (J. Marlowe); Custodian Y; open; blank; blank; A. Marlowe, J. Marlowe.
  • Marlowe; 9021; Family trust; Custodian X; open; blank; blank; A. Marlowe, J. Marlowe.
  • Pendry; 1156; Joint brokerage; Custodian Y; open; blank; blank; R. Pendry, S. Pendry.
  • Pendry; 6643; Education account; Custodian Z; new; 12 August 2026; blank; R. Pendry, S. Pendry.
  • Quillon; 5207; Individual brokerage; Custodian X; open; blank; blank; T. Quillon.
  • Quillon; 8814; IRA; Custodian X; closed; blank; 5 September 2026; T. Quillon.
  • Ashgrove; 2290; Individual brokerage; Custodian Y; open; blank; blank; L. Ashgrove.

Custodian statements (Custodian; Account (last four); Account name; Period start; Period end; Ending value)

  • Custodian X; 4410; Joint brokerage; 1 July 2026; 30 September 2026; 412,380.55.
  • Custodian X; 7782; IRA (A. Marlowe); 1 July 2026; 30 September 2026; 188,206.10.
  • Custodian Y; 3305; IRA (J. Marlowe); 1 July 2026; 30 September 2026; 96,450.00.
  • Custodian X; 9021; Family trust; 1 July 2026; 30 September 2026; 251,330.25.
  • Custodian Y; 1156; Joint brokerage; 1 July 2026; 30 September 2026; 305,118.40.
  • Custodian Z; 6643; Education account; 12 August 2026; 30 September 2026; 24,950.00.
  • Custodian X; 5207; Individual brokerage; 1 July 2026; 30 September 2026; 140,775.30.
  • Custodian X; 8814; IRA; 1 July 2026; 5 September 2026; 0.00.
  • Custodian Y; 2290; Individual brokerage; 1 July 2026; 30 September 2026; 78,420.75.

Billing records (Account (last four); Fee period start; Fee period end; Fee amount)

  • 4410; 1 July 2026; 30 September 2026; 1,030.95.
  • 7782; 1 July 2026; 30 September 2026; 470.52.
  • 3305; 1 July 2026; 30 September 2026; 241.13.
  • 9021; 1 July 2026; 30 September 2026; 628.33.
  • 1156; 1 July 2026; 30 September 2026; 762.80.
  • 6643; 12 August 2026; 30 September 2026; 31.19.
  • 5207; 1 July 2026; 30 September 2026; 351.94.
  • 8814; 1 July 2026; 5 September 2026; 166.20.
  • 2290; 1 July 2026; 30 September 2026; 196.05.

Draft reports (what each draft shows)

  • R-101, Marlowe. Recipients: A. Marlowe, J. Marlowe. Period: 1 July 2026 to 30 September 2026. Accounts: 4410 412,380.55; 7782 188,206.10; 3305 96,450.00. Household total 697,036.65. Fees: 4410 1,030.95; 7782 470.52; 3305 214.13; fee total 1,715.60. Sections present: all six.
  • R-102, Pendry. Recipients: R. Pendry, S. Pendry. Period: 1 April 2026 to 30 June 2026. Accounts: 1156 305,118.40; 6643 24,950.00. Household total 330,068.40. Fees: 1156 762.80; 6643 31.19; fee total 793.99. Sections present: Cover and recipients; Account summary; Allocation; Fees; Disclosures.
  • R-103, Quillon. Recipients: T. Quillon and V. Quillon. Period: 1 July 2026 to 30 September 2026. Accounts: 5207 140,775.30; 8814 0.00 (noted as closed 5 September 2026). Household total 141,775.30. Fees: 5207 351.94; 8814 166.20; fee total 518.14. Sections present: all six, but the Disclosures page reads "[to be added]".
  • R-104, Ashgrove. Recipients: L. Ashgrove. Period: 1 July 2026 to 30 September 2026. Accounts: 2290 78,420.75. Household total 78,420.75. Fees: 2290 196.05; fee total 196.05. Sections present: all six.

What comes out

CLIENT REPORT CHECK LOG: Q3 2026 batch, 1 July 2026 to 30 September 2026

Prepared for: the reporting lead. Checked 4 reports against 9 custodian statements, 9 billing records and the account inventory for 4 households.
Release is approved by the adviser and the designated reviewer. This log releases and sends nothing and comments on no performance.

Summary: 4 reports. Hold: 2 (R-101, R-103). Differences to correct: 1 (R-102). No differences found: 1 (R-104). Differences logged: 7.

REPORT LOG

R-101, Marlowe household. Status: HOLD (membership difference).
- Recipients: A. Marlowe, J. Marlowe. Match the inventory.
- Membership: 3 of 4 accounts open at any time in the period are on the report. Account 9021 is not on it. See D-1.
- Period: 1 July 2026 to 30 September 2026. Matches the batch.
- Totals: 4410, 7782 and 3305 match their statements. Household total 697,036.65 equals the three accounts shown; the four statements total 948,366.90; difference -251,330.25, which is the value of account 9021 (see D-1).
- Fees: 4410 and 7782 match billing. 3305 does not. See D-2. Fee total 1,715.60 against 2,370.93 in billing; difference -655.33, which is 628.33 for account 9021 (D-1) and 27.00 on account 3305 (D-2).
- Sections: all six present.
- Differences: D-1, D-2.

R-102, Pendry household. Status: DIFFERENCES TO CORRECT.
- Recipients: R. Pendry, S. Pendry. Match the inventory.
- Membership: 2 of 2 accounts open at any time in the period are on the report. 6643 opened on 12 August 2026.
- Period: 1 April 2026 to 30 June 2026. Does not match the batch. See D-3.
- Totals: 1156 and 6643 match their statements. Household total 330,068.40 equals the two accounts and the two statements.
- Fees: 762.80 and 31.19 match billing. Fee total 793.99 equals the billing records.
- Sections: Activity is missing. See D-4.
- Differences: D-3, D-4.

R-103, Quillon household. Status: HOLD (recipient difference; unexplained total difference).
- Recipients: T. Quillon and V. Quillon. V. Quillon is not on the inventory. See D-5.
- Membership: 2 of 2 accounts open at any time in the period are on the report. 8814 closed on 5 September 2026 and shows 0.00 with the closing noted, as the statement does.
- Period: 1 July 2026 to 30 September 2026. Matches the batch.
- Totals: 5207 and 8814 match their statements. Household total 141,775.30 against 140,775.30 from both the accounts and the statements; difference +1,000.00. See D-6.
- Fees: 351.94 and 166.20 match billing. Fee total 518.14 equals the billing records.
- Sections: Disclosures is present but unfinished. See D-7.
- Differences: D-5, D-6, D-7.

R-104, Ashgrove household. Status: NO DIFFERENCES FOUND.
- Recipients: L. Ashgrove. Match the inventory.
- Membership: 1 of 1 account open at any time in the period is on the report.
- Period: 1 July 2026 to 30 September 2026. Matches the batch.
- Totals: 2290 matches its statement at 78,420.75. Household total equals it.
- Fees: 196.05 matches billing. Fee total equals it.
- Sections: all six present.
- Differences: none.

DIFFERENCES FOR CORRECTION

D-1. R-101, membership. The report omits account 9021, Family trust, Custodian X, open all quarter. Statement ending value 251,330.25; billing fee 628.33. Difference: account missing, and both its value and its fee are missing from the household total and the fee total. Marked for correction. Resolved by the reporting lead: ______
D-2. R-101, fees. Account 3305. Report shows 214.13; billing shows 241.13. Difference -27.00. Marked for correction. Resolved by the reporting lead: ______
D-3. R-102, period. Report shows 1 April 2026 to 30 June 2026; the batch period is 1 July 2026 to 30 September 2026. Account 6643 was opened on 12 August 2026, after the period the report shows. Marked for correction. Resolved by the reporting lead: ______
D-4. R-102, sections. The firm's checklist requires Activity; the report has no Activity section. Marked for correction. Resolved by the reporting lead: ______
D-5. R-103, recipients. The report is addressed to T. Quillon and V. Quillon; the inventory lists T. Quillon only. Marked for correction. Resolved by the reporting lead: ______
D-6. R-103, totals. Household total on the report 141,775.30; accounts on the report and their statements total 140,775.30. Difference +1,000.00, not explained by any account. Marked for correction. Resolved by the reporting lead: ______
D-7. R-103, sections. Disclosures contains the placeholder "[to be added]". Marked for correction. Resolved by the reporting lead: ______

NOT CHECKED
Allocation percentages, activity figures, holdings, performance figures and wording were not checked, and no figure was recalculated from transactions. The draft reports show no period against each account and no fee periods, so account periods and fee periods were not checked on the reports; only the cover period was. The statements are taken as the correct source for values and the billing records for fees.

SIGN-OFF
Differences resolved by the reporting lead: ______ Date: ______
Release approved by the adviser: ______ Date: ______
Release approved by the designated reviewer: ______ Date: ______

Every figure traces to the draft reports, custodian statements, billing records and account inventory supplied for the Q3 2026 batch. The log changes no record, releases nothing and sends nothing.

Counts: 9 accounts in the inventory and 9 statements and 9 billing records; 4 reports; 7 differences.

Where it fits

What has to change for your company

Set the sections your reports must carry. Decide how many cents of difference you accept on an account value, if any. Name the roles that resolve differences and approve release. Say which records are the source for membership, values and fees; the template logs both facts when two records disagree and leaves the choice to the reporting lead. Decide which differences hold a report, if you want more or fewer than it does. Match the default column headers in the template to your exports, or tell the assistant which headers you use.

What has been checked

Fully Powered AI wrote this capability template from its own map of the work. It was editorially reviewed on 10 November 2026. It was tried once on its invented example, in Claude on 10 November 2026, and the record is published with it. It has not been tested in a client environment or as a packaged version in ChatGPT, Claude, Copilot or Gemini.

Testing in your environment means running it on a past batch whose differences the reporting lead already knows, and checking that each one is found and each clean report is left clean. The reporting lead checks every figure in the log against the source records before anyone relies on it.

The full capability template

Everything above is the outline. The complete capability template is the working version: the roles, the inputs, the procedure, the exceptions and stop conditions, the output format, the reviewer checklist, the acceptance tests, the instructions for an AI assistant and what to customize for your company. It comes with a download and the link to its folder in Fully Powered’s public repository.

View the full template

Free with an account. Sign in by email: no password and no card.

Next step

Put this capability to work for your team: on your plan, or built with you in a sprint.

Put this on your plan

Add it to a workflow in the Fully Powered Planner, beside the teams and roles that will run it.

Build this in a sprint

In a sprint, Fully Powered adapts this capability template to your rules, proves it on your own work and puts it in the hands of the roles that own it.

Two ways to begin:

Rather talk it through first? Book a fit callDiscuss adapting this

  • Spreadsheet check before sharing

    Before a model or schedule goes to a client, a lender or a board, the sender gets one report on it: every error value, short total, buried assumption and hidden row pinned to its cell, each with a fix or a question, and a plain list of what was not checked. Nothing in the workbook is changed.

  • Weekly receivables summary

    The finance lead takes one page into each week’s management meeting: what came in, where every receivable stands, which exceptions are open and who owns them, and the decisions management must make. Every figure ties to the aging report.

  • Household fee check

    On the fee review date, the billing owner gets a fee check by account and household that applies the firm's own agreed schedules and approved waivers to the valuation files, with draft invoice lines, differences against custodian debits and every doubtful account kept apart for review.

  • Household record differences

    When the CRM and the custodian's account export disagree about a household, the operations owner gets one comparison: accounts with no household, possible duplicates and field-by-field differences, each with its source row and a proposed correction left as a question. No record is changed.