As we have discussed before, the IRS has the authority to request QuickBooks data files from US taxpayers as part of their audit procedures. (And not only QuickBooks – they can request Peachtree data as well.)
We also hear of state agencies and insurance companies sometimes requiring copies of QuickBooks data for their audits.
If you are selected for this, you can send them your regular QuickBooks data file, and they will have access to all your financial records, including the years before and after the audit period. The problem with that is it gives the auditors access to much more information than is necessary. Tax accountants worry about auditors going on “fishing expeditions” in those situations.
One approach that could prevent additional complications is to have an Audit Disclosure Copy created. The Audit Disclosure Copy contains only the QuickBooks information for the year under audit. That will give the auditors complete information for the audit period in question, but nothing beyond that.
Creation of an Audit Disclosure Copy is available as a third party service. Get more information here or call 1-800-999-9209.
Have you ever seen the classic 1968 short film, Powers of Ten? It’s an amazing demonstration of the power of adding zeros, one at a time. I love it. Check it out:
Somehow it reminds me a bit of QuickBooks files. The power of adding a zero, you see.
With your company file open in QuickBooks, press the F2 key. It will tell you, in the left column, how big your file size is. It expresses it in kilobytes (KB): thousands of bytes. A byte is a single character of information in a digital file.
A medium-sized QuickBooks Pro file might have 80,000KB of information, or 80 million bytes. We usually notate that as 80MB, or call it 80 megabytes. That sounds like a lot of bytes, but it’s not for a QuickBooks file.
Add a zero. That would make for a file of 800 megabytes. Now that’s an oversized file, bursting at the seams, if you are using QuickBooks Pro or Premier. A file of that size in Pro or Premier would likely be having performance and/or stability problems and would be a great candidate for supercondensing. An 800MB file would not be uncommon for Enterprise, though.
Add another zero. Now your file is 8,000,000,000 bytes big – 8 gigabytes. That’s a huge file, even for Enterprise. We have repaired or supercondensed a handful of files like that before. 8GB is about the biggest we’ve seen.
Until now. A user is planning to send us a file with another zero added, and then some: a file of 88 gigabytes, by far the largest QuickBooks file we’ve ever personally worked with. Is it the biggest QuickBooks file in the world? I’ve never heard of a bigger one. Have you?
Now this file is not a QBW file; it’s a TLG file – an auxiliary data file that QuickBooks maintains along with the main QBW file. We will use it to repair his damaged QBW file. Still, for QuickBooks to maintain any file that big is stupendous, and again reminds me of Powers of Ten.
Most startups struggle at the beginning and mine was no exception.
My business partner and I started our software consulting company in 1986. By mid-1987, I had little left in savings. My wife and I did have a new baby on the way. And we had a new mortgage too…with a wonderful mid-80s fixed rate note at 13.5%! (What were we thinking?!)
I was more than a little discouraged at my consulting business’ prospects and my personal finance situation.
It seemed that it was time to bail out and get a job again. I sent my resume out to a few companies in Austin.
Here’s what I got back from IBM:
That was September of 1987. No offers. Troubled Texas economy. In the absence of other options, I plugged away at my consulting business.
Fast forward a few months. My partner and I created an add-on program to a now-defunct accounting app called BPI Accounting. Our little program allowed users to archive and report general ledger information for a whole fiscal year, instead of just four months. (Primitive! This was for the first generation of PC-based accounting software.)
Somebody helped us reach out to the user base, and the next thing I knew, our mailbox was full of order forms and checks. Wowee!
Developing accounting software add-ons and troubleshooting accounting data files became our niche, and the second part of that equation still works for us 24 years later in the QuickBooks world.
In an alternate life, I’m sure that a career at IBM would have been very challenging and rewarding. But it was not to be; I got to be a long-term software entrepreneur instead.
“A person often meets his destiny on the road he took to avoid it.” ~Jean de La Fontaine
We’ve been hearing from a number of users in the last month about this problem.
One day, everything is fine. Then suddenly, the users notice that a lot of their bills, or bill payments, or invoices have missing vendor or customer information. The name, in particular. Or their customer or vendor lists go blank. This is called list damage in a QuickBooks file.
Rebuilding the file in QuickBooks doesn’t seem to help; rebuild fails.
The problem is usually repairable. But it is still a bit of a mystery as to why we’re seeing more instances of list damage than usual (We’ve seen and repaired this problem over the years, but it has not been commonplace.)
Anyone seen this problem recently? Did the problem seem to appear randomly, or in association with something else happening in QuickBooks?
Have you ever had a QuickBooks problem where all the normal troubleshooting techniques don’t work?
Maybe your computer got infected with a virus or a trojan program. You got that cleaned up and you reinstalled QuickBooks. But now QuickBooks just won’t launch, or it’s operating at a snail’s pace, or something that used to work just fine now won’t work.
You might get the wonderful error, “QuickBooks has experienced a problem and needs to be shut down. Error ….” or “Unrecoverable error …”.
If the relationship between QuickBooks and Windows gets messed up, QuickBooks will be messed up. If something alters or corrupts your Windows registry settings for QuickBooks, just uninstalling/reinstalling QuickBooks often won’t help.
[NOTE: This has nothing to do with registering your installation of QuickBooks with Intuit, by the way.]
Here’s a tool you can use that might help, and it’s already right there on your computer. The REBOOT.BAT file gives you a one-click way to re-register your QuickBooks program files to the Windows registry.
The REBOOT.BAT file (sometimes seen as just REBOOT in your Windows folder view) can be located simply by right-clicking your QuickBooks icon on your computer’s desktop.
If a menu item then appears saying “Open file location”, click that and it will take you to the folder where REBOOT.BAT lives. If you don’t see “Open file location”, click instead on “Properties” and under the Shortcut tab, look at “Target”. Don’t change the contents of “Target”, but make a note of the path it specifies. Then open My Computer and open the folders to drill down to that location on your computer.
Then double-click REBOOT.BAT (or REBOOT) and your QuickBooks program files will be re-registered to Windows. You’ll see a command prompt-style window open and a number of commands execute. When I ran this on my computer, one of the commands took several seconds to complete. Be patient. When it runs through all the commands, the window will automatically close. Your computer will NOT reboot (I think this command is badly named.)
Then run QuickBooks again and see if REBOOT has cleared up your problem.
NOTE: This troubleshooting tip won’t help solve company data file problems in QuickBooks. Data corruption issues have to be handled in a different way.
You want to keep good books? Then read a good book.
There are good training resources available for beginning and advanced users of QuickBooks. Here are some of the highest rated ones on Amazon:
QuickBooks 2011, the Missing Manual, by Bonnie Biafore. 720 pages. Pogue Press. 4.7/5 Stars on Amazon. Great balance between instructions on specific features and basic accounting advice.
Running QuickBooks 2011 Premier Editions: The Only Definitive Guide to the Premier Editions, by Kathy Ivens. 608 pages. CPA911 Publishing. 5/5 Stars on Amazon. Tips, tricks, shortcuts, and workarounds to unleash the full power of the Premier editions.
QuickBooks 2010 Solutions Guide for Business Owners and Accountants, Laura Madeira. 528 pages. Que Publishing. 4.5/5 Stars on Amazon. For intermediate to advanced users, this guide helps you use QuickBooks to understand where your business is currently, and where it’s going.
This last one is not a book, but it is a great do-it-yourself training resource: QuickBooks Essentials LiveLessons (Video Training): For All QuickBooks Users [DVD-ROM], by Laura Madeira. 1 DVD. Published by Que Publishing. 4.4/5 Stars on Amazon. This training DVD has 18 lessons to help walk you through every essential QuickBooks skill.
These resources cost under $30, but can fill in some of the gaps in your QuickBooks knowledge.
Please follow and like us:
AccountingUsers, Inc. ("us", "we", or "our") operates the https://quickbooksusers.com website (hereinafter referred to as the "Service").
This page informs you of our policies regarding the collection, use and disclosure of personal data when you use our Service and the choices you have associated with that data.
Service is the https://quickbooksusers.com website operated by AccountingUsers, Inc.
Personal Data means data about a living individual who can be identified from those data (or from those and other information either in our possession or likely to come into our possession).
Usage Data is data collected automatically either generated by the use of the Service or from the Service infrastructure itself (for example, the duration of a page visit).
Cookies are small files stored on your device (computer or mobile device).
Data Controller means the natural or legal person who (either alone or jointly or in common with other persons) determines the purposes for which and the manner in which any personal information are, or are to be, processed.
Data Processors (or Service Providers)
Data Processor (or Service Provider) means any natural or legal person who processes the data on behalf of the Data Controller.
We may use the services of various Service Providers in order to process your data more effectively.
Data Subject (or User)
Data Subject is any living individual who is using our Service and is the subject of Personal Data.
Information Collection and Use
We collect several different types of information for various purposes to provide and improve our Service to you.
Types of Data Collected
While using our Service, we may ask you to provide us with certain personally identifiable information that can be used to contact or identify you ("Personal Data"). Personally identifiable information may include, but is not limited to:
First name and last name
Cookies and Usage Data
We may use your Personal Data to contact you with newsletters, marketing or promotional materials and other information that may be of interest to you. You may opt out of receiving any, or all, of these communications from us by following the unsubscribe link or the instructions provided in any email we send.
We may also collect information on how the Service is accessed and used ("Usage Data"). This Usage Data may include information such as your computer's Internet Protocol address (e.g. IP address), browser type, browser version, the pages of our Service that you visit, the time and date of your visit, the time spent on those pages, unique device identifiers and other diagnostic data.
We may use and store information about your location if you give us permission to do so ("Location Data"). We use this data to provide features of our Service, to improve and customise our Service.
You can enable or disable location services when you use our Service at any time by way of your device settings.
Tracking & Cookies Data
Cookies are files with a small amount of data which may include an anonymous unique identifier. Cookies are sent to your browser from a website and stored on your device. Other tracking technologies are also used such as beacons, tags and scripts to collect and track information and to improve and analyse our Service.
You can instruct your browser to refuse all cookies or to indicate when a cookie is being sent. However, if you do not accept cookies, you may not be able to use some portions of our Service.
Examples of Cookies we use:
Session Cookies. We use Session Cookies to operate our Service.
Preference Cookies. We use Preference Cookies to remember your preferences and various settings.
Security Cookies. We use Security Cookies for security purposes.
Advertising Cookies. Advertising Cookies are used to serve you with advertisements that may be relevant to you and your interests.
Use of Data
AccountingUsers, Inc. uses the collected data for various purposes:
To provide and maintain our Service
To notify you about changes to our Service
To allow you to participate in interactive features of our Service when you choose to do so
To provide customer support
To gather analysis or valuable information so that we can improve our Service
To monitor the usage of our Service
To detect, prevent and address technical issues
To provide you with news, special offers and general information about other goods, services and events which we offer that are similar to those that you have already purchased or enquired about unless you have opted not to receive such information
Legal Basis for Processing Personal Data under the General Data Protection Regulation (GDPR)
AccountingUsers, Inc. may process your Personal Data because:
We need to perform a contract with you
You have given us permission to do so
The processing is in our legitimate interests and it is not overridden by your rights
To comply with the law
Retention of Data
AccountingUsers, Inc. will also retain Usage Data for internal analysis purposes. Usage Data is generally retained for a shorter period of time, except when this data is used to strengthen the security or to improve the functionality of our Service, or we are legally obligated to retain this data for longer periods.
Transfer of Data
Your information, including Personal Data, may be transferred to - and maintained on - computers located outside of your state, province, country or other governmental jurisdiction where the data protection laws may differ from those of your jurisdiction.
If you are located outside United States and choose to provide information to us, please note that we transfer the data, including Personal Data, to United States and process it there.
Disclosure of Data
Disclosure for Law Enforcement
Under certain circumstances, AccountingUsers, Inc. may be required to disclose your Personal Data if required to do so by law or in response to valid requests by public authorities (e.g. a court or a government agency).
AccountingUsers, Inc. may disclose your Personal Data in the good faith belief that such action is necessary to:
To comply with a legal obligation
To protect and defend the rights or property of AccountingUsers, Inc.
To prevent or investigate possible wrongdoing in connection with the Service
To protect the personal safety of users of the Service or the public
To protect against legal liability
Security of Data
The security of your data is important to us but remember that no method of transmission over the Internet or method of electronic storage is 100% secure. While we strive to use commercially acceptable means to protect your Personal Data, we cannot guarantee its absolute security.
Our Policy on "Do Not Track" Signals under the California Online Protection Act (CalOPPA)
We do not support Do Not Track ("DNT"). Do Not Track is a preference you can set in your web browser to inform websites that you do not want to be tracked.
You can enable or disable Do Not Track by visiting the Preferences or Settings page of your web browser.
Your Data Protection Rights under the General Data Protection Regulation (GDPR)
If you are a resident of the European Economic Area (EEA), you have certain data protection rights. AccountingUsers, Inc. aims to take reasonable steps to allow you to correct, amend, delete or limit the use of your Personal Data.
If you wish to be informed about what Personal Data we hold about you and if you want it to be removed from our systems, please contact us.
In certain circumstances, you have the following data protection rights:
The right to access, update or delete the information we have on you. Whenever made possible, you can access, update or request deletion of your Personal Data directly within your account settings section. If you are unable to perform these actions yourself, please contact us to assist you.
The right of rectification. You have the right to have your information rectified if that information is inaccurate or incomplete.
The right to object. You have the right to object to our processing of your Personal Data.
The right of restriction. You have the right to request that we restrict the processing of your personal information.
The right to data portability. You have the right to be provided with a copy of the information we have on you in a structured, machine-readable and commonly used format.
The right to withdraw consent. You also have the right to withdraw your consent at any time where AccountingUsers, Inc. relied on your consent to process your personal information.
Please note that we may ask you to verify your identity before responding to such requests.
You have the right to complain to a Data Protection Authority about our collection and use of your Personal Data. For more information, please contact your local data protection authority in the European Economic Area (EEA).
We may employ third party companies and individuals to facilitate our Service ("Service Providers"), provide the Service on our behalf, perform Service-related services or assist us in analysing how our Service is used.
These third parties have access to your Personal Data only to perform these tasks on our behalf and are obligated not to disclose or use it for any other purpose.
We may use third-party Service Providers to monitor and analyse the use of our Service.
Google Analytics is a web analytics service offered by Google that tracks and reports website traffic. Google uses the data collected to track and monitor the use of our Service. This data is shared with other Google services. Google may use the collected data to contextualise and personalise the ads of its own advertising network.
We may use third-party Service Providers to show advertisements to you to help support and maintain our Service.
Google AdSense & DoubleClick Cookie
We have no control over and assume no responsibility for the content, privacy policies or practices of any third party sites or services.
Our Service does not address anyone under the age of 18 ("Children").
We do not knowingly collect personally identifiable information from anyone under the age of 18. If you are a parent or guardian and you are aware that your Child has provided us with Personal Data, please contact us. If we become aware that we have collected Personal Data from children without verification of parental consent, we take steps to remove that information from our servers.
By email: firstname.lastname@example.org
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.