Import Bank Reconciliation Transmittal

Payment Reconciliation Batch Processing allows authorized users to import the reconciliation transmittal file by bank account (singular) or bank (multiple bank accounts for the bank).

1. Go to Financial Management > Payment Processing > Payment Reconciliation Batches.
2. On the Payment Reconciliation Batch List page, click Import. The Import Bank Reconciliation Transmittal page opens.
3. In Responsible Department, select the department responsible for this payment reconciliation batch.
4. Select the Bank associated to the payment reconciliation batch.
5. Select the Bank Account associated to the payment reconciliation batch. Users must be granted access to the account in User-Based Security.

   For Bank and Bank Account, you can select one of the following options:

   • a single Bank with all accounts (leave Bank Account blank)
   • a specific Bank Account (leave Bank blank)
   • a single Bank with a specific account selected in Bank Account

   The data from the bank dictates how the system should be used. If a single Bank is selected and if multiple Bank Accounts for the bank exists in the transmittal file, the system generates multiple payment reconciliation batches–one for each bank account in the transmittal file.

6. Select the Default Reconciliation Date used for the payment reconciliation batch.
7. In Create ZBA Wire Transfers, select whether confirming wire transfers will automatically be made as a result of reconciling these payments. The bank selected must be configured to accept wire transfers. See Zero Balance Account for more information.

Click here to see the available options:

• No – No wire transfers are made.
• Yes, One Per Batch – One wire transfer is made for the entire batch regardless of the reconciliation date of the payment.
• Yes, One Per Day/Per Batch – One wire transfer is made on each day that a reconciliation transaction occurred in the batch.

8. Click Next to go to Page 2 of the import process.
9. Enter the appropriate Import Definition information. See Import Setup for more information on defining the import type Reconcile Bank Import for the import bank reconciliation transmittal process.
10. Click Next to go to Page 3.
11. On Page 3, select a check box next to the appropriate Processing Options, as needed. Notice the Validation Warning and Error Messages that display at the bottom of the page. Click a plus sign (+) next to the Error or Warning to expand the message and view detailed information.
12. Click Next to complete the import process and generate Edit and Audit Listings if selected in Processing Options. Page 4 displays the Import Confirmation information.

See Also

Import Process