Toll-Free: +1-866-453-7060 [email protected]
QuickBooks Import Excel and CSV Toolkit

QuickBooks Import Excel and CSV Toolkit

When you use online banking, the transactions are recorded. And to download these transactions, a CSV file is required. A CSV file is basically used to import online banking transactions into QuickBooks. You can import CSV files that include bank transactions, general journal entries, accountant’s changes, and batch transactions in QuickBooks. In order to import CSV files, you need to start installing QuickBooks Import Excel and CSV toolkit. To make the import process easier for you, here we are with this segment sharing the complete details as to how to install QuickBooks import Excel and CSV toolkit and how to import CSV files.

Thus, to learn further, stick around till segment till the end. You can also connect with our technical support team at  +1-866-453-7060, and we will provide you with immediate support and assistance.

Also Read: How to Export or Import IIF Files in QuickBooks?

What is a CSV File?

CSV files are basically simple text files that contain tabular data. A comma separates each field in the file from the next in a CSV file. The majority of spreadsheets support this format including Microsoft Excel and Google Spreadsheets. Also, you can create and edit CSV files with any text editor like Notepad. You can also import files related to some of your vendors and customers. CSV files are also termed as Comma Separated Values.

Why import CSV into QuickBooks?

In order to track finances, it is essential to maintain records of all the data. The CSV file is already in a tabular format and is further supported by spreadsheets. In the case of online banking, there are so many QuickBooks transactions and manually Creating transactions in QuickBooks desktop involves a lot of effort and takes time. Moreover, recording manually can lead to inaccuracy. The concept of importing CSV files eliminates the chances of errors due to inaccuracy and saves a lot of time.

Import CSV files

In order to import a list in the CSV format, you simply have to install QuickBooks import Excel and CSV toolkit. This toolkit includes:

  • Import from Excel and CSV manual – A PDF document with instructions, best practices, and notes.
  • CSV Example Folder – 4 Sample CSV files, one for each type of list
  • XLS Example Folder – A sample Excel file that contains 4 worksheets, one for each type of list.
  • Allowed fields – A reference guide explaining what fields are available for Excel and CSV import.

Steps to install QuickBooks Import Excel and CSV ToolKit

You can try to install QuickBooks Import Excel and CSV toolkit using the set of steps enumerated below. 

  1. Initially, open the file download window for the toolkit and then choose the save tab. 
  2. The next step is to head to the Windows desktop and choose Save. 
  3. Double-click the QuickBooks_Import_Excel_and_CSV.exe on the Windows desktop. This will open the WinZip Self-Extractor window.
  4. After that, choose browse and select the folder where you want to install the toolkit. 
  5. Also click on the ok tab. 
  6. The next step is to choose Unzip to extract the contents and choose Close to close the WinZip self-extractor window.
  7. You now have to open QuickBooks Import Excel and CSV folder from the location you opted for. 

Here is: How to Delete Duplicate Transactions in QuickBooks? 

Export CSV files 

One can try to export a list as a CSV file, in case you do not have MS Excel installed on the system or if you want to view and edit the data using a different format. 

Customer and Vendors 

  1. The very first step is to open a Customer/vendor Center 
  2. After that, choose the Excel drop-down and select
    • Export customer/vendor list, in case you want to export customer/vendor data such as name, balances, and contact information. 
    • Export transactions, if you wish to export transactions (either by name or transaction type)
  3. Now, in the export window, you are supposed to create a comma separated values file i.e., .csv file. 
  4. Furthermore, choose export. 
  5. After that, assign a file name, and select the location where you wish to save the file. 
  6. Open and edit the file as needed. 

Also Read: How to Resolve QuickBooks Unable To Export To Excel Error?

Items 

  1. Here, you need to lists menu and further opt for the Item list 
  2. The user needs to then opt for the Excel drop-down and select Export all items. 
  3. And furthermore, select Create a comma separated values file in the export window. 
  4. Now, choose the export tab. 
  5. You need to then assign a file name and select the location where you want to save the file. 
  6. And lastly, locate, open, and edit the file as required. 

Reports 

  1. At first, open the report 
  2. Furthermore, choose the Excel dropdown at the top of the report 
  3. The next step is to choose create a new worksheet 
  4. Now, on the send reports to Excel window, choose Create a comma-separated values file. 
  5. Now, go for the export tab. 
  6. After that, assign a file name and select the location where you want to save the file. 
  7. The last step is to locate, open, and edit the file as needed. 

Also Read: How to Resolve QuickBooks Unable To Export To Excel Error?

Conclusion! 

