Doing my taxes this year, I find it amazing how incompetent most financial software is (including Quicken).
For example, take a simple task: download all your financial data for the last year. Log into your bank's site. There is no button for "last year". You have to laboriously enter 01/01/2015..12/31/2015. Then you're given a choice of formats. Download ALL of them, because sure as shootin', Quicken will only import one of them, and that's one is different for every different account! (Stunningly stoopid.)
Then try to get the statements, just try, my pretty. There is no "get me all the statements from last year." Nope. You download them one at a time, and some of them download to the same file name! So it's clicking around, then rename the file to "January 2015", then repeat for the next one, etc.
Oh, you wanted the tax 1099 forms? That's a whole 'nuther section on the web site.
Buy anything from Paypal? This is the killer. Paypal lists the payee as "Bob". Your credit card statement lists the payee for the same transaction as "Carol". The credit card downloaded data file lists the payee as "Ted". And, Quicken somehow calls it "Alice". Can you believe it in 2016? Naturally, you cannot download the full information about the transaction anyway. Download the CSV file, and Paypal randomly leaves out information you have to manually edit back in, like the item description which appears on the web site but not in the CSV data.
And why does my bank list the payee for a check as "Check 236"? The bank knows who the money got sent too. It's all on a computer.
What gets me is when I see software designed this way and then start imagining how much money was spent developing it, and fellow software architects sitting back with their arms folded staring at the screen thinking what a good job they did.
Every year I call up one or two of their tech support numbers, and suggest they add a button labeled "download everything I need to give to my accountant for the last tax year." Every year they are astonished at this suggestion, say what a great idea it is, and next year nothing has improved.
Am I really such a unique snowflake that nobody else even thinks of this?
Maybe I should patent it. It's obviously not obvious!
There's no incentive, but you should probably really be pushing the Accountants of (Country) professional org (or whatever it's called) to support this.
They could register a branding for compatible download systems.
The thing is different people have different tax needs. Some people have very tax filings while others are very complex and some things can't be downloaded at all. It would be great but it's just not possible. FYI I work in a related field and I can tell you some tax filings are complicated!
Also not every source generates valid data files :(
Just because it's difficult to handle 100% of use cases doesn't mean you can't easily solved 80% of use cases. The suggestion the parent and grandparent comments are making is simply to add a button which combines the previous year's statements (understanding that not everyone's fiscal year matches the calendar year) with all the documents that are already in a separate section named "tax documents" into a single download. More generally, they're just suggesting things like naming the file for January's statement as e.g. "2016-january-statement.pdf" instead of the same generic name as every other month's statements.
Saying that those suggestions aren't valuable or worthwhile just because 100% of use cases can't be accounted for probably isn't the best way of deciding which features should be implemented (and if it were, then it seems like most of their current features should have never been built since they rarely seem to handle even 80% of use cases).
My brokerage account allows me to search for statements and then check off the ones I want to generate a PDF for, they then get combined into a single PDF. Of the three banks I deal with it was the only one with this feature made catching up on my statements so much easier.
It certainly is possible because every banking site has a fixed set of downloads for a particular year. There's no problem at all putting them in a zip file and making that available for download.
For example, for a checking account there are:
1. The monthly statements
2. The transaction data in CSV, QIF, QXF formats
3. The tax filings (1099)
4. Overdraft notices, safe box bills
Collecting the data can be automated. Classifying it, not so. I.e. what is a business expense, what is not, etc., all require knowledge that is not reasonably available to the computer until a human classifies it.
For example, I fill up at a gas station. Is that for a business purpose, or not? The computer cannot know. An awful lot of such decisions need to be made.
"staring at the screen thinking what a good job they did."
Do you work in programming in anything other than greenfield projects?
I'm sure they weren't nodding in smug pride, but weeping and drinking themselves into a stupor many nights, and sometimes during the workday. They know. At least, the better of them know.
I remember our bank changing our account type (Number stayed the same, they just changed the fee structure) so they expunged all our transaction history from the site, we could only request paper copies be sent out.
I ended up scanning them all, writing a script that split the images up and OCR'd them, then formatted them correctly into and importable format in a single file. It turned out to be much faster and easier than the CSV data provided by the bank (Actually having transaction descriptions on your imports helps!). So much so that for the next couple of years instead of getting the CSVs from the bank, I got PDF copies of our paper statements and fed them into the same script.
If only there was a web plugin or some other web client software that could login to your bank account for you and fetch everything you want, in convenient formats, with nice labels. It would support the weird interfaces of thousands of different banks (and PayPal)...
GNUCash supports QFX and OFX, but banks seem unprepared to actually support an API endpoint like that. End result: Mint and whatever systems my retirement funds started using to 'plan your retirement' ask for username and passwords to other accounts. A rare few banks allow for OAuth style read-only tokens, but it's not like my 403b is selected based on security principles.
Just wait until the payee has a comma or a quote in the name and you download a CSV and the programmers can't even properly format a CSV and it's broken in Excel.
That's especially aggravating because the IRS can audit your return going back 3 years. And you're right, it's a trivial amount of data to store.
I had a lot of trouble with Paypal because it kept insisting that the transaction data I requested was "too large" for it to handle. It was about 40k of data, less than the web page it served telling me that.
Oh, they store it, you just have to pay extra for a complete record. In a more perfect world, this is because it takes effort to retrieve your history from offline storage.
If there was one piece of desktop software that I think the world definitely needs an alternative for it's Quicken. I've got about 15 years of my financial life in my Quicken file, and I probably have used the software at least twice a week, religiously, during that time period. I've grown so dependent on it in a way I've never grown dependent on any other software. If it were to stop functioning tomorrow, I'd be screwed.
It's funny because I'm sure I don't even use like 95% of Quicken. I don't use the budget, or the bill paying, or the charts and reports, or the tax crap, or the retirement planning or all the other various bells and whistles Intuit has decided to bolt on to its vast menu structure over the years. I use it as a checkbook register and as a way to plan the month so I don't overdraw my checking account (which would probably happen monthly if I didn't have Quicken), and to download credit card transactions weekly to watch for fraud. That's it. Surely those two functions are the MVP for any alternative.
There is no way in hell I am going to upload 15 years of financial history to "the cloud". Not a snowball's chance in hell. And yes, I've tried GnuCash. It's just not as good. Clunky UI, double-entry accounting, Yuck.
I use Moneydance for my business, and I like it quite a bit. It's geared towards personal finance more than small business, and the double-entry accounting stays out of the way if you want it to, though it was a selling point for me. It has some functionality to auto-download bank/CC statements, but none of my banks are supported (except for US Bank which charges), so I download and import monthly, which isn't that big of a hassle.
Me, too! Moneydance is stable (no UI churn) and effective. I was able to import all my Quicken transactions and I can do online banking (downloading transactions).
The day I got off Quicken was a very good day for me. I had developed real hatred of the software and the company.
What is super sensitive that you couldn't export to something like Mint? They don't store your account numbers on their cloud after you've completed the link.
It doesn't work like Quicken. It's too limited. Won't prevent you from bouncing a check, for one.
I keep my Quicken files on Dropbox so they sync just fine. I am also protected from data loss due to versioning. I also like the idea that the company storing the data is separate from the company that makes the software, so I can be assured that my accounts cannot be data-mined and everything works exactly the way I want it to.
> I use it as a checkbook register and as a way to plan the month so I don't overdraw my checking account (which would probably happen monthly if I didn't have Quicken)
Why are you running your financial life so close to the edge? Keep two months' spending as buffer in your checking account. That's what I do. The mental load saved of not having to worry about overdrawing my account is completely worth it.
I've also used both, and I agree: Quicken sucks. The easiest way to explain the difference in fundamental approach between Quicken and YNAB is this: Quicken looks backward, and YNAB looks forward.
Same reasoning here. Like my financial data local. I also use own toolset using ledger cli for reporting and entry. People developed tools to convert CSV from banks to ledger format.
Using text only and my own toolchain I can setup how I want. Get reporting how I want it. You just need some time for the initial startup.
I'm just not going to put all of my financial records in once place under one vendor in the cloud. On the other hand, I'm not going to trust Quicken after years of neglect and no sane way of getting my data out.
I used GnuCash for a few years, and was generally satisfied with many parts of it, yet it was horribly broken in some ways. And it isn't easy to get data out, even though it can use a native XML storage format.
These days I'm forcing myself to use Ledger http://ledger-cli.org/ The UI is essentially the UI of your favorite text editor (with all the efficiencies and pain that entails), but no one can argue that your data is held hostage! It's a text file!
Re: Getting your data out, Quicken has supported OFX and CSV import/export since at least the 90's, and it's enough of an industry standard that any other place you take your data will support the same.
I'm curious how you are organizing your data. Do you have one file per account (checking, credit card) or is it all in one big file? I've looked at ledger a few times and get a little overwhelmed, part of it though is because Quicken is so easy since it downloads everything.
From what I've heard, the Quicken team is already pretty trim. It's just not growing and not in the cloud, so it doesn't align with Intuit's overall goals. The private equity basically just bought a discount annuity.
FWIW, they didn't reveal the terms, but they did say that they expected around $500m from all three divestitures, and Quickbase and Demandforce are bigger.
Intuit holds an annual internal developer conference (CTOF) and it appeared that the contingent from Quicken all sat at one lunch table. Probably between 10-20 devs, though I guess it's possible some didn't attend.
Intuit has squandered the Quicken brand for years with lousy updates and even worse customer support. In some respects it's good to see them sell it to someone who might do something with it.
Unfortunately, the Quicken name is now so tarnished that the private equity firm likely has one swing at a decent update. Anything less than a homerun and they might as well shut it down.
I work at a PE-owned company (over 20 years in PE ownership now) and the strategy is to seek growth, not to cut costs by shedding headcount.
Caveats:
1. This is anecdotal evidence, and many PE firms actually do buy companies with the intention of firing people.
2. I don't know whether this is the most common activity or just generates the most press/attention. I would be pretty interested in a statistic that looks at PE company acquisitions and compares company headcount at entry and exit.
Interesting. I wonder if this is the start of a pattern of desktop companies who have converted to SaaS ditching their origins. It makes sense that there is residual value, and the current owners don't want to be distracted.
If the SaaS companies are dumping their desktop offerings, who is buying them? Like you, I'm wondering if this really is a pattern, but it sounds interesting.
On a Mac, the only software I've been able to migrate to is Banktivity (formerly iBank). The migration wasn't perfect but I eventually successfully ported over more than a decade of transactions including investments.
Every once in a while I look into gnucash or ledger but so far I've always run out of steam before I've been able to ensure that they'd truly give me feature parity for the features I care about.
At any rate though, it is a joy to not be using Quicken anymore.
Very interesting. Mint must of been making, a um, mint for inuit. I was always skeptical it was a big money maker for them. This move tells me it is far more profitable.
You're very correct but not in the way you might think. They are reselling the consumer spending data (timestamps, store/merchant, dollar amounts, demographics about the consumer, etc) to hedge funds, investment banks, and as competitive intelligence to other companies.
Imagine detailed consumer spending for Home Depot & Lowe's for the past few years broken down by market, average purchase size, frequency, churn rate, loyalty, demographics of consumer, financial position of consumer, credit scores, et al. That's huge if you're investing in either company or if you are either company and you want to know how your competition is faring, marketing spend, expansion decisions, etc.
In their earnings they only show direct Mint.com revenue (affiliate traffic from signing up for credit cards, bank accounts, mortgages, etc) which is extremely small compared to the data intelligence. The rest probably shows up in "data services" or something vague.
I'd wager acquiring mint was one of their worst decisions ever. A product that's losing popularity year after year and a pain to maintain technically too. Wouldn't be surprised if they shutdown the product in a year.
Some of my credit card accounts have started to do that automatically and for free. Discover card even includes a nice little graph of my FICO score over the last year with each statement.
Quicken is good when it works with your bank, I have a bank that doesn't work with Quicken and only exports to an older Quicken file format that is no longer supported.
I remember when Microsoft Money was Sun downed, I thought Quicken had beaten them. But it seems Inuit still has financial problems and sold Quicken.
Thank You!! This is the best news I heard all day. I loved MS Money and only moved away because I thought it was inevitable. I didn't know about this option.
CSV files are good, but sometimes they contain blank data and spaces that mess up importing them. I used to work as a federal contractor importing text files into databases by downloading them via FTP or Web Sites on a federal Intranet.
I would import them into Oracle, SQL Server, MS-Access, Clipper, etc and sometimes had to write a custom program to import the files.
I would work in a Unix environment as well and had to run AWK and SED to remove blank spaces and other problems that would cause invalid use of null errors in a database that the column couldn't be null. Sometimes the CSV file didn't follow the database validation rules, like using text in a number field, etc.
We also had fixed width files. Stuff from an IBM Mainframe that was in EPISODIC that had to be converted to ASCII. Then when it converted some of the characters in the file had to be edited because they were illegal control characters that had something to do with DASD JCL/JECL control codes.
But a CSV file is basically one database table with a bunch of columns in it that you import, separate the data with commas.
I'm drawing a blank on the normalization that would be relevant for transactions. Do you mean something like "the sub-sub-account determines the sub-account which determines the account"?
You find that database armatures usually store everything in one table. The professionals break things up into different tables using normalization.
For example you usually have a table with names in it and an ID, and then you have a transaction table that has the ID in it plus the transaction with a foreign key going back to the table with names in it. Could be names of each account or checking or savings account with an ID assigned to them.
Thing is you could be downloading more than one account and you don't want them mixed up into one CSV file. You want them separate in normalized tables. Now you could just have a CSV file with Account ID in it and then have a separate CSV file with the name of the account with the ID in it. But that just gets confusing.
What if you are a business and have several accounts you want to download and process? You don't want them all mixed up together. Yeah there could be sub-accounts as well that have an ID as a foreign key and then another Foreign key to the main account or sub-sub account etc. When you get into accounting and you have sub accounts and sub-sub accounts to track spending you have to have a way to figure out how they work.
I believe our bank just stopped accepting stuff from the version of quicken that my father uses to do his financials. To this day he runs quicken on a 2005 (!) iMac G5, which is his daily driver.
I'm still running it on a Mac iBook from 2004. Its the only thing I use it for because I can't stand later versions of Quicken on either the Mac or a PC. Granted, I'm only using it as a checkbook register but it does it so well, why look for something else?
Interesting that it's a management buyout. It sounds like the head of Quicken has a significant stake in this buyout. So, obviously he has some amount of confidence in the company to put his own money into it.
There is a lot of complaint about this kind of software, and I have to agree, it's often not well done. But that shows us that the money flows in different directions, right? Maybe there is a value to having a good tax guy.
My impression is Intuit worked to make sure the online pay system keep changing their protocol just to force you to upgrade to a new Quicken every 2 years. Can anyone confirm?
I think the story here is that it is much better to do business in the web space where the user pays monthly, her data is stored (locked?) in the cloud and she can be costantly upsold features. Compared to the desktop space, where the user pays a one-off price, stores her data locally and in general does not update her software.
I use it primarily because quicken on mac is completely useless when you have multiple accounts with different currencies. They even list your totals wrong like "100 USD + 100 GBP = 200 EUR" last time I tried it. And there aren't that many alternatives for personal use since i don't need anything extremely complex.
GNUcash is probably the ugliest piece of software that I use regularly, but at least it works. Depending on one's needs YNAB or Quicken might be a better choice though - but neither work well with multiple currencies or even accounts.
Perhaps I am already too old, but the idea of cloud application sucks and I hope the desktop never dies.
In my opinion the cloud should only be used to synchronize my data between my devices but it should never be the sole source of my programs. If I spend money on software then my main requirement is that I can install it locally and run it independent of the mother company.
I mean, Intuit has moved its core accounting products to the cloud a while ago as well right? I'm not sure I understand how Xero is connected to Quicken-type services.
For example, take a simple task: download all your financial data for the last year. Log into your bank's site. There is no button for "last year". You have to laboriously enter 01/01/2015..12/31/2015. Then you're given a choice of formats. Download ALL of them, because sure as shootin', Quicken will only import one of them, and that's one is different for every different account! (Stunningly stoopid.)
Then try to get the statements, just try, my pretty. There is no "get me all the statements from last year." Nope. You download them one at a time, and some of them download to the same file name! So it's clicking around, then rename the file to "January 2015", then repeat for the next one, etc.
Oh, you wanted the tax 1099 forms? That's a whole 'nuther section on the web site.
Buy anything from Paypal? This is the killer. Paypal lists the payee as "Bob". Your credit card statement lists the payee for the same transaction as "Carol". The credit card downloaded data file lists the payee as "Ted". And, Quicken somehow calls it "Alice". Can you believe it in 2016? Naturally, you cannot download the full information about the transaction anyway. Download the CSV file, and Paypal randomly leaves out information you have to manually edit back in, like the item description which appears on the web site but not in the CSV data.
And why does my bank list the payee for a check as "Check 236"? The bank knows who the money got sent too. It's all on a computer.