News and tips for Sage 50 (formerly Peachtree), Excel, and whatever other general nerd knowledge I think will help computer users be more productive.

IQ Accounting Solutions LLC

January 2022 News & Tips

Sage 50 versions 2013-2019 can no longer be reinstalled.   How to download updated 1099-NEC tax forms   Reset an Excel Spreadsheet – Delete your data but not your formulas


Sage 50 versions 2013 - 2019 Can't Be Activated: THIS IS EXTREMELY IMPORTANT NEWS FOR ANYONE USING AN OLDER VERSION OF SAGE 50, SPECIFICALLY VERSIONS 2013 THROUGH 2019. Like most accounting software, Sage 50 uses a 3rd party database management tool to manage it's data files. The provider of that tool, Pervasive, is no longer supporting older releases of that software and therefor, no longer supplying activation keys.

How does that affect you? According to the email I received from Sage, users on the affected versions "are able to use the product so long as they do not update their hardware, operating system (to major version), or add new installs."

To summarize the Sage 50 knowledgebase entry, any attempt to install or reinstall Sage 50, upgrade the computer hardware (replacing RAM, hard drive, network card, BIOS, etc), or upgrade the operating system (such as upgrading from Windows 7 to 10, or 10 t0 11) will cause the software to attempt to activate and fail.

Obviously my recommendation is to upgrade to Sage 50 2022. You can find pricing on my website at You can also contact me at or 918-851-9713 for pricing or questions. I sell at 20% off list price and give the option of perpetual or subscription licenses.

How soon you need to upgrade depends on your risk tolerance. The main risk is down time. If you have to replace a computer, how long can you go without access to Sage 50? There are also certain error messages that are fixed by reinstalling. I have customers with multiple users in Sage 50 all day, others who update their books weekly or even monthly. Only you know what's best for your situation. I can sometimes get orders processed the same day, almost always by the next business day.

The other risk is the continued availability of traditional perpetual licenses. I'm assuming that if you wanted to be on a subscription license, you already would be, and you wouldn't be running an older version now. A year ago, the rumor mill was saying that perpetual licenses sales were about to come to an end. Now the rumor mill has changed its mind and is projecting that they won't be going away any time soon. Who knows what will really happen? If you're determined to stay on a perpetual license, it makes sense to upgrade sooner rather than later. On the other hand, for those considering switching to a subscription license, now through February 15th, users on versions 2016-2021 can get 50% off the first year's subscription. You can find my comparison of Sage 50's subscription license versus perpetual license at

Steve Collins
IQ Accounting Solutions LLC

A complete archive of these tips is available at

Sage 50/Peachtree Tip - Downloading Updated Formats for 2021 1099s.

There are two ways to do 1099s in Sage 50. If you do payroll in Sage 50 it's probably easiest to use Aatrix, like you would for W-2s, and print on blank 4-up forms. But if you use Sage's internal forms engine, you'll need to download the updated formats for the new 3-per-page 1099-NEC and the 1096.

If you ordered 3-per-page 1099-NEC forms from Sage or other form suppliers, you can download the *.frm files from the knowledgebase entry 1099-NEC Filing Forms for use with Sage Checks & Forms(L1096/L99NECA Laser)

If you ordered 1099-NEC form from the IRS, you can you can download the *.frm files from the knowledgebase entry 1099-NEC Filing Forms for use with IRS scannable fileable forms.

When you download the files, you'll need to save them in the Forms folder in your Sage 50 data path. To determine where that is, go to the Maintain menu in Sage 50 and choose Company Information. Make note of the location in the Directory field; it shows you where your data path is. For example, if the Directory field reads C:\Sage\Peachtree\Company\mycompany, then your Forms folder will be located at C:\Sage\Peachtree\Company\Forms.

Once the files have been downloaded and saved to the Forms folder, you can print 1099s by going to the Reports & Forms menu > Forms > Tax Forms. Depending on which set of files you downloaded, the new forms will show up as either:
  1. Form 1096 2021 Preprinted
  2. Form 1099-MISC 2021 Preprinted
  3. Form 1099-NEC 2021 RED
  1. Form 1096 IRS 2021
  2. Form 1099-MISC IRS 2021
  3. Form 1099-NEC IRS 2021 RED

Excel Tip - Reset an Excel Spreadsheet – Delete your data but not your formulas

Have you ever built a spreadsheet and then wanted to re-use it, say for the next year, but realized you forgot to save a blank copy? That means you have to delete all the data that was entered into the workbook while being careful not to delete any of your formulas. That can be a tedious process, but it doesn’t have to be. Here’s an easy way to delete everything that’s not a formula.

  1. Select everything in your spreadsheet except column and row headings.
  2. Press the F5 key, or Ctrl+G (for Go To), or click the Find & Select button on the ribbon and then choose Go To.
  3. In the Go To window, click the Special button.
  4. In the Go To Special window, select Constants and click OK. This will select everything within your highlighted range that isn’t a formula.
  5. Press the Delete key on your keyboard.

You’ll be left with just your formulas so your spreadsheet will be ready to use again.


If you know other Sage 50/Peachtree users, do them (and me) a favor and pass this along to them. If you are someone that this has been passed on to, and would like to be added to my email list, you can subscribe for free at or send me an email at If you need to change your email address or would like to unsubscribe, you can use the links at the end of this email.

Steve Collins
IQ Accounting Solutions LLC
10611 E 17th Place
Tulsa, OK 74128
Copyright © 2022 IQ Accounting Solutions LLC, All rights reserved.
Email Marketing Powered by Mailchimp