Simplify and streamline the management of your foreign currency exposures with our CSV Bulk Uploader. This powerful tool is designed to make data entry efficient, accurate, and user-friendly.
Step 1: Navigating to the Client Import Menu Item
From the View Reports page, upon logging into CNS, scrolling down the left-hand menu, there is a menu option called "Client Import." Select "Client Import" to get started on your bulk upload journey.
On this page, you will see the upload file requirements (.csv and not exceeding 4 MB) along with a csv file template hyperlink for you to download and begin filling out the details necessary for your exposure upload. There is also a hyperlink under "Click here for more information" that gives details on the handling of variables within the upload template and how to apply your information accurately for a successful upload.
When "here" is clicked, the cashflow column details for forecasts, source documents, and budget rates are defined to ensure accurate and relevant data is entered into their respective columns.
Step 2: Familiarization with Upload Template Functionality
Download the file named Forecast/SourceDoc/BudgetRate Template.CSV and keep the cashflow column information box handy as a reference tool.
The downloaded file should open up and appear as shown below with columns (in their respective order from A to M)
Note: Items marked with an asterix * are mandatory fields
- CNS_Id* (this is an ID stored in the CNS system memory in case of later updates or deletions to specific exposures)
- Action* (add, update, or delete)
- DocumentID* (an ID relevant for the user to distinguish between different exposures)
- NotionalCCY* (the currency being paid or received)
- CounterCCY* (the counter currency)
- NotionalAmount* (the amount of the currency being paid or received)
- Type* (forecast, source document i.e invoice or receipt, or budget rate)
- Direction* (payment or receipt or notional currency)
- StartDate* (the first day the exposure is due)
- EndDate* (the due date of the exposure)
- BusinessUnit (a business unit assigned to a particular exposure if applicable)
- Rate (an expected or budgeted rate associated with particular exposures)
- Note (any information that may help the user identify a particular exposure)
Step 3: Example Exposure Entry Walkthrough
This step will take you through a walkthrough on the details that are necessary to be inserted into the mandatory columns for a successful upload:
Fill in the appropriate information as shown below:
Save the .csv file with a name of your choice, such as in this example I have named it "Exposure Upload Walkthrough." Make sure the name is unique to you for any future adjustments that may need to be made.
Step 4: Uploading the .csv file
The box that is labelled "Drag files here to upload" can be used to drag and drop the exposure upload files and may also be clicked to prompt the file explorer window to appear for you to search for your desired upload file.
Once clicked, you can navigate to the folder in which your desired upload file is located as shown below:
At this stage you have selected the file you want to upload, you click Open and the name of your file will appear in the box in CNS as below:
Step 4: Import Data and Check for Errors
Once the file name is visible in the upload box it is time to click Import Data, which will give you a preview of your data in their respective fields in CNS. There will also be a Status column on the far right of the preview table to indicate with a green tick or a red cross to show whether the fields are entered in correctly as shown below (in another part of this guide we will demonstrate the error handling and how to rectify any issue):
Step 5: Save Upload File and View in CNS
Upon importing the data and the status of each row being correct through the display of green ticks under the status column, click Save as shown below:
Once the Save button has been clicked, an automatic message will pop down with the message "The data has been imported successfully" as shown below:
Step 6: View Uploads in CNS
Now you can view your data in CNS under the FX menu. In this case, we uploaded forecasts so the menu navigation would be FX >> FX View Data >> View Forecast Data
You can use the filtering functionality in the search bars across the table to make sure your data has been uploaded as expected.
Common Mistakes and Error Handling:
There are a number of common errors when entering in exposure data. Thorough examination of this knowledge base should reduce the margin for error significantly, thereby creating a seamless and user-friendly experience when using the bulk upload functionality within the CNS platform.
Common Errors:
- Currencies being misspelled due to typo e.g NDZ instead of NZD or UDS instead of USD etc
- Due to the upload file being in .csv format, if there is a typo and it is dragged down the columns, then every row will have the same error
- Misspelling of business units or entering business units into the column before these business units are stored in the CNS database
- The start date must be before the end date - please check that this is the case in your upload file
Error Handling for Client Import:
To reduce the margin for error of uploading incorrect data there are mechanisms in place to indicate whether there are issues within certain rows and particular cells prior to saving the data in CNS via the Save button. If there are any errors in the upload file, CNS will not accept the upload until the issue is resolved. For any issues that cannot be resolved via self-service correction - contact support@cnstreasury.com for further assistance.
Examples of Error Handling:
For the following example, errors have been fabricated to illustrate the handling of these in CNS when uploading files with clear issues. Below is an edited file upload version with deliberate errors: You will see that in row 2 the NotionalCCY is UDS and the direction is spelled Receiptt and in row 2 the CounterCCY is NDZ while the direction is spelled Reciept. Row 3 remains unchanged.
Following the same process as in Step 4, you can see below the Status column has marked a red cross next to rows with incorrect or unrecognizable data:
For more specific details on the error, you can hover your mouse over the red cross under the Status column and it will provide a message as shown in the example below, the error message reads: "NotionalCCY 'UDS' is not recognised, value must be a supported 3 character currency code at line 2. Direction required must be one of {'pay, 'payment', ''receive', 'receipt'} at line 2"
Updating and Deletion of Existing Exposures
Step 1: Exporting existing exposures in file upload format
In this example, we are using forecasts; however, the steps to take follow a very similar process.
Firstly, we navigate to the View Forecasts screen via the menu through FX >> View Data >> View Forecast Data as shown below:
Once you have reached the View Forecast Data screen, circled in the image above is the Export Data button. Clicking on the Export Data buttons gives you all of the raw data in your environment This 
button allows you to export all of your data in the correct format for bulk upload 
via the Export Bulk Upload Format button, with the ability to Update or Delete specific exposures if there are any adjustments to your risk, giving you seamless coverage of your FX risk.
Once clicking the Export Bulk Upload Format button, a .csv file will download for you to open and view your current exposures as shown below:
Upon opening your exported file you will see a .csv file with your data in an upload format with the most notable columns being the CNS_Id and Action columns.
The CNS_Id column allows for CNS to use any particular piece of data to be uniquely identified to give the user flexibility in making any changes if and when necessary to their focus data points. Due to the nature of these user needs, the Action column accepts three commands: Add, Update, and Delete. Upon exporting existing data, the .csv file produced automatically uses the command update in case of any potential mistakes. For example, if a particular exposure was not meant to be changed and a file was uploaded with the Action command Update, while the other details for the exposure remained the same - there would be no change in CNS.
However, when using the commands Add or Delete, these result in changes in the data in your profile and we will illustrate some examples of how this may occur below.
You may export the file as is and add to your data by inserting more rows of data and using Add in the Action column. Conversely, you may insert Delete into the Action column depending on your individual needs.
For the purpose of this exercise, we will focus on the first three entries and display how the records can be edited via the Update in the Action column.
Above shows three CNS_Ids with the Action column reading Update for all three entries. The noted columns that will be updated are the NotionalAmount and Direction columns. Note that the dates are remaining unchanged along with the currency pairs.
As shown below, the NotionalAmount has the been adjusted to $2,000,000 USD for all three and the Direction column reads Receipt instead of Payment, while all other data points remain the same.
Following steps 1-4, you will be able to see a preview of your adjustments prior to saving along with the error checking to give you full confidence in your upload file. Below is a snapshot for your data preview for your last checks before saving the new file.
Once you press Save, you can double check your data has been updated the way you expected it to. Below is a snapshot of the updated View Forecast Data screen:
Here you will be able to view any edits and your complete exposure profile.
This guide has walked you through the steps required to format your CSV file correctly and seamlessly upload it into CNS using the Client Import functionality. With this tool, you can efficiently manage and input large volumes of data while ensuring accuracy and consistency. Should you have any questions or require additional support, our team is always ready to assist you. For any additional queries please feel free to contact support@cnstreasury.com
Thanks,
The CNS Team