Spreadsheet to track card usage

[moosemoney]

I have seen a lot of people mention keeping spreadsheets to track their credit card activity in order to follow certain plans (AZEO, for example), especially when they have 10+ cards.

I was wondering if anyone had an example of the spreadsheets they use? I was thinking of trying this and would like to see some examples, if anyone is willing to share.

Thanks!

[19eighty5]

+1

[Anonymous]

It might be a bit of overkill but check out Johnny Africa's spreadsheet here: https://johnnyafrica.com/credit-card-tracking-spreadsheet/

I'm an Excel geek so I designed my own spreadsheet but if you don't understand something like ="Under 5/24 on "& TEXT((EOMONTH(EDATE(LARGE(B2:B23,5),24),0)+1),"mmmm d, yyyy") it wouldn't be much use to you.

[moosemoney]

I work in excel all the time for work and also to track my peronsal finances/budget, and I do all my bookkeeping for my small business in excel as well.

Thank you for the link I will check it out.

[sdsoccerdad]

I started with this one at first.  I eventually created my own but that's a good place to start with.

Edit: Didn't see that someone above posted the same thing.  That's what happens when i'm trying to multi task at work.

[Anonymous]

I created my own spreedsheet. I also posted something early where I asked people how they managed their credit cards. I'm a software Engineer so i have the know how on how to create "complex" data track spreed sheets. I'll upload a picture of my personal spreedsheet with some information blurred out for your likeness.

https://drive.google.com/file/d/1S56JtMukwOIKE86PZHsT3FxOx9hMQU9k/view?usp=sharing

[Anonymous]

This is great.  I already used a spreasheet to track my credit cards, but was looking to beef it up.  This definitely has a lot that I can add to the one I currently use.  Thank you all.

[sdsoccerdad]

---

@Anonymous wrote:

I created my own spreedsheet. I also posted something early where I asked people how they managed their credit cards. I'm a software Engineer so i have the know how on how to create "complex" data track spreed sheets. I'll upload a picture of my personal spreedsheet with some information blurred out for your likeness.

https://drive.google.com/file/d/1S56JtMukwOIKE86PZHsT3FxOx9hMQU9k/view?usp=sharing

---

**bleep**, that's a nice spreadsheet!

[Anonymous]

---

@sdsoccerdad wrote:

---

@Anonymous 

https://drive.google.com/file/d/1S56JtMukwOIKE86PZHsT3FxOx9hMQU9k/view?usp=sharing

---

**bleep**, that's a nice spreadsheet!

---

Thanks!

With enough inspiration I might go create a Pubic Advanced spreadsheet for people who want detailed analysis. 

[marypoppins70]

I have a TON of cards so I keep an excel spreadsheet with columns from left to right: Credit Card, Total CL, Current Balance, % used, amount available, monthly payment, and the due date.  It's worked out great for me and I can keep track of utilization for each card and overall.