Step
Action
Illustration
1
The Overview page appears.
2
On the right side, click the Task icon and in External Cash Transactions section, click either Create Transactions (Go to Step 3) or Create External Transactions in Spreadsheet (Go to Step 7).
3
In the Create External Transaction screen, complete the following fields:
Bank Account: Select a bank account
Business Unit (recommended): Select the business unit.
Amount: Enter the transaction amount.
Date: Enter the date of the transaction.
Reference: Enter a reference for the transaction.
Transaction Type: Select a type from the list.
4
Complete the following Accounting section fields:
Un-check the Account transaction check box
Enter Cash Account
Enter Offset Account
5
Click Save. An Information pop-up message appears.
6
Click OK.
7
Create External Transactions in Spreadsheet selection.
The Open Excel Template pop-up defaults to Open with Microsoft Excel. Click OK.
8
The spreadsheet opens in Excel.
Click File and select Save As to save the file in the desired location and enable editing.
9
Enter data into the corresponding cells of the spreadsheet.
10
Click the Instructions and CSV Generation tab and follow the instructions to generate a CSV file.
11
Upload the Excel file to Oracle
Click the Navigator and in the Tools section select File Import and Export.
The File Import and Export page appears.
12
In the
Search Results section,
click the Add 
icon. The Upload
File pop-up appears.
13
Click Browse and locate the file in the source directory. In the Account field, select fin/cashManagement/import. Click Save and Close.
14
Click the Navigator and in the Tools section select Scheduled Processes. The Scheduled Processes Overview page appears.
15
Click Schedule New Process. The Schedule New Process pop-up appears.
16
In the Name field, select Load Interface File for Import and click OK. The Process Details pop-up appears.
17
In the Import Process field, select Import External Transactions.
In the Data File field, select the file uploaded to Oracle in Step 13.
Click Submit.
A Confirmation pop-up appears.
18
Click OK.
