cancel
Showing results for 
Search instead for 
Did you mean: 
BlueWingedOlive
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

What about importing .csv, for credit card transactions, to QB Desktop?  I just spent the last couple hours researching and calling QB support.  No solution found.  Should be easy.  Or is this another subtle issue to move people from Desktop to Online?

IamjuViel
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Hello. @BlueWingedOlive.

 

As of the moment, the ability to import credit card transactions to QuickBooks through CSV is not available. It only accepts transactions in the web connect file with a QBO format.

 

Here's how:

  1. Click Banking.
  2. Choose Bank Feeds
  3. Select Banking Center.
  4. From the Bank Accounts list, choose the account you need to connect.
  5. Click Download Transactions to receive transactions.
  6. Select Synchronize.
  7. Choose Sync all for this Bank to connect all accounts for the same bank.
  8. Type your PIN or password.
  9. Select OK.

 

You can also manually import your transaction using the Web Connect feature. For detailed instruction, please check this article: Download Bank Feed transactions.

 

Also, you can try finding applications that will convert your Excel file to QBO format. You can find one in the QuickBooks Desktop Marketplace.

 

Get back to us here if you have other questions. I'm always here to help.

Fiat Lux - ASIA
Level 15

How to upload excel data file or csv file into QuickBooks Pro ?

@BlueWingedOlive 

Utilize the trial period of these 3rd party tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template should be like this

RefNumberCreditCardPayeeTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101Visa AccountStarbucks01/10/2020            General SuppliesMiscellaneous12.51   Supplies  112   
102AmexCostco01/10/2020            General SuppliesOffice Supplies125           
103MasterCardStaples, Inc.01/10/2020            Office SuppliesOffice Supplies25           

 

megrussell
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

Note: I am using Quickbooks Desktop 2017. Not to be the contrarian here, but I HAVE found a way to convert CSV files to IIF and then import them and it works very, very well. All you need to get this going is a little conversion app that I was able to get from Propersoft.net called CSV to IIF. It works like a charm. You first obviously download your CSV transactions from your bank, and whatever column order or format that is in is fine because you open "CSV to IIF" and then you select the mapping of each column. For instance, do I want the description column selected as PAYEE? Do I want to include the memo column? Do I need signs reversed. One of the things I discovered is that I need to select a generic income and expense account in the conversion tool because Quickbooks will not accept the transactions without assigning an account in my chart of accounts. SO pick something generic and refine them later, the idea is to get the transactions INTO the books first. You also have to tell "CSV to IIF" the exact name of the Quickbooks account these are going into. It is very archaic that there is not a direct csv to bank account import function in a software so widely used as Quickbooks, but so be it. I do not like the auto import features because it is harder for me to control what the bank is going to send. I also tend to use a slightly later desktop Quickbooks and Intuit keeps suspending the import functions anyway as a newer product becomes available. I will not be a slave to forced upgrades, so my solution really works well! This is what works for me, hope it helps someone. 

megrussell
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

While I am at it, let me throw in that the Quickbooks support team that responds to these inquiries generally does two things over and over that are infuriating. One: they  miss the fact that most of us are trying to import TRANSACTIONS and not lists of vendors or customers. TWO: If they DO "get it," then they are sending us links to articles and third party software for us to spend another few hours trying to figure out the solution. IF someone asks ME for help, I give them step by step how to solve the problem, not a bunch of links to send them on another wild goose chase. Just sayin' - thanks for listening.

m_o_n_t_y
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

Sorry, this should not be marked as "Solved". OP clearly stated it is CSV transaction data in QB Pro.  The "QuickBooks Import Excel and CSV toolkit" you link to clearly says "Import from Excel and Comma Separated Values (CSV) can only import lists. Transactions cannot be imported using this method." This is a very frustrating "oversight" (being generous there) in QB Desktop.

MaryLandT
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Thanks for joining this thread, m_o_n_t_y.

 

You're correct that transactions cannot be imported using the CSV file. You'll want to use Intuit Interchange Format (IIF) to bring in your entries.

 