The process of setting up QuickBooks Import Excel and CSV toolkit is easy and involves a few basic steps. Hopefully, performing the above steps carefully might be of some help to you in successfully importing QuickBooks Excel and CSV toolkit. However, if you have any queries even after performing the steps above, or if you need any sort of technical assistance, then, in that case, feel free to consult our technical support team at  +1-866-453-7060, and our certified QuickBooks ProAdvisors will answer all your queries immediately. 

QuickBooks Migration Tool – Download and Set up 

QuickBooks Migration Tool – Download and Set up 

Moving QuickBooks from one system to another, well you will need QuickBooks Migration Tool for this. This tool is designed in a way to make transferring data from one system to another super easy and swift. You can use this tool to transfer data safely from one system to another without much human intervention. It can get the work done in half the time and thus, it saves a lot of time. To help you understand the QuickBooks migration tool better, here we are with this segment sharing the complete set of steps to download and use the QuickBooks Migration tool.

QuickBooks migrator tool

Thus, read this segment carefully. Or you can further get in touch with our technical support team at +1-866-453-7060, and let our certified QuickBooks ProAdvisors help you with your queries. 

Also Read: QuickBooks Migration Failed Unexpectedly [SOLVED]

What is QuickBooks Migration Tool? 

As the name suggests, the QuickBooks migration tool is an essential tool when you migrate or move QuickBooks from one system to another. This tool eases the process and eliminates the risk of data loss when transferring the data. The migration tool is accessible via your browser, which cuts down the need for a copy of QuickBooks Desktop Pro, premier, enterprise, or Mac on your system to migrate the data files. 

QuickBooks migration tool

Requirements for QuickBooks Migration Tool 

There are a few things that you might require when transferring your data using the QuickBooks Migration tool. Let us have a look: 

  1. To store your QuickBooks data, you must have a USB flash drive with optimum space. 
  2. Another essential thing is that your new computer should be connected to the Internet. 
  3. The available space should be at least 150MB to 250MB. 

Steps to set up QuickBooks Migration Tool 

You will initially have to download and install QB Migration Tool on your system. Let us check out the steps that you need to perform to download, install, and set up the tool successfully. 

  1. Begin with logging in to QuickBooks using your admin ID and password. 
  2. Once done with that, allow access so that you can easily copy the data into the system. 
  3. The next step is to head to the migration tool and click on it. 
  4. The migration tool will now ask for a password. Thus, enter the admin password in it. 
  5. After accessing the tool, you need to click on the Start or Run tab. 
  6. The migration tool will begin the process. 
  7. When the tool initiates its process, the flash drive also starts copying and transferring some files. 
  8. Note that, after the completion of transferring the data, the tool never formats or erases your data, the data remains as it is in the past. However, if you want to erase it, then you can by clicking on the delete tab. 

What data can be transferred using QuickBooks Migration Tool? 

Here is a list of data that can be easily transferred using the QuickBooks Migration Tool. Let us evaluate: 

  • QuickBooks Desktop details, including the version and other details needed to install QuickBooks Desktop on your new computer.
  • Up to the last three company files that you opened on the old computer, including sample files.
  • Related files, custom templates & forms
  • QuickBooks letters and templates
  • Scheduled and memorized reports
  • Local attachments
  • Printer Setting (PrintEng.ini, wpr.ini, and QBPrint.qbp)
  • Spell Checker (spell.ini and UserDictionary.tlx)
  • Financial Statement Designer (FSD clients)
  • Financial Statement Designer (FSD data)
  • Cash Flow Projector (.cfp)
  • Business Planner (.bpw)
  • QuickBooks Loan Manager (.lmr)
  • Statement writer (for QuickBooks Accountant)
  • Advanced reports (for QuickBooks Enterprise)

What data can’t be transferred using the QB migration tool? 

Certain data can’t be transferred even after using the migration tool. This includes: 

  • In case you are using QuickBooks in a multi-user setup, then the configuration won’t be copied to the new system.
  • Also, if you have payroll or payment services set up, then you might have to sign in again on the new computer, as this is something to protect the data.
  • The user will have to uninstall Intuit Data Protect on the old computer, sign in again on the new computer and go through the setup process. All previous backups will still be available.
  • Any company files that aren’t used by you recently, won’t be copied. As mentioned earlier, QuickBooks only copies three of the most recently opened company files. Other files will have to be moved manually or you can also restore them from the Intuit Data Protect.
  • You should also note that any manual backups you created earlier won’t be copied by the Migration tool.

Steps to move data using QuickBooks Desktop Migration Tool 

You can perform the below steps to transfer QuickBooks from Old Computer to a New Computer with the help of the migration tool. Make sure to perform the steps wisely to avoid any sort of data loss.

Process to be followed on an old computer 

