Toll-Free: +1-866-453-7060 [email protected]
How to Fix QuickBooks Banking Error 9999?

How to Fix QuickBooks Banking Error 9999?

Over the past few years QuickBooks has become one of the most trusted accounting software in the world. Right from small and medium businesses to accountants to even individuals are using this software as it comes with many perks. Packed with powerful features, this accounting program can handle bookkeeping, payroll, manage sales and finances and also helps with inventory. This software also helps in tracking payments and finances. Even after being the best accounting program, it does have problems. In this article, we are going to share the complete details about QuickBooks banking error 9999, to help you culminate such issue successfully. However, if you are seeking for any sort of professional guidance, you can reach out to our technical support team at +1-866-453-7060, and our certified ProAdvisors will answer all your queries.

See Also: How to Troubleshoot QuickBooks Error 7149?

What is QuickBooks Banking Error 9999?

Many a times, QuickBooks face error and of such common issue that users face is banking Error 9999. Error 9999 is a script error that can block your internet connection of your bank and QuickBooks Online. When this error happens the system hangs, responds slowly or just stops working. This situation can really affect the business operations.

QuickBooks banking error 102 happens when you try to update your bank information. The best thing is that when this issue comes up you can report the error by yourself or seek advice from QuickBooks online support professionals.

You might see the following error messages on your desktop screen:

Error Message: “Sorry, we can’t update your account. Please try updating again later. (9999)”

Or

Error code 9999 – Can’t update

QuickBooks banking error 9999

To Report Regarding the Error 9999, you have following options

All about reporting regarding Banking error 9999.

  • On the banking transaction screen, you have to click on the “Report” Issue which is there on the error.
  • Provide your “Registered name” as well as “Email address” and then click on “Submit“.
  • You will get a response within 10 working days.

Read Also: How to Fix QuickBooks Error 1334?

What causes QuickBooks Banking error code 9999?

There are a bunch of factors that trigger QuickBooks banking error 9999. Let us have a look:

  • The link between the bank and the Server is too slow, as a result of poor internet connection.
  • Or in case there is any antivirus or firewall application hindering the connection between the QuickBooks server and the bank’s website.
  • Excessive browser cache files can trigger such an error.
  • If the windows firewall is blocking the bank website
  • Moreover, some issues with the bank’s end can trigger such an error.
  • QuickBooks files mistakenly deleted can trigger such an error.

Fixing QuickBooks Banking Error 9999

There are a bunch of solutions that you can try to perform one by one to fix the banking error 9999 in QuickBooks. Let us explore each of the methods one by one:

Method 1: Clear Browser’s Cache Files

Clear browsing data - Error code 9999

For Google Chrome

  • You can launch Google Chrome and head to settings tab and click on clear browsing data.
  • Move to cached images and files option
  • Also, click on clear data tab
  • Furthermore, the cache files will be deleted

For Firefox

  • Enter About: preference#privacy in the address bar and click on enter tab
  • Further, select the clear recent history tab
  • Followed by clicking on clear now and select cache from the list

For Internet Explorer

  • Click on ctrl + shift + delete tab
  • You now have to head to the temporary internet files and website files from the delete browsing history page.
  • Furthermore, click on delete tab

Also Read: QuickBooks – Application with Revoked Certificate

Method 2: Use System file checker

You can check your system files with windows system file checker. The command prompt window can be used using the below steps to complete the operation.

Use System file checker - Error code 9999
  • You need to first click on windows key
  • Now, in the search bar and enter command
  • Furthermore, select run as admin by right clicking the command prompt tab
  • Type the following command in the command prompt: SFC/Scannow
  • Click on enter tab.
  • You can restart the computer
  • And later on check if the issue is fixed or not

Method 3: Repair the registry files

Use registry editor - banking error 9999

Windows registry can be extremely essential for running various functions. It is crucial to fix any damaged windows registry files at the earliest. The steps below can help in fixing the registry files successfully:

  • The very first step is to select the start menu
  • After that enter command in the search box.
  • Press ctrl + shift and click on enter tab
  • If asked, click on yes
  • You now have to enter regedit
  • And further click on enter tab.
  • You will then have to right click teh key associated with the issue in teh registry editor
  • Also, proceed to the file menu.
  • Hit the export tab
  • The backup key should now be saved in the folder
  • Choose selected branch in the export range
  • And click on save tab
  • Ascertain that the .reg file extension is used to save the file
  • Make a backup of the registry entry and check if the issue is rectified.

You might also find this helpful: What are the Best Ways to Fix QuickBooks Error QBW32.exe?

Method 4: Update bank account

In case you update the bank account a few times, then the error can be fixed. In order to update the bank, perform the steps below:

running a manual update on your bank account
  • You can launch QuickBooks online and perform the steps below to select banking option
  • Further, select the update tab.
  • And further repeat the same action number of times

Method 5: Disconnect and reconnect the bank account

