Cleaning Up Your QuickBooks File at Year End

Cleaning Up Your QuickBooks File at Year End

QuickBooks Tips & Tricks
Are you in the habit of cleaning up your QuickBooks file at year end?  If not, it's a good habit to get into as few of us ever think about including our QuickBooks file when we think of year-end cleanup. If you’ve been using QuickBooks for any length of time (like I have) or inherited the company QuickBooks file from one or more previous bookkeepers, I’m betting that your QuickBooks Lists are just full of “things” that are no longer used. Let’s go take a look shall we? Let’s start with your Chart of Accounts: Can you still see that checking account listed there that you (or someone else) closed a year or two ago? Do you see an account used for the same thing but listed with several different…
Read More

How Well Does the New QuickBooks 2012 Condense Feature Work?

From Our Guest Bloggers, QuickBooks Setup & Cleanup
  QuickBooks 2012 introduced a new approach to condensing large QuickBooks data files. How well does the new condense feature work? And how does it compare to the results given by third party data condensing services, like those of AccountingUsers, Inc.? We did some tests to find out. We used the new condense function in QuickBooks 2012 (using either QuickBooks 2012 Premier Accountant Edition, or Enterprise Accountant 12) and recorded the results. We then ‘supercondensed’ those same original files. We tested “apples to apples” for seven separate QBW files. Some files were QuickBooks Pro and some were Enterprise. Results? For 3 of the 7 files we tested, the QuickBooks condense function performed pretty well. Those files were reduced in size by 57%, 58% and 73%. When we supercondensed those same…
Read More

QuickBooks Tip – File Size & DB File Fragments What Do They Mean?

Be A Better Bookkeeper, Free & Fee-Based QuickBooks eBooks, General QuickBooks News, QuickBooks Setup & Cleanup
The size of your QuickBooks file and the number of DB File Fragments determines the health of your QuickBooks company data file. Most people don’t periodically check the health of their QuickBooks file to help prevent data corruption – mainly because they don’t realize that they should or even how to go about it. Monday's blog post - Basic File Maintenance Before & After You Upgrade - talked about checking your current file size and health before before you upgrade to a new version of QuickBooks.  In reality, you should periodically check this information just to see how healthy your file is or isn't. To check the size of your own QuickBooks file – with QuickBooks open press the CTRL and the 1 keys at the same time OR press…
Read More

QuickBooks Tip – How To Rebuild Your QuickBooks Data File

General QuickBooks News, QuickBooks Setup & Cleanup
This QuickBooks Tip provides instructions for how to rebuild your QuickBooks data file.  The rebuild function will help maintain the overall health of your file. Is your QuickBooks file very large?  Is it running slow?  Are you in a multi-user environment where 2 or more people are inputting a lot of information on a daily basis?  If you answered yes to any of these questions you would probably benefit from rebuilding your data file on a regular basis. The QuickBooks Rebuild Data function is like a cleaning lady.  When you access the rebuild function it looks at all of the information in your file and makes sure that it has been filed correctly.  Think of your desk, covered in piles of papers that need to be filed.  Before you actually…
Read More