Braio

Evaluation method

From Excel Actuals to a Reviewable Management Report

The deliverable is a linked reporting package, not just a polished paragraph. Start with a question, selected source data and acceptance checks. Preserve the calculation that the workbook and document are supposed to describe.

Published: Reviewed:

Write a report brief that can be checked

Specify the audience, period, currency, source files, expected sections and decision the report supports. Define which totals need independent controls and who reviews unsupported explanations. An instruction to “make this board-ready” leaves too many numerical and editorial decisions unspecified.

Keep source facts, scenario assumptions and presentation choices separate. Use the dedicated financial report process for numbers tied to a canonical analysis reference; use narrative drafting only when it is clearly labelled as such.

Inspect and select the actual source

Inspect workbook sheets, headers and formulas before selecting the cells. In a source-bound analysis, the server reads the exact inspected file version and range; it does not treat amounts copied into a model response as verified source cells.

Confirm a representative total and the period boundary. Unsupported imported formula caches are not independent verified calculations. If a required value cannot be calculated or controlled, retain an unresolved item rather than editing the prose to hide it.

Use a short management structure

A useful package contains the question and scope, key calculated results, the relevant comparison, source-linked observations, assumptions and open decisions. Put detailed schedules in the workbook and explain their meaning in the document.

Do not label every difference a cause. A number can be correct while its interpretation is unsupported. The human reviewer should be able to follow one important figure from the summary back to its source and control.

PartWorkbookDocument
ScopeInputs, period and assumptionsQuestion and boundary
NumbersCalculated schedules and controlsSelected reconciled figures
EvidenceSource cells and auditReferences and limitations
DecisionUnresolved check statusOwner and next check

Generate both files from one result

The dedicated Braio process generates XLSX and DOCX from the same stored canonical result and reads monetary values back before delivery. This establishes file agreement with that calculation, not proof of every source fact or business interpretation.

A generic document tool can also write a narrative file, but that path is not automatically a reconciled financial report. Check which process produced the artifact. Keep both output filenames and the analysis reference in the review record.

Revise without overwriting the evidence

Change a source or assumption through a new calculation and deliver a new file revision. Preserve the old source and accepted package so differences can be explained. Editing a displayed output total is not an auditable update.

Start with the public cash-flow pack to inspect a source-bound XLSX/DOCX pair. Management actuals use their own selected inputs and checks. A month-close decision requires its additional completeness and completed-period controls.

Sources

  1. Braio: synthetic finance source pack, method and file checks

Continue with your workflow