Disconnect and reconnect bank account
  • Under this process, you need to select the banking tab
  • Click on edit tab next to the account you want to disconnect from
  • Select the disconnect this account option from the account window
  • Further, click on save and close
  • Perform the onscreen steps
  • Also, click on the add account under the bank tab
  • You now have to enter the bank account login information and select continue
  • Click on the bank option after selecting securely connect
  • And further select the account from the account type
  • Select a credit card or bank account
  • The last step is to click on add new and click on connect.

Also Read: How to Troubleshoot the QuickBooks Error Code 6069?

Winding Up!

By following these simple steps if still the issue doesn’t get resolved then worry not seek assistance from the QuickBooks Error Support Helpline Number at +1-866-453-7060. You will get an instant solution as well as some advice on how to avoid such errors in the near future.

 

FAQs related to QuickBooks banking error 9999

How do I fix QuickBooks Error 9999 in online banking?

You can perform the below steps to fix the online banking error 9999″
1. The first step is to click on updates tab and run it three times to see the results
2. Clear cache
3. Disconnect and reconnect the feed
4. When you disconnect the feed there shouldn’t be any transaction listed in the list.

What is QuickBooks error 9999?

Error 9999 is a script error that causes interruption between the connection of your bank and QuickBooks Online (QBO). You can bring in your transactions through WebConnect.

How do I fix a bank error in QuickBooks?

You can sign in to QuickBooks online and head to bookkeeping and choose transactions and further select the bank transactions. Choose the blue blank square for the account you want to update. Go for edit tab in the bank account you want to update.

 

You might be also like

How to Resolve QuickBooks Error 61686?

Fix QuickBooks Banking Errors 103 and 310

QuickBooks Banking Error 102 and its Solutions

How To Fix QuickBooks Error Code 31600? [Solved]

How To Fix QuickBooks Error Code 31600? [Solved]

QuickBooks Error code 31600 is an unexpected internal error that can appear when you try to set up or remove access for the accountant. As a result of this glitch, the software might stop working or might not respond to any inputs. Such errors can further end up in data loss and further technical glitches. Not just that, when you try to create a portable company file or backup a file, you might land into such an error.

QuickBooks Error code 31600
The image as shown above is similar to what appears on your desktop.

Experiencing this issue can be annoying. Thus, if you want to identify the possible triggers and also the quick fixes that you can implement, it is recommended to stick around this piece of writing, or you can also connect with our technical support team at +1-866-453-7060 and we will cater you with instant support and guidance.

You may also like: QuickBooks Desktop 2023 – Pricing, Features and Download

Possible Causes Behind QB Error 31600

QuickBooks error 31600 happens in various situations and they are listed below. Often understanding the reason or situation can help in finding a solution to this error.

  • When creating a portable company file.
  • Taking a backup
  • When you are sending payroll through Direct Deposit.
  • The error also occurs when you are trying to create a company file.
  • Using the Open Company’s facility open
  • Verifying or rebuilding properties
  • When you are saving a transaction.
  • Opening a new window in QuickBooks
  • When you are downloading the payroll updates.
  • A company closing a file.

Read Also: How to Fix QuickBooks Error Code 6150, -1006?

How to Resolve QuickBooks Error code 31600?

Now that you have unleashed the causes of QuickBooks error 31600, it is the right time to perform the necessary steps to eliminate the issue successfully. let us explore each of the method one by one to get rid of the error in QuickBooks.

Solution 1: Press your QuickBooks Desktop

Press desktop when you are starting QuickBooks.

  • Press and hold the ‘Control Key’.
  • Then double click on the ‘QuickBooks icon‘.
  • When you have company open window, hold down the ‘control key

Click on desktop when opening the company file

  • First thing to do is click and select the ‘Desired company file‘ and not make any company open window.
  • Now hold the ‘Alt key‘ on your keyboard.
  • After this click ‘Open‘.
  • Now if you are asked to login in then release the key and enter your ‘login details‘.
  • You shouldn’t ‘Alt key‘ until and unless the file is completely open and now hold down the ‘Alt key‘ and click on ‘OK‘.
  • Once you do this you will get a blank screen on QuickBooks.
  • If you can highlight a ‘QuickBooks menu‘ though your pointer, your QuickBooks file will open.

See Also: How to Fix QuickBooks Error 6190 and 816?

Solution 2: Identify how many users are affected

  • From the company menu select ‘Set up users‘ and ‘Password‘.
  • Now click on ‘Set Up Users‘.
  • For Enterprise users click on ‘Company‘ and then choose ‘Users‘.
  • After this click on ‘Set Up Users and Roles‘.
set up users and roles - Error 31600
  • Once done, click on ‘Add Users‘ and provide the ‘Username and Password‘.
  • Now click on ‘Next‘ option.
  • As required customize the ‘User
  • Now click ‘Finish‘.
  • Once down, with the new ‘Login details‘ login to the company file.

Solution 3: Create a Windows Administrator and fix QuickBooks error code 31600

You can try eliminating the error by creating a windows admin. The steps for creating an admin might differ for different windows versions. To further understand the process, continue reading the steps below:

