In v6.1 or later, you can edit Mathematical Accuracy (MA) Suggestions with the MA Suggestions Editor in the Financial Statement Suite. When FSS does not capture all totals or correctly identify every part of a sum, you can step in and adjust system-generated suggestions by pinpointing the correct parts of a sum. Once you start working on a new version of the financial statement, the edited tickmark also transfers to the next version.
FSS is a separate paid DataSnipper add-on module that automatically analyzes your financial statements and helps you perform and document financial statement procedures quickly, while relying on your professional judgement.
Prerequisites
v6.1 or later
Financial Statement Suite add-on module
Video tutorial
What the video covers
The video shows how to spot a sum where the parts were incorrectly identified, open the red tickmark to edit the calculation, and reselect the numbers so the tickmark turns blue.
Step-by-step guide
Click the Financial Statement Suite button in the top right-hand corner of the DataSnipper tab in Excel. Alternatively, launch FSS directly from your desktop by creating a shortcut or pinning it to your taskbar, or open an existing project you have already started.
Financial Statement Suite opens in a new window. You can import an existing tick and tie project from your desktop with the Import Project option.
You can also click the blue button to start a new tick and tie.
Import your current (and prior year) version(s) of your financial statement to start the tick and tie.
Once you have opened your project, you will see the overview page, including all the tests you can perform in FSS (Mathematical Accuracy, Internal Consistency, Spell Check, Prior Year Consistency, and Version Compare).
Click the Mathematical Accuracy tab to open the Mathematical Accuracy left-side panel.
DataSnipper automatically places suggestions of valid totals and errors. By hovering over the numbers, you can quickly analyze the suggestions and place tickmarks.
If you notice an error where the parts of the sum were incorrectly identified (for example, one number not being included in the calculation), you can correct it by editing the suggestion.
Click on the sum, and a red tickmark appears to indicate this calculation is mathematically incorrect.
Click on the red tickmark and then click Edit calculation.
Drag your cursor over the numbers that you want to include in the calculation to verify its mathematical accuracy.
Click Finish.
The new calculation now verifies that the mathematical accuracy is correct, and the tickmark has turned blue.
Once you start working on a new version of the financial statement, the edited tickmark also transfers to the next version.
