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 creation process, Costpoint 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, Costpoint 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. Costpoint 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.
After data is copied to the Bank Transactions History table, Costpoint 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 was not used.
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Bank Abbreviation
Use this row to select the bank abbreviations for which to create bank transaction history.
Option
From the drop-down list, select the type of range for entering the range of bank abbreviations. The options are:
-
All — Select this option to create bank transaction history for all bank abbreviations. The Start and End fields are disabled for this option.
-
One — Select this option to create bank transaction history for one bank abbreviation. Enter the bank abbreviation in the Start field. The End field is disabled for this option.
-
Range — Select this option to create bank transaction history for a contiguous range of bank abbreviations. Enter the beginning bank abbreviation in the Start field and the ending bank abbreviation in the End field.
-
From Beginning — Select this option to create a range that starts from the beginning of all available bank abbreviations and ends with the bank abbreviation that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to create a range that starts with the bank abbreviation that you enter in the Start field and ends with the last bank abbreviation of all the bank abbreviations. The End field is disabled for this option.
Start
If you selected One, Range, or To End in the Option field, enter the beginning bank abbreviation, or click 
to select one from a list. If you select All or From Beginning in the Option field, the Start field is unavailable.
End
If you selected Range or From Beginning, enter the ending bank abbreviation, or click to select one from a list. If you select All, One, or To End in the Option field, the End field is unavailable.
Timing
Use this row to enter the fiscal year, period, and subperiod for creating bank transaction history.
Option
From the drop-down list, select the type of range for entering fiscal year, period, and subperiod. The options are:
-
All — Select this option to create bank transaction history for all fiscal years, period, and subperiods. The Start and End fields are disabled for this option.
-
One — Select this option to create bank transaction history for one fiscal year, period, and subperiod. Enter the bank abbreviation in the Start field. The End field is disabled for this option.
-
Range — Select this option to create bank transaction history for a contiguous range of fiscal years, periods, and subperiods. Enter the fiscal year, period, and subperiod in the Start field and the ending fiscal year, period, and subperiod in the End field.
-
From Beginning — Select this option to create a range that starts from the beginning of all available fiscal years, periods, and subperiods and ends with the fiscal year, period, and subperiod that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to create a range that starts with the fiscal years, periods, and subperiods that you enter in the Start field and ends with the last fiscal year, period, and subperiod of all the fiscal years, periods, and subperiods. The End field is disabled for this option.
Start (Fiscal Year, Period, and Subpd)
If you entered One, Range, or To End, in the Timing Option field, enter the starting fiscal year, period, and subperiod for which to create bank transaction history. You can also click to select the fiscal year, period, and subperiod from a list. If you select All or From Beginning in the Option field, the Start (Fiscal Year) field is unavailable.
After you enter a starting subperiod, the subperiod ending date automatically displays next to the subperiod number.
End (Period, Subpd)
If you entered Range or From Beginning in the Timing Options field, enter the ending accounting period and subperiod for which to create bank transaction history. You can also click to select the period and subperiod from a list. If you select All, One, or To End as the Timing Option, the From Period and From Subperiod fields are unavailable.
After you enter an ending subperiod, the subperiod ending date automatically displays next to the subperiod number.
Options
Select Transaction Types
Use this group box to specify whether or not to create bank transaction history from Accounts Payable, Cash Receipts, and/or Payroll detail records. You must select at least one of these transactions types before you can create bank transaction history.
For companies that use a combined bank account for both payroll and non-payroll activities, the same cash accounts are used for A/P, Cash Receipts, and Payroll transactions.
A/P Transactions
Select this check box to create bank transaction history from accounts payable checks and EFT data.
The following information for each A/P transaction is created for the bank transaction history:
-
Fiscal year, period, and subperiod
-
Check date, check number, and check amount
-
Vendor ID and name
-
Cash account, organization, reference 1, and reference 2
The following are assigned for each A/P bank transaction created for history:
-
OUT (Outstanding) for the code.
-
AP (Accounts Payable) as its source.
-
AP Transaction as the transaction description.
C/R Transactions
Select this check box to create bank transaction history from cash receipts data.
The following information for each C/R transaction is created for the bank transaction history:
-
Fiscal year, period, and subperiod.
-
Cash receipt date, number, and amount.
-
Cash account, organization, reference 1, and reference 2.
The following are assigned for each C/R bank transaction created for history:
-
OUT (Outstanding) for the code.
-
CR (Cash Receipt) as its source.
-
Cash Receipt as the transaction description.
P/R Transactions
Select this check box to create bank transaction history from payroll checks and direct deposit data.
The following are assigned for each P/R bank transaction created for history:
-
Fiscal year, period, and subperiod.
-
Check date, check number, and check amount.
-
Employee ID and last name.
-
Cash account, organization, reference 1, and reference 2.
The following are assigned for each P/R bank transaction created for history:
-
OUT (Outstanding) for the code.
-
PR (Payroll) as its source.
-
PR Transaction as the transaction description.
Create Bank Transactions History
Click 
and select Create Bank Transactions History to run the create bank transaction history process.
To view selected transactions from the Bank Transactions History table that were populated as a result of the creation process, use any of the following:
Subtask
|
Subtask
|
Description
|
|
Exchange Rates
|
Click this link to access the Exchange Rates subtask.
This link is not enabled when you select the P/R Transactions check box in the Select Transaction Types group box.
|