Many investment companies offer Debit Orders, Regular Withdrawals and LA Payments to their clients. These are usually processed once or twice a month as part of a batch run. The result of this is hundreds to tens of thousands of cashbook transactions (1 or more for each client!) and only 1 transaction on the bank statement. Making this a particularly difficult recon. Bank Recon allows you to import helper data to assist with this recon. This helper data is the same set of instructions initially sent to the bank, with any upfront rejections excluded. For every bulk recon, one set of helper data is imported: 1 Helper bank transaction which must match the bank statement amount exactly, and a helper record for every client payment or collection. This data is imported into Bank Recon using the Bank Details Import functionality. It is a completely separate process to the Bank and Cashbook Imports. The linking is only done via the recon rules and it doesn't matter in what order the different imports are run. But the Helper Data, Bank Transaction and enough Cashbook Transactions need to be present in the database for the Helper rule to work. Once imported you need to write a helper rule which uses the helper data to find the correct cashbook transactions and then reconciles everything together. If there is a helper cashbook transaction not yet present in the cashbook transactions (maybe it hasn't allotted), Bank Recon will create a contra pair of helper balancing entries for this transaction, use one in the recon and leave the other as unreconciled on the Cashbook Transaction side. This transaction can then be used in a same side match with the actual cashbook transaction once it allots or against the rejection on the bank side if it occurs. Here is a small example Debit Order Expected Transactions allotted Bank Statement Record Client 1 - R 1 000 DO ACME - R 10 000 Client 2 - R 5 000 Client 3 - R 2 000 Cashbook Helper Data - Bank Helper Data - Individual Client Instructions to the bank Total Amount Instructed to the bank Client 1 - R 1 000 DO ACME - R 10 000 Client 2 - R 5 000 Client 3 - R 2 000 Client 4 - R 2 000
Writing a Helper Rule and a Same-side matching rule
|