CashFlowMapper - Importing Plan Details & Transactions

Importing Plan Details & Transactions

This is the recommended way to both set up you plans and do any editing involving more than a few changes to existing transactions.

Refer to the video on this feature at our YouTube Channel.

Template

• For a first-time use, download the sample template and the import rules at the Templates menu.

Upload sample

1. In the yellow header section, only edit cells B2:B7.
2. Amount fields must have a number in them, even if it’s zero.

Import rules

1. You have the option of using the full names of recurrence types & frequencies, and / or the abbreviations.
2. An imported FX code with no rate will prompt a warning that FX calendars net to be uploaded or manually set up.
3. Tax Links will not work unless your tax code match those of a tax calendar you link to your plan.

Uploading data

Importing to a new plan

• From your workspace, select the “Import Plan” menu option.

1. Select:

• Tax calendar – required for API links and recommended for all plans.
• FX calendar – optional.

2. Browse for your file.

3. Click the “Import plan” button.

Importing to an existing plan

You can make edits to your plan details or transactions as well as append new transactions.

• Select your plan, and then the “Import from CSV” option from the “Add Transaction” menu.

1. Browse for your file.

• The effects of your import are per the text underneath the option.
• You can edit existing details and transactions (transaction description must match exactly for an edit to take place), as well as add new transactions.

2. Click “Import transactions”.

Importing Data from Accounting Packages

This can be done by exporting the data you want to work with, and ensuring it is formatted correctly in the upload template – refer to the Import Rules discussed above in this article.

You can also link to software directly to import debtors, creditors and applicable consumption tax data. Refer to the Accounting Software Links Overview.