If you need to calculate a date in Excel based on another date, such as a due date that is 30 days after an invoice date, or scheduling a follow-up 3 months after a meeting, you can do so using a simple formula to add a number of days to a date, or using the EDATE function to get the same date in a future (or past) month.
The “Waiting on Bill” option in Sage 50/Peachtree allows you receive inventory before you have an invoice for it. This tip explains how and why you should use it, as well as how to work around some of its shortcomings.
Sage 50 will let you sell more inventory than you have on hand. But how does that affect inventory and cost of goods sold?
Recurring Transaction Setup
Aug 28
If you manually enter the same transaction every week, month etc, recurring transactions can save you time.
If you have ever needed to shut down Windows 7 in a hurry only to discover updates waiting to install, this is the tip you’ve been waiting for.
Pricing Formulas
Jul 31
Pricing formulas can make it easy to changes prices for your whole inventory.
Centering text across multiple columns in Excel is easy with this quick formatting tip.
Learn how to combine budget and actual data using a custom income statement to make a year-end projection.
Peachtree Accounting is being renamed Sage 50 starting with version 2013. Read on to find out what is new and what has stayed the same.
Have you ever wished you could take a picture of your computer screen to use in a document? Well most Microsoft Office 2010 programs finally give you a convenient way to do this.
