CM Transaction Flow
While it is possible to import Bank Reconciliation (BR) transactions, there are a couple of problems due to BR not using work files. One is that GL distributions are not created during the import and journal entries need to be imported. Also, because you are not posting the transactions, the Current Balance in the Checkbook master is not updated. This makes the reconcile process difficult. Here are three different ways to work around these issues:
Method 1. Keep track of the imported transactions and the net change. When reconciling later, reconcile to this net change. Post an adjustment to BR to allow for the net change so that checkbook has the correct balance. Insure that you do NOT post that adjustment to the General Ledger because the GL balance is correct due to the direct import of the journal entries.
Method 2. We can export the Checkbook Master table (CM00100) to a file. Change the current balance to reflect the BR transactions that were imported. Clear data on the CM00100 table or delete it and re-import the newly changed file into the Checkbook Master. The correct balance will now be displayed.
Method 3. Write directly to the Checkbook Master (CM00100) table, updating the Current Balance using Microsoft Access or another application in conjunction with an ODBC connection. The current balance would now be correct. Note, this will not work on Ctree databases as the ODBC drivers are read-only.
It is possible to bring older, outstanding checks into Dynamics from before BR was started. This process would assume that the current checkbook balance was correct. Outstanding checks would be imported normally and since the checkbook balance is current, nothing further needs to be done. The checks should reconcile normally.
Importing Cash Receipts as deposited is possible, but has the same problem as with the bank transactions above. The best suggestion for cash receipts is to import the cash receipt then deposit the receipts manually which will update the Current Balance field in the Checkbook Master.
One thing to note about importing BR Transactions and Receipts is the Audit Trail Code should be imported. Unlike other modules, this is necessary since the BR entries are never posted. After manually assigning the Audit Trail Code to the entry, the next Audit Trail Code in the Audit Trail Code Setup window must be manually adjusted to reflect the imported entries. If it is not incremented, the next manually entered BR documents will use the next audit trail code number which might overlap the entries just imported.
Posting transfer is like posting two one sided bank transactions, one debit one credit. Just setup a transaction with one distribution (from checkbook account) and Transaction type of transfer and call post and this will post the one side. Than create the second transaction with one distribution (to checkbook account) and transaction type of transfer and post this. After these transactions are posted then you need to post the distributions over to GL and update the transfer table with the correct information.