About Bank Services Integration with Other Accounting Modules
About Bank Services Integration with General Ledger
Fields and controls
Integration Tab
Consolidate G/L Batches
Specify whether to combine transaction details for the same general ledger account into a single detail, or to send unconsolidated transaction details to General Ledger:
- Do Not Consolidate. If you select this option, separate details are kept for each bank transaction
Tip: 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
Specify when to create general ledger transactions in Bank Services:
-
During Posting. If you select this option:
- General ledger transactions are created 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 Screen. If you select this option:
- You create general ledger batches using the Create G/L Batch screen, after posting a bank reconciliation.
- You can print the Bank G/L Transactions report.
Tip: 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
Specify how new transactions are added to G/L batches:
- Creating a New Batch. If you select this option, a new G/L batch is created each time you post a reconciliation.
- Adding to an Existing Batch. If you select this option and there is an unposted G/L batch, G/L transactions are added to the existing G/L batch.
- Creating and Posting a New Batch. If you select this option, a new G/L batch is created and posted immediately.
Transactions Tab
Use this tab to assign information to G/L transactions. For more information, see Assigning Information to G/L Transactions.
Overview
Use the Bank G/L Integration screen to:
- Determine how Bank Services produces transactions for General Ledger from posted Bank transactions.
- Specify the data to include as the G/L Entry Description, G/L Detail Reference, G/L Detail Description, and G/L Detail Comment fields for general ledger transactions.
Integration Tab
Use the Integration tab on the Bank G/L Integration screen to:
- Specify whether to add general ledger transactions to the G/L batch each time you post, or to create the transactions at a later date.
- Choose whether to add new transactions to the existing G/L batch or create, a separate G/L batch each time you create G/L transactions. You can also choose to post new batches automatically.
- Choose whether to consolidate the G/L batch when you post, or always enter full transaction details in the batch.
Before changing the Create G/L Transaction option to create transactions during posting (if it was set to create transactions using the Bank Create G/L Batch screen), print an up-to-date copy of the Bank G/L Transactions report, then create any outstanding transactions.
Any change to your selections for the Consolidate G/L Batches option or the data to include in the G/L Entry Description, G/L Detail Reference, G/L Detail Description, and G/L Detail Comment fields applies only to transactions posted after the change. It has no effect on transactions already in a general ledger batch.
Transactions Tab
Use the Transactions tab on the Bank G/L Integration screen to specify the type of information to use in the transaction description, detail reference, detail description, and detail comment fields for general ledger transactions.
You can assign one or more pieces of information (segments) to each field, provided that the combined length of the segments and separators does not exceed 60 characters. Fields exceeding this limit will be truncated when you post general ledger transactions.
The segments you can select depend on the type of transaction to which you are assigning information and whether the information is for the transaction header or the details. This ensures that the information passed to General Ledger is relevant for each type of transaction.
When you create general ledger transactions, if no data exists in the source transaction field, the field will be blank in the general ledger transaction. For example, if you assigned the original transaction description to the G/L Entry Description field, but there is no description for a particular entry, the field will be blank in the G/L transaction.
This information also appears on Bank Services posting journals and on the G/L Journal Entry screen and reports.