Upload a Bank Statement

This procedure describes how to upload the weekly bank statement retrieved by select associates to Oracle.

Step	Action	Illustration
1	Retrieve the Bank Statement files from Ipswitch. Click the Ipswitch application icon on your desktop. Drag and drop the desired file(s) to the desktop. Rename the file by adding a .txt to the end of the file name. Send to a zip folder. Save the zip folder to a designated folder for future reference.
2	In Oracle, click the Navigator icon and under the Tools section, select File Import and Export. The File Import and Export Overview page appears.
3	In the Search Results section, click Actions and select Upload from the list. The Upload File pop-up appears.
4	Click Browse and locate the BAI2 .zip file in the source directory. In the Account field, click the arrow and select: fin/cashManagement/import. Click Save and Close.
5	Click the Navigator icon and in the Tools section select Scheduled Processes. The Scheduled Processes Overview page appears.
6	Click Schedule New Process. The Schedule New Process pop-up appears.
7	In the Name field, select the Load Interface File for Import. If the process is not in the drop down list, click the Search link at the bottom to Search and Select the process name. Verify the process by reading the Description. Click OK. The Process Details pop-up appears.
8	In the Import Process field, select the Process BAI2 Format Bank Statement file. In the Data File field, select the file uploaded to Oracle in Step 3. Click Submit. A Confirmation pop-up appears.
9	Click OK.

Verify a Successful Bank Statement Upload

Use the steps below to verify the bank statement was uploaded correctly.

Step	Action	Illustration
1	Click the Navigator icon and under the Cash Management section, select Bank Statements and Reconciliations. The Bank Statement Overview screen appears.
2	On the Overview screen, scroll down to the Process Monitor section. If the processes from the section above are not shown, click the Refresh icon. The processes and status will display in the list.
3	The process Status should be Succeeded. If process are still running or paused, click the Refresh icon again.
4	Periodically click the Refresh icon until all Status rows show Succeeded.
5	If a status shows Error, scroll to the top of the screen to the Process Warnings and Errors section. Click the Refresh icon until the process displays.
6	Click the file expand icon. Click the linked Import Error in the Status Column.
7	The Error Message displays. Email the error to the Service Desk at servicedesk@remingtonhotels.com.
8	After successfully uploading the statement, send a confirmation to the following (replace titles with the current names): Hotel Accounting Managers Remington Corporate Accounting Manager Accounts Payable Coordinator for Remington Hotels Corporate Accounting

Updated 4/9/2019 JM

Disclaimer: This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use as an Ashford or Remington employee or contractor. This document may not be shared, downloaded, copied, printed, displayed, reproduced, published, licensed, posted, transmitted or distributed in whole or in part without the express authorization of Ashford or Remington. The information contained in this document is subject to change without notice. TRC last published on 1/3/20 by JM. Version 1.14