How to validate the internal consistency with Financial Statements Suite

Easily review the internal consistency of the amounts in the financial statements. Quickly cross-reference amounts to their occurrences within the same document.

About Financial Statement Suite

Financial Statement Suite (FSS) is a separate paid DataSnipper Add-on module. FSS automatically analyzes your financial statements and helps to both perform and document all financial statement procedures extremely fast, while relying on your judgment – improving standardization and the overall quality of procedures.

Choose your Financial Statement Suite version to learn more about validating Internal Consistency:

👉 DataSnipper version 25.1 and later

👉 DataSnipper version 5.0

👉 DataSnipper version 4.1

👉 DataSnipper version 4.0

DataSnipper v25.1 - Validate Internal Consistency

1. Begin by clicking the Financial Statement Suite button in the top right-hand corner of the DataSnipper tab within Excel.

   1. Alternatively, you can launch FSS directly from your desktop by creating a shortcut or pinning it to your taskbar for easy access. You can also open an existing project you've already started working on.

2. Financial Statement Suite will open in a new window. You can import an existing tick and tie project from your desktop with the ‘Import Project’ option.

3. You can also click on the blue button to Start a new tick and tie.
4. Import your current (and prior year) version(s) of your financial statement to start the tick & tie.
5. Once you have opened your project, you will see this overview page, including all the tests you can perform in FSS (Mathematical Accuracy, Internal Consistency, Spell Check, Prior Year Consistency and Version Compare).
6. Click on the ‘Internal Consistency’ tab to open up the Internal Consistency left-side panel.
7. DataSnipper automatically places suggestions of inconsistent numbers within the financial statement. By hovering over the numbers, you can quickly analyze the suggestions and place tickmarks.
8. You can see the references on the second screen by hovering over them on the pop-up.
9. Using the pop-up, you can add comments, choose references, add a manual reference, add a custom tickmark, or remove the tickmark.
   
   

Applying multiple tickmarks at once

If you want to apply multiple tickmarks at once, you can do that using the drop-down menu in the upper left corner. You can apply multiple tickmarks in four ways:

1. Apply tickmarks to the current page;

2. Apply all the tickmarks to the document;

3. Apply all suggested correct tickmarks to the document;

4. Finally, apply all suggested incorrect tickmarks to the document.

DataSnipper v5.0 - Validate Internal Consistency

1. Begin by clicking the Financial Statement Suite button in the top right-hand corner of the DataSnipper tab within Excel.
2. Select the current and prior year versions of your financial statement to start the tick & tie.
3. Select the 'Internal Consistency' tab within the Financial Statement Suite window to move on to verifying the internal consistency.
4. DataSnipper automatically places suggestions of inconsistent numbers within the financial statement. By hovering over the numbers, you can quickly analyze the suggestions and place tickmarks.
   
5. You can see the references on the second screen by hovering over them on the pop-up.
6. Using the pop-up, you can add comments, choose references, add a manual reference, add a custom tickmark or remove the tickmark. 
   

Applying multiple tickmarks at once

If you want to apply multiple tickmarks at once, you can do that using the drop-down menu in the upper left corner. You can apply multiple tickmarks in four ways:

1. Apply tickmarks to the current page;

2. Apply all the tickmarks to the document;

3. Apply all suggested correct tickmarks to the document;

4. Finally, apply all suggested incorrect tickmarks to the document.

DataSnipper v4.1 - Validate Internal Consistency

1. Begin by clicking the Financial Statement Suite button in the top right-hand corner of the DataSnipper tab within Excel.
2. Select the 'Internal Consistency' tab within the Financial Statement Suite window to move on to verifying the internal consistency.
3. Click on one of the highlighted findings on the sidebar and the occurrences will pop up.
4. You can see the occurrences on the second screen by hovering over them on the pop-up.
5. Using the pop-up, you can add comments, choose references, add a manual reference, add a custom tickmark or remove the tickmark. 

DataSnipper v4.0 - Validate Internal Consistency

1. Begin by clicking the Financial Statement Suite button in the top right-hand corner of the DataSnipper tab within excel
2. Click 'Next' from the Mathematical accuracy tab or select the 'Internal Consistency' tab within the Financial Statement Suite window to move on to verifying the internal consistency.
3. Click on a number and select the appropriate occurrence which pops up.
4. The other occurrence will show up on the 'Secondary View' page in the bottom right of your window.
5. You can then click on the number to enter a tickmark which verifies the internal consistency or right-click to add findings, highlights, or clear a tickmark.