A Quick Guide to learn to enter opening balances for accounts in QuickBooks
When creating a new account in QuickBooks, the user is suggested to pick a day to start tracking all of the transactions. The user should enter the balance of the real-life bank account for the day that has been selected. This will let QuickBooks match the bank records form the start. The starting point here is the account’s opening balance. This summarizes all the past transactions that came before it. To learn the process to enter opening balance in QuickBooks, make sure that you read this article carefully till the end. Or you can also ask our QuickBooks support team professionals using our support number 1-800-615-2347, and they will come up with the most effective steps for you.
Steps to enter opening balance for accounts in QuickBooks
The below steps can be of some help in entering opening balance for accounts in QuickBooks. Let us check the steps out one by one:
Step 1: Enter an opening balance
The steps for the type of account the opening balance is for are listed below:
Bank or credit card accounts
Before creating a new account on QuickBooks chart of accounts, ensure to know what to enter for opening balance. The user can enter an opening balance for a real-life bank account you just created, or one that is already present.
At first, the user needs to get the bank statements or sign in to the bank’s website
And then, in QuickBooks move to the company menu and then choose chart of accounts
Right click anywhere on the chart of accounts and choose new
The next step is to select bank or credit card for the account type and also choose continue tab
The user needs to give account a name. in case the user is having multiple accounts of the same type or at the same bank and give them unique names so that they are easy to tell apart
After that fill out the rest of the data fields
And also, choose enter opening balance. In case the user requires to edit the opening balance, the button will be change opening balance
Once done with that, the user should choose save and close to record the opening balance
The user can enter an opening balance for a real life bank account that is created above. The user should also be careful entering the opening balances for accounts on your balance sheet. This includes fixed asset, equity, long-term liability, other assets, other current assets, and other current liability accounts. In case the user is unsure or have any queries, then it is suggested to reach out to the accountant. In case the user isn’t having an accountant, he/she can look for one.
The user can get the bank statements or sign in to the bank’s website initially
After that, move to the company menu in QuickBooks and then choose chart of accounts
The next step is to right click on chart of accounts and choose new
Choose fixed asset, loan, or equity. For other types of accounts, choose the other account types drop down and one of the types
Also, choose continue tab
Assign the account a name
Enter rest of the details
And also select enter opening balance
After that choose save and close tab to record the opening balance
Income and expense accounts
The user need not to enter opening balances for income or expense accounts. These accounts simply track the earnings and spending.
Step 2: Check the opening balance entry
After entering the opening balance, move to the account register and ensure it is appropriate.
Here, the user needs to move to the lists menu and choose chart of accounts
Look for and open the opening balance equity account
Also, check the account balance
In case the balance isn’t 0.00, then need not to worry. The user simply needs to write down the remaining balance. Then run a balance sheet report for last year.
The user needs to move to the reports and hover over company and financial
And choose balance sheet standard
The next step is to select last fiscal year form the dates dropdown
Check the retained earnings balance
Compare last year’s retained earnings balance with the remaining balance in the opening balance equity account
Entering opening balances for accounts in QuickBooks can be a little easy, once the above stated steps are performed properly. However, if there is any query or if for some reason the user isn’t able to perform the required steps, then in that case give us a call at 1-800-615-2347, and we will be there to come up with the best possible assistance immediately.
Rebuilding of the company files refers to the process of resolving any data related errors or corruption in the company files. These company file errors could be triggered due to various reasons that encompass data corruption, network related issues, any damaged .ND and .TLG files, etc. In this context, Verifying and Rebuilding the company file in QuickBooks is a one-stop solution. QB users should go for the rebuilding of their company files after frequent intervals, generally after 1 to 3 months.
Pertinently, this task can be achieved by the use of the Verify and Rebuild Data utility. While the Verify data tool checks for the data issues in the file, the Rebuild data tool fixes the issues. You need to follow this entire article to know the procedure for verify and rebuild your QuickBooks company file. Thus, keep read on!
Why Rebuild QuickBooks Company files?
It is a judicious decision to rebuild your QuickBooks company files quite often considering the serious ramifications of the data integrity issues. This process is necessitated due to the following:
Resolution to data integrity problems confronting the company file.
Fixing freezing and crashing of the computer while opening the company files
Rectification of the backup issues related to the company files
Rooting out any ancillary causes that prevent access to the company file.
Steps to Verify and Rebuild Company file in QuickBooks
The Rebuild process can be done by using the Verify and Rebuild Data tool. This comes in as an in-built utility in QuickBooks, and is thus reliable and free from technical issues. It is recommended to first verify the company file for issues, and when the issue is detected, the next process involves the use of the Rebuild data tool. The procedure to use the tool is enumerated below.
Step 1: Verify the Company data (Verify data tool)
The first initiative to be taken by the user is to run QuickBooks with admin privileges (by right-clicking the QB icon and choosing Run as Administrator).
Thereafter, make advancement to the File menu.
Then, head for Utilities.
Next step involves choosing the Verify Data option.
Upon the completion of the Verification process, if QuickBooks does not detect any data-related problems, it indicates that there is no need to rebuild the company file.
However, if it detects any data integrity issues, then the next step of Rebuilding the file should be followed.
In such cases, usually, the following error message shows up “Your data has lost integrity—Data damage was found in the file.” Rebuild your data to fix it.”
Step 2: Rebuild Company file (Rebuild data tool)
Similar to the steps to use the Verify tool, the user should first head to the File tab.
Then, head to the Utilities option.
Within Utilities, make a choice for Rebuild Data option.
Before beginning the rebuild process, the user shall be prompted for the creation of the backup. At this stage, choose Ok.
Now, choose some suitable location for saving the company file backup, and follow by hitting on Ok.
Make a choice for the file name of the backup file and save it to the earmarked location on the PC.
Then, the Rebuild process will start and upon its completion, the user should click on Ok on the message which states that the Rebuild has completed.
Step 3: Again Verify the Company file
The next step is to verify the company file again for any technical error. For this, perform the below-given steps:
Move to the File tab, and then go to Utilities.
Choose the Verify Data option and allow the tool to scan the company file for any further issues. Basically, this step is a double-verification of the efficacy of the Rebuild data tool to make sure that the issues existing previously got resolved.
In mere instances, when the Verify data tool still diagnoses any company data issues, these should be manually fixed.
For this, the user should open the qbwin.log in the QuickBooks folder, and then search for the sources of the error in this log file. These can later be fixed either manually, or by using other tools like the QuickBooks File Doctor, Quick Fix My Program, etc.
Manual Method to Fix Company file issue (Rename .ND and .TLG files)
If the user is still marred by data integrity issues, or company file corruptions, he/she should rename the .TLG and .ND files in the QuickBooks folder. The steps for the same are:
Start by hitting a right-click on the QB Desktop icon and then choose Properties.
The next step involves choosing Open File Location tab. This will straightaway take the user to the QuickBooks folder.
Within this folder, look for the files with the same name as the company files, but having the .ND and .TLG extensions.
Upon locating the files, right-click them individually and choose the Rename option.
Now, append “.old” towards the end of the file name.
Follow the steps for both the ND and the TLG files.
Now, run QuickBooks and try opening the company file from the File menu.
In the above provided discussion, we have familiarized users about the steps to verify and rebuild process and it’s importance. It is recommended you should often rebuild your company files as it safeguards the file from any crucial data integrity issues. However, if you have any query, or you’re facing any kind of issues while verifying and rebuilding your QuickBooks desktop company files, then feel free to reach out to our QuickBooks desktop support team via a call at 1-800-615-2347. We will be happy to assist you!
QuickBooks users have been experiencing a missing employee issue in QuickBooks Desktop Payroll. This issue prevents users from using the payroll. This issue is often experienced when the employee has been set to an inactive state or if the employee is not linked to the correct payroll schedule. Nonetheless, there are multiple fixes for this issue and by the end of this blog, users shall master all the troubleshooting steps to fix a missing employee in QuickBooks Desktop Payroll.
What are the principal causes that may incite a missing employee in QuickBooks Desktop Payroll?
Some of the main causes behind this issue are:
Employee is inactive.
An Employee hasn’t been added to the payroll.
Employee has a specific release date.
Employee is not linked to the correct payroll schedule.
The current article contained the different cases and solutions to fix a missing employee in QuickBooks Desktop Payroll. The steps should be clearly discernible to users. However, if you come across any hurdles while performing the troubleshooting steps, just reach out to our QuickBooks desktop error support team of QuickBooks experts at the helpline i.e. 1-800-615-2347.
QuickBooks users have the leverage to import their customer list in QuickBooks Pro. The procedure for the same is pretty simple and requires users to adhere to a few simple steps. Notably, QuickBooks users cannot proceed with the invoicing unless they have the customer contacts added to their invoice. In this context, users can add contacts individually. However, if the user has an existing file that carries full contact information of customers, the importing process will be easier. This article shall guide you towards importing your customer list into QuickBooks Pro. So, stick around till the end.
Procedure to Import your Customer List in QuickBooks Pro
To initiate the process of import your customer list, start off by heading to the Customers option.
After that, head to the Customer Center.
From there, choose Excel and click on the option to Import from Excel.
Step 1: Choose the Customers
Users should be able to see a prompt on the screen stating “if you are importing the Customers, Vendors, or Products I sell.
Herein, pick the Customers option.
In case, user’s Excel file has already been formatted like the Customer Import template of QuickBooks Pro, he/she should skip the step and instead click on the Advanced Import option. The option should be accessible on the right side of the screen. Click on it to finish the importing of customers.
In case, the user is importing the customer list for the first time, he/she will see a popup box message stating that the imported information cannot be undone.
Herein, hit on Yes in order to continue with the process of importing the customer list.
Step 2: Copy paste the Customer data
The next step requires users to copy the customer list data from the existing Excel file.
Subsequently, users are required to paste the customer list data into the QuickBooks Excel template file.
Once the user hovers over any specific cell, QuickBooks Pro will give the details about the type of information that needs to be incorporated in that particular cell.
Users should be able to find the example of the process to format cells located above the column headings.
The below –mentioned customer information can be saved:
Step 3: Rectify any issues
Before finalizing the process of importing your customer list on QuickBooks Pro, it is pertinent to ensure that the file is devoid of any errors.
In case of any major issue, QuickBooks Pro will show up a warning message in the error box located on the top left side of the file.
Also, a red warning triangle will show up in the cell that is facing the issue.
QuickBooks Pro will guide you through the process of easy rectification of the error.
Upon ensuring that all the data pertaining to the customer list is correct and devoid of any issues, users need to hit on the Add My Data Now option.
Step 5: Saving the Changes
This step requires the users to save the changes made to the QuickBooks Excel template.
For that, hit on the option to Save and Add My Data Now.
Make sure not to pick the option “I will add my data later”. By choosing this option, users will lose their data and all the changes made to the Template file.
Choose the location to save the file and then save the file on the system.
Step 6: Opt for the File
Upon saving the file, the file shall automatically appear in the box.
If it doesn’t show up, just click on Browse, and then choose the file.
Step 7: Importing the Customer List File
Pick the option labeled Add My Data Now in blue color.
This action will successfully import the customer file list.
Users can view the customer list any time upon importing the list.
For viewing the customer list file, users can visit the Customer Center option.
That culminates the importing process of the customer list in QuickBooks Pro.
Once you have completed these steps, QuickBooks Pro should have imported your customer list successfully. You can double-check that the customers have been imported by going back to the “Customer Center” and verifying that the new customers are listed.
Our experts hope that the step-by-step procedure enumerated in this blog should help you in Importing your customer list in QuickBooks Pro. If you feel need of technical support, you can reach out to our QuickBooks desktop support experts without any hesitation by calling at the 24/7 helpline number i.e., 1-800-615-2347.
SDI is an abbreviation for State Disability Insurance, which is a tax paid by the employee. It is paid by employees and assists them in case of an accident while working. The SDI rates vary across different states. Notably, only a few states offer State Disability Insurance contributions. If you are seeking the procedure on how to change SDI rate in the different QuickBooks products rolled out by Intuit, this article will be of immense assistance to you.
More about State Disability Insurance
State Disability Insurance (SDI) rates vary according to the state of residence. The states in which SDI contributions exist include New York, Rhode Island, California, Hawaii, and New Jersey. It is pertinent to note that SDI rates do not get adjusted automatically, but rather, need to be manually adjusted.
This article briefed users with the easy procedure to change SDI rate in the different versions of QuickBooks. If users come across further issues pertaining to SDI adjustment or any other QuickBooks issue, they may call our QuickBooks desktop support advisors by ringing a call at 1-800-615-2347.
QuickBooks Desktop is exemplary and unmatched accounting software that has attested to its usefulness by delivering innumerable accounting services to small and medium-sized businesses. However, what cannot be overlooked is the spate of ever-evolving and recurring technical snags encountered while working with the QuickBooks software. One such error in QuickBooks shows up when the Internet Explorer is required when it is already installed on your system, which usually requires you to upgrade the Internet Explorer browser.
Such error can be extremely annoying, leading to unwelcome delays in the submission of work and forcing you to wander on the net in search of troubleshooting avenues to fix the same. However, we are here to assist you in the most convenient way. This blog shall make sure that this error gets resolved in the next couple of minutes. Make sure to read it carefully till the very end.
If you feel that the contents require technical proficiency and you cannot implement them on your own, then reach out to our technical support team through the helpline i.e., 1-800-615-2347. As an alternative, you can also reach out to our team through the live chat option available on our website. Our team will perform the troubleshooting on your behalf. So, without wasting any time, let us march forward.
Internet Explorer is Required Warning: Causes Behind the Warning
Some conspicuous causes may trigger the error. These include:
Internet Explorer browser is not updated to the latest version.
Effective Steps to Fix Internet Explorer is Required When it is Already Installed Warning in QuickBooks
This section entails all the practical troubleshooting steps arranged sequentially. As a necessary prerequisite, you must follow all the steps in the same sequence.
Step 1: Check the current version of Internet Explorer on your computer
In the inception, you need to make sure that you have the latest version of the browser installed on your system. If not, then it is the principal cause behind the error and requires you to upgrade the browser to its latest version. Follow the steps below to check your version of the Internet Explorer browser:
First, launch the Internet Explorer browser.
Subsequently, hit on the Gear icon. As an easy alternative, you can hit the Alt + X keys together on the keyboard. This shall open a drop-down list.
Choose the About Internet Explorer option.
From the dialog box that shows up on the screen, check the version of the browser. If you have a version older than Internet Explorer 11, then update the browser. To let the browser update automatically in the future, hit on the Install new versions automatically checkbox.
However, if you already have the latest version (Internet Explorer 11), then follow the subsequent step.
Step 2: Edit the qbw.ini file using Notepad
Close the Internet Explorer browser.
Afterward, proceed to the destination ‘C:\ProgramData\Intuit\QuickBooks.’
Herein, locate the qbw.ini file and hit a right-click on it.
Choose the Open With option.
From the list of programs to open, hit a click on Notepad and subsequently choose OK.
Upon opening the file through Notepad, you are required to scroll down and search for the [Misc] section.
Once located, you need to delete the following line: IEVersionOverride=600
After deleting the portion, hit on the File menu, followed by choosing the Save option.
All the changes are thus saved. Follow it up by closing the Notepad.
The QuickBooks Tool Hub is a commendable tool that has far-reaching benefits when it comes to rectifying an innumerable number of technical intricacies and error codes in the QuickBooks software. It can also assist in fixing the Internet Explorer required when it is already installed warning. Follow the steps below to use this exceptional tool:
Upon downloading the file, save it to a desirable location.
Double-click on the QuickBooksToolHub.exe file to initiate the installation process.
Follow the on-screen instructions and conclude the process by accepting the Terms and Conditions.
Once the installation is finished, launch the tool by double-clicking on its Desktop icon.
Head to the Program Problems tab.
Follow it up by choosing the Quick Fix my Program option.
Let the scan initiate and check for any issues related to the QuickBooks software. The process may take a while.
When completed, restart the computer and open QuickBooks Desktop.
Verify if the error got fixed.
Although Internet Explorer 11.0 is required when it is already installed error doesn’t involve any technical proficiency to get it wiped off from your system. However, there may still be an instance wherein you may feel a need for technical assistance. Reach out to our QuickBooks technical support team for indomitable customer support.
Our team of certified experts endeavors to make the QuickBooks software error-free. So, reach out to us through the helpline, 1-800-615-2347. We offer 24/7 support services to our revered users.
We've to collect some data when you use our website so it works and is secure. We'd also like your consent to collect data to study how users use our site. Doing so helps us improve our services and allows us to tailor the marketing you see on our site. Select 'Accept cookies' to agree or 'Cookie settings' to choose which cookies we use. You can change your mind at any time by clicking the 'Manage Cookies' link.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.