Note

An asterisk (*) indicates a required field.

Header Fields

Bank Account *

The bank account associated with the bank statement.

Include future transactions

Select this check box to display future items, based on the Bank Reconciliation date, that hit the cash account in Bank Reconciliation; this includes PY (Check), DP (Deposit), and JE (Journal Entry) and IV (AP Invoice). These future items will show in the reconciliation grid and can be reconciled; a Bank Adjustment (BA) is created to offset each item.

Note

Once a future item is selected in the Bank Reconciliation, this check box is disabled. All items must then be unchecked before it can be enabled again. When unchecked, the associated BA is removed from the Bank Reconciliation. The BA items created for the future items are disabled and cannot be selected.

Reconcile Date *

The bank statement date. When you enter this date on a new bank reconciliation, the status is changed to In Process. After you select a transaction to be reconciled, this field becomes disabled. You can enable the field by deselecting all selected transactions and clicking Refresh.

Note

Enter a date into the Reconcile Date field and the Select from file... button appears in the header. Refer to "To Add a Bank Reconciliation" instructions, below for details on how to use this button.

Current Balance *

The current balance from the bank statement.   

Starting Check

Use this field when you are inquiring or reconciling and want to narrow the display. Enter a starting check number. When you click Refresh, the system updates the transactions grid with checks that start with the alpha/numeric combination you entered. If you are reconciling, clear this field to enable the Reconcile button.

Ending Check

Use this field when you are inquiring or reconciling and want to narrow the display. Enter an ending check number. When you click Refresh, the system updates the transactions grid with checks that start with the alpha/numeric combination you entered. If you are reconciling, clear this field to enable the Reconcile button.

Show

Use this field when you are inquiring or reconciling and want to narrow the display. Select a show option from the drop-down list. The system updates the grid immediately based on your selections.

• All Tran — Select this option to display all transactions in the grid. This option is the default. All reconciled (checked) transactions and unreconciled (not checked) transactions display based on the Reconcile Date.
• Reconciled — Select this option to displays reconciled transactions in the grid. All reconciled (checked) transactions appear.
• Unreconciled — Select this option to displays unreconciled transactions in the grid. All unreconciled (not checked) transactions appear.

Starting Date

Use this field when you are inquiring or reconciling and want to narrow the display. Enter a starting date. When you click Refresh, the system updates the grid with transactions that start on or after the date you entered. If you are reconciling, clear this field to enable the Reconcile button.

Ending Date

Use this field when you are inquiring or reconciling and want to narrow the display. Enter an ending date. When you click Refresh, the system updates the grid with transactions that end on or before the date you entered.

This field defaults to the Reconcile Date you entered. If you edit this date and you are reconciling, you must enter the reconcile date in this field to enable the Reconcile button.  

Difference

The display-only total of the difference between the Adj GL Balance and the Adj Bank Balance total fields at the bottom of the tab. When the difference is zero, the system enables the Reconcile button at the bottom of the grid.

Reconcile All Current

Select this check box to include all non-future or "current" transactions in the grid in the reconciliation process.

Select from File

Click the Select from File button to open the Import Bank Reconciliation File window to import an ASCII file that contains cleared checks information (provided by the bank) into eFinancials. The Bank Reconciliation process will mark the checks as reconciled by default.

Note

• Refer to Import Bank Reconciliation File Fields and To Add a Bank Reconciliation, above, for more information on the window fields and the process.
• Refer to Import File Format, above, for the format required for the ASCII file.

Find

This field defaults to Document ID. If you click any underlined grid column title, the field label changes to reflect your selection. You can then search for entries based on the field label. For example, if you know the entry transaction code, click the Tran Code column title and the find field label changes to Find Tran Code.

Enter the first few letters or numbers to search for (or select from a drop-down list if one displays), and click Find. The items that are the nearest match to your entry display in the grid.

Refresh

Click to update entries in the grid. Typically, you select this button after you complete Bank Statement Information fields. For example, if you enter starting and ending check numbers, selecting the Refresh button causes checks with those numbers to display in the grid.

Grid Fields

Note

To sort the list by a particular column, click the column title.

Reconcile

Select the individual transactions you want to include in the reconciliation process. Or, you can select the Reconcile All check box in the header to select all transactions at once.

Tran Code

The transaction code that describes the transaction.

Document ID

The identification of the document used to generate the transaction. For example, a document identification that starts with JE is a journal entry document.

Acct Date

The date of the document used to generate the transaction.

Description

The description of the document used to generate the transaction. For journal entries that affect cash, the journal entry identification displays as the description.

Deposit

The total amount of funds deposited for a deposit, interest, or adjustment. If the transaction resulted in a deposit to the account, an amount appears. Otherwise, the field displays $0.00.

Withdrawal

The total amount of funds withdrawn for a check, direct deposit advice, service charge, or adjustment. If the transaction resulted in a withdrawal from the account, an amount appears. Otherwise, the field displays $0.00.

GL Acct Balance

