For help with the fields on the Bank Services G/L Integration window, select from the field names listed below:
Integration tab
Consolidate G/L Batches
Use this option to specify whether to combine transaction details for the same general ledger account into a single detail, or to send unconsolidated transaction detail to General Ledger. You can select:
- Do Not Consolidate. If you select this option, separate details are kept for each bank transaction. During bank setup, select this option so that you have a detailed record of the setup entries.
- Consolidate by Account and Fiscal Period. If you select this option, all transaction details with the same account number and fiscal period are combined into one detail. For example, all service charges, interest income, and other transactions entered in Bank Services within a given fiscal period are consolidated to show a total amount for each General Ledger account.
- Consolidate by Account, Fiscal Period, and Source. If you select this option, all transaction details with the same account number, fiscal period, and source code are combined into one detail.
Note: The posting date for consolidated entries is the last date of the fiscal period.
Create G/L Batches
Use this field to specify when to create general ledger transactions in Bank Services. You can select one of the following options:
- During Posting. If you select this option, the program creates general ledger transactions automatically when you post a bank reconciliation. You cannot print the Bank G/L Transactions report. However, you can print a record of the transactions by printing the Batch Listing report in General Ledger.
- On Request Using Create G/L Batch. If you select this option, you create general ledger batches using the Generate G/L Batch function, after posting a bank reconciliation. You can print the Bank G/L Transactions report.
When you are setting up your system, select this option so that you can set up all your banks before sending information to General Ledger.
Create G/L Transactions By
This option lets you choose whether to add new transactions to the existing G/L batch, if there is an unposted G/L batch, or to create a separate G/L batch. You can select:
- Creating a New Batch. If you select this option, the program creates a new G/L batch each time you post a reconciliation.
- Adding to an Existing Batch. If you select this option, the program adds G/L transactions to the existing G/L batch.
- Creating and Posting a New Batch. If you select this option, the program creates and posts a new G/L batch immediately.
Transactions tab
Use this tab to customize the descriptive information supplied to general ledger transactions to strengthen your audit trail. The information you select will display on transaction reports in General Ledger as the references, descriptions, and comments for transactions coming from Bank Services. The table shows a list of Bank transaction types. Learn more about Setting Up Bank G/L Integration.
For each transaction type, the table shows the segments (information) that have been selected to be the transaction's:
- G/L Entry Description (that is, the overall description of the transaction)
- G/L Detail Reference
- G/L Detail Description
- G/L Detail Comments
The "G/L Detail" choices refer to the reference, description and comments that apply to the each detail line of the transaction. When you double-click a transaction type from the table, a G/L Integration Detail window displays, with these fields:
Transaction Type
From the drop-down list, choose the Bank transaction type that will transfer to the General Ledger. Choose from the following transaction types to customize:
- Transfers
- Bank Entry
- Bank Entry Detail
- Bank Reconciliation.
G/L Transaction Field
From the drop-down list, choose the G/L Transaction field for which you are defining the segments. This can be an entry description, detail reference, detail description, or detail comment.
Example
As you include or exclude segments, the Example field displays a sample view of the segments you have selected for the transaction type.
Segment Separator
Select a character to separate segments of information. The separator is used only if you assign more than one segment. The default separator is a hyphen.
Choose Segments From List
From the list, choose the information (segment) you want to accompany each General Ledger transaction created by Bank Services, as an additional audit trail marker.
To assign one or more segments to the selected transaction field, select the segments from the Choose Segments From List section, then click Include.
You can assign a maximum of five segments to a G/L Transaction field, providing that the combination does not exceed 60 characters. If the assigned information exceeds this number of characters (including separators), it will be truncated when the transaction is posted.
Segments Currently Used
This shows the segments currently selected. To remove a segment, select the segments from the Segments Currently Used section, and click Exclude.