Import Cashbook Transactions with Multiple GL Allocations

  • 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
Source Records
 Date      GL Account Details Reference1 Reference2Amount Vat key GroupID   
 2015-06-24 GL Account 1 Debit Order ACME12345 Smith 500.00 0 1
 GL Account 2Debit Order  ACME12345 Smith 1456.78 0 1
 GL Account 3Direct Debit  ACME12345  3412.67 0 1
 2015-06-24 GL Account 1 DepositACME67842   1000 0 2
2015-06-24  GL Account 4Debit 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 Reference2Amount
5489  2015-06-24 Debit Order ACME12345 Smith 5369.45
5490  2015-06-24
 Deposit ACME67842

Cashbook Transaction Allocation Records
Details, Inclusive Amount, and Vat Amount as per individually imported allocations

CT ID     GL Account DetailsInclusive Amount Vat Amount
5489 GL Account 1 Debit Order 500.00 0
 GL Account 2Debit Order  1456.78 0
5489 GL Account 3Direct Debit  3412.67 0
5490 GL Account 1 Deposit 1000 0
5490  GL Account 4Debit Order  8500 0