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.

Reconcile to GL Dynamics GP

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. 

Additional Microsoft Dynamics GP Resources

Reconcile Misaligned Receivables Batch in Microsoft Dynamics GP

Hands-Free, Mistake-Free, Rapid Sales Order Entry in Dynamics GP

Microsoft Dynamics GP Upgrade Planning and Best Practices

Find The Data You’re Looking For With Smartlists in Dynamics GP