- Bank Recon allows you to import one cashbook transaction that has multiple General Ledger Allocations associated with it.
- To do this you make use of the Optional GroupId Column allowed in the Cashbook Import Definition query
- You import each individual allocation as a separate record with the appropriate GL mapping
- Give each individual allocation that belongs to one Cashbook Transaction the same GroupID Value
- On Import Bank Recon groups the transactions on this ID and creates a single cashbook transaction with multiple Cashbook Transaction Allocation records associated to it
- The total amount for this single Transaction is the sum of all the allocations in the group
- The Cashbook Transaction details are pulled from the first allocation in the Group so the ordering of your records will affect this
Example Source Records Date | GL Account | Details | Reference1 | Reference2 | Amount | Vat key | GroupID | 2015-06-24 | GL Account 1 | Debit Order | ACME12345 | Smith | 500.00 | 0 | 1 | 2015-06-24
| GL Account 2 | Debit Order | ACME12345 | Smith | 1456.78 | 0 | 1 | 2015-06-24
| GL Account 3 | Direct Debit | ACME12345 | | 3412.67 | 0 | 1 | 2015-06-24 | GL Account 1 | Deposit | ACME67842 | | 1000 | 0 | 2 | 2015-06-24 | GL Account 4 | Debit Order | ACME67842 | Khumalo | 8500 | 0 | 2 |
Cashbook Transaction Records Created according to GroupID with the details from the first allocation record processed and the amount the sum of all the allocations
ID | Date | Details | Reference1 | Reference2 | Amount | 5489 | 2015-06-24 | Debit Order | ACME12345 | Smith | 5369.45 | 5490 | 2015-06-24
| Deposit | ACME67842 |
| 9500 |
Cashbook Transaction Allocation Records Details, Inclusive Amount, and Vat Amount as per individually imported allocations
CT ID | GL Account | Details | Inclusive Amount | Vat Amount | 5489 | GL Account 1 | Debit Order | 500.00 | 0 | 5489
| GL Account 2 | Debit Order | 1456.78 | 0 | 5489 | GL Account 3 | Direct Debit | 3412.67 | 0 | 5490 | GL Account 1 | Deposit | 1000 | 0 | 5490 | GL Account 4 | Debit Order | 8500 | 0 |
|