For Windows 10:
Create new windows admin
  • Firstly click on ‘Start‘ button.
  • Now click on ‘Settings
  • After this select ‘Accounts‘ tab.
  • Click on ‘Family and Other users
  • Under other users you have to select ‘Add‘ someone else in the PC.
  • Once done you have to choose ‘I do not have sign in information for this person‘.
  • Now click on ‘Add a user without Microsoft account‘.
  • After this enter the name of the ‘New Account‘.
  • Click on ‘Finish‘.
  • Now select the newly made account.
  • Click on ‘Account Type
  • Click on ‘Administrator‘ and click on ‘OK‘.
Steps for Windows 8.1
  • To open the Run Window, Press ‘Windows + R‘ keys on your keyboard.
  • Now select the ‘Control Panel‘ and click on ‘OK‘ button.
  • Click on ‘User Account‘ and select ‘Manager another account‘.
  • Now select ‘Other accounts‘ and click on ‘Add an account‘.
  • You need to click on ‘Sign in without a Microsoft Account‘.
  • Choose the ‘Local account‘ and enter the ‘Username, Password and Password prompt
  • Click on ‘Next‘ tab.
  • After this the screen will return to manage other accounts screen.
  • Choose the ‘Account‘ which is newly made and click on ‘Edit
  • Click on drop down option and choose ‘Admin
  • Finally Click ‘OK‘ button.
For Windows 8, 7 and Vista
  • Open ‘Run‘ dialogue box Window by Pressing ‘Windows +R keys‘ on your keyboard.
  • Now click on ‘Control Panel‘ and click on ‘OK‘ button.
  • Now click on ‘User Accounts
  • After this choose the ‘Manage another account‘.
  • Now hit on ‘Create a New Account
  • Now type the name of the ‘New account‘ to be created
  • After this select the ‘Administrator
  • Click on ‘Create Account‘.
  • Done.!

You may also read: How to Fix QuickBooks Error 6129, 0?

Solution 4: Make a New Windows Server

Another possible method is that you can try to create a new server using the steps below and try fixing the error.

  • The first thing to do is open the ‘Server Manager‘.
  • Now click on ‘Tools
  • After this select on ‘Computer Management
Computer management - Error code 31600
  • Increase ‘Local Users and groups
  • Now select the ‘Groups
Change admin properties - QB error 31600
  • Double-click the ‘Administrator group‘ to open the Administrator properties windows.
  • Now Hit on ‘Add‘ option.
  • In the Select User section choose ‘Computers, Group Windows and Service Accounts.’
  • Now type the name of the accounts that you want to add in the local admin groups.
  • Finally Click on ‘OK‘.

Solution 5: Browser Inspection to fix QuickBooks error code 31600

QuickBooks error 31600 can be seen if there is any issue with the browser. You can try performing the steps below and inspect the browser for any configurations. The steps involved here are:

  • Just in case you are using QuickBooks online, make use of the updated version of any of the search engines like Mozilla Firefox, or Google Chrome.
  • Once you have checked the browser version, clear all your search history and remove the cache.
clean history or cache
  • Close the browser and further log in again.
  • Moreover, press ctrl + shift + del together while the browser is open.
  • The history window will open and you now have to choose all the boxes.
  • In case you are using Google Chrome, set the timing to – The beginning of time, or for Firefox, you can choose everything option.
  • This will clear all your history.

See Also: How to Fix QuickBooks Error 6000 77?

Conclusion!

By the end of this segment, we believe that the user might be able to turn down the error code 31600 in QuickBooks successfully. On the contrary, if the user is unable to or comes across a similar error again even after implementing the set of steps enumerated above, then in that case, it is suggested to connect with our QuickBooks Technical help @ +1-866-453-7060. Feel free to reach us and get answers to all your queries immediately.

 

FAQs related to QuickBooks error 31600

How do I fix error code 31600 in QuickBooks?

You can try fixing the error code 31600 using the steps below:
1. Create an admin
2. Create a new server
3. Browser Inspection
4. Check for the affected user

How do I fix QuickBooks files?

You can repair your company file using the rebuild data utility. The steps involved here are:
1. Move to the file menu, hover over utilities and choose rebuild data.
2. Choose ok on the QuickBooks information window
3. After that let the tool repair your file
4. You now have to choose ok tab
5. Go to the file menu
6. And let the tool check your file for data issues

How does a QuickBooks file get corrupted?

A QuickBooks company file can get corrupted due to hardware or software issues, abrupt system shutdown, network connection errors, large file size, virus attack, and much more.

How do I fix a reconciliation error in QuickBooks?

You can try fixing a reconciliation error in QuickBooks by entering the correct amount.
1. Select edit info in the reconciliation window
2. Review the ending balance and ending date
3. You now have to check your bank statement and make edits
4. Choose save once done.

Checkout these articles too

How to fix Error 12xxx when getting QuickBooks Online or Payroll Updates?

How to Fix QuickBooks Error 6000, 301?

Fix QuickBooks Error Code 3140

