Topic Wiki

Here is my Excel template to keep track of all of my credit card stuff.

The first tab contains the instructions. I included some of my own entries as examples so you will know what to fill in where.

I put in almost everything possible I could think of. Only thing I'm missing that I didn't get around to adding is the spending bonuses by category (e.g. travel, gas, etc.).

Enjoy. If you have any suggestions, comments, or improvements, Please let me know, I'd love to fix it.

Update- when editing, DO NOT modify any of the tables in the Dashboards (except expected money and debts), ONLY modify data in the Credit Card master sheet and Bank master sheet. The Dashboards contain what is called Pivot Tables and they automatically update when you refresh the data.

I'm not sure how to include an attachment in a wiki, so the file can be downloaded from the first post in this thread.
Download
« Last edited by shoobi on October 11, 2015, 09:21:06 PM »

Author Topic: Master Excel Template for keeping track of all Credit Card stuff  (Read 27439 times)

Offline shoobi

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 642
  • Total likes: 4
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #80 on: July 20, 2015, 10:59:11 PM »
Also will add a better way to keep track of when statements close and when payments are due.

Offline smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4396
  • Total likes: 9
  • DansDeals.com Hat Tips 8
    • View Profile
  • Location: NJ
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #81 on: July 20, 2015, 11:08:24 PM »
Wow, Just poking around the template and I already learned some new stuff. Thanks

Note: Why the need for Application M&D and  today M&D columns?

If for only checking the upcoming year you can just put the formula in the next column itself

=IF(TEXT(TODAY(),"mm/dd")>=TEXT([@[Application Date]],"mm/dd"),YEAR(TODAY())+1,YEAR(TODAY()))

Change Upcoming AF column to

=DATE([@[Upcoming yr.]],MONTH([@[Application Date]]),DAY([@[Application Date]]))

And you should be able to delete the Application M&D and  today M&D columns.

Offline ayman

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2013
  • Posts: 1466
  • Total likes: 34
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
    • Simplify Shopping
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #82 on: July 21, 2015, 12:41:26 AM »
After filling in data and trying to refresh I keep getting an error msg that one pivot table can not overlap another pivot table.
Buy discounted gift cards from me.
www.simplifyshopping.com

Offline shoobi

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 642
  • Total likes: 4
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #83 on: July 21, 2015, 09:53:11 AM »
Change Upcoming AF column to

=DATE([@[Upcoming yr.]],MONTH([@[Application Date]]),DAY([@[Application Date]]))

And you should be able to delete the Application M&D and  today M&D columns.

True, but the formula was getting so long that I was making mistakes in it i.e. forgetting parentheses etc, so i split it up to simplify it a bit

Offline shoobi

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 642
  • Total likes: 4
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #84 on: July 21, 2015, 09:53:50 AM »
After filling in data and trying to refresh I keep getting an error msg that one pivot table can not overlap another pivot table.

Try this: Highlight the pivot table and drag it down a bunch of cells.. should work

Offline loveddeals

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2014
  • Posts: 516
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: CA
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #85 on: July 21, 2015, 11:53:13 AM »
Thanks shoobi, looking forward to the updated file. Any idea when it would be ready?

AJK: did you share your file here? I might have missed it if you already did that. If not, can you please share your file with us too. Thanks

Offline Welder

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2014
  • Posts: 1184
  • Total likes: 17
  • DansDeals.com Hat Tips 13
    • View Profile
  • Location: NYC
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #86 on: July 21, 2015, 03:24:45 PM »
Here's mine, in case anyone's interested:

https://docs.google.com/spreadsheets/d/1o9_xViXU5wyTBZKtIdEaWLEtAFZ3i0xSvW8sAVvpAxg/edit?usp=docslist_api

It's pretty similar to others I've seen posted here. I looked around, found a bunch of different excel sheets, and different styles or systems for organizing, compared them all to each other and made one that works for me.
"We Need More Welders and Less Philosophers" - Rubio

Offline Aerial Dag

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Jun 2013
  • Posts: 990
  • Total likes: 64
  • DansDeals.com Hat Tips 7
    • View Profile
  • Location: MS Desert
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #87 on: July 21, 2015, 10:27:13 PM »
Wow my spreadsheet is almost identical to your Master CC sheet but I like all your extras.
On my spreadsheet I have a True/False column asking if I signed up for automatic payments. Gotta make sure each card is signed up!

Offline dudi

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Nov 2013
  • Posts: 1618
  • Total likes: 4
  • DansDeals.com Hat Tips 10
    • View Profile
  • Programs: Star Alliance Gold, Skyteam Elite Plus
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #88 on: October 11, 2015, 08:23:32 PM »
I just downloaded the spreadsheet from the wiki why isnt it working?

Offline shoobi

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 642
  • Total likes: 4
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: Master Excel Template for keeping track of all Credit Card stuff
« Reply #89 on: October 11, 2015, 09:21:27 PM »
Should work. I just tested it.