topic Re: Spreadsheet to track card usage in General Credit Topics

Spreadsheet to track card usage

moosemoney — Fri, 01 Jun 2018 14:56:37 GMT

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!

Re: Spreadsheet to track card usage

19eighty5 — Fri, 01 Jun 2018 15:16:39 GMT

Re: Spreadsheet to track card usage

Anonymous — Fri, 01 Jun 2018 15:49:52 GMT

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.

Re: Spreadsheet to track card usage

moosemoney — Fri, 01 Jun 2018 15:58:45 GMT

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.

Re: Spreadsheet to track card usage

sdsoccerdad — Fri, 01 Jun 2018 16:14:40 GMT

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.

Re: Spreadsheet to track card usage

Anonymous — Fri, 01 Jun 2018 16:49:43 GMT

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

Re: Spreadsheet to track card usage

Anonymous — Fri, 01 Jun 2018 16:54:51 GMT

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.

Re: Spreadsheet to track card usage

sdsoccerdad — Fri, 01 Jun 2018 17:14:58 GMT

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

Re: Spreadsheet to track card usage

Anonymous — Fri, 01 Jun 2018 17:24:41 GMT

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

Re: Spreadsheet to track card usage

marypoppins70 — Fri, 01 Jun 2018 17:26:48 GMT

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.

Re: Spreadsheet to track card usage

marty56 — Fri, 01 Jun 2018 22:18:29 GMT

I make the rows and account that has to be paid and the column is my paydate which is every 2 weeks. You can see what needs to be paid as well as when a card can be PIF if you revolve a balance. It is also great for budget too.

Re: Spreadsheet to track card usage

Asilomar — Sun, 03 Jun 2018 03:24:22 GMT

@Anonymous wrote:
@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.

Uh, what kind of inspiration are you looking for?? Begging? Gifts? Money? Flowers? Snack products? A coupon for one free back rub???

Re: Spreadsheet to track card usage

Anonymous — Sun, 03 Jun 2018 10:41:29 GMT

@Asilomar
Uh, what kind of inspiration are you looking for?? Begging? Gifts? Money? Flowers? Snack products? A coupon for one free back rub???

hmmmm, is that a serious request? lol. I do like all of those things hehe

Re: Spreadsheet to track card usage

Anonymous — Sun, 03 Jun 2018 21:38:36 GMT

WoW...

I wish I had your know-how. Awesome work.

@sdsoccerdad wrote:
@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!

Re: Spreadsheet to track card usage

Anonymous — Sun, 03 Jun 2018 21:43:19 GMT

@Anonymous PLEASE @Anonymous

uummm... IF you're looking for financial inspiration... I might have a card for that.

@Anonymous wrote:
@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.