Cash flow import copy paste tool

Note: The cash flow import / copy-paste tool is not available in all Global Statutory Reporting apps.

Cash flow import / copy-paste tool has been developed to assist our users to efficiently transfer the cash flow statement balances from external sources (Excel or CSV worksheets) into dynamic tables within the financial statements.

End user workflow

As an end user, you are required to document the following information:

  1. Specify whether the amounts you want to import or copy are already rounded or not.

    Note:

    1. Financial statements can be rounded to thousands, millions and billions.

    2. Specify whether the amounts imported/copied are already rounded as per the financial statements rounding settings.

    3. If the amounts are not rounded, the form will automatically apply the same rounding settings as specified in the financial statements rounding settings.

    4. To enable rounding in the financial statements refer to Customize rounding in the financial statements.

  2. Select the method to insert the cash flow amounts into this form: CSV Import | Copy-Paste.

    Note: The cash flow import tool supports two methods to insert the amounts into this form:

    1. CVS Import: Import the amounts using the predefined CSV template file provided.

      Note: CSV Import supports loading the information from a CSV file with a predefined format/structure. An example file can be found here: CSV Import Template demo file.

    2. Copy-Paste: Allows you to directly copy and paste the amounts for each of the applicable cash flow sections.

  3. Select if you want to import Prior Year amounts or not.

  4. Review the Summary section to ensure the cash flow statement is in balance.