Bank Statement Management

Menu Path: Cash Management $Images\bluerarw.gif$ Processing $Images\bluerarw.gif$ Bank Statement Management

Purpose

View and manage transactions in imported bank statements.

Overview

Use Bank Statement Management to review transactions for a previously imported bank statement, and reconcile the bank statement transactions with Apprise transactions.

For a diagram of using Bank Statement Management with credit and debit bank statement lines, see Bank Statement Management Process Flow Diagram.

Managing Bank Statements

To manage a bank statement:

Enter the code for the bank statement in the Bank Statement Code field. Information for the bank statement appears.
If there are bank statement lines in the grid that you do not want to automatically match with transactions, select the check box in the Skip Auto Match grid column.
Click the Auto Match and Check Dupl button in the ribbon to match bank statement lines with Apprise transactions.
Review and update information in the grid to ensure each bank statement line matches an Apprise transaction, and includes all related information. If necessary, you can void bank statement lines that you do not want to reconcile with Apprise transactions.
Select bank statement lines, and click the Reconcile button in the ribbon to reconcile the lines with Apprise transactions. You may need to create transactions for bank statement lines if necessary.
Mark bank statement lines as finished. A bank statement is marked as Closed when all lines are marked as finished.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the Bank Statement Management window.
Select All	Click this button to select the check box in the Select column for all displayed bank statement lines. This button is only available if the Main tab is displayed.
Deselect All	Click this button to clear the check box in the Select column for all displayed bank statement lines. This button is only available if the Main tab is displayed.
Void	Click this button to void bank statement lines for which the check box is selected in the Select column. This button is only available if the Main tab is displayed.
Finish	Click this button to mark bank statement lines as finished for which the check box is selected in the Select column. This button is only available if the Main tab is displayed.
Reconcile	Click this button to reconcile bank statement lines for which the check box is selected in the Select column. This button is only available if the Main tab is displayed. Depending on the type of bank statement line selected, the following occurs: If a credit bank statement line is selected and a customer code is specified, but the line is not matched to an invoice, Deposit Entry appears, and allows you to enter a deposit for the bank statement line. If a credit bank statement line is selected, it is matched with an invoice, and a customer code is specified, a deposit is automatically created. If a debit bank statement line is selected, it is matched with a direct deposit voucher, and a supplier code is specified, the payment is automatically completed. If a debit bank statement line is selected and a supplier code is specified, but the line is not matched with a direct deposit voucher, A/P Matching Transaction Detail appears, and allows you match a voucher with the bank statement line. If a debit bank statement line is selected and a supplier code is specified, but the line is not matched with a direct debit voucher, Voucher Payment Select appears, and allows you match a voucher with the bank statement line. If no customer or supplier code is specified for a bank statement line, Service Charge Entry appears, and allows you to create a service (miscellaneous) charge. NOTE You can only reconcile multiple bank statement lines at the same time if the selected lines can be automatically reconciled.
Import	Click this button to display Bank Statement Import, which allows you to import OFX or MT940 bank statements from banks. This button is only available if the Main tab is displayed.
Auto Match and Check Dupl	Click this button to match invoices/vouchers with each bank statement line for the selected bank statement code. When you click this button, the software determines if there is an accounts receivable deposit, accounts payable payment, or general ledger service charge entry for each statement line. This button is only available if the Main tab is displayed.
Duplicates	Click this button to display Duplicate Transaction Detail, which allows you to view duplicate transactions for the selected bank statement line. This button is only available if the Main tab is displayed.
Linked Transactions	Click this button to display information for the transaction associated with the selected bank statement line, as follows: If the bank statement line is matched with an invoice and not reconciled, Invoice Inquiry appears, and allows you to view information for the invoice. If the bank statement line is matched with a voucher and not reconciled, A/P Detail appears, and allows you to view information for the voucher. If the bank statement line is a reconciled credit with an assigned customer code, Deposit Inquiry appears, and allows you to view information for the deposit. If the bank statement line is a reconciled debit with an assigned supplier code, Payment Inquiry appears, and allows you to view information for the payment. If the bank statement line is a reconciled credit or debit with no assigned customer or supplier code, Journal Entry Inquiry appears, and allows you to view information for the journal entry. This button is only available if the Main tab is displayed.
Reversed Transactions	Click this button to display Reversed Transaction Detail, which allows you to view and manage reversed credit and debit transactions for the selected bank statement. This button is only available if the Main tab is displayed, and is only used for MT940 bank statements.
Additional Information	Click this button to display SWIFT MT940 Additional Information, which allows you to view additional information for a selected MT940 bank statement line. This button is only available if the Main tab is displayed.
Show Data	Click this button to display bank statements on the Inquiry tab based on the selected criteria. This button is only available if the Inquiry tab is displayed.

