Banking reference consolidation
You can use the displayed value in the Banking Reference field on the transactions to determine a bank account.
For bank account transactions that are the result of a receipt reversal or transfer, you can select an application to consolidate in the Ledger Transaction Export Control form. Any receipt reversal or transfer are never consolidated.
Where a receipt reversal has been performed that is not in the same receipting period as the original receipt, the banking reference is written to the bank account transaction. A suffix of "R" is added.
Where a receipt transfer has been performed that is not in the same receipting period as the original receipt, the banking reference is written to the bank account transaction. A suffix of "T" is added.
This table shows the options for banking reference consolidation in the Ledger Transaction Export Control form:
| Option | Fields that must match for each record | Data output for the consolidated transaction |
|---|---|---|
| Banking Reference and Source Application | Ledger Account Project Posting Period/Year Source Application Banking Reference Disallow consolidation is off |
Ledger Code: As is Account: As is Project: As is Posting Period: As is Posting Year: As is Source Application: As is Transaction Date: Transaction date of the first transaction in the group of transactions to be consolidated Amount: Total of the amounts from each transaction consolidated Banking Reference: As is Application Reference 1: Banking reference Application Reference 2: Banking reference Application Reference 3: External Source (For example, LAP, LLC, or manually specified) Application Reference 4: External reference Particulars: Source application, consolidated, and banking reference. |
| Banking Reference | Ledger Account Project Posting Period/Year Banking Reference Disallow consolidation is off |
Ledger Code: As is Account: As is Project: As is Posting Period: As is Posting Year: As is Transaction Date: Transaction date of the first transaction in the group of transactions to be consolidated Amount: Total of the amounts from each transaction consolidated Source Application: Blank Banking Reference: As is Application Reference 1: Banking reference Application Reference 2: Banking reference Application Reference 3: External Source (For example, LAP, LLC, or manually specified) Application Reference 4: External reference Particulars: Consolidated plus the banking reference Receipt System Date: Receipt System Date |
| Source Application |
Ledger Account Project Posting Period/Year Source Application Disallow consolidation is off |
Ledger Code: As is Account: As is Project: As is Posting Period: As is Posting Year: As is Source Application: As is Transaction Date: Transaction date of the first transaction in the group of transactions to be consolidated Amount: Total of the amounts from each transaction consolidated Application Reference 1: Consolidated Application Reference 2: Consolidated Application Reference 3: External Source (For example, LAP, LLC, or manually specified) Application Reference 4: External reference Particulars: Source application and consolidated |
| None | No consolidation of bank transactions | All fields are normal except the banking reference is duplicated into Application Reference 2. |