Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

By Deb Schaffer | June 14, 2022

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your sub-ledger to your General Ledger using Reconcile Routines in Dynamics GP.

This solution is a great fix if you run into the issue that your sub-ledger Accounts Receivable, Accounts Payable, Bank Reconciliation, or Inventory sub-ledger accounts are not matching your General Ledger (GL) accounts.

To start, navigate to Financial > Routines > Reconcile to GL and open the Reconcile to GL window.

Picture1

In this window, you can define what modules and accounts you want to find differences for. The Reconciliation field is an auto-incrementing number GP defines to keep track of different reconciliations users have run in the past. The Reconciliation Date is simply the date you run the reconciliation.

Then, you follow these steps:

  1. Enter the Date Range you want to search – you can start with a full month, or even multiple months if you haven’t run this before. If you have a lot of transactions, you can narrow the date range as well
  2. Then enter the accounts that you want to compare. For this example, I am using my AP account, 000-2100-00
  3. Next, define the output location by clicking on the file folder. This process generates an excel spreadsheet that compares the data in the sub-ledger to the data in the GL.
  4. Once you have made your selections, click on Process at the top of the window

The spreadsheet shown below is split into two screenshots so it’s easier to analyze. The first screenshot is the AP side of the transactions. The spreadsheet breaks the data into unmatched transactions, Potentially Matched Transactions, and Matched Transactions.

Picture2

The second screenshot below shows the GL Entries as they match the AP transactions in the screenshot above.

Picture3

An example of an Unmatched transaction would be a transaction entered directly into General Ledger and doesn’t have a corresponding AP entry. Potentially matched transactions typically are matched but could have a slight variance such as a date difference. Matched transactions have a clear path from AP to the GL.

When running this process, keep in mind that this is only pulling the data for you. No entries will be made into GP to enter changes or corrections. You will have to enter those manually.

Questions?

Please reach out to our experts if you have any questions. We are happy to assist you!

Related Posts

Recommended Reading:

Performance Turning Webservices in Dynamics 365 Business Central: Migrate Your Integrations off SOAP and Move to OData or API

Dynamics 365 Business Central users will soon be unable to use SOAP web services when making application functionality available to […]

Read the Article

Stoneridge Software Selected for 2022 Microsoft US Partner Award – Dynamics 365 Business Central

Stoneridge Software is honored to be selected as a 2022 Microsoft US (MSUS) Partner Award winner for Dynamics 365 Business […]

Read the Article
6.29.22 Dynamics CRM

Reduce Manual Data & Increase Productivity with Dynamics 365 for Sales

Dynamics 365 for Sales has a ton of great features to help automate processes for you and your team to […]

Read the Article

Dynamics 365 Business Central Boolean Field Bug Temporary Fix

If you are a Dynamics 365 Business Central cloud (SaaS) customer who is using Edge or Chrome to run the […]

Read the Article

Using Non-Sequential Numbering to Prevent Locking In Your Dynamics 365 Business Central System

Running into locks in your system? Enable non-sequential numbering on your number series to prevent number series locking issues! As […]

Read the Article
6.24.22 Dynamics GP

Uncommonly Used Features: Setting Up Account Categories in Dynamics GP

This is the final part of my current series on Uncommonly Used Features in Dynamics GP. In this post, I […]

Read the Article

Increase User Productivity in Dynamics 365 Business Central with These 10 Tips

There are constantly evolving ways for you to increase user productivity in Dynamics 365 Business Central. Here are 10 tips […]

Read the Article

Star Tribune Lists Stoneridge as a Top 200 Workplace for 2022

Stoneridge Software’s emphasis on creating a positive and flexible culture has earned recognition as a top workplace in Minnesota. The […]

Read the Article
6.14.22 Dynamics GP

Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X