Ribbon Batch Tab Buttons

Button	Description
Select	Click this button to display Select a New Batch, which allows you to select a previously created accounts receivable batch.
Open Manual Batch	Click this button to display Open a New Batch, which allows you to create a new accounts receivable batch for manual deposits.
Close	Click this button to display Close A Batch, which allows you to close an accounts receivable batch.
Edit	Click this button to display Edit A Batch, which allows you to edit an existing accounts receivable batch.

Main Tab Fields and Buttons

Field or Button	Description
Bank Statement Code	Enter the code for a bank statement for which you want to display information, or click the Lookup button to select a bank statement code. Bank statement codes are automatically created when you import bank statements in Bank Statement Import.
Description	Enter a description of the selected bank statement code.
Statement Start Date	This field displays the start date of the selected bank statement code.
Statement End Date	This field displays the end date of the selected bank statement code.
Cash Account	This field displays the cash account of the selected bank statement code.
Status	This field displays the status of the selected bank statement code. A bank statement can have one of the following statuses: Open - The bank statement was imported, but has not been processed. In Process - A user manually updated a bank statement line or used the Auto Match feature to match bank statement lines to Apprise transactions. Closed - All bank statement lines are marked as finished.
Bank Account Currency	This field displays the currency of the selected bank statement code.
G/L Currency	This field displays the default general ledger currency.
A/R Batch #	This field displays the open accounts receivable batch if one is still open. You can use the Select, Open Manual Batch, Close, and Edit buttons on the A/R Batch tab in the ribbon to work with accounts receivable batches. Note The accounts receivable batch number sequence is shared by both Deposit Entry and Factor Receivables Entry, but you cannot use the same batch number for both. If you attempt to use the same batch number for both programs, a warning message appears, and you must select a different batch number.
Bank Statement Lines	This grid displays lines for the selected bank statement code. You can update data for the following columns: Select - Select the check box in this column for bank statement lines you want to mark as voided, finished, or reconciled using the ribbon buttons. Duplicate - Select the check box in this column to indicate a line already exists as a transaction in Apprise. Voided - Select the check box in this column for bank statement lines you want to mark as voided. Matched Invoice # - After using the Auto Match feature, this is the Apprise invoice number that matches the bank statement line. You can update this number. Matched Voucher # - After using the Auto Match feature, this is the Apprise voucher number that matches the bank statement line. You can update this number. Customer Code - After using the Auto Match feature, this is the Apprise customer code that matches the bank statement line. You can update the customer code. Supplier Code - After using the Auto Match feature, this is the Apprise supplier code that matches the bank statement line. You can update the supplier code. Voucher Payment Method - Enter Direct Deposit or Direct Debit for bank statement lines. Finished - Select the check box in this column for bank statement lines you want to mark as finished. Skip Auto Match - Select the check box in this column for bank statement lines which you want to skip when using the Auto Match feature. Status Note - Enter notes for each bank statement line. NOTE The MT940 Additional Information column may not show all additional information. Click the Additional Information button in the ribbon to view all additional information.

Inquiry Tab Fields and Buttons

Field or Button	Description
All Cash Accounts	Select this check box to display bank statements for all cash accounts. This check box is selected by default.
Cash Account	Enter a cash account for which to display bank statements, or click the Lookup button to select a cash account. This field is only enabled if you clear the All Cash Accounts check box.
All Statement Dates	Select this check box to display bank statements for all dates. This check box is selected by default.
Start Date	Enter a date for which to display bank statements, or click the drop-down arrow to select a date. If you want to display bank statements for a range of dates, enter the first date in the range. This field is only enabled if you clear the All Statement Dates check box.
End Date	Enter the last date in a range of dates for which to display bank statements, or click the drop-down arrow to select a date. If you want to only display bank statements for a single date, you can leave this field blank. This field is only enabled if you clear the All Statement Dates check box.
Bank Statements	This grid displays bank statements after you click the Show Data button in the ribbon, based on the criteria selected. Double-click a bank statement to display information for it on the Main tab.