Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

How to Reconcile Sage 100 Accounts Payable Detail to the General ledger

December 6, 2022 by Wayne Schulz

man and woman working at the office
Photo by Pavel Danilyuk on Pexels.com

The Sage City community has answered a frequently asked question about which AP report to use when reconciling your Accounts Payable detail to the General Ledger Trial Balance. The answer is the AP Trial Balance Report because it produces a cutoff based on the posting date, which can be reconciled to General Ledger.

The Accounts Payable Aging Report is used to manage payables based on their invoice date, which may not always be correlated to the accounting date they were posted in.

From Sage City:

When reconciling AP to the GL and using the AP Trial balance, does the invoice date have an impact on differences? As I understand it using the AP Trial balance goes by transaction date which is the GL posting date. I’m reconciling day by day and sometimes the AP invoice date does not equal the transaction date. Would this scenario be a valid difference in balancing the AP Trial Balance to GL or no because the the trial balance does not use invoice date?

Read the answer here and background information on why the AP Trial Balance is the correct report to use.

For timely updates about Sage 100 accounting software, please subscribe to our Thursday Sage 100 email newsletter.

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 Tagged With: AP

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Does Sage have plans to stop supporting TLS 1.0 & 1.1 for Sage 100?
  • Payroll Requirements for Year-End 2023
  • DataSelf ETL+ v2023.07 for Sage 100 Announced
  • Version History of Sage 100 Accounting Software
  • What Happens if Sage 100 Goes Read-Only?
  • Sage 100 Knowledgebase Updated
  • Top Sage 100 New Features – Versions 4.4 through 2023
  • The Wayfair Ruling at Five: Why 72% of Businesses Still Struggle with Economic Nexus
  • AVALARA UPDATE: Sales Tax Holiday Changes in Florida
  • Sage 100 & CRM – May 2023 Update

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter
Schulz Says Email NewsletterSent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.

 

Loading Comments...
 

You must be logged in to post a comment.