I often get questions about how to do direct deposit payroll in Sage 50. There are a few different options, each with different benefits and different costs. Since people often considering implementing new procedures at the beginning of a year, I thought this would be a good time to cover this subject. OPTION 1 – [...]
Archive for category All
Usually we think about Excel saving us time by performing lengthy or repetitive calculations for us. But sorting is another great time saving feature. It can do simple sorting with just two clicks or more complex multilevel sorting with an easy to use tool. You can sort your whole worksheet or just selected cells. In [...]
If you have ever charged a customer sales tax when you shouldn’t have, you probably learned that correcting the mistake can be tricky. First let me point out a couple of common mistakes people make and why they don’t work. Mistake #1 – Using the sales tax field alone to issue the credit. Whether you [...]
Today’s tip is about how you can discover some of Excel’s power on your own. Built into Excel are many helpful tools called functions. Functions are shortcuts that make it easier for you to accomplish things that would otherwise require long, complex formulas. For example, the best known function is Sum. You’ve probably used it [...]
By default, most numbers in Sage 50 show 2 decimals. But you have the option of changing that. To change the number of decimals used on screen, open the Options menu and choose Global. On the Accounting tab are you can choose the number decimal places for Quantity fields, Unit Price fields, and Standard Fields. [...]
You probably know that you can hide columns or rows in an Excel spreadsheet simply by selecting one or more rows or columns (for simplicity, I’ll only talk about rows, but everything here applies to columns also), then right-clicking and choosing Hide. You can unhide them by selecting a range of rows that includes the [...]
In Sage 50 and Peachtree, inventory related transactions all revolve around the Item ID. Since it st the unique identifier for each item, it’s always used for data entry. While you are limited to using the Item ID on screen, Sage 50 can substitute an item’s Part Number or UPC/SKU field for the item ID [...]
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.
Occasionally you may need to replace a payroll check if an employee loses or destroys their check. It’s a simple process in Sage 50 (formerly Peachtree). This tip will show you everything you need to know about the process.
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 [...]