Import CSV into Quicken for Mac

TidBITS Talk
7

Hi Nello,
I spent 20 minutes looking at the Mint.com site and could not find information about import/export data capability. This didn’t surprise me when I read that Intuit purchased Mint. When Intuit offered up the new Quicken after the bankruptcy of the original Quicken, all the old Quicken.com support info, knowledgebase, and the hosted forum were deleted. I suspect Mint is not being supported/improved as other accounting apps are. And why would they want to cut into the Quicken revenue?

Mint has no general search function on the home page which is odd. There is one on the forum page but not helpful. I’ve never seen so many white spaced pages that describe the obvious features that all accounting apps have but really say nothing.

So let’s start with the Mint export types first. Since I don’t use Mint, eyeball your Mint menus to see if Import/Export is shown. For example, my Citi card export page shows CVS, Txt (tab-delimited), QFX (a defunct proposed standard for banking), OBO (QuickBooks, na), and OXF the current banking standard accepted by a consortium of banks and Quicken (the licensing fees QFX required were a show-stopper for the banks).

If one of these formats (QFX or OFX) are supported, then I’d recommend you abandon Mint for a more modern, powerful application. I am working with Banktivity, MoneyDance (only QIF/OFX file import), and See Finance on a conversion project to import 10 years of 30 yrs old data. I too reviewed these conversion apps and many had “yes, but…” phrases, like doesn’t handle investments and/or splits.

Any app you choose should support OFX.

Do you have Investment data to convert?

I can help you with this but I need to know the export capabilities of Mint.
We can work offline from Tidbits since this is a personal problem.

Pls advise MIke Noonan mrnoonan@yahoo.com

PS, if only the one credit file data is involved I see this as a 10-column Excel conversion where you need to add the category. Need to determine what ID is.

8

Your answer is perhaps here: https://community.quicken.com/discussion/7303280/

And this tool to convert to Mint CSV https://www.propersoft.net/csv2csv/

9

Mike:

Thank you for taking the time to contact me.

I guess that I wasn’t clear. I am NOT a Mint user; I’m a Quicken for Mac user.

My hunt is to import transactions into Quicken without using Intuit’s servers; I just don’t feel comfortable having my data travel through their servers. Some financial institutions provide .qfx files directly to their customers and I import such files with no problems. Unfortunately, others offer only their own flavor of .csv files, which Quicken will not import.

Interestingly, Quicken supports importing .csv files exported by Mint. So, I’m trying to transform my ad hoc .csv files into Mint imposters. For more information on the Mint .csv file format, see:

Thanks again for you offer to help. I may come back to you later, but for now I think I’m fine. I may be back.

10

Matt:

Thank you for taking the time to contact me.

Yes, I’ve found both these resources. If you are interested, you can follow my adventures here:

Thank you again.

1 Like
11

Hi Nello,

I want to back up the train a little bit. You mention “…to import transactions into Quicken without using Intuit’s servers…”.

I could write up a response but it will be faster if we talk via phone or Facetime.

I’m in Southern Calif in Orange county and retired so I’m here all day most days. I’m a nite owl and the evening w/b be a good time to talk.

I think you misunderstanding about how all the accounting apps import user financial data.

please call. Regards. Mike Noonan

12

It turns out that importing a Mint CSV (imposter) into Quicken does not solve my problem because this Quicken import feature is designed to be for moving from Mint → Quicken, not for repeatedly loading transactions into Quicken.

I apologize for whatever wild goose chase I sent anyone on as a result of my misunderstanding.

Thank you for your help.

13

I found several applications with the name CSV2OFX,

Python

Java

14

It was from ProperSoft, which have replaced it with their new app. Convert CSV/XLS/XLSX to OFX - CSV2OFX - ProperSoft

I have no idea about those other apps that you linked.

15

Rather than wrestle with converting a .csv → .oxf, I’m just going to switch credit cards to one that makes .qfx downloads available.

Problem solved, along with several collateral benefits.

I just posted my discoveries in order to help someone else following in my miserable path.

1 Like
16

Right, I’m having the same issue with Discover Card. Their customer service claims that QFX is a proprietary format owned by Quicken so they can’t use it and must instead go through Quicken online. I don’t use Quicken. I have a few other credit cards that all use QFX, and there is also OFX, an open standard, anyway. So, I just don’t use the Discover Card anymore. Their loss, not mine.

17

Hey folks, here is my situation.

I have historically used Quicken. But when I switched from pc to mac, quicken was not cutting it. I tried a few alternatives and finally landed with Banktivity, which is OK.

Anyways, while helping a family member with a huge court case, I had to pull all her banking transactions for every bank 3 years - DONE. Since I have it in excel I want to get her on a financial program (quicken or Banktivity).

I’m struggling with finding a converter tool. Yes there is proper soft which as mentioned is pricey. I only need this ONE time then i’m done. I guess I could get the monthly then cancel after conversion.

Just wondering if there are any realistic and not as costly (free better) conversation tools. Banktivity will accept the basic ones (gif, webconnect).

Thoughts?

18

Did you read my (several) posts in this Topic about importing csv into Mint and then transferring to Quicken? (This wasn’t a solution for me because it is a complete transfer—not a sync—but it sounds perfect for your one-time conversion.)

19

I saw it but as I didn’t have mint, i may have glossed over it. I will take a look at assuming mint.com or the app Mint - Thanks

20

Even better, the version of Banktivity I use does support csv as an import file. Of course I will have to figure out the mapping etc. This could be a great option - create 3 new banks (for her) import then export out as a qfx qif etc

21

Does Banktivity EXPORT a CSV file? If so, export a few transactions and then compare the mapping.

22

Apparently doing the mapping in ver 5 was pretty easy, just select from a dropdown list.

23

I tried it out with one transaction. The import overall went well. The category field from csv did NOT come into Banktivity (despite checking that one as to be brought in)

24

I heard back from Banktivity. The reason my categories did not pull in with csv import was that they need to be added ahead of time (manually).

This is a JOKE as I have hundreds or more transactions. To add each category manually first in insane. They said there is a request to add this feature, but i’m not holding my breath.

I guess my only option is to pay for proper soft (monthly), convert and then cancel.

Wish there was another (easy and sure free (it not cheaper)) way to do this. I don’t need this re-occuring

25

Did you try importing your .csv file(s) into Mint (and then exporting your entire Mint account to a .csv file, which can be transferred into Quicken)?

26

mint the app or mint.com?? - i dont have an acct there. Kinda hate having accounts all over the place if i’m not going to use them

Will re-look into that THANKS