Commingled Accounting
Commingled accounting is used to generate individual accounting
records for endpoints that have been marked as requiring commingled
accounting. This process affects the accounting records being generated
for a cash letter in the following ways:
- Individual accounting records are created for each transaction routing transit number within the cash letters
- The outbound batch (ICL) settlement account number may be determined from a commingled accounting table
For commingled accounting, the transaction codes, cost center work
units, and line numbers are calculated as described earlier for general
ledger, non general ledger, and endpoint type accounting. The transaction
amount and settlement accounting numbers are generated as follows:
- All transactions within the cash letter are grouped by transaction routing transit number and an individual accounting record is created for the sum of the transactions.
- If the transaction routing transit number is defined in the commingled account table, the settlement accounting number for that routing transit number is used to generate the accounting record.
- If no matching routing transit number can be found in the commingled account table, the routing transit number itself is used as the settlement account number and the accounting type from the endpoint is used.
- When looking up the routing transit number of an transaction,
the endpoints accounting type may also be defined. This means that
the same routing transit number can have a different settlement account
number for different accounting types. If no accounting type is defined,
the accounting type from the endpoint is used.
Note: The sum of all commingled accounting records for a cash letter must equal the original totals of the cash letter.