How to Fix QuickBooks Condense Data Errors (80004005, 80004003)?

How to Fix QuickBooks Condense Data Errors (80004005, 80004003)?

Fix Error Code 80004003, 80004005 – QuickBooks Damaged/Corrupted File Repair and Data Recovery

Troubled by QuickBooks condense data errors and can’t find an ideal way dump them? Well to save you from such a situation, we are here with this piece of writing. You might shockingly bump into condense data errors, when using QuickBooks accounting software and especially when trying to archive the data file. The condense data errors like 80004005, 80004003 in QuickBooks can hinder the smooth working procedure midway and might not let the file be condensed. The condensation process basically indicates the process to reduce the company file size. This feature further helps in reducing the size of the company file to a considerable degree restoring QuickBooks performance. You can land this this issue depicting a bunch of warning messages on screen, which include:

Warning 1- QuickBooks encountered a system error when trying to archive your data file. QuickBooks will not condense your data file. The error is – an unspecified error. Please try the operation again.

Warning 2- QuickBooks encountered an error and was unable to successfully complete the condense process. Your company file has been restored to its original state.

Warning 3- Unable to run QuickBooks Clean up data utility

Warning 4- Not enough storage is available to complete this operation Illegal operation error

You can come across these errors due to damaged company file at the time of attempting to condense the QuickBooks company file. Also, the issue QuickBooks Error 80004005 can be fixed by Intuit data services tools as it can scan and repair company files. The process will eradicate all the damaged files. To help you culminate these errors successfully, we have drafted this piece of writing with the complete details regarding these errors. You can call our QuickBooks Data Repair Support team on +1-866-453-7060 to obtain these QuickBooks errors solve shortly. Having said that, let us delve in deep and unleash further about condense data errors!

Read Also: How to Fix QuickBooks Error 6190 and 816?

What is QuickBooks Error 80004005, 80004003: QuickBooks Condense Data Error?

QuickBooks Error 80004005, 80004003 - Pro Accountant Advisor

You may like: How to Fix Overflow Error in QuickBooks Desktop?

QuickBooks Condense Data Error shows up a different error code, for example, QuickBooks error code 80004005, 80004003. These codes indicate that company file repair in detail is required and keeps users from facing company data loss in condensing utility process or later. The troubleshooting for these errors may also not be the same. If you are performing the troubleshooting steps for QuickBooks error code 80004005, please ensure that you keep a portable backup of your company file.

How to Resolve Error 80004005 and 80004003 – QuickBooks Condense Data Errors?

What makes QuickBooks an ideal software even after being prone to certain errors is the fact that the users can implement some set of steps to rectify the errors successfully. And the same theory applies in case of condense data errors. Let us explore each of the methods that can be implemented to culminate the condense data error in QuickBooks.

Technique 1: Use Rebuild Data Tool

  1. First of all, ‘Reboot database server‘ or your computer system.
  2. Wait for your computer to shut down completely.
  3. Check and ‘Rebuild your QuickBooks company file‘ through utility tools.
  4. In case the step mentioned step doesn’t work, check if ‘QuickBooks is configured appropriately‘ and if the PC that hosts the data file is working properly

Verify and Rebuild to fix QuickBooks Condense Data Error 80004005

Tips to verify and rebuild to repair QuickBooks Condense Data Error 80004005

Verify and Rebuild Data in QuickBooks Desktop - Screenshot
  1. Firstly, Login to your QuickBooks and run it as a ‘System Administrator
  2. Go to your ‘Company file
  3. Choose ‘Utilities
  4. Select the prompt that will allow you to back up your file.
  5. Select ‘Verify‘ to check if the company file is hosted right.
  6. Allow it to rebuild and fix the errors

See Also: How to Fix QuickBooks Error Code 6150, -1006?

Technique 2: Clean Install QuickBooks Software

At times, a mere reinstallation of QuickBooks can rectify the issue to a certain extent, and clean installation is a more advanced version of the same. You can try performing the below procedure to clean install QuickBooks.

Step 1: Remove QuickBooks

  • You can try opening the windows start menu at first.
  • Eventually, search for the control panel.
  • Choose the programs and features tab or uninstall a program.
  • You would then have to select the version of QuickBooks desktop you want to remove.
  • Go for the option to uninstall/change, remove.
Uninstall and reinstall the QuickBooks file or program
  • Furthermore, select the next tab.
  • In case you are able to spot this option, try to sign out and sign in back to windows as admin.

Step 2: Install QuickBooks Desktop Again

Once you are done, install QuickBooks desktop, and when you install again, QuickBooks will automatically install new folders and rename the old ones.

Technique 3: Change the name of QBWIN.LOG file

In case you are facing an issue when condensing the file, try to rename the file. You simply need to add old in the file extension and then condense the company file.

Rename QBWin file - QuickBooks condense data errors
  • Start off by opening the QuickBooks folder in the Drive C.
  • Furthermore, you need to right click the QBWIN.LOG file.
  • Heading forward, choose Rename tab.
  • And then, add .old at the end of the file name.

