Microsoft Dynamics GP Tip: Using Reconcile to GL

Microsoft Dynamics GP Tip: Using Reconcile to GL

 Download: Microsoft Dynamics GP Tip: Using Reconcile to GL

When your A/P, A/Record or cash sub ledgers don’t match your General Ledger, the GL reconcile can show you where you have missing or “unmatched” transactions.

  1. Open the Reconcile to GL screen in Dynamics GP.Using Financial Reconcile to the GL1
  2. Change the module to Receivables Management
  3. Enter a reconciliation date
  4. Enter from and to dates
  5. Enter the main A/R accounts
  6. Enter a place for the Output files
  7. Select “Process” (icon on top left corner) and the report will print.Using Financial Reconcile to the GL2
  8. Check to see Unmatched Transactions.

Note: You will also see the reconciliation when you scroll to the bottom.

Using Financial Reconcile to the GL3

If they do not match you can subtract one from the other to see your difference.

Normally this is what you have in the transactions that are unmatched in the top of the report.

Each change in color on the report is another entry or batch.

If something has hit the subledger and not the GL:

  1. Check that there are no batches sitting in the GL waiting to be posted.
  2. Check your posting setup that both check marks are in for Post to and Post thru for the series.
  3. If you have something in the sub-ledger and not in the GL, you may have to create an entry to the GL in order to balance.

Tip: Look for a date issue to see if perhaps something posted in the next month or previous month before making an entry.

For more Dynamics GP Tips and Tricks go to www.calszone.com/tips and sign up for our Tips and Tricks e-newsletter.

By Sue Conrod,  CAL Business Solutions, www.calszone.com

 

 

 

 

By |2016-02-22T18:01:38+00:00February 22nd, 2016|Accounts Payable Tips, Accounts Receivable Tips, CAL ERP Tips & Tricks Blog, Dynamics GP Tips, General Ledger Tips, Microsoft Dynamics GP|Comments Off on Microsoft Dynamics GP Tip: Using Reconcile to GL

About the Author:

Microsoft Dynamics GP (formerly Great Plains) is ERP/accounting software that grows with your business, easily integrates with other systems, and is quick to set up, customize and use. CAL Business Solutions is focused on Microsoft Dynamics GP: * Implementation * Integration * Customization * Data Conversion * Training * Support We are a practical, hardworking team that has built our reputation on giving honest advice, straightforward answers, and a software system that works. Serving companies nationwide—focused on Connecticut, Massachusetts and Rhode Island. * Northeast Dynamics Partner of the Year Winner * Dynamics Presidents Club Winner: Recognizing Top 5% of Partners If you are considering new accounting software, upgrading your existing system, or currently use Microsoft Dynamics GP and want expert support and training contact CAL.