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?
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.
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.
Utilize the trial period of these 3rd party tools
The template should be like this
|101||Visa Account||Starbucks||01/10/2020||General Supplies||Miscellaneous||12.51||Supplies||1||12|
|102||Amex||Costco||01/10/2020||General Supplies||Office Supplies||125|
|103||MasterCard||Staples, Inc.||01/10/2020||Office Supplies||Office Supplies||25|
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.
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.
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.
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:
The steps outlined below will help you import the file:
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!
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:
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.
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.
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.
QuickBooks Desktop Premier is available in US version. Below are the types of transactions you import to QuickBooks using iif:
Here's how to import:
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!
Utilize the trial period of TP Importer
The template for Sales Order
|Customer||Transaction Date||RefNumber||PO Number||Class||Template Name||To Be Printed||Ship Date||BillTo Line1||BillTo Line2||BillTo Line3||BillTo Line4||BillTo City||BillTo State||BillTo PostalCode||BillTo Country||ShipTo Line1||ShipTo Line2||ShipTo Line3||ShipTo Line4||ShipTo City||ShipTo State||ShipTo PostalCode||ShipTo Country||Phone||Fax||Contact Name||First Name||Last Name||Rep||Due Date||Ship Method||Customer Message||Memo||Cust. Tax Code||Item||Quantity||Description||Price||Item Line Class||Service Date||FOB||Customer Acct No||Terms||Sales Tax Item||To Be E-Mailed||Other||Other1||Other2||Unit of Measure||Currency||Exchange Rate||Sales Tax Code|
|Anne's Bakery||01/09/2020||100||Y||15/09/2020||Anne's Bakery||One Harbor Street||Anytown||NY||12345||USA||Anne's Bakery||One Harbor Street||Anytown||NY||12345||USA||(123) 456-7890||Non||Cabinets||10||Cabinets||1000||Net 30 Days||Non|
|Anne's Bakery||01/09/2020||100||Y||15/09/2020||Anne's Bakery||One Harbor Street||Anytown||NY||12345||USA||Anne's Bakery||One Harbor Street||Anytown||NY||12345||USA||(123) 456-7890||Non||Hardware||10||Hardware||50||Net 30 Days||Non|
|John's Barber Shope||02/09/2020||101||Y||15/09/2020||John's Barber Shope||1 Main Street||Anytown||NY||12345||USA||John's Barber Shope||1 Main Street||Anytown||NY||12345||USA||(999) 888-8888||Non||Blueprints||1||Blueprints||500||Net 30 Days||Non|
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.
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:
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.
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.
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:
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.