Facilitate Month End Close with Dynamics GP Reconcile to GL Routine

At the end of the month, one of the most commonly performed tasks is to reconcile your sub ledgers to your general ledger. If these numbers are in agreement, everything is fine and you can continue with your next task. However, if your General Ledger doesn’t tie to your sub ledgers at the end of the month, reconciling these modules can be one of the most frustrating, time consuming processes you go through.

To alleviate the pain associated with this process, Dynamics GP has a built in reconciliation routine called Reconcile to GL that simplifies this reconciliation process for the following modules:

Cash Management
Inventory
Payables Management
Receivables Management

Simply select the module you’re looking to reconcile to your General Ledger as well as your desired date range. This will produce a spreadsheet that identifies the transactions that are causing the discrepancy.

Simply make any required adjustments and re-run this routine. You will notice that your sub ledger as well as your General Ledger are in agreement.

Keep in mind that since you can enter a date range, you don’t have to enter a month. The Reconcile to GL routine can be added to your daily, weekly, or monthly checklist. Performing this process on a more regular basis rather than once a month allows you to quickly identify and reconcile any discrepancies; which will benefit your organization by increasing the efficiency of your month end closing.

If you need help simplifying your reconciliation process, MIBAR can help. Contact us for more information.

The end of GP support is coming. Over the past few years, we’ve worked with former GP users to migrate their data and start using new products with minimal risk and maximum reward. Learn more about Dynamics GP alternatives.