After renaming the file, try to launch QuickBooks program and try condensing the company files.

Also Read: How to Resolve QuickBooks Desktop Error C=387?

Steps to Fix QuickBooks Condense Data Errors

Other than the above discussed procedures, you can try performing the below shared methods to eliminate the condense data errors in QuickBooks.

Method 1: Run QuickBooks File Doctor Tool

As the name suggests, QuickBooks file doctor tool is designed to eliminate all sorts of file related issues in QuickBooks. You can try performing the below set of steps to run the file doctor tool.

Run QuickBooks file doctor - Condense Data Errors

Step 1: Download and Install QuickBooks Tool Hub

  • You need to first close QuickBooks
  • Furthermore, download the latest version of QuickBooks Tool hub.
  • Save the file where it can be accessed easily.
  • Open the file you downloaded i.e., QuickBooksToolHub.exe.
  • Later on, perform the onscreen steps to complete the installation process.
  • In case you are unable to spot the icon, do a search in windows for QuickBooks tool hub and then choose the program.

Step 2: Run QuickBooks File Doctor Tool

QuickBooks file doctor - Condense data error 80004003
  • After opening the QuickBooks tool hub, head to the company file issues tab.
  • You would then have to choose run QuickBooks file doctor option.
  • This might take around a couple of minutes to open.
  • If QuickBooks file doctor doesn’t open, then look for the QuickBooks desktop file doctor manually and try opening it.
  • Choose the company file from the drop-down menu.
  • And further, if you do not see your file, then choose browse and search to identify and spot the file.
  • You now have to choose check your file and hit the continue tab.
  • Later on, enter the QuickBooks admin password and select next.
  • The scan time usually depends on the size of your file and might take around 10-15 minutes.

Also Check This Out – How to Fix QuickBooks Desktop Installation Errors?

Method 2: Fix Negative Entries in QuickBooks Company file

  • To start off with, explore QuickBooks Installation, and further open the qbwin.log file.
  • You will then have to scroll down to the bottom of the file and search for the error and type the error in the text.
  • Heading forward, the text in the file will show the transaction and entries that are having a negative value or any other type of issue.
  • You will then have to note the invoice number and look for the same in the company file.
  • Perform the necessary changes to the value of the transaction or the entry and save the file.
  • Towards the end, you need to try condensing the company file again and check if the issue is rectified or not.

Method 3: Start Windows in Safe Mode

Entering safe mode helps in eliminating various errors hindering the smooth working process. In order to enable the safe mode on windows, perform the following instructions:

Safe mode - Condense data error 80004005
  • Simply begin by pressing shift key and then restarting the system.
  • You will find the Advanced Boot options there on the startup screen.
  • Make sure to choose the troubleshoot option.
  • And further click on the advanced options. This will provide you with some advanced options, one of which is the startup settings.
  • There you need to click on the Restart tab.
  • When Windows starts, you will see the active boot options list.
  • You need to press F4 key to enable safe mode.
  • After you enter the safe mode, the system will itself prevent the third-party application from performing, ultimately preventing the errors.

Read also: How to Fix QuickBooks Update Error 1603?

Conclusion

If the Error 80004005, 80004003 persists or any new error code shows up you can contact our round the clock QuickBooks error support number at +1-866-453-7060. We are a team of highly trained and experienced QuickBooks experts and can help you fix any QuickBooks related issue in the least possible time.

FAQs

What happens when you condense data in QuickBooks?

When you condense the data file in QuickBooks, it reduces the size of the company file. It further converts individual point data for each calendar month into a single summarized entry. Condensing data conserves disk space. Not just that, it removes data points from the Single Test Point Data Entry dialog box and adds them to the Single Test Summary Data Entry dialog box.

How do I delete a transaction from QuickBooks condense data?

For this, you simply need to:
1. Click on the File menu.
2. After that, choose Utilities.
3. Now, select Condense Data.
4. Go for, Remove the transactions you select from your company file and click on Next.
5. Choose what transactions do you want to remove and click on Next.
6. Opt for how transactions should be summarized.

Can I undo the QuickBooks Condense data process if I encounter errors?

No, the condense data process cannot be undone. Thus, it is suggested to keep a backup of the company file before condensing the file.

 

Read More Helpful Topics

Backup or Restore Files in QuickBooks Software

How to Recover Deleted QuickBooks Data Files?

Recover Lost QuickBooks Data from a Hard Drive

QuickBooks Condense Data Utility: Repair your Data Files

QuickBooks Condense Data Utility: Repair your Data Files

QuickBooks Condense Data Utility often assists in streamlining the company data file and enhancing performance. Intuit, lets the QuickBooks users to make use of the condense data utility feature and reduce the size of the company file to make it more compatible and easy to use. To use this utility, you simply need to use the QuickBooks condense data tool. This tool comes in handy, when the file size is way too large and causing issues. This particular tool was introduced in the year 2019. The tool keeps the data intact and ensures that your overall file size is usable.

