Clients and results

Boy Scouts of America Logo
Hilton Logo
Oregon State Police Logo
Toshiba Logo
HCA Healthcare Logo
Allegis Group Logo

We saved more than $1 million on our spend in the first year and just recently identified an opportunity to save about $10,000 every month on recurring expenses with PLANERGY.

King Ocean Logo

Cristian Maradiaga

King Ocean

Download a free copy of "Preparing Your AP Department For The Future", to learn:

  • How to transition from paper and excel to eInvoicing.
  • How AP can improve relationships with your key suppliers.
  • How to capture early payment discounts and avoid late payment penalties.
  • How better management in AP can give you better flexibility for cash flow management.

How to Import a CSV into QuickBooks

How to Import a CSV into QuickBooks

How to Import a CSV into QuickBooks

If you have a lot of data to import into Intuit QuickBooks, there’s no need to waste time entering everything manually. 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.
CSV 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. QuickBooks allows you to import CSV files and Excel files into the program. There’s a plugin you must download and install to help you.

Step One: Download the QuickBooks Import Excel and CSV Toolkit

You’ll be able to download the toolkit here. 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. This file is for Windows desktop versions and is not available for Mac. Mac users should look into using Quickbooks Online, which allows you to import transactions in a CSV format natively.

Step Two: Install the QuickBooks Import Excel and CSV Toolkit

Open the file download window for the toolkit and save it. Double click it to start the installation process. Choose the folder where you want to install it on your computer. Then click OK.
Unzip the folder to extract the contents, and then close the Win-Zip window.
Open the QuickBooks Import Excel and CSV folder from the location where you saved it on your computer.

Step Three: Import CSV

Select the Banking Menu. Then choose, “Update drop-down menu” or “Upload Transactions Manually”. Click “File Upload” and browse to the location where the CSV is saved on your computer. Click Next.
In your QuickBooks account, choose the account to import. Click “Next”. Map the fields, if necessary, so the data matches up with what’s imported. Click “Next”.
Choose the CSV files to import. Click “Next”. Click “Yes” on the notification where it will tell you how many records you’re pulling in. Once you get confirmation of the important, click “Finish”
You can see a list of transactions imported from CSV files in the Downloaded Transactions Window.
You can use this approach to import bank transactions, credit card transactions, chart of accounts, lists of customers, vendors, items, and more. 

Control, track, and report on spending with ease with our QuickBooks integration. Keep your workflow simple and do it without having to increase your QuickBooks user count.

You can connect your bank account and credit card account to QuickBooks to automatically import transactions. If you need to go further back, you can manually download CSV files of transactions from your bank and then upload files for CSV import into your accounting software. This allows you to create a more complete picture of your business finances.

QuickBooks and PLANERGY

If your business is looking to streamline purchasing and accounts payable, then the one-click QuickBooks integration will save you a great deal of time and effort. Import QuickBooks data to make it easier to efficiently manage your procurement processes.
Your team will be able to request, approve, and manage purchase orders in PLANERGY without needing QuickBooks user access. Accounts Payable can automate invoice matching against purchase orders in PLANERGY to reduce or eliminate error from incorrect payments and fraud. You’ll even be able to automatically generate bills in QuickBooks for all authorized invoices in PLANERGY. All data and documents are imported but remain editable by your accountant before payments are processed.

What’s your goal today?

1. Use PLANERGY to manage purchasing and accounts payable

We’ve helped save billions of dollars for our clients through better spend management, process automation in purchasing and finance, and reducing financial risks. To discover how we can help grow your business:

2. Download our guide “Preparing Your AP Department For The Future”

Download a free copy of our guide to future proofing your accounts payable department. You’ll also be subscribed to our email newsletter and notified about new articles or if have something interesting to share.

3. Learn best practices for purchasing, finance, and more

Browse hundreds of articles, containing an amazing number of useful tools, techniques, and best practices. Many readers tell us they would have paid consultants for the advice in these articles.