I'm adding a screenshot below that'll show you the list of transactions you can import using this format:

transactionsyoucanimporttoQBDT.PNG

 

The steps outlined below will help you import the file:

 

  1. Sign in to your company file as Admin.
  2. Switch to Single User mode.
  3. Click the File tab at the top menu bar.
  4. Select UtilitiesImport, then IIF Files.
    importIIF.PNG
  5. Click Import IIF.
    importIIF1.PNG
  6. Choose the file from your folder, then click Open.
  7. Follow on-screen instructions to bring in your entries.

Feel free to read through this article for more details: Export, import, and edit IIF files

 

To download the .IIF kit, check out the IIF Overview: import kit, sample files, and headers to get the file. It also provides sample files for each transaction type you want to bring in to QuickBooks Desktop.

 

Don't hesitate to tag my name if there's anything else you need. I always have your back.

 

Thank you and stay safe!

aboone
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

I don't see an option for banking data.  This is so frustrating.  I need to import credit card transactions to Quickbooks Desktop Pro 2019 from either a .csv or excel file.  There is no way to do it?

JenoP
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Thanks for joining us here, aboone.

 

Unlike the online version, QuickBooks Desktop does not support the importing of banking transactions through a .CSV or Excel file. Instead, you can download a .qbo file from your bank's website and import it in your company file. 

 

After getting the file, follow these steps on how to import it in QuickBooks Desktop:

 

  1. Go to the File menu, then select Utilities.
  2. Click Import and look for Web Connect Files.
  3. Select the QBO file that you saved, then select Open.
  4. When prompted to select a bank account, use:
    • Use an existing QuickBooks account if the account you'll be using is already set up in QuickBooks.
    • Create a new QuickBooks account if the account is not yet set up.
  5. Select Continue. You should see a dialogue box telling you that the data has been successfully read into QuickBooks. Select OK.
  6. Go to the Bank Feeds Center to review your transactions.

Once imported, use this article as a guide on how to categorize and match the banking transactions: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Please add another reply below if you still need more help. The Community is always here to help. 

Fiat Lux - ASIA
Level 15

How to upload excel data file or csv file into QuickBooks Pro ?

HollyP
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

Do I have to purchase Winzip?  When I went to the website it asked me to purchase it.  I tried the free trial but it doesn't seem to be doing anything?  

HollyP
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

I tried following your instructions but when the program took me to my files the only options are already IIF files. How do I choose a CSV file? 

Mark_R
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Hi there, @HollyP.

 

Let me clarify things about your concern and help you from there.

 

As mentioned by my colleagues above, the only option to import transactions to QuickBooks Desktop is using the IIF file format. You can follow the steps provided above to import your transactions.

 

However, if you're trying to convert your CVS file to IIF or vice versa, you can search for a third party application for it.

 

You can read through this article for more details: Export, import, and edit IIF files.

 

As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a good one and keep safe.

Fiat Lux - ASIA
Level 15

How to upload excel data file or csv file into QuickBooks Pro ?

@HollyP 

What kind of transaction data you wish to import? Estimate, Invoice, Bill, or else? There are more than 20 data types you can import and we have to use a specific template in XLS/CSV for each data type. 

nicolatopus
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

Can I also use this to import sales orders in premier?

IamjuViel
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Hello, @nicolatopus.

 

QuickBooks Desktop Premier is available in US version. Below are the types of transactions you import to QuickBooks using iif:

  • Account beginning balances
  • Cash sales to customers
  • Checks
  • Deposits
  • Invoices
  • Account transfers of funds
  • Vendor bills
  • Cash refunds to customers
  • Credit card transactions
  • Estimates
  • Payments from customers
  • Vendor bill refunds
  • Credit card refunds to customers
  • Credit memos to customers
  • General journal entries
  • Purchase orders

Here's how to import:

  1. Sign in to your company file as Admin.
  2. Switch to Single User mode.
  3. Click the File tab at the top menu bar.
  4. Select Utilities.
  5. Select Import.
  6. Click IIF Files.

