In Tensoft’s recent Microsoft Dynamics GP training webinar, I walked attendees through the process of how to use the “Reconcile to GL” routine. This great tool helps reconcile your sub-ledger balances to your General Ledger control accounts – a huge improvement over doing this via Excel downloads. Here’s a brief transcript to give you a sense of what I covered:
“So with this historical aged trial balance run with your ‘as of’ date and using the GL posting date to select transactions, you’re now going to run this report. If the total on this report agrees with the General Ledger control account or accounts, then your reconciliation is done. There is no more work to do. If they don’t agree, this is where we can use the Reconcile to GL routine to troubleshoot transactions that could be causing an issue. So let’s go through that process.
Now I’m going to navigate to Financial, Routines, and Reconcile to GL. Remember that this routine is a troubleshooting tool only – it doesn’t make any adjustments. It simply presents data that is designed to highlight the differences.
Our reconciliation number is generated at just sequential. The beginning and ending dates of the period you’re working to reconcile can be entered here. You can choose your dates from your dropdowns. I’m selecting the Payables Management modules to reconcile here, but you can see that Receivables Management is also available as is Bank Reconciliation. Inventory is available as well.”
If you haven’t already made a regular practice of using this tool, now’s the time to add that to your repertoire! Please take a look at the entire recorded training webinar here (and be sure to let me know if you have any questions):
And, if you’re interested in learning more about Microsoft Dynamics GP, and to see some of the great training and resources that Tensoft makes available to the public, please visit our website. If you’d like to be notified about upcoming Tensoft events – including our CPE eligible webinars – please sign up for our newsletter. I hope to see you there!
Diane Faria, Tensoft Senior Applications Consultant
by TenSoft, Inc