QuickBooks Condense data utility

To help you understand QuickBooks condense data utility better, we have drafted this segment right here. Thus, stick around this article and find out the quick ways that can help you condense your data using the tool. However, if you need any technical guidance, you can contact our team at +1-866-453-7060, and let our certified professionals help you fix the issue.

Read Also: How to Fix data damage on your QuickBooks desktop company file?

Condense Your Data using QuickBooks Condese Data Utility

Now that you have an idea about what QuickBooks Condense Data Utility is, it is time to understand the right steps that can be performed to condense your data. Let us have a look:

Condense QuickBooks Data While Keeping All Transactions

  • Here you simply have to opt for File and then go for Utilities
  • Now, choose Condense Data
  • After that, go for Keep all transactions, but remove audit trail info to date
  • The next step is to click on Next
  • Once done with that, choose Close.

Condense QuickBooks Data by Removing Selected Transactions

  • Under this procedure, you will have to opt for File tab.
  • Later on, choose Utilities
  • Once done with that, go for Keep all transactions, but remove audit trail info to date.
  • The next step is to choose Next.
  • Lastly, let the process complete, and choose Close.

Condense Data by Removing Selected Transactions

  • The very first step is to choose File and then go for Utilities
  • After that, choose Condense Data
  • You now have to choose Remove the transactions you select from your company file.
  • Now, select Next tab
  • The next step is to choose the transactions you would like to remove and then hit Next.
  • Choose how transactions would be summarized, and then click on Next
  • Select how inventory should be condensed, and click on the Next tab
  • After that, choose the recommended transactions you would like to remove and then hit the Next tab
  • You now have to go for the list entries you would like to remove and click on the next tab
  • The last step is to choose begin condense and wait for the process to complete.
  • Hit close and end the process.

You might also find this helpful: How to Fix Error: This is a Corrupt or Damaged QuickBooks Database?

Understand QuickBooks Condense Data Utility Better!

There are a few factors that you can know to understand the QuickBooks Condense Data Utility in a better way. Let us Explore:

QB Condense Data Repair isn’t Reversible

After you condense your company file, note that it can’t be undone. You can try other solutions first, before you perform the steps related to condensing the data. Here are some quick reasons to do so:

  • Having a large data file
  • You have close to a list limit
  • In case you have upgraded your hardware
  • Your Accountant and technical support have discussed other options and are willing to proceed with condensing

Condense Data Utility in QuickBooks may or may not affect the size of the company file

  • It might reduce the size as it’ll remove transaction details and list entries.
  • Furthermore, open transactions won’t get condensed and the file size won’t be affected
  • The condense won’t be available, in case there is no significant change to the file size.

Condense Data Repair might not fix Data file damage

There can be scenarios, when QuickBooks condense data repair might fail in fixing damaged files, in such scenarios, you need to try the following:

QuickBooks Condense Data Repair doesn’t remove certain transactions

Transactions Description/Reason
Payroll TransactionsIn case the condense date is before 12/31/2018 or if an employee’s W2 isn’t reviewed.
Invoices, payments, credit memos, and refund checksIn case they are not linked to each other in a proper manner.
Payments recorded to Undeposited FundsIf they haven’t been deposited to a bank account.
Bills, bill credits, and bill payment checksIn case they are not linked to each other in a proper manner.
Estimates linked to invoicesEstimates are non-posting entries and can’t be condensed into journal entries, which are posting transactions.
Sales tax not paid in Pay Sales TaxPaying sales tax with checks leaves invoices open which are non-condensable.
Transactions linked to a non-condensable transactionExample: You entered an invoice on 12/15/2015 and the corresponding payment on 1/15/2016, then ran the Condense Data utility through 12/31/2015. Both won’t be condensed. This is because the invoice is linked to a payment made outside the period.

Also Read: How To Set Up a Chart of Accounts in QuickBooks?

Condense Data Utility Affects Various Reports

Account and item-based reports

The account-based reports will be accurate due to entries on accounts aren’t affected:

  • Profit and Loss (accrual)
  • Balance Sheet (accrual)
  • Statement of Cash Flows (accrual)
  • Trial Balance (accrual)

The item-based reports will be blank due to all of the item data is gone.

  • Sales and Purchase reports
  • Job Costing reports
  • Accounts Receivable and Accounts Payable Aging report

Cash Basis Reports

Cash basis reports for the condensed period will not be accurate. There aren’t any links from cash into income or from cash out to expenses.

Reports filtered by Class

Note that, any transactions summarized by the utility won’t have classes assigned. When you run a profit or loss by class report will show amounts in the unclassified column.

Sales Tax Liability Reports

It is important to note that the invoices with sales tax no longer exist. A condensed journal entry basically has an amount credited to income accounts. QuickBooks will not be able to identify what part of the income is taxable and which part is nontaxable. Moreover, the tax collected comes from the invoices, which no longer exist, so it will show zero.

Read Also: How to Turn off Sales Tax in QuickBooks Online 

Sales and Purchase Detail Reports

