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

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 […]

Sage 50 2021 New Features

Sage 50 2021 released on July 15th 2020. The new release provides a few new features that improve ease of use. It also steps up security for those who integrate Sage 50 with Gmail. And the new feature that I haven’t had a chance to test yet but has the potential to be a huge […]

Using Price Levels in Sage 50 US Edition (formerly Peachtree)

Easily assign different prices to different groups of customers using price levels.

QUANTITY DISCOUNTS

Sage 50’s quantity discount feature makes it easy to give price breaks based on the number of units sold.

Keep Column Widths When Copying Cells in Excel

When you copy and paste cells on a spreadsheet, do you get tired of having to resize the columns where you pasted the cells?  There are two good ways to copy the column widths along with your data. Copying entire columns is the fastest and easiest way to copy contents and formatting at the same […]

Accounting for PPP Funds in Sage 50

By now I’m sure most of you have heard about the Paycheck Protection Program (PPP). Several people who received money under the program have asked about the best way to account for the money in Sage 50, so I thought it would a good topic to address here. Most lenders are having PPP recipients setting […]

SUM Cells Across Multiple Tabs in Excel

You probably know that you can use the Sum function to add up a range of cells. But did you know that you can specify a range that covers multiple tabs (worksheets) in your Excel workbook? EXAMPLE Let’s say you have a workbook that lists the month’s sales of each of your products. There is […]

Sage 50 2020.2 New Features

The second update to Sage 50 version 2020 is scheduled to be released today. You should see a message in Sage 50 notifying you of the update within the next few weeks. These aren’t ground breaking new features but they (particularly the first two on the list) will be appreciated by most users Cash Account […]