Don’t Kid Yourself, You Need a Reliable Backup.

So far this year I’ve already talked with 3 people who have lost data because of hardware failure or malware attack, and another who was lucky enough to get their data back but spent a very nervous weekend waiting to hear if their IT person would be able to recover data from their dead computer. […]

Printing Sage 50 Invoices, Picking Lists, or Other Forms From Prior Periods

A common question from Sage 50 users is how to reprint a form, such as an invoice, sales order, or picking list from a closed year or, if you have restricted user’s access to previous periods, how to you reprint one from a closed month? Most people print forms, such as invoices from the same […]

Automatically Add Subtotals and a Grand Total to a List in Excel

Did you know that, with just a few clicks, Excel can add subtotals and a grand total to your lists? In order for it to work you do have to start out with your data formatted correctly. Logically, you’ll need to have the data in your list sorted by field you want to subtotal by. […]

Introducing Sage 50c

You may have received information about the new Sage50c. So I thought I would take a moment to explain what it is, what it’s not, and who might be a good candidate to use it. Sage describes it as “Reliable desktop software with anytime, anywhere cloud access. Perfect for working with your accountant or while […]

Insert Comments on Excel Worksheets

If you’ve ever wanted to make notes on an Excel worksheet like you would on a printed report, you’re in luck. That’s exactly what the Insert Comment feature does. Simply right click on the cell you want to attach the comment to, and choose Insert Comment. A box that looks similar to a yellow sticky […]

Sage 50 1099 Tips – Adjustments & Non-Cash Payments

Most of the 1099 process in Sage 50 is pretty straight forward. Record your payments throughout the year, set the “1099 Type” field to Independent Contractor for any vendor that should get a 1099-Misc, and print your forms at the end of the year. But how do you adjust the 1099 amount when needed? Or […]

Sage 50 Automatic Backup Scheduler

Backup is one of those issues that is so important it’s almost impossible to over emphasize it. I’m a big fan of the sister companies IBackup and IDrive as a reliable and affordable way to get an off-site backup. But because your accounting data is so important I still recommend using Sage 50’s built in […]

Recalculating Prices in Sage 50

If you want to change prices for all or part of your items or services in Sage 50 (Peachtree), it’s easier than you might expect. Obviously you could go to Maintain Inventory Items and change the price each item individually, and that’s fine for making a few changes. But there’s a better way to make […]

Conditional Formatting in Excel

Everyone knows how to apply formatting such as bold, italics, or color to a cell on an Excel worksheet. But did you know you can establish rules so that if certain conditions are met, the cell will automatically receive selected formatting? You can, and it’s called conditional formatting. Let’s look at a few examples. I’ll […]

Sage 50 2016.1 Update Released 10/20/2015

Sage 50 2016.1: The first update to Sage 50 2016 was released on 10/20/02015. Most significant is that with the update, Sage 50 is now “compatible with and certified for Windows 10.” There were also fixes to the Sales Journal and Cash Receipts Journal reports that involved problems with the Invoice Notes field. Also new are: […]