Archive for category All

Dealing With Uncleared Checks From Prior Years in Sage 50

This month’s tip is a request from a reader. Ginny wanted me to address “How to write off uncashed checks from prior years and how to handle re-issuing an uncashed check from prior years.” Even though the same principals apply in all three cases, the exact steps will vary depending on whether the check paid […]

Excel Watch Windows

A watch window lets you monitor cells from different parts of a spreadsheet all in one spot.

Recording an NSF Check From a Customer in Sage 50

Hopefully this is a tip you won’t need very often but when a customer does bounce a check, at least there’s any easy way to account for it in Sage 50. It’s basically just two steps: First invoice the customer for the NSF check charge. Second, record a negative cash receipt in the amount of […]

Printing Selected Rows Or Columns On Every Page of an Excel Worksheet

Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen.  This month I’ll show you how you can choose rows or columns to appear on every page when you print. This lets you print a report heading and/or column/row headings on […]

Sage 50 Won’t Open After July 2018 Windows 10 Update

A few months ago Microsoft released an update to Windows 10 that caused Sage 50 to crash. But you could work around it by setting Sage 50 to run in compatibility mode. Now Microsoft has released a new Windows 10 update that is causing Sage 50 to fail to open when it is set to […]

Keep Row and Column Headings Visible in Excel With Freeze Panes

Freeze Panes lets you keep row and columns headings visible as you scroll through a large spreadsheet.

What’s New in Sage 50 US 2019

I just received my copy of the new release of Sage 50 and have been looking it over. So whether you call it Sage 50 US Edition, Sage 50c, or Sage 50cloud, Here is my summary of what’s new in Sage 50 2019. Expanded Sales Order Drop-down Menu in Sales/Invoicing Window – When choosing a […]

Put Your Company Logo On Forms

Adding your company logo to your forms takes just a few minutes. It is an easy way to make your forms more professional looking and more noticeable.

Ranking List Entries in Excel

Learn how to rank list entries in Excel without resorting your data.

Customize the Sage 50 Shortcut List for Quick Access to Frequently Used Features

The shortcuts that are on the left side of Sage 50’s main window were introduced with version 2007. But because we are all creatures of habit, they are still overlooked by many users.  These shortcuts provide one click access whatever tasks/features you choose. By default the list of shortcuts includes: Sales Invoice Receive Money from […]