And the biggest kahuna of them all: QB Pro 2013, 9GB. File fails verify. That’s right, this is a Pro file! This file had over 30 million transaction links in it — the most we’ve ever seen in any QuickBooks file.
What did the users do? They sent us the files to be supercondensed and/or repaired. Sometimes rebuilding and condensing files within QuickBooks works. When it doesn’t we can (most of the time) repair and supercondense a file even when the built-in tools in QuickBooks fail.
Is your file’s size of concern? How about list size? How does it perform?
We frequently hear from people that they can’t backup their QuickBooks file:
* The verification stage of the backup process fails
* The backup command crashes
* Regular backups can be made, but portable files cannot be created
The problem might be media related, but it’s most often caused by data corruption. Here are the DIY fixes:
* Rebuild your company data (File / Utilities / Rebuild Data) and try again. The Rebuild command can often fix things in the file that prevents a verified backup from being created.
* Try backing up to a local hard drive, instead of to a network server, cloud drive, external drive, or USB drive. All those kinds of drives, besides a local hard drive, could possibly have connectivity or speed issues that would prevent a successful backup being made. Try backing up to your Windows Desktop and see what happens.
Still having problems? Then your data is probably corrupted to the point where the Rebuild command can’t fix it. If that is the case, you have three options:
1. Restore your last good backup and go forward from there. That might or might not require a good bit of data rekeying.
3. Ignore the problem. There are some obvious risks with doing this, but sometimes data can be damaged enough to prevent a verified backup being made, but that otherwise doesn’t cause errors in the operation of QuickBooks. If you choose this option, you can turn off the verification option in the backup command so that you can still make backups. Please note, however, that you are backing up damaged data.
Any other thoughts on this? Any other options or workarounds to consider?
Thinking about migrating from QuickBooks desktop to QuickBooks Online Edition? What if your file is too big?
There is a way around this obstacle, but first, a little background.
It used to be that if your QuickBooks file was bigger than 200MB, it wouldn’t migrate to QuickBooks Online…too big. You’d get an error when you tried to create the QuickBooks Online export file.
Then the limit changed, and it was a limit on the total number of transactions that your file contained.
As of today’s writing, the limiting factor is on how many “targets” exist within your file. A “target” is basically a line of detail within a transaction. If your file has more than 350,000 targets in it, it’s too big to migrate to QuickBooks Online.
You can find out how many targets your file has by opening your company in QuickBooks and pressing the F2 key.
In the screenshot above, the total targets is less than 6,000. This is from a sample set of data, and an actual working set of data — particularly with lots of inventory or jobs transactions — will have a high total targets figure.
So if you have a ton of transaction detail in your file — move than 350K lines — but you want the advantages found in QuickBooks Online Edition, what can you do?
The first thing to try would be the built-in Condense command in QuickBooks. Try it on a copy of your file. If the Condense command is found in your version of QuickBooks, it’ll be in the File / Utilities menu (the command is not in all versions).
Why would you want to run Condense on a copy? Because sometimes the Condense command will freeze and you’ll have to exit QuickBooks abnormally. If that happens, you don’t want it happening on your live data. But when the Condense command works well, it works well, so try it and see what happens.
If the Condense command succeeds, then you can strip out lots of old transaction lines, and possibly bring the file down to the point where you can successfully create the export migration file.
If the Condense command doesn’t work, or doesn’t get enough reduction to make the data migration possible, then you could consider getting your file prepared for migration. This is an external process we provide that can reduce your file’s size (and targets) by 50-80%. We remove all but the last 1-7 years of data (your choice), and create the export file (OE.qbw) that is ready to send into QuickBooks Online.
QuickBooks permissions let you permit — or restrict — your users’ activities in QuickBooks. If you have more than a couple of employees’ who use QuickBooks, you probably take advantage of this feature.
When I posted “How to Restrict User Access in QuickBooks” a few years ago, it elicited scores of questions and comments. My thanks go out to all those commenters. Here’s a summary of those comments and answers:
What is possible to restrict in QuickBooks (partial list):
You can restrict…
Access by module (Sales, Payroll, etc.)
Ability to change or delete existing transactions
Access to especially sensitive information like bank accounts, customer credit cards
Access to financial reports
What is impossible to restrict in QuickBooks (any edition):
You cannot restrict…
Name-based access (e.g. you can’t allow transaction entry or reporting for some customers / jobs / employees / vendors / sales reps, while restricting others)
Changing other users’ entries, but allowing you to change your own entries
Access to only selected reports (as opposed to whole categories of reports)
Access based on payroll group, weekly vs. bi-weekly, for example
Date-based access (e.g. running reports or viewing transactions only data before or after a certain date)
Account-type access (e.g. able to view P&L accounts but not BS accounts)
Viewing of the item list
Access to bank accounts without access to paychecks
Field-level access, e.g. disallowing a sales rep from changing the sales rep field, or disallowing access to inventory cost while retaining access to QOH
Allowing the entry or reconciliation of some bank accounts or credit cards, but not others
Entering a transaction without being able to see the previous entries also
There are many examples of restrictions that are possible in Enterprise edition but not in Pro or Premier editions. Here are a few differences that came out of the comments.
What ispossible to restrict in Enterprise, but impossible to restrict in Pro or Premier:
Preventing the viewing the Employee Center’s list of employees
Allowing access to estimates without also giving access to other sales/receivables functions
Allowing access to payments without also giving access to invoicing
Allowing creation of purchase orders but no other A/P entries
View-only mode for non-financial reports, without also giving the ability to enter transactions (e.g. you can’t keep access to A/R reports without also giving access to A/R transactions)
Which of the “impossibilities” listed above do you think Intuit should definitely address in a future version?
How? You can continue using your product, but any connection between your QuickBooks 2012 product and outside services (e.g. payroll) will stop working. You won’t be able to sign up for tech support, or any services, for your product.
Why? According to Intuit’s website, it’s because they are “committed to developing easy, straightforward financial tools that help you today and grow with you tomorrow. But it’s a balancing act – making QuickBooks better and easier to use while still supporting older versions.”
If you are using a QuickBooks 2012 product now, you can upgrade to a more recent version, and your data should automatically convert up when you first open your company with the newer version.
So is there any more growth potential for QuickBooks? Yes…among the self-employed. There are, Michal Clements says, 15 million self-employed individuals who have a “casual approach” to their books. (Shoeboxes, anyone?) These are folks who are have not yet used technology to address their self-employed bookkeeping needs. How will these entrepreneurs be reached?
Intuit wants to reach them through something called QuickBooks Self-Employed. This version of QuickBooks lets you record expenses and income, manage quarterly estimated payments (it can interface with TurboTax), pull data from your bank account or credit card accounts, write checks, and more. (They are working on billing capabilities now, according to their website.)
So it strikes me as an application that has more than personal finance (like Mint or Quicken) but less than general accounting (like QuickBooks desktop or Online). It is phone and tablet-based. It is licensed as a service, which is very much in line with Intuit’s recurring revenue model strategy. What would be the lifetime customer value of 15 million monthly subscribers? It boggles.
Almost everyone cheers for their home team. But who cheers for unknown strangers on an unknown team?
I was at a high school track meet in the Colorado Springs area. Towards the end of the day, in the 3200m (2 mile) race, all the runners had crossed the finish line except one. There were hundreds of spectators in the stands…and one boy on the track.
He was coming into the stretch a good minute or more behind the next-to-last finisher.
This runner was out of gas, in pain, but he had his game face on and was finishing with the best kick he could muster. He was finishing purely for pride.
As he passed our section of the bleachers, one of our track moms stood up. She started yelling, “Run! Run! Come on, boy in blue!” She started clapping. We all clapped and cheered for the boy in the blue jersey. We didn’t know him, didn’t know his school. But someone saw his courage and perseverance and cheered him on. And then so did a lot of the rest of us.
It’s a good thing to cheer for the home team. It’s also good to cheer for brave strangers.
What if you upgraded your QuickBooks Pro or Premier data file to QuickBooks Enterprise Solutions and now need to revert back?
There’s a way for it to be done. Here’s what real users have said:
“We used the downgrade service from QB Enterprise to Premier. It worked flawlessly. We got our company file back in less than 24-hours and couldn’t be happier. Thanks!” — Jonathan, Fresh Start Vitamin Co.
“This service WAY surpassed my expectations!! I received the converted file less than 12 hours after I submitted it for conversion. WELL worth the money spent. Also made me look like a hero to the nonprofit company we were helping. Thank you so much!!” — Heidi Jennings, Watermark CPA Group, Inc.
“I really appreciate how fast and easy you made the transition from Enterprise to Pro for me. Thank You!” — Peter Garza, Scantech Utility Detection Service, Inc.
The process is simple. You order the service and upload your file to us. We convert it and email you a secure download link to retrieve your converted data. The file you get back from us is ready to use in Pro or Premier. The data will be as if it had been created and used in your version of Pro or Premier from the beginning. You don’t have to rekey, recreate, or export/import anything…it’s a turnkey service.
QuickBooks 2015 collects data about you. It happens by default. It’s an opt-out arrangement, not an opt-in one. What do they want to know about you?
“We collect information about the features our customers use, how they navigate through the product, and other demographic and quantitative data. We also collect information about your license, product, system, or other technical data that help us direct you to the appropriate information or services. We don’t collect data that is identifiable to your employees, customers, or vendors.” (emphasis mine)
Why do they want information about you?
“We will use the data to improve your experience, to enhance our products and services, and to recommend products, services, and promotional offers that we believe will add value to your business.” (emphasis mine)
Oof. I don’t think I want Intuit (the maker of QuickBooks) recommending products, services and (especially) promotional offers to me. Opt-in marketing has been a marketing best practice for a long time (although browser-based marketing doesn’t practice it). Opt-out marketing is better than giving you no choice at all, but it doesn’t build many trust points with me.
So how do you opt out of QuickBooks collecting information and using it to serve up marketing offers to you?
Click Help / QuickBooks Usage & Analytics Study. You’ll see this:
Click the Discontinue button. (Because, until you opt-out, you’re in!)
That’s it. You’ve opted out.
Anyone want to argue for the side of participating in the “Usage & Analytics Study”? I’d like to hear your point of view.
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: email@example.com
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.