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?
When WaMu got bought out by Chase, we lost it all for good. Sure, they gave you some notice to back up what you could, but after that, poof, it was gone.
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 think the rule of thumb is most banks offer a few months' worth of records. My Canadian bank offers 3 months worth of records on line as well. I don't know what the practice is with other banks. But mine offers further records if I go to the branch and pay for the records. You may find that you will also need to pay for transaction records. These records may or may not be available on-line and you may only be able to get them at a branch.
Now, if you have enough money in your account (you're of sufficient high net worth) they may be able to give you better service. Then again, you wouldn't be posting the question on /. you'd already have a banking officer doing it for you!
My credit union LFCU lets you pull down up to 16 months of statements....
The right question is, "What can I do to remember to download it every month?"
What if you find a bank that has a current policy of letting you download 5 years' of history, you forget for 4 years, and they change policy to three months?
Or what if you do nothing for four years, decide to switch banks for some other equally trivial reason, forget to download even then, and then a year later need it?
You need some idiotic little reminder, a cron job if nothing else, to do it once a month. That's the real solution.
Or maybe you need to decide the data isn't really very important after all, if you can't oblige yourself by downloading once a month and don't actually use it.
Infuriate left and right
All US banks are very happy to offer many years worth of transaction history to any Federal agency that desires this information. Too bad they won't do the same for their putative "customers".
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.
I eventually got an account with Ing, they offer the entire history of your transactions, but you have to get a savings account first.
Like the "department" tag says... write a script that fetches and parses it automatically. Preferably stored on an encrypted medium on a reasonably secured box, so that your bank password isn't stored in plaintext and the chances of it getting out are minimal.
See if you can create a second user that has access to the same account, preferably with read only access - for example, up here at RIT the student financial website ("eServices") lets you create accounts for use by the benefactors of your education. I took advantage of this feature and wrote a simple two line bash script that logs in with a sub-account I made that only has enough access to read the balance of my food debit account. The purpose I plan to use it for is a little different (screenlets widget) but the methodology is the same: peek at the login form HTML (to figure out what form fields are required), play with curl until you get a proper response, and grep around for the information you need.
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.
Allows me to pull down statements including transaction histories for the past year in CSV, Quickbooks (on the merchant account), Quicken, txt, and XML. They use another company that handles their web portal, but its' pretty easy to use even if it does look like it was designed for Netscape 4. I download my statements monthly when emailed and review them. Regions also has a decent web portal as well, at least on the business side of things. I've never used them for personal banking.
That being said, I know there's a punchline there somewhere with "Transactional History" and MySQL.
"The problem with socialism is eventually you run out of other people's money" - Thatcher.
BankAtlantic, a florida bank. I never tried to download more than a month's worth before, so I just tried it. Downloaded 4 years worth with no fuss. Had the choice of OFX, QFX, QBO & CSV
I have a hard time remembering to pull my transaction history down every three months
A suggestion:
1. Find a calendar program that will remind you when it's time to do things. For example, the google calendar.
2. Program it to nag you every few weeks to download the transaction info from your bank. Make the interval short enough so that you can afford to miss one or two if you're on vacation or utterly absent-minded.
3. When it nags you to do so, download the transaction info... and back it up, of course.
Problem solved, without changing banks, or breaking a sweat.
Am I part of the core demographic for Swedish Fish?
Just write a perl script to scrape it, duh. Did you forget where you were submitting? :)
See subject
Why don't you just set up a script to read the transactions nightly?
-jcr
The only title of honor that a tyrant can grant is "Enemy of the State."
Set up a Perl script to jump through all their hoops, etc. Then set up cron or anacron to go through that once a month and validate the results.
LedgerSMB: Open source Accounting/ERP
Bank of America offers 12 months of back data, and if you can't be bothered with it for a whole year, it just isn't important is it?
Snowden and Manning are heroes.
US banks are required to keep seven years of history, so it is available to you if you really want it. It seems to me that the solution lies within developing your own routine to fetch your statements more regularly.
A bit of research would have revealed a few banks that do this. Or, asking on a more generic answer/question site would have yielded faster replies.
This is not a techy thing in the least, it's a waste of space when real and interesting issues that the slashdot community would love to discuss disappear.
Fuck this site
If you ignore ACs because they are anonymous - you're an idiot.
& they offer at least Quicken and CSV. 'Course, I can't promise said bank won't go bankrupt, get absorbed into another bank, or change their back end system, in which case your history may be lost.
My suggestion is to not let 6+ months of transactions go unaccounted for. If you've your transactions for all but the last month or 3, then most banks will let you pull the rest of the transactions.
That way, if they get bought, change their back end, or whatever, you have all, or 99% of your data.
If you have your transactions saved locally and downloaded about once a month, then it shouldn't matter that you can only get 3-6 months of transaction data.
My 2c.
I can download monthly statements going back 7 years.
I use Huntington and I just was able to download my entire transaction history since mid 2009 (When I opened the account). It took two date ranges to get it, but the information is there and available.
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.
I just downloaded 3 years of my savings account information on ingdirect to test. They offered it in CSV and two other formats (like Quicken probably, I forget specifically and already closed that tab out).
You are clearly willing to pay a little bit for this, since you don't mention any extra fees. So this sounds like a service opportunity to me.
For only $3.99/month I'll deliver your csv records to you. Just send me you account and password information. Might as well give me your social, mother's maiden name, and favorite color.
No problemo...
Keeps 90 days of history and offers a quicken format dump.
I want a bank that lets me download my transaction history and view processed checks. And most importantly, can use a security token, smart card or some form of private key/two-factor authentication. I am sick of shitty screen keyboards. If anyone knows a place that has all three, that would be better yet.
We'll be sure to make sure to download the data every month and email it to you.
Don't switch banks... get a calendar :)
http://www.automatiq.se
Seriously... has everything you'll need, including finical reports, transaction details and you know.. great rates on just about everything.
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.
I haven't had an account for long enough to test how far back they will let you download but there is no obvious limit.
USAA is pretty awesome in general so I'd recommend it anyway.
I can't imagine ever being put into this situation of having to download transaction data FROM a bank. I was taught to write down transactions as they happen and check the bank every month. Over the years I have caught them in several minor errors. I've had several hundred dollars of transactions that never posted, and even a deposit erroneously posted to my account. I rarely attempt to correct these errors on the theory that it would cost us both more to reconcile them than I got in "free" services. (What was with that Las Vegas trip, anyway?) But I did pursue that bad $300 deposit. I did a little invasion of privacy thing, found out who it was, google-earthed his address seeing it was no mansion and thought he might need that $300. It took forever to get through to a real person, but she bird-dogged it thru and got the guy's money back to him.
Today I have several years worth of transactions stored locally and backed up five ways against Sunday all reconciled against the bank records to no more than a month behind.
How about a moderation of -1 pedantic.
Of course you have to be able to live with yourself for using them.
You should be balancing your books at least once a month, so you should make downloading your history part of that. I'd also be wary of any third-party sites grabbing your info on your behalf... but I'm slightly paranoid about my data... I believe only I, and my bank, should have access to it.
WTF???????
But obviously, this post is yet more free advertising for the likes of B of A, and since they happen to own the controlling interest in Monsanto, perhaps it's simply free advert for the overlords???
I spent a career in banking in IT. None of the banks I worked for ever kept that much history online for checking or savings accounts - cost too much in storage (multiple copies) and daily processing time to justify keeping it available for the (very) occasional request. Generally archived it offsite and deleted it onsite after three statement cycles. But, for a fee, we could research activity back further than that.
You only check every three months? You either don't have enough money to worry about in the first place or you have lots of money and so little time to spend it that you forget to check your balance. On the off chance it's the latter, howz about you don't need to remember anything but ol' HD here. I can do it for you on a monthly basis and handle all yer details.
insert pithy comment here
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.
Try http://www.mint.com/ or one of the other personal financial services.
Good question. I'm old enough that I'm in the habit of downloading my info every month (i.e., part of my monthly former balance checkbook/ pay bills by hand process), so it hadn't occurred to wonder how far back it goes.
I use NYCB (New York Community Bank) here in NYC. Turns out I can download stuff from the past 6 months, and it's free. Things I'm not thrilled about with the system: (1) Got hung up when I first applied for online access because they demanded my mother's birthdate and I actually don't know it. (Friendly girls at bank laughed and said "make something up", but I'm aware of banking fine-print gotchas). (2) The online site demands a ridiculous amount of personal info, requiring a new trio of "security questions" every 3 months or so (Mom's name, dad's name, pet's name, street, college professor, best man, etc., etc. -- I just fill in random codes but now have a list 11 items long). (3) Message system spams me with sales pitch for online bill pay every 6 weeks or so.
We know where leadership by an anti-intellectual "strongman" who scapegoats minorities and likes boisterous rallies goes
Let me have your email address and I can send you a MONTHLY reminder to download your transaction CSV data. To pay for this service, all the other days I'll send you some spam.
Better yet, just give me your bank web site, account number, and password, and I'll just download the CSV for you and email it to you. I'll still need your email address, and this extended service will require two spams each day.
now we need to go OSS in diesel cars
See, the way evil big business cheats is to ensure that people don't have real option. Use Quicken or don't use banking software. This is the only way these incompetent rich kids can ever compete.
So, let me get this straight. You would consider changing banks, and going through all the pain associated with changing direct deposits, ordering new checks or a debit card, going online to change any websites you had your bills tied to your old account, all because you can't seem to manage to put a reminder in one of your 17 electronic devices to remind you to do something once every three months?
Seriously?
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
I can see back at least 2 years using Morgan Stanley Smith Barney. At the end of the year I just download everything in CSV format for my taxes. The last time I did it, it was kind of hard for me to find the CSV option on the website but I found it. I think it was called "Excel" format on the site, but it was actually CSV.
I just pulled my checking account to CSV going back to 03/2006. I'm not sure if transaction load affects how much they keep but I had 1572 transactions on that account.
I have been with FirstIB.com for over ten years and they've always been ahead of the curve.
- Pat Niemeyer
18 months back and in csv, Quickbooks etc.
Is there some reason why your bank offers such a poor history of your transactions? It's not like it's hard for them to implement, several years of history for the average customer should be no more than a few hundred KB using decent compression so storage and retrieval shouldn't be an issue.
My bank, Nat West (UK) provides me with 7 years of transactions online which I can easily copy and paste into a spreadsheet. They're obliged to keep 6 years' worth and even if your bank doesn't make them available online, you can demand that they send them to you if you make a request under the Data Protection Act and pay a fee of £10.
For all intensive porpoises your a bunch of rediculous loosers
This is your make or break bank feature? Just don't be lazy and check it once a month. I do mine via Quicken about every weekend to two weeks, just 'cos. It takes about 5 minutes, and I have transactions going back to 2001. Easy peasy. (substitute your program of choice to do the same exact thing)
I've been using Yodlee for years and I love this free service.
So now that we know where you all bank, onto the next set of questions...
1. What password scheme do you use?
2. What hobbies do you enjoy (so those extra transactions won't be questioned)
3. Profit!!!
...to set a calendar reminder every 3 months to go download his transaction log, well then, there's no hope for him to begin with.
Answer the man's question, or don't post at all.
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.
The origin of the word "check": "a token used to check against loss or theft" (surviving in hat check) and "a check against forgery or alteration," which gave the modern financial use of "bank check, money draft"
The idea of waiting for your bank to tell you what you've done is backwards.
You're supposed to keep a record of what you've done to keep the bank/anyone else from cheating you.
You're basically waiting for a third party to forward your server logs to you and complaining about the log format, but still assuming they're accurate.
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.
Those are the three banks I use, and all three are different. USBank is only 90 days, Schwab is two years, and PNC goes back to January 2006 (provided you get online statements, otherwise it's three months). PNC also seems to have the most versatile export utility - it can export data in Quicken, Quickbooks, MS Money, or CSV formats, though I've never used any but CSV. Schwab only uses CSV.
Three months is plenty! Set up a calendar app to REMIND you to do the download. Set the reminder monthly. Do it when you pay your bills for crying out loud.
Look, I KNOW it is hard to remember stuff like that. I'm just about the worst about it having forgotten my own birthday more than twice. (And it's not like my birthday is hard to remember -- it's the first of a month!) But since I got a Blackberry and started setting calendar entries for important things and reminders, I've been much better off. I'm not using an Android phone but it's the same deal. I can only remember things when I don't need to. So I use that time to put the reminder in my calendar which then reminds me on time.
Don't look for a bank that will enable your weakness. Look for something to help against your weakness.
Try Google Calendar. It'll even send you an email reminder.
If you've got a longstanding relationship with a bank, and they've been doing a good job but the only problem is you can't remember to download your transaction history every three months, it seems to me it would be easier just to get a reminder every three months to press the little button that downloads the transactions.
Being with the same bank for a while can be useful when you're trying to get a loan for a house or business.
I use a small community bank, and I've been using it for a good long while. I've got personal and business accounts with them. It's now to the point where they'll give me loans or services that the big banks wouldn't even consider. They know me, they know I'm a good customer. I bet if I asked them, they'd put my transaction history on a thumb drive for me any time I want.
And you should be dealing with smaller local banks or credit unions if possible anyway. With all the consolidation, it's more important than ever that we have neighborhood banks where you can talk to the president and they actually care about your business. In my experience (I used to have my business account with Chase) a small local bank is much less likely to screw you than a big bank, and they're much more likely to help you. Just take the time to learn if they're well-capitalized before you give them your business.
You are welcome on my lawn.
How about, instead of expecting the world to cater to your deficiencies, managing to take responsibility for yourself and remember to do the things you're supposed to do?
Does there exist a bank yet that SUPPORTS data access? I know banksimple is coming with theirs, (http://www.banksimple.com/api/), but they are invite only still. That's probably the better solution.
My bank is similar when it comes to CSV/QIF/OFX files, only 90 days of history. But they have years of online statements in pdf format. Recently I got behind on my imports, and found that pdftotext and a little perl was all I needed to create .qifs from the pdf statements. .csv should be easier.
Give mint.com your bank info, they download and store the transaction history for you, and from there you can download it when ever you want.
Anchor Bank does it but I think they're primarily only in like 2 states. But their internet banking is amazing. It's even semi-AI when it comes to determining abnormal/suspicious login behaviour. And they let you download multiple formats of history for any date range.
Google's Super Secret Search Algorithm: SELECT @search_results FROM internet WHERE @search_results = 'good'
Then I can import my [banking] data into MySQL and run some reports on it
You must be a hit with the ladies
In particular because even if you switch, who's to say that bank doesn't change their policies? Maybe you go to a bank that currently maintains 10 years of records. However they audit things and find out nobody accesses anything older than a year. So to save space they archive everything over a year old to tape and take it offline. If you were relying on it you are now SOL and probably have to pay them a fee to get the tapes and drag up your old data (banks almost always have it and can get you a copy, it can just cost a fee to do so).
As a practical matter if you think the data is important enough to keep for years, it should also be important enough to check multiple times per month. I don't keep my data, my bank keeps a years wort of records and that is plenty for me. However I still log in probably 10 times a month to review it. Why? Because if I found an error 10 years ago, it is too late. I can't get it fixed. However if I find an error from 3 days ago, I can have that cleaned up right away.
So if you actually care about your accounts, log in often. When you do log in, nab the data. If you can't be bothered to log in more than once every few months, don't bother saving the data because it is useless. You have no need to know what you charged to your Visa in 2000. You need to know what you charged to your Visa last week.
...remembering to do it yourself is the best option. I'm not going to tell you how to manage your finances, but if you can go so much as three months without knowing any of your account history, it probably isn't that valuable to you. I recommend keeping a running ledger (JGnash2 can do it for you, and it has pre-defined queries you can run on it in ways that will far exceed a simple MySQL database unless you categorize your transations--which, given your rate of downloading, is fairly unlikely).
Or, as others have suggested, set a reminder for yourself, if nothing else.
R.Mo
Maybe because they like their bank? Seriously, if you have a Credit Union you like that's great, but people have banks they like too. This idea that banks are mean to all their customers is just false. Many of us have accounts with banks we like. Why go through the trouble of switching, if you are happy with what you have and can't see benefits to a new service?
What's more, the idea that all Credit Unions provide better service is false. Some may, but not all. In particular I've found Credit Unions often fall behind features wise. My bank was doing the online banking thing a long time ago, back before such a thing was common. At the time, no credit unions I'd seen did it. Things just weren't online then, but my bank was. These days they offer a couple features I don't see much, if any of. One is two factor authentication, I have a little authenticator card I need to log in. It was optional, of course, but I like it. The extra security is of value to me.
So really, you should use the institution that offers what you want, regardless of the agency they pay their insurance to.
What's more, you aren't tied to one company these days. In the modern era of online banking and ACH transfers, it is easy to do business with multiple institutions. I maintain my primary checking and mortgage through my main bank because I like them and I got a good mortgage rate, however my savings are not there. They don't pay much interest on savings accounts. Neither do the local Credit Unions I looked at. ING Bank currently holds my savings, as I like their interface and they pay a pretty reasonable rate. I may change that though, American Express may get to hold it instead. In that case it would be as simple as issuing an order to transfer funds. Likewise I have credit cards from a few different banks, because they offer different features, and bonuses with merchants (like American Express for Costco because that's all the take).
You don't have to have only one institution to handle your accounts if you don't want to. For me, I find that my bank does a good job handling a checking account, so they maintain that, and they offered me a good mortgage rate and a good interface for dealing with it, so they have that too. I don't pay any fees, they don't charge me to have a checking account and I have the philosophy of "Don't spend money you don't have," so I don't pay overdraft fees or the like. In the rare cases there have been problems, they've cleared them up in a hurry.
I fail to see what isn't to like.
What bank I use? LOL. Hmm, security focus here. I needn't tell you what financial institution I use. Visit ones in your area and ask them. I don't need more scam/spam about my financial institutions password changes or what not in my mailbox, thank you. If you have a real complaint, take it up with your financial institution. I don't feel we need to advise anyone with whom to do their finances with. Don't mean to be terse. Just saying those that responded with their financial institutions name could be releasing more information than they should. The less released about you individually, the harder a target you become.
All you transactions from banks, credit cards, mortgages, investments, etc.
Yeah - they're a nerd. Why do you read Slashdot? For the pictures?
--
make install -not war
Most banks don't own the servers where the transactions take place. When I was in banking, we had ready access to three months of transactions. If we wanted something older, we had to pay to get it pulled from archives. So, they're probably offering three months, because offering more would cost them more.
They give you yearly summaries in csv, and they retain your records for 6 years online (due to trading laws).
But mint.com would be the way to go...
What is this doing on slashdot? How many slashdotters know less than three scripting languages? Wouldn't be many. I have never seen and article so full of fail.
But if you want an everyman's answer there may be no choice but to pay for the data. My bank makes 7 years available on line, it has to to compete with other banks. Trouble is it is not an American bank.
I am very happy with Patelco CU (also a tech/comms credit union). Full transaction history and they doesn't try to rob me at every opportunity! It's almost like open source banks!.... almost. Maybe we could start a credit union for open source developers?
I've been with them 14+years.
M0571y H@rml355.
Why not just try really, really hard to download your transaction history every month, then if you mis a month (or two) you can still have all your transactions?
I don't understand the mindset that can't remember to download the raw data required to do the in-depth analysis it claims it wants to do...
Ken
Wells Fargo lets you see the past 18 months of transactions on their website anytime. I've found that feature to be very helpful.
I was able to download multiple years worth of banking data, though I had to click a few extra times to get the extended download. The last three months was an easy one click. I would prefer to use a credit union, but Wells Fargo holds my mortgage, credit line and an unfortunate credit card I stopped using but am still paying off. Until my income improves and I can change my loans I'm stuck with Wells Fargo
I've been with Key for many years now. I've never had a single serious issue with them. Their online banking is excellent and allows me to download my statements as PDF in a few text formats going back for a fairly long time -- at least a year. I've had occasion to call their help line a few times over the years and have ALWAYS gotten nearly instant resolution to whatever it was.
The downside is, they do tend to be expensive in terms of fees and things -- Much less so now that I'm a little older, further along in my career, and have more than the minimum amount of money with them.
The problem with quotes on the internet, is that nobody bothers to check their veracity. -- Abraham Lincoln
This is why you stick your paper statements into a folder. "Just in case." It doesn't take much space.
Or if you insist on a tech solution, many companies will PDF + OCR all of your bills and email them to you. I assume you already back up regularly...
I think banks are required to keep statements for ten years. So they have the information somewhere. You might have to do some data entry if you forget to download. I can respect forgetting to download; I forget to pay bills, deposit checks, invoice clients, and anything to do with money because I'm insufficiently into it. You want to be rich, you gotta be like Al Davis of the Raiders. They say he knows how many rolls of toilet paper there are in the locker room at any given time. Successful businesspeople NEVER forget to download data about coin; they live for the stuff. Marry a Chinese woman; they're usually pretty sharp about money. Then your only problem will be stashing a little a way so you can eat lunch like a DC lobbyist without her knowing about it. But you need somebody who loves money in your life.
I work in IT for small local bank (5 Branches) and our on-line service provides provides customers with the last 3 years of history in a wide variety of formats (including CSV). Considering our relatively tiny size, I'm surprised that there are any institutions that don't offer this level of service. But if your institution doesn't I second the recommendations of mint.com.
It's hard to believe that here is Australia, we have superior online banking to that of the US.
Our banks here offer years' worth of historical transaction downloads. I'm with the Commonwealth Bank, they don't even mail me paper statements anymore, I can download every quarterly statement as a PDF file, or CSV, for the past several years.
I can also do searches on transactions, by combination of date, description, whether debit or credit and other things. All my bills can be paid on the bank's site, via our national "BPay" system.
And you're saying that, in the US, banks won't even let you access your own financial data? That should be a legal requirement. But the US does have a fascination with deregulation, so there you go.
Companies can charge reasonable fees to the government for complying with subpoenas. When they are against you, like you are being investigated for the wrong doing usually not, but when you are just a party who's information they need then usually they'll pay. That's one of the reasons they want an easy system for wiretaps and so on, not just that they like doing them but that phone companies can charge a reasonable fee. Well if a wiretap was all manual, like an employee manually hooking up an impedance tap to a line (it isn't but just saying) then the phone company would charge a lot more than if it is just pushing a button.
So ya, the bank probably charges them too since the process involved is probably the same: An employee has to go get in to the archives, maybe physical, maybe tape, and pull the data needed.
Theres mint.com which consolidates different accounts, but you have to give the site you online banking password which is kind of sketchy
My current main account is less than 90 days old, so even though the date-range function on their site is open-ended and you can download the search results as CSVs, I thus can't tell you much. :)
Or go low-tech and stockpile the paper statements.
If you want to go low-tech and high-tech at the same time, play around with OCR?
I listen to both RIAA and non-RIAA stuff if I like the music, tangential business/politics nonwithstanding.
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.
I use the tellers anyway, especially since I like going in the branch to check for any $2 bill stockpiles. And is more convenient to ask a proper bank for change (if I'm there already), instead of $dinky_convenience_store
I listen to both RIAA and non-RIAA stuff if I like the music, tangential business/politics nonwithstanding.
I do business with three different banks. All of them offer me the option of waiving the paper statements. In exchange for this they agree to make my electronic statements available to me for a year. If you cannot remember to download your statements at least once per year, perhaps you should have a conservator manage your finances for you.
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.
Awesome.
I have low activity in my account, and so I thought everything was on track. A week later I got hit with an NSF fee when I was paying off my monthly credit card balance. The reason? The issuing bank "uncleared" my deposited check once they got the original delivered to them. They were pissed off about the endorsement on the back of the check. Everything was in order, they were just being pricks.
To recap:
Hell, I have also been hit by an NSF fee when I attempted to ACH transfer funds from a bank account that had sufficient funds to cover the transfer. The reason? The FDIC had swooped in that day and taken over the source bank.
God bless the fucking government... they clawed back my ACH (ie. after it had already gone through) in order to issue me a paper check for the amount of the ACH plus the remaining $100 in the account. WTF, you stupid bureaucrats? I feel so much more secure about our banking system knowing that these tools stand behind our institutions.
In all candor: does anyone know of an actual brick and mortar banking institution that I can use that is not a member of the FDIC or NCUA? I prefer to keep the government out of my life as much as possible, but sadly I doubt that there is any way to avoid these damn agencies while continuing to use a banking institution.
I just did a blog post after hitting this problem.
http://johnsokol.blogspot.com/2010/09/converting-qif-to-text.html
I just want my data in something really simple format such as comma delimited.
I can copy and paste off the HTML and it's a mess. Or get my data in several formats that all require some Windows GUI based applications that you must pay for. Maybe there is something open source, but I just want a comma delimited file or just plain text even.
In my post I show a simple shell script that uses sed to flatten out a QIF file so i can use grep and awk to extract and sum data, such as how much I spent at Mc Donalds for the past year.
I am always doing that which I can not do, in order that I may learn how to do it. - Pablo Picasso
I feel sorry for You, people living in the USA. Here in Estonia I can get a CSV file of my transactions for no cost and for the last 10 years. Maybe longer but I have been a client of my bank for the last ten years. The file is downloadable from the banks website. Also nowadays the only reasons to go to the physical bank are these:
* You need to sign the a contract but you don't have an ID card (which has your signing keys)
* You need to exchange currency
* You need to pickup your debit/credit card
My bank emails me transaction history in PDF once every month, quarter and year. I could enable every week too, but that seems unnecessary. Seems easy enough to do simple calculations or to generate reports as each statement has a summary. I'm in India though :P All the best finding a bank in the US who would offer you this.
You could consider bringing your money to Switzerland. Most banks there will allow you to access your transaction history for several years. They also offer Internet access and let you save on postage.
Disclaimer: IANAL, this is no legal or financial advice, in this course also consider a fanciful tar and feathers treatment from your community or even burning at the stake for being Un-American.
I hadn't the slightest objection to his spending his time planning massacres for the bourgeoisie... (P.G. Wodehouse)
The ING bank in The Netherlands provides their customers the history up to 5 years back in CSV format.
What Bank will give you back ATM fees charged by other banks 2x a month?
My current credit union (Pacific Service CU) does. I also can deposit at some bank ATM locations and all network credit union ATMs. It's nice not having to search for a Wells Fargo or WAMU ATM.
Make sure everyone's vote counts: Verified Voting
I agree with geekmux, quite thoroughly.
Chase bank seems to have the highest tech. I have seen.
They have even texted me in the morning that I was about to overdraft. I then made a cash deposit during the day and saved an overdraft fee. Can't guarantee they'll allow that in every state or circumstance, but it's spectacular.
But to answer the question:
Hmmm, it seems like they used to have a much longer transaction history, but I can only get 3 months.
Like many banks/companies, their own employees (at least some) use IE on a Wintel box, but I'll work with that, because I have full functionality on their site with Firefox. I can download Quicken, CSV or MS Money manually or through Quicken, but have to pay $10 a month if I want to schedule transactions through Quicken.
Bank Of America allowed me to go back to 2 years I think, but it was such a lousy bank overall that I closed my account.
Citibank lets me download statements from my entire history, which is 6 years so far. The only "catch" is that the last 4 months are available online at any moment, if you want older ones you click the months that you want (as many as you wish) and the next business day the links to the pdfs for those months are activated and stay on for at least a day. Also citibank has always had savings rates that were very competitive (well, right now rates are down everywhere, but for when they go up again...)
Violence is the last refuge of the incompetent. Polar Scope Align for iOS
I use E*Trade and can view monthly statements going back 7 years to when I first opened the account. I never thought of downloading the data since E*Trade has some query tools built in. Downloading is restricted to 3 month blocks, but not just the past 3 months.
NEWS FOR NERDS
any self respecting nerd should know about cron or even fucking Scheduled Tasks
get a grip, loser
There are places where the networks are not touching,and there are places where they are-Boeing's Lori Gunter
of transaction history. I've got about 5 years worth in a PostgreSQL database.
They seem to keep nearly a years worth available, I update things every couple
of months.
You will need some scripts to convert csv into sql-insertable data. Then I do
reports with OpenOffice.
i am going to trademark and copyright the word "the" and any single use of that word written or spoken requires you to pay royalties to me. Don't worry i only want $0.01 per use.
Track your finances on your own with software like grisbi -- it even lets you configure the reports your looking for.
If you enter all your receipts in to software yourself you wont have to rely on the bank to provide you with records you should already have.
Australian Banks are just as annoying. In their defense, they aren't thinking like geeks, they are thinking like Bankers (as in, there was once a material cost in looking up historical data). Banks do take time to innovate...
One of my Banks was more than happy to give me lots of historical data - except that they would stop sending me paper records. Nope - bank statements are the only paper I hold on to.
I'd love for a monthly PGP-encrypted statement to be sent to my email.
I did notice one loophole, they wouldn't supply old data in CSV format, but would supply them as "formatted" statements. (Once again, something that would only make sense to a banker.) So I got around it by copy/pasting the text, whipped it up via AWK, and output TSV. Turn out I prefer this method because it a) gives me a running balance and b) doesn't mangle date data.
I wished it was easier too.
I just checked and regions bank allowed me to pull up to 540 days... if that isn't sufficient, you should really just be using a program like quicken to download things automatically for you.
stephen
mint.com is a free financial aggregation service that will do this for you. Depending on the specificity of the reports you're looking for
Most banks offer your transactional information over the internet in a format called OFX (Open Financial Exchange). This is what Quicken et al use to download transactions into their software. I imagine you should be able to make the OFX connection yourself and download the data you wish.
you don't remember what you bought?
I see no purpose in doing anything like you want other than the fact that you can.
I get up to $6 per month of ATM charges rebated at my bank (First IB).
I bank with Pinnacle. I can download my history from since I opened my account.
I use Mint.com -- I took this directly from the site. "We download and categorize your balances and transactions automatically every day— making it effortless to see graphs of your spending, income, balances, and net worth." Id say its worth checking out if you havent done so already.
I'll bet they know which bank is the best to get data from.
use mint.com , have you transaction history stored indefenitely
Perhaps my bank is unique, but all I did was ask customer service for just such a file, and they gave it to me. Yes, I actually had to get off my butt and go to the branch and ask for it (and identify myself), but I'm kind of glad that no one, including me, is able to easily download my entire banking history.
Proverbs 21:19
US Bank sends you front and back copies of your checks with each statement.
Etrade online banking stores and lets you access years of your own transaction data. Very, very good UI also, and they refund ATM fees. I've used them for around 5 years.
Only drawback is that you need to mail in physical checks that you want to deposit. Wouldn't surprise me if they allowed you to deposit via camera phone pic soon though, like some other banks.
see: http://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings
It shouldn't be too difficult to set up a cron job which imports your data via aqbanking. You should be able to get by without Gnucash, but aqbanking will be your friend here.
Bank of America
Chase (and before that Wamu)
Wells Fargo
I've had accounts with these three over the past 5 years and I've always been able to go back at least a year and get a .pdf (at minimum).
Quicken Use it to balance your accounts monthly. You will have an infinite transaction history because it has downloaded the latest transactions. I'm no money manager but if you're not doing some kind of reconciliation of your accounts on a regular basis, then you don't seem to be as concerned about your transactions as the question appears to be. If you're doing it manually, switch to use Quicken or a similar program and do it electronically and you'll get the transaction record you're looking for.
I use Citibank, which collects all your accounts on one page. Going back about a year is very easy, and you get PDFs of the front and back of all checks. However, you get only payee and amounts of credit card transactions. Getting older transactions requires repeatedly clicking "show more" links, and anything more than a couple of years old requires an email request, which takes between one and two days. Their tech service is very good, particularly at the first escalation level.
That's baloney -- as it *requires* that he DO something whenever some date comes up and says "time for you to hop to their tune!". What about a bank that hops to your tune? Are you a customer or a puppet?
Admittedly, a good turnkey solution to download the material automatically to the customer's computer might be good, but what happens when the customer's computer crashes? Functional, complete and tested home backups are rare for home users of any sort, let alone non-tech types.
I don't see why they shouldn't be able to allow downloading of complete account history *these days*, or for as long as such information is required to be kept by federal or local law, which is probably a long time these days -- alot more than three months, that's for certain.
I'm looking for one that does easy to use virtual debit cards, now that paypal stopped doing it. discover does, but they're harder to use, especially closing them after you've used them (which is the whole point, after all). Unfortunately, neither of my credit unions offers the service.
Why kep using a bank in USA ?
why not open an account at a Swiss bank ?
They have very good archives (if you suddenly feel like you need to run stats over the past 3 years)
and are much less eager to sell your private/personnal data to governments (due to swiss law about banks secrecy).
also, the EC / Maestro system used for debit cards works at least all over europe (in my experience) and should probably work in the USA too (haven't tested recently).
"Sufficiently advanced satire is indistinguishable from reality." - [Tips: 1DrYakQDKCQ6y52z6QbnkxHXAocMZJE61o ]
Schwab Investor Checking accounts refund third-party ATM fees at the end of every month. Domestic and international, and they don't charge conversion fees when using non-US ATMs. Also, you get free checks and postage-paid envelopes for making deposits by mail. These accounts are also interest-bearing, although that doesn't count for much these days (it was 4.5% when I joined back in 2007 but dropped after the financial crash and is currently only 0.5%).
Web consulting +
Nothing substantive, but normally the merchant creates a hold (or "auth"[orization]) and then the charge "settles". Meaning you might get a $150 auth from the gas station that eventually settles as a $32.33 charge. So, with your Shell example, it would be $50 that is unavailable on the account rather than $60.
Furthermore, normally it is only merchants who don't know the exact amount of the final charge that pre-auth a large "guess". Gas stations are a prime offender, because you swipe before the fuel flows. At KFC, you swipe your card after you order. They know exactly how much money they require from you, so they auth exactly that amount.
Notwithstanding the technicalities, the scenario you describe is very feasible.
I see nothing but trolls whining about the fact that this guy doesn't want to pointlessly waste time in his impressively short life.
Seriously? You people manually download shit from your bank every two weeks? You see nothing wrong with that? Gods above and below, you could be using that time to cure cancer, or to patch a bug in the Linux kernel, or to masturbate.
To mangle a quote from xkcd, we live in a world where we have robots that can and do kill people. We have greater than encyclopedic knowledge (I doubt Britannica has lengthy articles on the Horus Heresy - thrice damned servants of Chaos!) at our fingertips, anywhere on the planet that there's a wireless connection. You can build railguns, coilguns and jetpacks on the cheap after watching short videos on YouTube.
The future is here. And you people want to waste it hunched over a keyboard, downloading CSV's.
What the hell is wrong with you?