Welcome

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

Using IFERROR in Excel to Hide Error Messages and Prevent Errors in Dependent Formulas

You have probably all seen Excel formulas that result in an error such as #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, or #VALUE!. Usually they indicate that you need to correct something in your formula or the data it references. But sometimes the condition that produces the error is unavoidable. In those cases not only does […]

Sage 50 2022 New Features

Version 2022 of Sage 50/Sage 50cloud releases July 21, 2021. It should show up in your updates soon as they gradually roll it out to users. The list of improvements is short, but they will be significant to some users. State Paid Family and Medical Leave enhancementsNew payroll functionality has been added to accommodate the […]

Creating a 12 Period Income Statement in Sage 50 for Prior Years

One of Sage 50’s built in financial statement formats, “<Standard> Income – 12 Period”, gives you an income statement for the current fiscal year split out into monthly columns. People are often surprised to find that it doesn’t let you choose a date range so you can’t use it to report on prior years. But […]

STARTING A NEW LINE WITHIN AN INVOICE DESCRIPTION

When typing in the description field of a Peachtree invoice, the enter key moves you to the next field. Read this tip to find out how to start a new line of text within the same description field.

Customer Prepayments in Sage 50

Do you require down payments or prepayments from your customers? I’m often asked how to record prepayments since there is no invoice that the payment can be applied against. Today I’m going to go over two ways to a deal with this and some of the pros and cons of each method. OPTION 1: Use […]

Pay Fields Missing From Payroll Entry Screen

I’ve had several calls recently from people trying to do payroll, but for some employees there are no pay fields showing in Payroll Entry. As a result there’s nowhere to enter the employee’s pay. The solution is simple, but far from obvious so I thought it would be a good topic to cover here. In […]

Printing the New 1099-NEC in Sage 50

You’ve probably heard by now that non-employee compensation now must be reported on form 1099-NEC, instead of the 1099-MISC. The 1099-MISC still exists for other types of payments (rents, royalties, attorney fees, etc.) but non-employee compensation, (payments to contractors) now have their own form. How does this affect Sage 50 users? It depends on how […]

Sage 50 2021.1 New Features

The first update to Sage 50 2021 released a few weeks ago. Many people were glad to get it because it fixed the problem that plagued some users with a lagging or freezing mouse pointer. But it also brought a couple of important new payroll features. Unlimited Pay Types – Previously you were limited to […]

FIND YOUR TOP CUSTOMERS

Whether you are negotiating prices or making a Christmas gift list, it is important to know who your top customers are. With Peachtree, this information is always just a few clicks away.

Setting a Default Cash Account for Cash Receipts

Out of the box, the standard behavior for the Receive Money window is Sage 50 is to remember the last account that was use in the Cash Account field. Sometimes that is fine, but other times it causes problems. For example, a common way to write off bad debt is to receive a dummy payment […]