1. Implementing Applications
  2. Enter Daily Rates Using the Daily Rates Spreadsheet

Enter Daily Rates Using the Daily Rates Spreadsheet

You are required to enter the daily rates for currency conversion from Great Britain pounds sterling (GBP) to United States dollars (USD) for 5 days.

To load rates using the Create Daily Rates Spreadsheet, you must first install Oracle ADF Desktop Integration client software. Oracle ADF Desktop Integration is an Excel add-in that enables desktop integration with Microsoft Excel workbooks. You can download the installation files from the Tools work area by selecting Download Desktop Integration Installer.

Entering Daily Rates

  1. From the General Accounting work area, select the Period Close link.

  2. From the Tasks panel, click the Manage Currency Rates link.

    Use the Currency Rates Manager page to create, edit, and review currency rate types, daily rates, and historical rates.

  3. Click the Daily Rates tab.

    Use the Daily Rates tab to review and enter currency rates.

  4. Click the Create in Spreadsheet button.

    Use the Create Daily Rates spreadsheet to enter daily rates in a template that you can save and reuse.

  5. Click in the From Currency field. Select the GBP - Pound Sterling list item.

  6. Click in the To Currency field. Select the USD - US Dollar list item.

  7. Click in the Conversion Rate field. Select the Spot list item.

  8. Click in the From Conversion field. Enter a valid value: 10/2/2017.

  9. Click in the To Conversion Date field. Enter a valid value: 10/6/2017.

  10. Click in the Conversion Rate field. Enter a valid value: 1.6.

  11. Click Submit and click OK twice.

  12. Review the Record Status column to verify that all rows were inserted successfully.

  13. Save the template to use to enter daily rates frequently. You can save the spreadsheet to a local drive or a shared network drive.

  14. Optionally, edit the rates from the Daily Rates user interface or resubmit the spreadsheet.

Related Topics