Check financial statements without leaving Excel
The financial statements suite recomputes every total, ties statements, notes and prior year, and checks spelling in eight languages.
Included in the plan. We switch it on per organization, on request.
Red totals explained
A total that does not add up is flagged, with its likely cause when the suite recognizes it.
Notes and prior year tied
Each face-statement amount is looked up in its note, then elsewhere by value, and comparatives in last year’s report.
Drafts without rework
A tickmark follows its amount to the next draft if it stays on the same line.
Eight languages
Spelling is checked per paragraph, with HGB and IFRS accounting terms.
HGB Anhang checklist
62 points from §§ 264 and 284 to 288 HGB, or your own IFRS or US GAAP checklist.
Ready for the file
An annotated PDF and an Excel findings sheet linked to it.
What the suite checks, and how
Mathematical accuracy and diagnosis
The suite recomputes every total and subtotal by arithmetic, in any language. When a difference fits a known pattern, it names the cause:
- An amount missing or one too many.
- Two swapped digits (the difference divides by 9).
- A flipped sign.
- Rounding, within the tolerance you set.
- A doubtful OCR reading.
Internal consistency, by note and by value
Each face-statement amount is looked up in its note, then elsewhere by value. Only amounts with at least 3 digits are checked, because small numbers match by chance.
- Five statuses: consistent, found elsewhere (with the page), inconsistent, ambiguous, or not found in the note.
Find All Sums
In the document viewer, Find All Sums detects printed totals, turns each into a Sum Snip and exports the list to Excel.
Tickmarks in one click
^ and < for mathematical accuracy, IC for internal consistency, PY for the prior period. Blue when correct, red when not.
- Apply the suggested tickmarks to a page or to the whole document.
- A red tickmark gets a comment written from its diagnosis, which you can edit.
Suggestions, findings and sign-off
A red tickmark turns a suggestion into a finding. The procedure can be signed off only once every finding is resolved.
Disclosure checklist
The HGB Anhang checklist is built in, with 62 points from §§ 264 and 284 to 288 HGB. For IFRS or US GAAP, upload your own (CSV, Excel or JSON).
- Two size-class questions (§ 267 HGB) hide the points that § 288 HGB exempts.
- An AI model proposes an answer with the passage it used. If that passage cannot be found in the document, the point cannot be accepted.
- Each decision carries your name and the date.
- The checklist review uses AI credits; the other checks do not.
From the PDF to the audit file in three steps
01Import the statements
Open the suite from the Office pane and pick this year’s PDF, plus last year’s if you have it.
02Work through the tests
Mark, flag or correct each item in one click.
03Export and sign off
Export the annotated PDF and the findings sheet, then sign off the procedure.
Questions before you start
- Which documents can it read?
- Annual reports and financial statements as PDF, scans included after OCR. Number formats (1.234,56 or 1,234.56) and scale units such as TEUR, kEUR or Mio. are read per document.
- Are my financial statements sent to an AI model?
- The accuracy, consistency, prior-period and spelling checks run in the add-in, on the text recognized at import. The disclosure checklist review sends the document text to an AI model for the length of the run. For abuse monitoring, Microsoft temporarily stores all requests sent to Azure OpenAI and all responses; only data that triggered its automated systems may be reviewed by authorised Microsoft employees. Checklist answers are written to your workbook, and the review itself (documents, annotations, answers) stays on our servers until about 30 days after it is closed.