MORE INFORMATION

  • The Reconcile to GL window is designed to display in the FUNCTIONAL currency only.

  • FUNCTIONAL CURRENCY:   If your checkbook is in the functional currency ID then the balances on the Reconcile to GL spreadsheet should be correct:

    • The 'Beginning balance' for Bank Rec is calculated by starting with the Current Checkbook balance, and adds/subtracts out the transactions in the CM20200 Bank rec table back to the 'FROM' date or start date of the date range entered.

    • The 'Ending balance' for Bank Rec is calculated by starting with the Current Checkbook balance, and adds/subtracts out the transactions in the CM20200 Bank rec table back to the 'TO' date or end date of the date range entered.

    • If either the Beginning balance or Ending balance for Bank Rec is incorrect, likely the Current Checkbook balance is incorrect due to a recent posting interruption. (so any posting interruptions in-between the time you last reconciled the checkbook and TODAY could play a role, since the calculation starts with the checkbook balance as of TODAY.)

  • ORIGINATING CURRENCY:  The Reconcile to GL spreadsheet was not designed to be used for checkbooks in an originating currency. (But can work if you did not have a beginning balance on the checkbook and have not revalued the currency ID in GL.)

  • If your checkbook is in an originating currency ID, both the Bank Rec side and the GL side will display in the FUNCTIONAL amounts.

  • If you entered a beginning balance in an originating currency on the checkbook at the time you created the checkbook, it is not stored anywhere in the functional amount, so will be omitted from the Reconcile to GL spreadsheet, since it only displays functional amounts.   The beginning and ending balances displayed for Bank Rec will not include any amount from the beginning balance entered on the checkbook.  You would have to manually update the beginning balance on the spreadsheet to include the amount of the beginning balance used on the checkbook if you wanted the amount to be correct.  Otherwise, you can just ignore the beginning and ending balances, if your checkbook is in an originating currency ID) and just utilize the 'Unmatched Transactions' section to help find differences to research.

  • If you have processed any Revaluation in GL for the originating currency ID, the gain/loss entries will also be displayed on the GL side only of the spreadsheet.  These are not listed on the Bank Rec side, thus causing a difference between the two sides.   Revaluation only books gains/losses to the GL cash account in the functional currency and does not flow back to Bank Rec.  So if you have revaluated GL at all for this currency ID, then the Reconcile to GL tool would not be recommended to use, as the GL side will include revalued amounts, and the Bank Rec side does not. 

OTHER RESOURCES:

• Information about the differences when you reconcile General Ledger to Payables Management or Receivables Management in Microsoft Dynamics GP 

http://support.microsoft.com/help/866570

• Information about the balances in the Reconcile to GL window in Microsoft Dynamics GP

http://support.microsoft.com/help/3191232

--------------------------------

KB 5003901 - published 5/13/2021

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×