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

December 6, 2022 by Wayne Schulz Leave a Comment

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.

Sage 100 Year-End 2022 Training Series

December 5, 2022 by Wayne Schulz Leave a Comment

A reminder that anyone printing 1099, W2, or other tax forms/reports through Sage 100 during year-end 2022 may need to install a product or version update to meet these minimum requirements:

Sage 100 Payroll 2.23.0 (release 12/15/2022)
Accounts Payable 1099’s
- Sage 100 2022.0 – 2022.2 (7.10.0 – 7.10.2) plus IRD (release 12/15/2022)
- Sage 100 2021.3 – 2021.5 (7.00.3 – 7.00.5) plus IRD (release 12/15/2022)
- Sage 100 2020.5 – 2020.6 (6.20.5 – 6.20.6) plus IRD (release 12/15/2022)
Aatrix year-end update will be released mid-December (before 12/20/22).

Sage 100 Minimum Versions for Tax Year 2022

Learn more about year-end processing by enrolling in either of these courses. The cost is $75 each, and they are scheduled once in December with a repeat in January 2023.

1099 Processing Course – $75
December 13, 2022 ( repeats on January 10, 2023)

Class highlights include:

Verify that your version of Sage 100 can process 1099s for 2022
Changes to 1099 boxes for 2022
Overall IRS guidelines for 1099 reporting
Cleaning up vendor 1099 classifications and verifying reporting amounts
Common pitfalls for 1099 processing
Using Aatrix in Sage 100 to report 1099 information electronically

Payroll Processing Course- $75
December 15, 2022 ( repeats on January 17, 2023 )

Class highlights include:

Year-End Processing Requirements
Tips & Tricks & FAQs
Year End Checklist
How to Report Third-Party Sick on W2’s
W-2 Processing
ACA Processing

More Information

Minimum Sage 100 Versions for E-Filing for Tax Year 2022

November 29, 2022 by Wayne Schulz Leave a Comment

In order to process electronic filing for the tax year 2022 using Sage 100, your company will need to be on the following minimum release levels.

Accounts Payable Minimum Versions For 2022

To file form 1099s, you must be using one of the below versions of Sage 100 as well as apply the IRD ( Interim Release Download ), which includes updates for the 2022 tax filing season

Sage 100 2022.0 – 2022.2 (7.10.0 – 7.10.2) plus IRD (Due: 12/15/2022)
Sage 100 2021.3 – 2021.5 (7.00.3 – 7.00.5) plus IRD (Due: 12/15/2022)
Sage 100 2020.5 – 2020.6 (6.20.5 – 6.20.6) plus IRD (Due: 12/15/2022)

Payroll Minimum Version for 2022

To file form W2 and related payroll tax forms – either printed or electronically – you must be on the following minimum payroll version.

Sage 100 Payroll 2.23.0 (Due: 12/15/2022)

Payroll Tax Update

Tax information is maintained in CLAD (Sage tax cloud), and system table changes will be pushed down via the Payroll Tax Update utility within the software.

Aatrix E-Filing for Sage 100

Sage 100 uses Aatrix for tax form printing and e-filing. Expect a year-end update to be released mid-December (before 12/20/22)

Year-End Processing Resources for Sage 100

For more information on how to prepare for year-end 2022 in Sage 100, please visit the Sage Knowledgebase article 49810.

For a summary of the changes to the 2022 Form 1099-MISC and Form 1099-NEC, please visit Form Changes for 1099-MISC and 1099-NEC For the Year 2022.

How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement

November 4, 2022 by Wayne Schulz

Avalara notes that all users of their popular Avalara sales tax integration must be using TLS 1.2 by February 16, 2023.

While most versions of Sage 100 meet those requirements, there may be some question about whether your Avalara integration is at the proper version. Here’s how to check.

In the ..\mas90\AvaTax directory, locate the Avalara.AvaTax.Adapter.dll file
Right click the file and select properties
Select the details tab, and check the Product Version
If the Product version is 17.2.0.0, you’re on the supported version, and there is nothing you need to do.

If your Avalara integration is not at the proper level you can update the integration by downloading the latest version from here and following these installing Sage 100 Avalara AVATAX instructions.

Sage 100 TLS 1.2 Compliance Update ( Nov 2022)

November 4, 2022 by Wayne Schulz

Sage updated their TLS 1.2 compliance chart with a list of Sage 100 versions which meet minimum requirements for compatibility with the company’s pending October 2023 licensing server changes.

As noted in the update, Sage will stop supporting the outdated TLS 1.0 and 1.1 protocols on their licensing servers in favor of more current (and more secure) TLS 1.2.

Note: Users of Avalara sales tax integration to Sage 100 who are using Rest v1 and SOAP will need to be on TLS 1.2 prior to February 16, 2023.

This protocol update will be required for any Sage 100 system on a subscription with Sage because the subscription requires a periodic verification against Sage’s licensing server. In order to be compatible with the new TLS 1.2 requirement you should ensure you are on one of the supported versions listed below.

Without TLS 1.2 any subscription version of Sage 100 will reportedly go into read-only mode.

Error: “Your Sage 100 subscription has expired. You can continue using the software for 45 days. Please contact Sage before xx/xx/xxxx to renew your subscription”

Which Sage 100 Versions Support TLS 1.2 As of November 2022?

As of November 2022, these versions of Sage 100 are compatible with the upcoming changes

2018 with product update 10 ( also referred to as 2018.10 or 6.0.10 )
2019 with product update 9 ( also referred to as 2019.9 or 6.1.9 )
2020 with product update 1 ( also referred to as 2020.1 or 6.2.1 )
2021 (all versions – no product update required )
2022 (all versions – no product update required )

For more information on Sage’s TLS requirements please refer to this knowledgebase article – Does Sage have plans to stop supporting TLS 1.0 & 1.1 for Sage 100?