Cash flow import / copy-paste tool
The Cash flow import / copy-paste tool lets you easily transfer balances from Excel or CSV files into dynamic tables within the financial statements.
Note: The cash flow import / copy-paste tool is not available in all Global Statutory Reporting apps.
You are required to document the following information:
-
Specify whether the amounts you want to import or copy are already rounded or not.
Note: Financial statements can be rounded to thousands, millions and billions.
-
Specify whether the amounts imported/copied are already rounded as per the financial statements' rounding settings.
-
If the amounts are not rounded, the form will automatically apply the same rounding settings as specified in the financial statements rounding settings.
-
To enable rounding in the financial statements refer to Customize rounding in the financial statements.
-
-
Select the method to insert the cash flow amounts into this form: CSV Import | Copy-Paste.
Note: The cash flow import tool supports two ways of inserting the amounts into this form:
-
CVS Import: Import the amounts using the predefined CSV template file provided.
Note: CSV Import supports loading the information from a CSV template file with a predefined format/structure. An example file can be found here: CSV Import Template demo file.
-
Copy-Paste: Allows you to directly copy and paste the amounts for each of the applicable cash flow sections.
-
-
Select if you want to import Prior Year amounts or not.
-
Review the Summary section to ensure the cash flow statement is in balance.