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

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

Washington Paid Family Leave in Sage 50 Payroll

In the February 2019 payroll tax update Sage finally released a formula for Washington state’s new Paid Family Leave tax that took effect 1/1/2019. Unfortunately they failed to realize that the new formula uses the Special1 Additional Withholding field, which is already used by the Washington L&I tax, causing the family leave formula to calculate […]

Hide Divide By Zero Errors in Excel Using IF

Nobody likes to see #DIV/0!, Excel’s divide by zero error, on their spreadsheet. But there is no option to suppress it and sometimes your data makes the error inevitable. Fortunately you can use the IF function to hide or replace the divide by zero error message.

Sending Identical Invoices to Multiple Customers in Sage 50

If you have ever spent time entering identical invoices for multiple customer, the Broadcast Invoice feature was made for you.

Setting Up Report Groups in Sage 50

Report Groups allow you to print a group of reports all at once with just a single mouse click.

Use the Split Button to Divide an Excel Worksheet Into 2 or More Viewing Panes

Using the Split feature allows you look at different parts of an Excel worksheet at the same time.

Adjusting Year End Balances for Sick Leave and Vacation in Sage 50

In Sage 50 you can choose whether or not sick leave and vacation can be carried over into the new year. You can also set a limit on the maximum number of hours an employee can accrue. But you can’t set a limit on the number of hours that can be carried over into the […]

Change the Case of Text in Excel

Text copied or imported onto a spreadsheet may not be capitalized the way you want. Or if several different people work on the same spreadsheet you may get some people typing in all caps while others use normal capitalization. Excel doesn’t have a Change Case button like Word does, but you don’t have to copy your text to Word to change case and copy it back. Excel has three functions, UPPER, LOWER, and PROPER that you can use to change the case of text.

Memorized Transactions

Peachtree users that repeatedly enter the same or similar transactions can save time and improve accuracy with memorized transactions.