Recent Articles
Correcting the QuickBooks Spelling Dictionary
If you use the spelling feature in QuickBooks you will find that it is easy to add a misspelled word to the dictionary. That is, QuickBooks says that a word is not in the dictionary and you accidentally click Add instead of Replace. The misspelled word is in your dictionary, and QuickBooks doesn’t provide you with a way to delete the entry. How can you fix this?
Paying a Bill Before Receiving Inventory in QuickBooks
Buying inventory is simple in QuickBooks. Create a purchase order, receive the items, enter the bill, pay the bill. Simple! Sometimes things don’t occur in this nice sequence, and it isn’t always obvious what the best procedure would be. What if you have to pay the bill before you have received the items? In this article I’ll give you some suggestions as to how to handle this situation.
Exporting QuickBooks Transactions with Transaction Pro Exporter
QuickBooks uses a “closed” database that you cannot access directly. If you want to extract transaction data, such as invoices or checks, you have to use a third party tool to extract the data (or get the SDK/ programming toolkit and write your own program). Today I’ll review the Transaction Pro Exporter from Baystate Consulting, which is an excellent program for extracting transactions from QuickBooks.
QuickBooks Inventory Quantity and Value Adjustments
If everything is working perfectly in your QuickBooks company you won’t need to worry about making inventory adjustments. You will receive inventory items, sell inventory items, possibly even build inventory items (assemblies), and everything will balance out. If that describes your company, great! For the rest of us, though, there are times when we will need to make inventory adjustments. The most common question I run into here is “do I make a quantity or a value adjustment?”
QuickBooks Manufacturing Forecasts: Component Demand
Having an adequate supply of component parts is critical to a manufacturer. If you run out of something, you can’t build your assembly. If you can’t build your assembly, you can’t fulfill customer orders. So let’s talk about how to avoid this if you are using QuickBooks.
Using Online Backups to save your QuickBooks Data
In my Backing Up QuickBooks Data article I talked about the importance of a good backup plan for your business. Today I’ll talk a bit about one portion of a good plan, using online backups.
When I’m hired to evaluate a business and their QuickBooks procedures one of the first things I look at is how they are making backups of their data. Not just their QuickBooks data, but all important electronic business information. All too often I find that there is no comprehensive backup and recovery plan in place. Some businesses have a plan, but they aren’t being implemented correctly. The most common reason is that backing up data is time consuming, complicated and a major hassle to perform. That is why I like online backups - they are simple to implement and don’t take a lot of effort to run.
Helpful QuickBooks Tips
Today I’m going to throw out a few miscellaneous small tips that may help you when you are working with QuickBooks. No particular theme, just a random collection.
If any of you have some helpful tips to add, pass them on in a comment here! I’ll add them to the article.
Goodbye to QuickBooks 2006 Support
It’s that time of year – Intuit’s annual “Sunset” of older versions of QuickBooks. If you are using QuickBooks 2006 then you won’t be able to use certain services after May 31st. I’m won’t editorialize on why this is done or if it is a good practice or not, I’ll just discuss what the impact will be on your business.
Changing QuickBooks Sales Tax Rates Mid-Year
You have your sales tax items and rates all set up, you have the sales tax rate selected for each customer, you can generate your reports, you are all set! HOWEVER - what do you do if a sales tax rate changes in the middle of the year? Today I’ll talk about some ways to handle this situation. I am going to assume you understand how to set up sales tax in QuickBooks (see my article on how to set up sales tax in QuickBooks).
Reconciling QuickBooks Inventory Balances
An important part of controlling your inventory is to make sure that your company financial statements match your inventory status. The inventory asset balance in your Balance Sheet should match the value in the Inventory Valuation Summary report. Unfortunately, these values don’t always match, and in this article I’ll talk about some reasons why this can happen, and ways to reconcile your inventory balances.
