US Banks That Offer Transaction History?
wirelessdreamer writes "I use a bank in the US that will only allow me to download transaction history in CSV for the previous three months. I have a hard time remembering to pull my transaction history down every three months, and would gladly jump ship to another bank if there is one that lets me download, say three years' worth of transaction history as one of the standard services. Then I can import my data into MySQL and run some reports on it, which is all I'm looking for." What banks out there do the best job at providing users with simple, downloadable data?
offers what seems to be unlimited download of transaction history. I pulled 2 years worth a few months ago.
Digital Federal Credit Union seems to let one pull for as long as they have been a member. And they have multiple formats!
My credit union LFCU lets you pull down up to 16 months of statements....
I just tested it, and their download form let me put in my own start/ending ranges (tried three year's worth) and it worked. It's also just a great bank in general.
Move to a service such as Yodlee or mint
If you are stupid enough to bank with Wells Fargo, they offer up to 18 months of history in 2 Quicken formats, 3 Microsoft Money formats, and CSV.
My credit union offers indefinite date range in those 3 formats as well.
There's no reason for *anybody* except for the absolute wealthiest to use banks. Use a credit union. Most credit unions provide much better service (including more than 3 months' transaction history).
I don't respond to AC's.
Mint.com is pretty great for connecting to whatever bank you have and it'll download your reports and also automatic categorization. I have almost 2 years of data in it, and they let you download it all CSV. It also has me in the habit of checking all of my accounts once a week, by just logging onto one website. Nice way to be on top of anything that might be fraudulent.
See subject
Security is the reason why you can't have an automated script downloading your data like that. My bank has three layers of security on their website: multi-band authentication via password, personal knowledge question and verification by displaying the personalized image and keyphrase I chose.
Keeps 90 days of history and offers a quicken format dump.
My Canadian bank offers 3 months worth of records on line as well.
If you want a Canadian bank that offers full history records for free, PC Financial will serve your needs (and almost never charge you a service fee, to boot!)
It's better to vote for what you want and not get it than to vote for what you don't want and get it.
- E. Debs
You could also import your transaction history into Mint.com. Once you have it linked to your bank's account, Mint will automatically grab the latest transactions any time you log in.
Bank of America has 1 year of transactions available online. You can download in various formats.
WEB Connect for Quicken 2007 and above, Statement Download for Money 2007 and above, Managing Your Money - QIF file (2 digit)
, Quicken and Microsoft Money - QIF file (4 digit), Microsoft Excel Format, Printable Text Format.
In addition, some local banks may also offer up to 1 year worth of items online and various download formats. Just call them and ask for a demo or specifically ask about amount of months and what formats are available.
I'll concur on USAA. USAA is an outgrowth of what used to be a set of support services for active and retired military personal and their families. They have turned into a full fledged financial & banking services company and most of their services are now available to the average non-military joe. It's branchless banking at its best.
Really excellent service, and if you need to talk with someone you can get them on the phone without having to wait more than 60 seconds... and you are talking to an American who speaks understandable english :-). USAA does very little, if any, outsourcing.
All the various account types are tied together into the web interface and very nicely integrated. Credit card, savings, checking, brokerage, bill pay, etc. They don't glitz up the interface... it works smoothly and it works well.
I personally put as many of my purchases as possible on my credit card, which I pay off every month, and get a paper record. That gives me a nearly full record for my spending.
-Me-
I use both Bank of America's online 'my portfolio' and Mint.com to track my long-term finances. Both allow you to connect to different accounts, there are built-in reports, budgeting, cool charts and graphs, and 'net worth' features.
I think BoA's service doesn't seem to reach back in time as far as Mint.
"Sometimes, I think Trent just needs a cup of hot chocolate and a blankie." -Tori Amos on Nine Inch Nails
Quickbooks now allows you to download transactions, semi-automatically (you have to go through them and edit them, in some cases, so you know what was the transaction was for. Then, export the data from Quickbooks for further analysis. Ever since Quickbooks added the "download transactions" functionality, my bank accounts are NEVER out of balance in my records, monthly reconciliation typically takes me 3-5 minutes/month/account, and (because I use "Memo" fields extensively), I can always search for a particular transaction.
Yes, this is how banks should do it... It would be a nice feature for one that would offer it.
-- these are only opinions and they might not be mine.
Wells Fargo lets you download up to 1.5 years as a CSV (also Quicken and Microsoft Money formats, for what they're worth).
It lets you download PDFs of statements for the past 7 years.
When I first wrote Beancount (http://furius.ca/beancount) I wanted to reconstruct up to 7 years of history for some of my accounts. I ended up using PDF statements where I could get them, and entering some of the missing statements manually. If you have PDFs, cut-n-pasting into Emacs and massaging the entries to fit Ledger/Beancount's input syntax manually is possible (though a bit time-consuming). I created macros to help the task, it wasn't crazy.
If you use a double-entry accounting system like this, it'll save you so much hassle that you won't have to remember to reconcile: you'll just *want* to reconcile more often than you actually need to. It's really cool to know where the pennies are going.
One of them gave me a stack of post-dated checks on which I highlighted the date to avoid confusion and even went so far as to confirm the teller knew they were post-dated
I would love to hear your thoughts on how this could have been prevented from our end.
Not giving post dated checks to the bank?
Flappinbooger isn't my real name