chrishop
Member
I am currently working on a process to be handled by JDE Xe which involves up to 30,000 bank transactions per day including cash, cheques, BACS, debit cards, credit cards (including an increasing volume of internet transactions), CHAPS, etc. In order that the bank reconciliation for these transactions may be performed efficiently and with a clear audit trail, the system would need modification as follows, or specialist reconciliation software used instead:
* Auto Reconciliation for the bank statement processing - Modify the match criteria to make them suitable for credit cards and allow for date variation of 1 or 2 days;
* Manual match - Modify this so that the users can perform a manual
match between the bank statement (F0917) and the General Ledger with maximum efficiency and retain a link between the reconciled items for audit purposes. The anticipated number of transactions that will fail auto-reconciliation will be quite large so we would really like to have the bank statement and GL transactions on the screen together for fast matching.
As a result I would be interested in any information on the following:
* Where you have experienced similar bank reconciliation requirements, especially the credit card reconciliation and the bespoke manual reconciliation requirements, have you modified JDE or utilised alternative specialist software to meet them. What would be your reason for using one of these options over the other;
* If you have taken the route of customising JDE, what was done and how much bespoke effort was required;
* If you opted for a specialist reconciliation package which did you use and how do the costs involved compare to modification of JDE.
Any information or opinions on the above would be gratefully received.
Many thanks,
Chris
OneWorld Xe
* Auto Reconciliation for the bank statement processing - Modify the match criteria to make them suitable for credit cards and allow for date variation of 1 or 2 days;
* Manual match - Modify this so that the users can perform a manual
match between the bank statement (F0917) and the General Ledger with maximum efficiency and retain a link between the reconciled items for audit purposes. The anticipated number of transactions that will fail auto-reconciliation will be quite large so we would really like to have the bank statement and GL transactions on the screen together for fast matching.
As a result I would be interested in any information on the following:
* Where you have experienced similar bank reconciliation requirements, especially the credit card reconciliation and the bespoke manual reconciliation requirements, have you modified JDE or utilised alternative specialist software to meet them. What would be your reason for using one of these options over the other;
* If you have taken the route of customising JDE, what was done and how much bespoke effort was required;
* If you opted for a specialist reconciliation package which did you use and how do the costs involved compare to modification of JDE.
Any information or opinions on the above would be gratefully received.
Many thanks,
Chris
OneWorld Xe
