Thanks for visiting my blog.  The main purpose of this blog is to serve as an archive of the tips that I send out in my monthly email newsletter.  Each month’s issue includes a tip for users of Sage 50 (formerly Peachtree) Accounting software as well as any relevant news or announcements.  For several months after a new release I also highlight a new feature.

Since most people use more than just Sage 50/Peachtree, I also include a tip for Excel, Word, or some other program that I think people will find helpful.  If you like what you read here, click on the link to the right and sign up for my mailing list.  Then you can get free tips and tricks in your inbox every month.

Also be sure to visit my main web site where you can take a free test drive of Sage 50-US Edition and find detailed comparisons of each version of Sage 50/Peachtree.

Steve Collins
IQ Accounting Solutions

Sage 50 Customer Sales History report and Items Sold To Customers

As we approach year end, are you looking for an easy way to get a summary of sales by customer? You have two great choices with the Customer Sales History or the Items Sold To Customers reports. To get to either report, go to to the Reports & Forms menu and choose Accounts Receivable. To […]

Use AutoFit to Adjust Column Width or Row Height in Excel

Do you get tired of adjusting column widths to fit what you think is your longest entry only to discover when you scroll down that the column needs to be wider? Excel makes it easy to adjust your columns widths or row heights to match your data. Let’s start with the simplest example. If you […]

Sage 50 2024 New Features

In my last newsletter I told you that Sage 50 2024 had released and that it now offered integration with Sage HR. I didn’t go into any details because Sage was a little late on getting those details to me. But here’s my summary of what’s new. In version 2024, Sage 50 payroll users will […]

Combine Excel Data into One Column using ToCol()

Last month I talked about how to use Transpose to copy data from a row and paste it into a column or vice versa. This month we’ll look at a fairly new Excel function ToCol() that can pull data from several adjacent rows and columns and combine it into one column. (There’s also a ToRow() […]

Sage 50 2024 New Release

Sage 50 Accounting US Edition 2024 was released on October 16th 2023. As in previous years, Sage 50 will automatically download the update for anyone with a current subscription or business care plan. Once it has been downloaded you will be prompted to install it when exiting Sage 50. Like always, it’s up to you […]

Hide Inactive Customers, Vendors and Inventory Items Based on Last Activity Date

Over the years, customers, vendors, and inventory items come and go. That means lists get cluttered up with obsolete records. While you can’t delete those customers, vendors, or inventory items as long as you still have transactions linked to them, there is an easy way to hide them so they don’t show in the drop […]

Sage 50 2020.1 & Older Will No Longer Activate after 9/30/2023 – What are your options?

If you’re using Sage 50 2021, 2022, or 2023, this does not apply to you. Anyone on an older version needs to read this. I take seriously my responsibility to provide you with accurate information so you can make good decisions for your business. I’ve been researching this problem for quite a while now and […]

Sage 50 2020.1 & Older Will No Longer Install

If you’re using version 2020.1 or older of Sage 50, you’ve probably already received warnings from Sage that parts of your software will stop working after 9/30/2023. I’ve heard from several people asking what this really means and how it affects them. In short, the problem is real and shouldn’t be ignored. But, from the […]

Procedure Entry Point Error In Tax Forms

Recently I’ve had several calls from people getting an error when trying to open the payroll tax forms. The exact error may vary, but it will be similar to The procedure entry point…could not be found in the dynamic link library…\Formviewer\Aatrixforms.exe. The problem can usually be fixed easily by reinstalling the Aatrix form viewer. Just […]

1099 Printing Changes in Sage 50 2023

Version 2020 added 1099 integration with Aatrix (the program used to generate payroll tax forms) while also still supporting printing of 1099s using the traditional editable forms built into Sage 50. But the Aatrix option was only available to payroll subscribers. Starting in version 2023, the legacy 1099 method has been dropped in favor of […]