CREATE BANK TRANSACTIONS HISTORY 

Use this screen to populate the Bank Transactions History table with transaction information from three sources: Accounts Payable (checks and EFT), Cash Receipts (deposits), and Payroll (checks and direct deposits).

During the Create process, the system copies transaction data from the source tables to the Bank Transactions History table. (The source tables include:  Vendor Check for A/P transactions, Cash Receipts Header and Transaction History for Cash Receipts transactions, and Employee Earnings for Payroll transactions.) During the copy process, the system marks the appropriate source table to indicate that the transaction has already been written to the Bank Transactions History table.

Transaction timing data (FY, Pd, Subpd) as well as transaction date, transaction ID, number, name, and amount are written to the Bank Transactions History table during the Create process. The system automatically assigns an initial OUT (Outstanding) condition to each record and identifies and writes the transaction origin (i.e., A/P, Cash Receipts. or Payroll) to the table.

Once data is copied to the Bank Transactions History table, the system performs all bank reconciliations using only data from this table. The source tables are accessed once to populate the Bank Transactions History table and are not accessed again during bank reconciliations.

Note that "manual adjustment" data entered as New Line entries in the Accept Bank Transactions screen will also be written to the Bank Transactions History table when a new row is saved. The source table for manual adjustments is MAN (Manual).

Always keep manual adjustment entries to a minimum. Record bank interest as a cash receipt and record bank charges in Accounts Payable. Manual entries are designed to facilitate bank reconciliations only in the rare circumstance in which the normal data entry source has not been used.

Bank Abbreviation

Range Option

Enter the desired range option or select a range option from the drop-down list. The default for this field is set to All. It can be changed to One, Range, From Beginning, or To End, as needed.

From

Enter, or use to select, a bank abbreviation. If you select All or From Beginning as the Range Option, this field will be inactive.

To

Enter the ending range of the bank abbreviations. If you select All, One, or To End as the Range Option, this field will be inactive.

Select Transaction Types

Use this group box to create transactions history from Accounts Payable, Cash Receipts, and/or Payroll detail records. You cannot run this process unless you have made at least one selection.

For companies that use a combined bank account for both payroll and non-payroll activities, the same cash accounts will have been used for A/P, Cash Receipts, and Payroll transactions.

A/P Transactions

Select this check box to create bank transactions history from accounts payable checks and EFT data.

When the Create process is run, the system first reads records from the Vendor Check table that qualify for the timing parameters specified. The system then writes the detail for each qualified transaction to the Bank Transactions History table, including the following data:

The transaction is marked as OUT (Outstanding) and its source is tagged as AP (Account Payable). The system also writes AP Transaction to the Transaction Description field in the table.

C/R Transactions

Select this check box to create bank transactions history from cash receipts data.

When the Create process is run, the system first reads records from the Cash Receipts Header and Detail tables that qualify for the timing parameters specified. The system then writes the detail for each qualified transaction to the Bank Transactions History table, including the following data:

The transaction is marked as OUT (Outstanding) and its source is tagged as CR (Cash Receipt). The system also writes Cash Receipt to the Transaction Description field in the table.

P/R Transactions

Select this check box to create bank transactions history from payroll checks and direct deposit data.

When the Create process is run, the system first reads records from the Employee Earnings table that qualify for the timing parameters specified. The system then writes the detail for each qualified transaction to the Bank Transactions History table, including the following data:

The transaction is marked as OUT (Outstanding) and its source is tagged as PR (Payroll). The system also writes PR Transaction to the Transaction Description field in the table.

Select Timing

Use this group box to specify the timing parameters for the Create Bank Transactions History process.

Range Option

Enter the desired range or select a range from the drop-down list to indicate the timing parameter to include. The default for this field is set to All. It can be changed to One, Range, From Beginning, or To End, as needed.

From Fiscal Year

Enter the starting fiscal year for the create process, or use the drop-down list to select a fiscal year from those displayed. If you select All or From Beginning as the Range Option, this field will be inactive.

From Period, Subperiod

Enter the starting accounting period and subperiod for the create process, or use the drop-down lists to select a starting period and subperiod from those displayed.

If you specify a starting subperiod, the subperiod ending date automatically displays next to the subperiod number.

If you select All or From Beginning as the Range Option, the From Period and From Subperiod fields will be inactive.

To Period, Subperiod

Enter the ending accounting period and subperiod for the create process, or use the drop-down lists to select an ending period and subperiod from those displayed.

If you specify an ending subperiod, the subperiod ending date automatically displays next to the subperiod number.

If you select All, One, or To End as the Range Option, the To Period and To Subperiod fields will be inactive.

Exchange Rates

Click this button to access the Exchange Rates subtask.

This button will not be enabled if you selected the P/R Transactions check box in the Select Transaction Types group box.

Create Bank Transaction History

Select this button on the toolbar to activate the Create Bank Transactions History process.

To view selected transactions from the Bank Transactions History table that were populated as a result of the Create process, use the Accept Bank Transactions or Process Batch Bank Transactions screens. You can also inquire on selected transactions in the Bank Reconciliation Inquiry or print selected transactions using the Bank Reconciliation Detail Reports.