Skip to main content

How to validate prior year consistency with Financial Statement Suite

In v25.1 or later, use Prior Year Consistency in the Financial Statement Suite to compare statements and validate amounts against the prior year.

Easily review the prior year amounts in the financial statement. Quickly compare two financial statements and automatically search and validate the corresponding amounts between the different years. 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.

Validating prior year consistency

  1. 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.

  2. 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.

  3. You can also click 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 and tie.

  5. 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).

  6. Select the Prior Year Consistency tab within the overview to open the Prior Year Consistency left-side panel.

  7. DataSnipper automatically places suggestions of numbers that are inconsistent with the prior year's financial statement.

  8. Using the search bar, you can identify keywords to locate the amount in the prior year's financial statement.

  9. You can use the pop-up to add comments, change or remove tickmarks, or add custom tickmarks.

Opening the Prior Year Consistency panel

Searching for the prior year amount

Adding comments and tickmarks via the pop-up

If you want to easily switch between the different tests you can perform in the Financial Statement Suite without going back to the overview page, you can do so directly through the collapsed sidebar.

Switching tests via the collapsed sidebar

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. Apply all suggested incorrect tickmarks to the document.

Applying multiple tickmarks at once

Applying multiple tickmarks at once can be enabled or disabled on a company level. If you do not see this drop-down menu, your company admin disabled this feature for your organization.

Did this answer your question?