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

[Facebook] [LinkedIn] [StumbleUpon] [Twitter]

Sage 50 2018.1 New Features

2018.1 Update for Sage 50: In November Sage released an update to Sage 50 2018. All users with a current subscription or Business Care Plan should be automatically notified when it is ready to be installed. If you don’t want to wait for it you can go to the Services menu and choose Check For […]

1099 Vendor Report – It’s not just for January

Year end is always a busy time for accountants and bookkeepers. The 1099 Vendor Report lets you review your 1099 data any time so you can resolve problems now, instead of in January when the deadline is looming.

Taking Advantage of Tables in Excel

In the general sense, a table is just data that you have arranged into columns and rows. But in Excel, when you use the Format As Table button to define an area on your spreadsheet as an Excel table, there are several things you’ll be able to take advantage of that make entering and working […]

Recording a Refund From a Vendor or Miscellaneous Cash Receipt in Sage 50.

It doesn’t happen very often, but sometimes you get money back from a vendor. How do you record the refund in Sage 50/Peachtree? It’s not hard but you’re probably so used to ignoring the option that you don’t even realize it’s there. And you don’t have to resort to using a general journal entry or […]

Highlight Differences In Lists Using Excel’s Go To Command

While there are several ways to compare lists in Excel and highlight differences, an option in the Go To feature provides a really quick and simple method.

Adding “Cleared Date” to the Check Register in Sage 50

One of the new features in Sage 50 2018 is the ability to add a column for “cleared date” to the check register and cash disbursement journal reports. Adding the column is simple, just click the Columns button when viewing either report, scroll down to the end of the list of available column and check […]

Using AND() or OR() in Excel to Allow Multiple Conditions When Using IF()

Excel’s IF() function, in case you aren’t familiar with it, allows you to do one thing if a chosen condition is met, but do something else if that condition is not met. For example, when evaluating test scores you might want to display “Pass” if the score is 80% or better, but display “Fail” if […]

Patch for Sage 50 2018 to Fix Slow Drop Down Lists

Shortly after Sage 50 2018 was released some users reported that drop down list, such as customers or items, were very slow to open. The problem is limited to very large lists. Sage has responded quickly with update 2018.0.1. Sage is recommending that only user who are experiencing the problem install the update, so I […]

Sage 50 2018 New Features

Version 2018 of Sage 50 U.S. Edition (formerly Peachtree Accounting) released on July 12th. As usual, notification to users of the update will be staggered to spread out the load on Sage’s servers. There are several updates, some big and some small, including the first significant update to the user interface in about 10 years. […]

COMBINING DATA FROM MULTIPLE CELLS USING CONCATENATE

Combining the contents of multiples cells in an Excel spreadsheet is easy thanks to the Concatenate function.