The reports draw their data from items on invoices and bills. As there are no more invoices and bills, there will be no more items and the reports will be empty.

A/R Collections Reports

The A/R collection report will usually show the condensed journal entries under No Name. The entries will contain the entries to A/R that aren’t linked to closing transactions and are considered as open. The total is zero as all of the invoices in the file are paid.

A/R reports won’t show the condensed journal entries as they have a default filter of Names All Customer: Jobs. You need to remove this filter and the A/R aging reports that will show the condensed journal entries.

Audit Trail Reports

  • Only edited, voided, and deleted transactions are removed from the audit trail report when condensing.
  • Moreover, the condense data doesn’t remove the audit trail report.
  • The audit trail report info option will be available in case a company file has a significant amount of edited, voided, or deleted transactions.

Reconciliation

  • Note that the opening balance for your next reconciliation will be correct as the condensed journal entries are cleared transactions
  • The checks and deposits no longer exist, so the reconciliation reports might be incorrect or gone.
  • The statement date gets incorrect as the last reconciliation ismissing.

Note: Before you condense, and reconcile all accounts, print all reconciliation and discrepancy reports, or save these reports in PDF format. Also, backup the company file.

Also Read: How to Create, Edit, or Delete QuickBooks Memorized Transaction?

Conclusion!

Toward the end of this segment, we believe that the reader might be able to successfully condense QuickBooks data file using the condense data utility. However, in case of any queries, or if the user needs our technical assistance at any point in time, then in that case contact us at +1-866-453-7060, and our certified ProAdvisors will help you with your queries immediately.

 

Read More Helpful Article Here:

How to fix QuickBooks Error 3371 Status code 11118?

How To Fix QuickBooks Error code 5502?

Steps to Fix QuickBooks Error 1334

How to Fix QuickBooks Payroll Error 30159?

How to Fix QuickBooks Payroll Error 30159?

QuickBooks error code 30159 is basically a payroll error that you can come across when trying to upgrade the payroll. Errors in QuickBooks can be extremely annoying, and dealing with issues immediately is crucial to avoid any further nuisance. Talking about QuickBooks error 30159, it usually appears on the screen with a warning message that states: QuickBooks has encountered a problem and needs to close.

QuickBooks Payroll Error Code 30159

Payroll errors in QuickBooks aren’t very common. However, you can experience such issues when trying to add an existing payroll subscription to your QuickBooks payroll account. Such an error can be further triggered due to misconfigured system files in Windows.

Furthermore, when running Windows-compatible programs, there is the probability of coming across this issue in QuickBooks. To further learn about this issue, make sure to read this piece of writing till the end. You can also get in touch with our technical support team at  +1-866-453-7060, for any further QuickBooks-related assistance.

What is QuickBooks Error 30159?

QuickBooks error 30159 usually shows up with a warning message: QuickBooks has encountered a problem and needs to close. We are sorry for the inconvenience. This error can further show up due to a variety of reasons as your QuickBooks subscription has ended, or the payroll subscription has expired. To fix this issue, you would have to check if the payroll subscription is active or not. You can further use the QuickBooks tool hub to diagnose the reason. Moreover, if the subscription has ended then you would have to buy the subscription again and this error will be resolved.

Read Also: How to Change Registered Email Address in QuickBooks?

Possible Causes/Reasons of Error Code 30159

The QuickBooks error 30159 can cause damage to the data of the company so it needs to be fixed. The main symptoms of this error are it crashes the program error, the PC often crashes while working on it or the system runs very slowly. Payroll update error 30159 occurs due to several reasons and they are listed below.

  • Incomplete installation of QuickBooks software.
  • Corrupted Windows system files due to virus infection.
  • Any program related to QuickBooks has been deleted mistakenly.
  • QB company file is corrupted or damaged.

Signs and Symptoms of QuickBooks Error 30159

  • The very first sign and symptom of this error can be when it appears and crashes the active program.
  • Also, if the system frequently crashes with this error, when running the same program.
  • Error message 30159” gets displayed on the computer screen again and again.
  • The system performs slowly or sluggishly.

You may also read: How to Fix QuickBooks Error Code 80070057?

Methods to Fix QuickBooks Payroll Error Code 30159

Perform the below-given solution methods in order to resolve the QuickBooks error code 30159 manually.

Method 1: Restore your system to an earlier point

  • Start your computer system and login as “System Administrator
  • Hit a click on “Start” button, on your keyboard
  • After that go to the “All Programs” and click on “Restore” option.
  • After this open a new window and select “Restore My Computer” and click on “Next” button.
Restore the Windows System -
  • Choose the most recent system restore point and again click on “Next” button.
  • Once done click on the “Confirmation Window“.
  • The next step is to restart the system once.
  • Once the system rebooted successfully, you need to download and install the “QuickBooks File Repair Tool“.
  • Click on the “Scan” button, after installing the QuickBooks file repair tool.
  • Hit a single click on “Fix Error” button after the scanning is finished.
  • Once the “Success” screen prompts, you need to restart your computer system again.

