Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I am trying to see why for years, the checkbook balance has not seemed to tie to the cash account balance for our operating account. It is off millions of dollars and this is something that could have gone wrong 5 years ago. Is there some sort of report to try and see what caused the variance?
For starters you could use the Reconcile to GL utility on the Financial home page and select Bank Reconciliation as the module. I don't remember if that was available in GP 2013, but it would be a good reason to do an update. Absent using that utility, or a third party product called 'The Closer'' (which is terrific), you'll need to export the checkbook register and GL detail to an Excel spreadsheet and compare the transaction detail in your checkbook register to the the entries made to the gl cash account. Be sure to use the individual deposit components so that the detail comes into the check register as the individual receipts that were deposited. Other than the GL Utility, I am not aware of any report in GP that analyzes the checkbook transactions with the checkbook register. If your GL is correct, I would be tempted to just adjust the checkbook balance to match the GL and just make sure it's in balance going forward.
Now that I think about it, if checks are cut by using the checking account, the book balance will never tie to the bank balance because of the dates these checks clear the bank. Is this an accurate possibility?
The formula for reconciling the bank and book balance is to take the bank statement ending (Bank) balance and add deposits in transit and subtract outstanding checks to get to the book balance.If you are referring to the Checkbook Balance and the Cash Account Balance (as seen in the Checkbook Maintenance and Checkbook Register Inquiry) being off, those two should balance. Common reasons they don't match are there are (1) checkbook-related transactions not posted through the GL, (2) receipts that have not yet been assigned to a Bank Deposit, or (3) JEs booked directly against the checkbook cash account.I have many clients that use external billing systems so they need to enter bank transactions to record the non-GP coded checkbook transactions (like Deposits).
What do you mean by using the checking account to issue the check. Are you saying you are making entries directly to the GL account without using a checkbook id? The dates the checks clear the bank will not impact the General Ledger account.
Business Applications communities