Sidebar
bankreconciliation:maintenance:banktransactions:createtransactions
This is an old revision of the document!
Create Transactions
Bank Reconciliation > Maintenance > Bank Transactions > Create Transactions
This tab is used to extract transactions from the Finance and Human Resources tables for bank reconciliation.
Transactions are grouped and summarized as follows:
- Cash Receipts - Cash receipt number, date, and description
- Checks - Vendor number, check number, check date, check void flag (voids are extracted)
- Payroll Checks - Employee number, pay frequency, pay date, adjustment number (voids are extracted)
- Journal Vouchers - JV number, JV description (the earliest date is extracted)
EFT payments are extracted as a JV with the following JV number (description for all is EFT Total):
- Vendor EFT: EFT-mmddyy where mmddyy is the month/day/year of the check date.
- Payroll EFT: PAY EFT-mmddyy where mmddyy is the month/day/year of the pay date.
Payroll transfer transactions are extracted as a JV. An additional extract for the same Bank Account Group, Accounting Period and/or Pay Date range does not create duplicate entries.
Modify a record:
| Field | Description |
|---|---|
| Bank Account Grp |
Type the bank account group code to be used. This field is required. |
| GL File ID | Click  to select a general ledger file ID. This field is required. |
| Accounting Period | Type the accounting period to be used. The leading zero is not required. Or, click  to select an accounting period. Only one accounting can be used at a time. If this field is not populated, Finance data is not retrieved. |
| Pay Date From and To fields | Type or select from the calendar the from and to pay dates to be used. You can enter the same to and from date to retrieve data for a single date. If the pay date fields are not populated, Human Resources data is not retrieved. |
| Execute |
❏ Click Execute to retrieve the applicable transactions based on the entered search criteria. All reports are displayed by the transaction category (Checks, Cash Receipts, and Journal Vouchers). You can toggle between the summary and the error report.
|
|---|---|
| Process |
❏ Click Process to import the transactions listed on the Summary Report to the Maintenance > Transaction Maintenance page. The Process button is disabled until valid transactions are retrieved. |
| Cancel | Click to cancel the process and clear the data on the tab. |
bankreconciliation/maintenance/banktransactions/createtransactions.1516292150.txt.gz · Last modified: 2018/01/18 11:15 (external edit)