Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kelley Karl]

Is there a specific process to use when the GL doesn’t match the checkbook?  Our cash account doesn’t allow GL entries.  Why does GP even allow this to occur?

——————————
Kelley Karl
Professional Assist Corp
Golden CO
——————————

[Kristen Hosman]

Hi .

Are you using cash receipts in the Sales module?  If so are you then posting the deposit in the Financial module? 

Let me know this then we can move forward on figuring out what’s going on.?

——————————
Kristen Hosman
Pine CO
——————————
——————————————-

[Kelley Karl]

Yes we use the cash receipts in the Sales module and yes we are then posting the deposit in the Financial module.  Thank you for your reply Kristen.

——————————
Kelley Karl
Professional Assist Corp
Golden CO
——————————
——————————————-

[Kristen Hosman]

are you able to determine what type of cash receipts are the issue?  Credit cards, checks, etc?  Are you importing cash receipts from another source??

——————————
Kristen Hosman
Dynamics GP Consultant
Briware Solutions Inc.
Pine CO
——————————
——————————————-

[Barbara Gavron]

You did not indicate what version of GP you are on, but hopefully you are on a later version (GP2013 or later) because the Reconcile to GL Utility in the Financial module will be of great value to you. It compares transactions in the checkbook to the GL transactions for the account associated with that checkbook over a specified time period and will return a report showing unmatched transactions.

If you are not on a version that has this capability then the steps to follow would be as follows:
1) Make sure all batches are posted. If you have cut checks in the AP module, but the GL side is not posted, this could be your issue.
2) Ensure that all deposits have been recorded – and in the correct period. For example, if you record a receipt in AR on the 30th of the month but do not record the deposit until the 1st of the next month you will be out of balance for a day.
3) Check your posting dates for voids.

Keep us informed as to your findings and let us know if the above does not help so we can provide further assistance.

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————
——————————————-

[Kelley Karl]

We are on version 2016.  We have two checking accounts which both have this issue.  We have NO IS support.
These appear to be duplicate deposits of credit card transactions and we don’t import any transactions from other software.  Is there a way to know specifically which transaction is the duplicate (the one not in the checkbook register)?  How do I go about deleting an entry in the GL which has a CMTRX source document?  Please let me know if I should contact my GP Partner.

One transaction is PMVPY Void Historical Trx.  Does this occur when the period and date of transaction don’t match?

Thanks for the assist!

——————————
Kelley Karl
Professional Assist Corp
Golden CO
——————————
——————————————-

[Mahmood M. AlSaadi]

?Hello Kelly
I would address the fact that there are multiple reasons for having a checkbook-GL variance, I have illustrated various factors on a series post which you may refer to for further details:

• Bank Reconciliation – Check book versus Cash Account Balance
• Checkbook Setup – Important Assignment Concept

Just to give a brief on why a variance may occur, when cash receipt is posted and not deposited, the GL cash account is debited while nothing occurs on the checkbook until a deposit is processed. Meanwhile, there is one type of transaction on the bank reconciliation module affects the check book without having actual cash receipts from the sales module

Furthermore, the reconcile to GL utility has an option to reconcile a checkbook, which will provide detailed report on the matched, unmatched and potentially matched transactions.

Your feedback is highly appreciated,
Best Regards,

——————————
Mahmood M. AlSaadi – MVP
Principal Dynamics ERP Consultant
SIROCo LLC – (844) 708-0008
McKinney TX
——————————
——————————————-

[Kelley Karl]

Thank you Barbara for the grand assist!  My key take away was that you should NEVER use Clear Unused Receipts for outstanding deposits.  This will always result in the general ledger balance being larger than the checkbook and forces the need for a journal entry to the GL account when it shouldn’t allow for data entry.  Do use VOID so that reverse entries for duplicates can be processed.

Merry Christmas to me! with an obligation to “pay-it-forward”.  I’m looking forward to helping someone in the new year…

——————————
Kelley Karl
Professional Assist Corp
Golden CO
——————————
——————————————-