Printing a Pick Ticket and Packing List with your Sales Order or Invoice

One of the things that has always been a nuisance in Sage 50/Peachtree is the process for printing pick lists and packing slips, at least if you wanted to print them at the same time as the sales order or invoice. I’ll use invoices and packing slips in my example but the problem (and now […]

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