CSV2QBO Import a CSV transaction file into Quickbooks

This tutorial shows how to convert a CSV or Excel file with transactions to QBO (Web Connect) format and import into Quickbooks. We will use CSV2QBO utility.

We will use a sample.csv file. You can find it on the ProperSoft product page https://www.propersoft.net/products/csv2qbo

CSV2QBO Import a CSV transaction file into Quickbooks Step 1: sample csv

A simple file has Date, Amount, Payee, Memo, Check.

CSV2QBO Import a CSV transaction file into Quickbooks Step 2: review csv2qbo

There are Debit transactions.

CSV2QBO Import a CSV transaction file into Quickbooks Step 3: debit transactions

There is Credit transactions.

CSV2QBO Import a CSV transaction file into Quickbooks Step 4: credit transaction

In most cases, you don't need to do anything else, except just click the 'Convert' button. But you still have to review transactions before importing to see how the converter understand your file, what is your settings. And you have all the controls you need to import your file successfully.

CSV2QBO Import a CSV transaction file into Quickbooks Step 5: convert

On the left side we have input file controls: you can map your CSV file; you can set expected date format if it is not obvious to the Parser; if your Dates are missing year, you can set it; if it is obviously Credit Card you can check the box, so it will reverse the sign of expenses to negative and payments to the account make it positive. And if it is not obvious, check that expenses are negative regardless if it is a Checking account or Credit Card account. Expenses must be negative and payments to the account or deposits must be positive. If it's not the case like in this example, then click 'Change +/-' button once per file to reverse that.

CSV2QBO Import a CSV transaction file into Quickbooks Step 6: left side

On the right side, we can see Account Type, which is important to set for QuickBooks. If it's Checking or Credit Card, enter the Account Number. If you are importing just for one account, you can leave the default, that's fine. End balance, Bank ID, Branch ID, Encoding settings you can leave the default or you can set them if you know, that you need to set them. Otherwise, the converter will use some good default values.

CSV2QBO Import a CSV transaction file into Quickbooks Step 7: Account Type

There is INTU.BID value '3000', which is "Wells Fargo" default value. You can look up your bank if you like or you can leave the default value if your bank is not listed or is not listed for specific Account Type. The transaction tab shows how the converter understands your data: it pick up date, pick up Amount column, correctly pick up Payee column, pick up Check.

CSV2QBO Import a CSV transaction file into Quickbooks Step 8: INTU.BID

And all we need to do is just click on the 'Convert' button and create a QBO file.

CSV2QBO Import a CSV transaction file into Quickbooks Step 9: sample qbo

Now we switch to Quickbooks. Before importing a QBO file, check the 'Chart of accounts'. That Bank you need to import into, let's say, for example Checking account, doesn't have a yellow strike icon. Because if you have a yellow strike icon, it means you downloaded directly from your Bank. You need to disconnect first to import any QBO file. It's not just the converter limitations, Quickbooks limitation that doesn't import QBO files, unless if you're already connected to directly download from your bank.

CSV2QBO Import a CSV transaction file into Quickbooks Step 10: chart of Accounts

For example, the Credit Card account has a yellow strike icon.

CSV2QBO Import a CSV transaction file into Quickbooks Step 11: yellow strike

To disconnect, right-click 'Edit account'.

CSV2QBO Import a CSV transaction file into Quickbooks Step 12: edit account

Then click 'Bank Feed Settings', select 'Deactivate all online services' and then 'Save and Close'. And now there is no yellow strike icon, so you can proceed for both of these accounts. We created a Checking account, so we will important into existing Checking account.

CSV2QBO Import a CSV transaction file into Quickbooks Step 13: deactivate all online services

Now go to 'File' - 'Utilities' - 'Import' - 'Web Connect Files'. Then open a QBO file.

CSV2QBO Import a CSV transaction file into Quickbooks Step 14: file import

It shows the Account number we enter '12345', it shows "Wells Fargo Bank", which is INTU.BID '3000'. And we choose 'Use existing Quickbooks account', then look for that Checking account and click the 'Continue' button.

CSV2QBO Import a CSV transaction file into Quickbooks Step 15: file import

Now data is successfully read into QuickBooks.

CSV2QBO Import a CSV transaction file into Quickbooks Step 16: data read

Where is this Data is? Data is shown under Bank Feeds. "Wells Fargo" label is only at this place, where you see it. The actual account, that you are choosing during import, that existing account, does the bank account, where data will go. But you have to review them in the Bank Feeds. Click on the 'Transaction List'.

CSV2QBO Import a CSV transaction file into Quickbooks Step 17: transaction list

You have to select the Payee. As you see, in this example, the QuickBooks already select the Payee for you, based on the previous imports. The Payee from the QBO file is shown under 'Downloaded as'. Payee here is actual Vendor record in QuickBooks, so you can choose it and QuickBooks will remember your choice for next QBO import.

CSV2QBO Import a CSV transaction file into Quickbooks Step 18: payee

Then mark all transactions or select the Payee, select expense account.

CSV2QBO Import a CSV transaction file into Quickbooks Step 19: mark transactions

Then say 'Add/Approve'. Done.

CSV2QBO Import a CSV transaction file into Quickbooks Step 20: approve

This is the rename rule creation when you select a certain Vendor for that 'Downloaded as' Payee name, QuickBooks will offer you to select to create a rule to use it for next time.

CSV2QBO Import a CSV transaction file into Quickbooks Step 21: rule creation

That's it.

CSV2QBO Import a CSV transaction file into Quickbooks Step 22: transactions imported

Related artciles