We are in the process of testing the Electronic Bank Rec module. We are using a simple bank CSV file that contains detail lines only. We have a field for the account number, check date, check amount, check number, and transaction type and a few other filler fields. We added an initial record type field at the beginning of the file.
Working in a test company we modified the CSV file so it reflected some current outstanding check transactions. The file successfully processes in the transaction download screen, but when reconciling is unable to complete the match.
Is there a step or best practice that we may be missing? Would appreciate any advice. Thank you.
JG