The display-only balance for the general ledger account associated with the bank. The balance is as per the date you entered in the Reconcile Date field.

Adj GL Balance

The display-only adjusted general ledger balance.

When the difference between the Adjusted GL Balance field and the Adjusted Bank Balance field is zero, the system enables the Reconcile button.

Adj Bank Balance

The display-only total of the adjusted bank balance of this bank account. That is, the current system balance for the account, plus deposits in transit, minus outstanding checks, plus or minus bank adjustments.

When the difference between the Adjusted GL Balance field and the Adjusted Bank Balance field is zero, the system enables the Reconcile button.

Interest Earned

The display-only total interest added to the general ledger cash account using the Add Interest instructions.

GL Adjustments

The display-only total of any adjustments (added or subtracted general ledger adjustments that have been made to the general ledger cash account) using the Add Adjustment instructions.

Bank Adjustments

The display-only total of any bank adjustments that have been made to reconcile the current bank statement. An adjustment does not affect the general ledger cash account.

Services Charges

The display-only total of service charges subtracted from the general ledger cash account using the Add Service Charge instructions.

Outstanding Checks

The display-only total of the checks that have been issued but are not included in the current statement.

Deposits in Transit

The display-only total of the deposits that have been made but not included in the current statement.

Buttons

Add Service Charge

Click to add a service charge, which is a special type of payment.

Add Interest

Click to add interest, which is a special type of deposit.

Add Adjustment

Click to add an adjustment, which can be a special type of payment or deposit.

Cancel

Click to exit without saving changes.

Reconcile

Select this button to complete the reconciliation and clear the transactions as reconciled. When you select this button, the system displays a detail version of the Bank Reconciliation report on-screen automatically. You can print the report now or print it later using the report menu option Bank Reconciliation Report.

The system enables this button when the difference between the Adjusted GL Balance field and the Adjusted Bank Balance field is zero. These fields appear in the total fields below the grid. The zero total displays in the Difference field in the heading of the tab.

Note

If the Reconcile button does not display, refer to Bank Reconciliation Troubleshooting for more information.

Instructions on how to import a bank reconciliation file appear in the tab.

Choose File / Browse...

Click the Choose File or Browse... button and the Open window appears so you can choose an ASCII file to import. Note that the label you see depends on the browser you are using.

Format

Select from the drop-down the file format for your ASCII file. Refer to Import File Format, above, for details on the valid file formats.

Options

Select an option that tells the system what to during processing.

• Process valid entries, report summary of checks and exceptions (default)
• Process valid entries, report cleared checks and exceptions
• Cancel process if any exceptions are found

Upload and Import

When all other selections are complete, click on this button to upload and import the ASCII file.

Use one of these file formats to create an ASCII import file when you want to import check information to use in the Bank Reconciliation process. The format you use depends on the length of the check number.

Format 1 (6 character check number)

1-6: Right-justified check number with leading blanks (total 6 characters)

7-12: Date in YYMMDD format (total 6 characters)

13-24: Check amount with no decimal (total 12 characters)

Format 2 (10 character check number)

1-10: Right-justified check number with leading blanks (total 10 characters)

11-16: Date in YYMMDD format (total 6 characters)

17-28: Check amount with no decimal (total 12 characters)

1. From the eFinancials menu, select General Ledger—End of Period—Bank Reconciliation.
2. From the Bank Account drop-down list, select the bank account for the statement you want to reconcile.

Note

The list includes all bank accounts for the entitiescompanies to which you have access.

3. Click Add Reconciliation. The Bank Reconciliation Detail tab appears, enabling you to add reconciliation details. For more information, refer to Bank Reconciliation Detail Fields list.
4. In the Reconcile Date field, enter the reconciliation date on your bank statement. The system updates the grid with all transactions that are eligible for reconciliation.  
5. In the Current Balancefield, enter the current balance on your bank statement.  
6. Perform one of these actions. When you do, the balances, adjustments, and Outstanding Checks amounts change.
1. If you want to import an ASCII file provided by your bank containing cleared checks information (so that the information will appear in the grid):
• Click Select From File. This button appears when you select a Reconcile Date.
• Click Choose File / Browse... (label depends on your browser) and select your file.
• From the Format drop-down list, select the format of the file.
• Click Upload and Import.
• Refer to Import Bank Reconciliation File Fields and Import File Format, above, for more information.
2. Match transactions in your bank statement to on-screen transactions in the grid. For each match you find, select the Reconcile check box in the grid for that transaction (deposit or withdrawal). Use the Add Service Charge, Add Interest, and Add Adjustment buttons at the bottom of the page, as necessary.
7. Notice the Difference field. When the difference is $.00, the system enables the Reconcile button.

Note

If the system is not enabling the Reconcile button, refer to Bank Reconciliation Troubleshooting.

8. Click Reconcile to complete the reconciliation. The system clears the selected transactions as reconciled and a report appears in PDF format.

Note

The report that appears is determined by the Bank Reconciliation process prints setting on the GL Accounts setup tab.

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.