Here are the steps that you need to carry out on your old system. 

  1. You need to first connect USB flash drive in your old computer 
  2. Later on, launch QuickBooks desktop. 
  3. Once done, head to the file menu and click on it. 
  4. From the drop-down menu of the file, choose utilities tab
  5. Then, choose Move QuickBooks to another computer option. 
Move QuickBooks to another computer
  1. Now, go for I am ready and create a unique password.
  2. Follow online instructions and choose your USB flash drive
  3. The last step is to sit aside and wait for all the files to be copied. 

Steps to be followed on the New computer 

After you are done copying the files, you now have to launch your new system. 

  1. Here, you need to plug in your flash drive in the new system. 
  2. The tool will not launch on its own. Thus, you will have to open the flash drive in the new system. 
  3. Also, double-click the Move_QuickBooks.bat file
Copy files - QuickBooks migration tool
  1. Furthermore, enter the password that you created in the old system. 
  2. After you are done with all the steps above, wait for the migration tool to complete its task. 

Other steps to complete QuickBooks setup 

Note that, not all the data can be copied using the migration tool. Thus, you need to perform some additional steps to complete the task easily and migrate the entire data successfully. 

  1. You need to log in to the payment and payroll services
  2. Furthermore, log in to Intuit data protect
  3. Also, configure the entire backup schedule 
  4. Take the backup of the company files so that you can skip unexpected issues or problems that might show up in the future. 

Steps to manually transfer the data 

Transferring the data might seem to be a tough nut to crack, however, a few basic steps can help you in transferring the data manually. Here are the steps that you need to follow to manually transfer the data to the new system. 

  1. First of all, create a QuickBooks backup on the old system. 
  2. You now have to uninstall QuickBooks from the old system. 
  3. Then, move to your new computer and install QuickBooks in your new system
  4. Restore the QuickBooks backup in the new computer that you have created in old system. 

Steps to migrate data to QuickBooks Online 

If you want to migrate data to QuickBooks online, you simply need to follow the following steps: 

  1. First, choose the plan
  2. Now, sign up for QuickBooks online essential 
  3. After that, you need to upload your complete data to the system. 
  4. Furthermore, fill in the conversion form provided by Intuit. 
  5. Upload the backup of the data. 
  6. And migrate the data successfully. 
  7. The last step is to click on the review tab

Also Read: How to install QuickBooks desktop on two computers?

Conclusion! 

Using QuickBooks Migration Tool you can migrate the required data from your old computer to the new one without much hassle. The steps enumerated above might be of great assistance in successfully completing the migration process. However, if you aren’t able to do so, or if you have any queries, then in that case, feel free to connect with our technical support team at +1-866-453-7060, and we will provide you with immediate support and assistance. 

FAQs Related to QB Migration Tool 

Where can I find the Migration Tool?

In order to find the Migration tool, you can perform the below steps: 

1. At first, you need to sign in to QuickBooks online using QuickBooks supported web browser 
2. After that, enter https://app.qbo.intuit.com/app/exportqbodatatoqbdt
3. Now, head to the export overview screen and click on the tab to start.  
4. Download the tool by clicking on the download tab in QuickBooks.  
5. After the installer is downloaded, launch and run it.  
6. Wait for the installation process to complete, and after that perform the onscreen steps to run it. 

What to do after migration of QuickBooks Desktop? 

After you are done with the migration, you need to perform the following steps: 

1. Sign in to your payroll and payment services. 
2. Furthermore, sign in to Intuit data protect and set up the backup schedule 
3. Transfer the additional company files that were left when using the tool, from the old system to the new system. 
4. Ensure that you always take a backup of the company file. 

What if I don’t have my CD?

In case you have your license and product number and not the CD and you need the installation files, then simply download your version of QuickBooks from Intuit directly.

What if I don’t have my license and product numbers?

You can perform the steps to find a lost QuickBooks license and product number.

Will I need to register QuickBooks after I reinstall or move it?

In case you need to move your installation to another system, you will have to register again. This can be done as follows:
1. Head to the help menu and choose Register QuickBooks
2. You now have to enter the info, Intuit detects the registration status of the copy of QuickBooks and records the info for the new computer.

How to Delete a Journal Entry in QuickBooks? 

How to Delete a Journal Entry in QuickBooks? 

Making an incorrect journal entry mistakenly is pretty common. In such a scenario, you might have to delete or reverse an entry by performing some basic steps. You can simply create journal entries in QuickBooks on your own, and if some issue arises, you can edit or correct a journal entry by reversing it if needed. Any entry made mistakenly can be removed permanently. A journal entry can be created and deleted in both QuickBooks desktop and QuickBooks online. However, the process might differ in both cases. To help you further, here we are with this segment sharing how to delete a journal entry in QuickBooks successfully. 

In case you have any queries or if you need any sort of technical guidance at any point in time, then in that case, feel free to connect with our technical support professionals at +1-866-453-7060, and let them help you with your queries. 

