Mass Loading Currency Exceptions

You can mass load currency exceptions to save time. An example is provided below.

In Practice: Currency Exception Mass Load

In this use case, a beginning retained earnings currency type is defined, which is mapped to accounts. Here is the structure:

Exchange Rates:

Currency Type:

Currency Exceptions:

1. Access the Currency Exception Setup page by navigating to Maintenance > Currency > Currency Exceptions.

2. Select a Reporting Currency. Reporting currencies are available based on what you've defined in the Hierarchy Management screen for Reporting Currency.

3. In the right pane, click the Add button and select the company name.

4. For Currency Exception, select Beg RE 00036.

5. Click Save.

6. Instead of clicking the Copy To option and selecting account 11001 and then repeating for account 11002, click the Mass Upload icon shown below.

7. The Mass Load page appears. Select a file to load by clicking the Choose File button. The .xlsx file selected for this example is shown below.

You can upload XLSX file types only with a maximum size of 10MB! See Understanding File Formatting for Currency and Calculation Exception Mass Load.

8. Click Submit to perform the upload. The system checks to see if the file contents already exists. If the contents exists, the system performs an append. If the contents does not already exist in Planful, an override is performed.

A message will appear indicating the upload processed and you can check the status in the Detail Log. Click the Output All icon to export the currency exception details to Excel.