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!
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.
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.
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 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.
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