To guide through the process of exporting lists and importing transactions, you can use the Export or import Intuit Interchange Format (.IIF).  For more insights about this procedure, please check out this article: Export or import Intuit Interchange Format (.IIF) files.

 

You can always visit the Community space for more ideas and references in managing your account and transactions.

 

Comment below if you have other questions about tracking your income and expense transactions. Stay safe and healthy!

Fiat Lux - ASIA
Level 15

How to upload excel data file or csv file into QuickBooks Pro ?

@nicolatopus 

Utilize the trial period of TP Importer

https://transactionpro.grsm.io/qbd

 

The template for Sales Order

CustomerTransaction DateRefNumberPO NumberClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceItem Line ClassService DateFOBCustomer Acct NoTermsSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100   Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000    Net 30 Days        Non
Anne's Bakery01/09/2020100   Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50    Net 30 Days        Non
John's Barber Shope02/09/2020101   Y15/09/2020John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500    Net 30 Days        Non
nicolatopus
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

thanks but I need to generate sales orders to deplete inventory and create invoices - I don't see your tool being able to do that for me

nicolatopus
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

actually never mind - i replied too quickly and didn't see the template image you pasted in - i will take another look at your app

asha_kanta_sharma
Level 6

How to upload excel data file or csv file into QuickBooks Pro ?

Thanks
sarylsam
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

Years ago I had QB Accountants' version which allowed me to download bank transactions into an excel file and import it into QB.  I cannot figure out how to do that now with QB Pro 2020.  It looks like I need a formatted spreadsheet, but I don't know where to get that.  Your instructions seem to indicate that I can only import lists (Customers, Items, etc.).  Please help me.

MaryLandT
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Hi there, sarylsam,

 

I'm here to help import your bank transactions to QuickBooks Desktop Pro. As mentioned in this thread, you'll want to use Intuit Interchange Format (IIF) to bring in your entries. 

 

Check out the IIF Overview: import kit, sample files, and headers to get the file. Then, go to Download and install the .IIF import kit to get the formatted spreadsheet. It also provides sample files for each transaction type you want to bring in to QuickBooks Desktop.

 

To import the file:

  1. Sign in to your company file as Admin.
  2. Switch to Single User mode.
  3. Click the File tab at the top menu bar.
  4. Select UtilitiesImport, then IIF Files.
  5. Click Import IIF.
  6. Choose the file from your folder, then click Open.
  7. Follow on-screen instructions to bring in your entries.

Feel free to read through this article for more details: Export, import, and edit IIF files

 

Let me know if you have follow-up questions by commenting below. I'm always around to help.

dh1122
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

Thank you so much for telling us about this ProperSoft software, it is well worth the $50. I've had to manually enter each and every transaction from USAA (which is our main CC) and it was always such a pain.  This took me literally seconds to convert my .csv file to the .qbo file and import them into my QB Desktop.

 

THANK YOU!!!!

nico8
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

Can some one provide me with: quickbooks desktop 2020 portable excel files for student.

 

GlinetteC
Moderator

How to upload excel data file or csv file into QuickBooks Pro ?

Thanks for joining this conversation, nico8.

 

Let me provide you some insights regarding the portable excel files in QuickBooks Desktop for a student. There is no portable excel file when installing QBDT. You can import data via excel file. There are several options available when importing Excel files from QuickBooks.

 

One of these is the Standard import. I'll show you how:

 

  1. From the File menu, select Utilities then Import, and then Excel Files.
  2. If you get the Add/Edit Multiple List Entries window, click No.
  3. Follow the wizard in importing files.
    1. Select the type of data.
    2. QuickBooks opens a formatted excel spreadsheet. Once you have entered your information, saved the file, and closed it, you will be given the option to Add My Data Now.
    3. Review results and view Data in QuickBooks.
    4. Select Close when done.

To learn more information, here's our detailed guide: Import or export MS Excel files.

 

If you have any other questions, please add them in the comment below.