Method 2: Install the Windows Updates

  • Firstly, hit on “Start” key, on your keyboard
  • After that type “Update” in the search box and then hit on the “Enter” key.
  • The system will check for the updates (if there any)
Update the Windows 10 (Check for updates)
  • If you found any updates there just try to install all of them.
  • Once the process completes, reboot your computer.

Read Also: Set-up a contract to ensure your Invoices to get paid – on time

Method 3: Use Windows File Checker

  • Login as the “System Administrator” on your computer.
  • Hit on the “Windows” or “Start” button, on your keyboard.
  • After that Press “Windows + R keys together to open the run box.
  • Type “cmd” and then hit “Enter” key, on your keyboard.
  • A black screen will open on your desktop screen.
  • Type “sfc/scannow” and then hit on the “Enter” key.
Use Windows File Checker
  • This process will take few seconds to complete.
  • Once the process is done, follow the screen instructions on your desktop screen to restore the corruptions problem of system files.

Method 4: Adding EIN to your company file

Adding EIN to your company file - Screenshot
  • First of all Login to your QuickBooks as “System Admin“.
  • After that hit a click on “Choose Payroll” option.
  • Now, the users needs to click on “Use my Existing Payrolls Service“.
  • A newly window named “Account Maintenance” appears on your desktop screen.
  • After that hit a click on “Add file” option.
  • Check on the radio button that is labeled as “Add EIN Number“.

Note: It should be noted that in case the radio button is disabled, then it means that the user has already subscribed to “EIN Number” for your company.

  • After that click on the “Next” button.
  • Check out the information and open your QuickBooks.

Method 5: Edit and Re-enter your payroll service key

  • You need to first proceed to the employees menu.
  • Further, opt for the My payroll service option.
My payroll service option - QuickBooks error code 30159
  • You now have to click on the manage service key and also click on account/billing information.
  • The next step is to find and choose your payroll service key and opt for the remove tab.
  • Once done with that, click on the add tab.
  • And also enter your active payroll service key.
  • Hit the finish tab and click on OK to end the process.

Method 6: Perform QuickBooks error scanning

  • You need to first download the QuickBooks payroll error utility.
  • Further, follow it up by installing the program.
  • You now have to click on the scan and start tab with the scanning process.
Scan the system malware - Quickbooks payroll error 30159
  • After that, select QB-related issues after the scanning process ends.
  • Towards the end, reboot your system.

Method 7: Perform disk cleanup in Windows

  • Under this process, you need to wipe off the temporary files by clicking on the start tab.
  • Once done with that, click on the enter tab.
Disk cleanup for QuickBooks
  • Choose the drive that you want to free up.
  • Also, click on the OK tab.
  • The next step is to select and remove all unwanted files and further click on the ok tab.
  • Now, select clean up system files in disk cleanup.
disk cleanup - QuickBooks error 30159
  • Select the file types and click on the ok tab.
  • This would remove all unimportant files from the system and further create the required space.
Cleanup drive windows

See also: How to Fix screen issues in QuickBooks Desktop?

QuickBooks error code 30159 is not complicated and can be easily fixed. I hope you have successfully troubleshooted this error from your QuickBooks. If the problem persists, then we recommend you to seek assistance from our QuickBooks online support team by dialing  +1-866-453-7060, and getting quick help from the experts. Our certified ProAdvisor’s are capable to handle your all type of issues related to QuickBooks.

 

Few other helpful resources:

Fix QuickBooks error code 1601, 1603 and 1642

How to Resolve QuickBooks Error 12152?

Troubleshooting QuickBooks error code C=343

 

Some Quick FAQs relating to QuickBooks Error 30159

What is QuickBooks Error 30159, and what causes it?

QuickBooks Error 30159 is a common error that occurs when the user tries to update or install QuickBooks software. It is usually occurs due to incorrect or incomplete installation, virus or malware attacks, corrupt system files, or registry errors. Other reasons for the error can be an outdated version of Windows or QuickBooks software, an incomplete installation of QuickBooks Payroll, or problems with the .NET Framework.

How can I fix QuickBooks Error 30159?

There are several methods you can use to fix QuickBooks Error 30159. Some of these methods include:
1. Run the QuickBooks Payroll update tool to fix the error.
2. Update your Windows and QuickBooks software to the latest version.
3. Verify your payroll subscription and make sure it’s active.
4. Perform a clean installation of QuickBooks software.
5. Use the QuickBooks file doctor tool to repair any damaged files.

How can I prevent QuickBooks Error 30159 from occurring?

To prevent QuickBooks Error 30159 from occurring, you can take the following steps:
1. Make sure your QuickBooks and Windows software is always up-to-date.
2. Regularly run antivirus and malware scans to protect your system from virus attacks.
3. Ensure that you have a stable and reliable internet connection when updating or installing QuickBooks software.
4. Avoid installing multiple versions of QuickBooks software on the same computer.
5. Always create a backup of your QuickBooks data to prevent data loss.