how to import csv file into quickbooks desktop

Step Two: Install the QuickBooks Import Excel and CSV Toolkit Mac users should look into using Quickbooks Online, which allows you to import transactions in a CSV format natively.

This file is for Windows desktop versions and is not available for Mac. Inside it, you’ll find a PDF document with instructions to help you, a folder with four example CSV files, a folder with four example XLS files (Excel), and allowed fields – a reference document that explains what fields are available for CSV and Excel import. You’ll be able to download the toolkit here. Step One: Download the QuickBooks Import Excel and CSV Toolkit There’s a plugin you must download and install to help you. QuickBooks allows you to import CSV files and Excel files into the program.

Not only will this take way more time than you have, but it increases the chance for error, which could easily throw off your entire dataset.ĬSV files are known as “comma separated values” format, that’s a simple text file that Excel uses to display a spreadsheet that is not in the Microsoft Excel format. If you have a lot of data to import into Intuit QuickBooks, there’s no need to waste time entering everything manually.

How to import csv file into quickbooks desktop