Setting Up Bank G/L Integration

The Bank G/L Integration window lets you:

Determine how Bank Services produces transactions for General Ledger from posted Bank transactions. (Use the Integration tab.)
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. (Use the Transactions tab.)

Integration Tab

Use the Integration tab on the G/L Integration window 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 Create Bank G/L Batch window), print an up-to-date copy of the 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, and has no effect on transactions already in a general ledger batch.

To specify when and how to create batches for General Ledger:

Choose the G/L Integration icon from the Bank Setup folder.
Select the following options on the Integration tab:

Create G/L Batches
Create G/L Transactions By
Consolidate G/L Batches

Click Save.

Transactions Tab

Use the Transactions tab on the G/L Integration window 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 displays on the Reconciliation Posting Journal report in Reports > Payroll > Bank Reports.