Exchange rates are typically produced from an external finance system in a spreadsheet format. Copying them into Allocadia by hand is tedious and error prone. The Import option allows Administrators to take the spreadsheet provided by finance and upload it quickly and efficiently into Allocadia
On the Home Tab access the Master Settings
Note: Only Owners and Admins assigned to the root folder are able to access the Master Settings
Under the Template Set Up click on Currency
Once on the Currency page scroll to the bottom of the screen to the Exchange Rates Overrides and click Import
Find the Excel file you wish to upload. The system will automatically start the upload process once you select the file you wish to Import
Note: To avoid errors, please note that file structure is important for the Import. Currencies must be listed in first column. Column names must be listed in first row, with cell intersections being the exchange rate for currency/column combo. Example:
Check your currency exchange rate override and look for an [i]. This will indicate that the exchange rate has successfully been overridden.
Note: During the Import any exchange rates that have been left blank in the spreadsheet will clear any previous overrides.