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 Accounting 2020 U.S. Edition New Features

Sage 50/Sage50cloud Accounting 2020 (formerly Peachtree Accounting) doesn’t bring any groundbreaking new features but it definitely brings some welcome changes. These are the kind of small changes that long time users often wonder why they can’t get, but software publishers are hesitant to invest time into because they don’t give them new features to advertise. […]

Distributing Text Over Multiple Rows in Excel Using Fill-Justify

This last installment on Excel’s Fill command explains how you can use it to distribute a long string of text evenly over multiple rows.

Creating Custom Autofill Lists in Excel

Last month we talked about how to use Excel’s Autofill feature to automatically fill in a series of words (like days of the week) or numbers. In order for the feature to work Excel needs to be able to recognize the series. So this month I want to show you how you can create your […]

Bank Deposit Report

If the deposits showing in Peachtree’s bank reconciliation window don’t match the deposits showing on your bank statement, the Bank Deposit Report is your best tool for fixing the problem.

Using the Fill Command In Excel

Excel’s Fill command lets you fill an adjacent group of cells with the same text or numbers, or with text or numbers that form a series. In its simplest form it’s like a faster version of copy and paste. For example, enter a name in cell A1, then highlight cells A1 through A5 and press […]

Cash Flow Manager

A business can turn a profit but still be short on cash. So now, when many businesses are experiencing decreased sales, it is more important than ever to be aware of your cash position. Peachtree’s Cash Flow Manager is designed to help you easily project your cash balance so you can make informed cash management decisions.


Unit of measure conversions allow you to buy, stock, and sell the same product in different units of measure. So if you need to buy something by the case and sell if buy the each, this is the feature you have been looking for.

Creating a Simple In-Cell Bar Chart in Excel using REPT()

Excel has some powerful features for creating graphs and charts, but sometimes they are overkill. Also, most charts give a view of your information that is completely separate from the original data. But if you have a list with numbers in Excel you can use the REPT() function to easily create a bar chart style […]

New Features in Sage 50 2019.2

Fewer Steps to Print Picking Lists and Packing Slips – After printing a sales order or invoice, a prompt will open asking “Would you like to print another form of this transaction?” Clicking Yes will take you back to the Print window so you can select the format you want to print. If you click […]

Switching Between Open Excel Workbooks

You may already be familiar with using Alt+Tab to switch between open windows. But the more windows you have open the less efficient that becomes. If you’re working in Excel and you want jump to another Excel workbook that’s already open you can bypass all the other programs that are running and just switch between […]