Share
Report
370We seem to always have a lot of unmatched transactions when we use the Reconcile to GL utility. When going through the BR module for example, the SL lists all the deposits, and the GL lists all of the cash receipts contained in said deposits. Is GP just not smart enough to match these? If they match, why are the beginning and ending balances different? Does Reconcile to GL actually change any figures on the SL & GL, or is it just displaying what it thinks may be off?
I am just investigating to make sure everything in our system is accurate as we always seem off from our bank account. We do monthly Bank Reconciliations without issue, but I read KB (https://learn.microsoft.com/en-us/troubleshoot/dynamics/gp/how-to-change-adjusted-bank-balance-in-select-bank-transactions-reconciliation) recently that stated you may be reconciling to the wrong amount. We have used GP since 2000 I believe so there is a chance something could just be carried over from years ago. What is the best way, or where is the best place to look to make sure our checkbook balance is at least close to our bank account?
I ran the scripts in the following KB, and we do have some of these records (glpostdate 1900/duplicate) in CM20200. Could that be a cause of discrepancy? If so, are the duplicates to be deleted? All of the glpostdate=1900-01-01 seem to be voids and alignment prints and are all $0. There are about $79k in duplicates however. Two of which are checks that were reconciled and later voided.
I also know the outstanding transactions in the Bank Rec affect the Adjusted book balance, and we have several payments from years past that were not cashed. I understand it is best to do an Increase Adjustment for these, but which accounts should be used in the distribution? Should it just be a reversal essentially, or should they go to misc income or something else? Some of these are paychecks, so I am not sure if it would be proper to debit W/H accounts etc.
Categories:
All responses (
Answers (