Also Read: How to Download Bank Feed transactions in QuickBooks Desktop?

Important points to consider 

Before you directly jump on to the steps to reverse or delete journal entries, it is essential to understand the difference between the two. 

  1. Reverse a journal entry: This can be done when you need to allocate a transaction between two accounting periods or fix a debit/credit error. Note that, reversing simply reverses the debits and credits and doesn’t delete the original entry. 
  2. Delete a journal entry: In case you create it by mistake and need to get rid of the entry permanently. 

How to delete a journal entry in QuickBooks Desktop? 

The procedure to delete a journal entry in QuickBooks Desktop is different from QuickBooks Online. Let us understand the steps in detail: 

  1. Initially, you need to head to the company menu. 
  2. Now, choose make general journal entries. 
  3. Once done with that, find and choose the journal entry that you want to delete:
    • In QuickBooks for Windows, choose find and enter the name, date, entry no, or amount, and then choose find. 
    • In QuickBooks for Mac, choose the journal entry you wish to reverse from the list on Make general journal entries window. 
  4. In order to delete the journal entry:
    • You need to double-click the journal entry in QuickBooks for Windows and then choose delete, or void and click on the ok tab. 
    • In QuickBooks for Mac, you need to choose Delete General Journal from the edit menu. 
  5. And the last step is to choose save and close. 

You might find this helpful: How to Delete Duplicate Transactions in QuickBooks? 

Steps to reverse a journal entry in QuickBooks Desktop 

In order to reverse a journal entry in QuickBooks desktop, you need to carry out the following steps: 

  1. At first, navigate to the company menu and choose Make general journal entries. 
  2. After that, find and choose a journal entry that you want to reverse.
    • In QuickBooks for Windows: You will have to choose find and enter the name, date, entry no, or amount and choose find. 
    • Whereas in QuickBooks for Mac, you simply have to find and select the journal entry you wish to reverse on the left side of the Make general journal entries window. 
  3. Now, go for the reverse option. 
  4. And lastly, choose save and close. 

How to Delete a journal entry in QuickBooks Online? 

Note that, deleting a wrong journal entry can unbalance the accounts immediately. Thus, you must be absolutely sure to delete the journal entry. In case you invited your accountant to review your books, then instead of deleting the entry, it is possible to make an adjusting journal entry. Having said that, let us check out the steps to delete a journal entry in QuickBooks Online. 

  1. To begin with, you simply need to choose the settings tab and then go for the chart of accounts. 
  2. Once done with that, find the account you create the journal entry for. 
Chart of accounts- Delete a journal entry in QuickBooks
  1. Now, choose the account history tab. 
  2. And find the journal entry in the account register. 
  3. The word journal should be present in the Ref no. or type column. 
  4. The next step is to choose a journal entry to expand the view. 
  5. Then, simply click on delete and yes to confirm. 
  6. This would delete the entry successfully. 

Steps to reverse a journal entry in QuickBooks Online 

Reversing a journal entry usually reverses the debits and credits and doesn’t delete the original entry. The steps involved in reversing a journal entry in QuickBooks online are as follows: 

  1. You need to first choose the settings tab and go for the chart of accounts in QuickBooks
  2. Once done with that, find the account you created the journal entry for. 
  3. Now, go for the account history. 
  4. And find the journal entry in the account register. 
  5. The word journal should be in the Ref no. or type column. 
  6. The next step is to choose the journal entry to expand the view and click on the edit tab. 
  7. Now, choose reverse and click on save to end the process. 

When you reverse an entry in QuickBooks, the software creates a new journal entry to balance it. This is a record of the changes that you made. 

The new journal entry in QuickBooks might show slightly different information. 

  1. The reversed journal entry keeps the original journal no. and further adds the letter R indicating Reconciled. 
  2. The new entry is dated the first day of the month following the original journal entry date. 
  3. It further keeps the same info, such as account, name, and description as the original journal entry. 

Also Read: Compile Error in Hidden Module – QuickBooks [FIX]

Conclusion! 

Deleting or reversing a journal entry in QuickBooks desktop and online involves a handful of steps only. However, it is important to ensure that you actually need to delete or reverse the entry or not, as this might trigger balance issues. Hopefully, reading this segment might have helped you in successfully deleting or reversing journal entry in QuickBooks. However, if you have any queries at any point in time, then in that case, feel free to connect with our technical support team at +1-866-453-7060, and we will provide you with immediate support and assistance. 

Other Related Articles:

Create Custom Email Templates in QuickBooks Desktop 

How to merge accounts in QuickBooks? 

Complete Guide to Write Off Bad Debts in QuickBooks Desktop and Online

How to undo a reconciliation in QuickBooks online?