We discovered something about a problem we are seeing with Cash Management. Our Accounting Manager left us beginning of April. So I have been trying to keep up with his work as well as mine. I had only the barest understanding of Bank Reconciliation. We are on GP2015, no third party products just native GP2015. I started doing cash receipt postings before our Accounting Manager left. So I was confident I was doing it correctly.
When I went to do the bank reconciliation for March, one of our companies did not 'jive'. Cash receipts are deposited to the bank account of our primary company. The secondary company may have cash receipts. The details are posted to the customer accounts and daily is balanced. Then I do a DECREASE ADJUSTMENT in the banking (to intercompany) for the total. On the primary company, I post any individual cash receipts, and then do an INCREASE ADJUSTMENT in the bank (from intercompany) for the total from the secondary company.
In the secondary company, the cash receipts do not show in the reconciliation window to match to the bank statement. I thought it might be my machine. So I entered cash receipts with the new Accounting Manager, on her machine. After posting we checked and the transactions do not show in the bank reconciliation window. This was last evening.
Today, she was asking about pulling some weekly totals for cash deposits. I showed her the SmartLists. She was in the primary company, so she ran it there. All was good. She opened the secondary company, and the SmartList did not display any of the cash receipts from last evening. We removed the parameter of showing DEPOSITS, and the transactions show up. In the field for CMTRX Type, these transactions were not tagged with a type.
In the primary company they are. We could not find a set up box to address this. Any suggestions for where to fix this issue?
Thank you Gerald. Apparently in our primary company, when we do cash receipts, the transactions are tagged as DEPOSIT individually. But in the secondary company they are not. I was able to group them into DEPOSITS. And the new Accounting Manager is very happy. Now we wish we could turn OFF the automatic setting in the primary company.
Have a Great Day.
If you've found this thread useful, dive deeper into User Group community content by role