Bank Account Quick Reference Table (Spreadsheet)
Originally posted on June 27th, 2017. Reposting on November 17th, 2017 as the spreadsheet is now completely up to date. This is one of the best resource pages on this site, so big thanks to Don for keeping it updated. ~Will
Contents
Quick Summary
Bank Account Quick Reference Spreadsheet [Link to Google Spreadsheet]
This spreadsheet can be thought of as another way to view the big DoC Bank Knowledge Base.
Reposting due to updated information, added functionality.
Spreadsheet Value
Perhaps you evaluate bank deals as they show up in your RSS reader, or use (Google) search to find them.
A spreadsheet is a nice additional tool because it allows you to sort and filter on multiple dimensions. For example, you might want to see all active, local, soft pull bank bonuses of a certain size.
You can add your own personal filter views to the spreadsheet. The following are a few sample filter views already added:
Active Filters
| Filter | Notes |
| Post Last 30 Days | Bank Bonuses posted/updated within the last 30 days |
| Not Expired (with Date) | Unexpired Bank Bonuses (not including those with unknown expiration dates) |
Credit Card Funding Filters
| Filter | Notes |
| CC Funding (Sorted) | Sorted by potential credit card funding size |
| CC Funding – Amex | Amex CC is allowed on initial account funding |
| CC Funding – Soft – Michigan | Michigan Banks that do a soft pull and accept credit funding on initial deposit. |
| CC Funding – Soft – USA v2.0 | Banks/Credit Unions available nationally that do a soft pull and accept credit card funding. (A work in progress – national availability data is not complete) |
Some More Example Filters
| Filter | Notes |
| [Location Filter] Michigan | Local and Regional Banks with a presence in Michigan. Every state has its own column. “*” indicate bonus available in only specific regions of the state. |
| [Bonus Size Filter] BB $250+ | Bank Bonuses greater than or equal to $250 |
| Hub Account Prospect | Hub Account options based on a number of dimensions |
More Details
Layout
Drill down from column headings or cells for more detail.
| Location | Description |
| Rows | One row per bank (financial institution) |
| Column Headings | Link to the consolidated bank resource page (e.g. Is Opening a Bank Account a Soft or Hard Pull?) |
| Cells | Link to a position within the bank resource page But may link directly to:
“*”s and colors attempt to highlight addition details or exceptions |
I would always recommend drilling down to the resource page:
- The spreadsheet may get out of sync with the source data (update times are shown in spreadsheet tab)
- You’ll get a sense of the quantity and quality of the data points supporting the determination
Warnings/Disclaimers
(In addition to all the standard disclaimers,) this resource is incomplete and filled with errors.
It is an attempt to summarize and categorize rules inferred from community data points.
Please share your data points and ideas to help improve the table.
Final Note
Big thanks to Will’s tireless effort to generate hundreds of bank bonus posts per year and the thousands of datapoints provided by the DoC Community.
All the best!
Related Posts
Marcus $100 Bonus for New & *Existing* Savings Customers with $10,000 Deposit (1.70% APY) →
Bank Of The West – $250 Checking Bonus [AZ, CA, CO, ID, IA, KS, MN, MO, NE, NV, NM, ND, OK, OR, SD, UT, WA, WI, WY] →
CIT Bank $100/$200 Savings Bonus + 1.8% APY – New & Existing Customers ($25,000/$50,000 Deposit Required For 90 Days) →
People’s United Bank $100 Checking Bonus – Inside Stop & Shop’s [NY, CT only] →
Latest
-
Chase Increases United Business Card Annual Fee To $99 (From ($95) & Adds 4 New Benefits (5,000 Mile Bonus, $100 Credit – Both With Requirements & More) January 23rd | by -
Chase United MileagePlus Explorer – 60,000 Miles Publicly Available (AF Waived First Year) January 23rd | by -
Chase United Business Explorer 100,000 Miles Offer ($10,000 Spend) January 23rd | by -
Amazon: Apple Airpods Pro for $235 (Potential Stack to bring down cost to $188); Other Airpods Discounted As Well January 23rd | by -
Kroger: Free Sweet Baby Ray’s Hot Sauce January 22nd | by
-
Popular Posts
-
Best Bank Account Bonuses For January, 2020
-
Best Current Credit Card Sign Up Bonuses & Offers For January, 2020
-
View Your Pre-Approved & Pre-Qualified Credit Card Offers (Updated For 2019)
-
Best High Yield Savings Accounts – up to 5% APY
-
List Of Methods Banks Count As Direct Deposits
-
Shopping Cart Trick 2020 – Get Credit Cards Without The Hard Pull
-
Bank Accounts That Can Be Funded With A Credit Card
-
Comenity Bank Credit Cards 2020: A List, Best Cards & Easiest Cards To Get Approved For
-
[Expired] Chase $600 Checking + Savings Bonus
-
Chase 5/24 Rule Explained In Detail – Everything You Need To Know (Updated For 2019)
-
Support the site
You can help support this site by using our links to Amazon & eBay.
As an Amazon Associate I earn from qualifying purchases. Keep in mind that if you do use our links, you won’t be able to earn cash back/miles/points from shopping portals.
In the interests of our readers you can find out what shopping portal is offering the best rates on eBay here & Amazon here.
What a great resource, thanks Doc!
Thanks goes to Don for putting this together!
I’ve done 25K of CC funding on 1st United CU (in one go).
Wow! I’ll update it
I think they are pretty strict about eligibility requirements. You have to be in one of the SF East Bay counties in order to open the account.
@Mel, do you live/work in those counties?
Jaw drops : ]
Awesome DP, thanks. I tried to open an account last week, but didn’t have a funding option, at all. Got approved for a savings and gave them a call.
They said the system for online funding for opening deposits had been “down for weeks” and that I’d have to go inside a branch to fund with cash or check.
Curious when you opened your account? Was the funding option after entering your personal info?
Damn this is awesome! I love you guys!
This is a fantastic resource.
I am still comparing this to the ones I have done to add/update the details
Am I missing these on the Main/Bonus history tab –
Wells Fargo $250 Checking https://www.doctorofcredit.com/ymmv-wells-fargo-250-nationwide-checking-bonus/
Wells Fargo $150 Checking https://www.doctorofcredit.com/wells-fargo-150-checking-bonus-select-areas/
TIAA Direct $250 https://www.doctorofcredit.com/tiaa-250-savings-account-bonus-nationwide-existing-clients/
SunTrust $300 https://www.doctorofcredit.com/suntrust-300-checking-promotion-al-ar-fl-ga-md-ms-nc-sc-tn-wv-va-d-c/
Discover Savings $100 AAA https://www.doctorofcredit.com/discover-aaa-100-savings-bonus-15000-deposit/
Discover Savings $100 https://www.doctorofcredit.com/discover-savings-100-bonus-15000-deposit-2/
Discover Checking $300 https://www.doctorofcredit.com/do-this-now-signup-for-400-in-discover-bank-bonuses-300-checking-100-savings/
Capital One 360 Checking https://www.doctorofcredit.com/targeted-capital-one-400-checking-bonus/
Capita One $400 Savings https://www.doctorofcredit.com/la-ny-nj-ct-tx-branch-capital-one-400-savings-200-checking-bonus/
BMO Harris $500 https://www.doctorofcredit.com/bmo-harris-300-checking-200-savings-branch-bonuses-highly-ymmv-az-fl-il-ks-mn-mo-wa-wi/
Thanks, added your links.
The main tab “2.x”, I think is pretty much complete – every bank/cu that DoC has mentioned across the dimensions (CC Funding, Credit Inquiry, …). But I was only maintaining one bonus page link per row.
Added the history tab recently to start keeping track of the posts over time, but it’s not complete. Basically, I’m adding rows as new posts come out (moving the old ones to history) – I haven’t cataloged all the previous posts. But more data is definitely better – maybe at some point.
Thanks again
amaze balls
Thank you so much guys!
I love your website!
U guys honestly have the absolute best credit card website out there.
Im doing CC now for 6 years.
I have yet to see a better site then that.
This post is just another reason to love this site!
Great work Don
Awesome !! Really helpful, thanks!
Wow, Don! I knew you were working on making some changes to this but this is seriously incredible work. Readers as always if you appreciate this sort of stuff make sure you bookmark it and also share it to get the word out.
holy crap this is amazing. Don is the man
For easy reference I’ve added this to the top menu under bank account bonuses.
Appreciate all the nice comments. If you have any ideas for improvement, or figured out how to use the data in other ways we would be interested to know.
Great spreadsheet. Thanks for all the work. One suggestion would be to differentiate on the expiration date cell those offers that have expired and those that are still available — perhaps by bolding one or using a different background color.
OK, added.
Conditional Formatting for a little bit darker green now when date is expired.
Amazing work.
For high-interest rate accounts, I’d personally like to have that rate included. However, rates change over time. :-/
(My) example use case: Looking for high-interest rate both checking and savings account to act as central hubs, both storing cash and facilitating transfers where needed. Currently using All America Bank / Redneck Bank for their savings (1.5%, >20 links so far), and Nationwide Bank for their checking (limited ACH links, but high-interest rate (1+%) checking).
Sh*t. This will bring about the end of all good things.
PLEASE stop trying to make every single exploit spoon-fed-easy for lazy, greedy noobs – the more you expose things like this, the quicker they die. These are usually VERY fragile, and all the attention this will drive will surely cause many good options to become massively hit and quickly killed. Please stop ruining everything!!!
Serious question, when did you start doing bank bonuses?
LOL.
I’d say don’t feed the troll William.
Maybe it’s a minority opinion.
But I’m of the belief that as the Banks get smarter, the more PhDs and computers they throw at eliminating us (less profitable customers) …
We actually have to share more, we need better tools, we need to move much faster
Agreed!
Thanks Don and all involved.
For the “CC funding USA 2.0 soft” filter, noticed it includes many banks/credit unions that are not available nationally. For example, OceanFirst and Westfield are both restricted to their local areas only. Is this something that can be revised? Or is the filter intended to mean something else…
Thanks, Jim.
I cleaned the filter up a little. Our what is available nationally data is a little sparse – so I was probably getting a little creative there. Now the filter is looking for a version of “Y” in any of the “USA”, “DoC USA”, and “CU USA” columns.
The DoC USA column mostly states if the specific bank promo was available nationwide. “DoC USA” and “CU USA” are actual availability but especially for credit unions often involve signing up for various groups (available nationally).
The OceanFirst DP, was just bad data entry on my side, should be removed now.
This is a really valuable resource. I only do a few bank bonuses per year, but this will be great the next time I’m looking to do one! Thanks Don and DoC!
Thanks Adam