How to manage your credit cards : Tracking credit card important details, bill payment status, targeted offers

[TechnoFino]

If you have one or two credit cards, then managing those cards are not that difficult. But what if you have more than 5 credit cards?
In this case, I'd recommend you to maintain some Excel sheets for managing all your credit cards properly.
I personally maintain 3 excel sheets for managing all my 40 credit cards.

1. For tracking credit cards important details
2. For racking credit card bill payment tracking
3. For tracking spend-based offer

I'm uploading my excel sheet format here. You can download and use it if you want.

And don't forget to watch this video -

 

[Lokesh]

Wh

If you have one or two credit cards, then managing those cards are not that difficult. But what if you have more than 5 credit cards?
In this case, I'd recommend you to maintain some Excel sheets for managing all your credit cards properly.
I personally maintain 3 excel sheets for managing all my 40 credit cards.

1. For tracking credit cards important details
2. For racking credit card bill payment tracking
3. For tracking spend-based offer

I'm uploading my excel sheet format here. You can download and use it if you want.

What does Cibil date mean in the first file?

 

[TechnoFino]

Wh

What does Cibil date mean in the first file?

That's CIBIL reporting date, to know more (in-depth info), watch this video -
And follow this thread- https://www.technofino.in/community/threads/credit-card-cibil-reporting-date.375/

 

[aman6490]

You're great dada... Thank you for sharing 🙏🏻

 

[arjun]

If you have one or two credit cards, then managing those cards are not that difficult. But what if you have more than 5 credit cards?
In this case, I'd recommend you to maintain some Excel sheets for managing all your credit cards properly.
I personally maintain 3 excel sheets for managing all my 40 credit cards.

1. For tracking credit cards important details
2. For racking credit card bill payment tracking
3. For tracking spend-based offer

I'm uploading my excel sheet format here. You can download and use it if you want.

I still can't believe how do you manage 40 cc? Like seriously bro, here having 5 cc also is headache

 

[DISHANT]

Ek hi ❤️ hai Dada. Kitni bar jitoge🫶🏻..
@TechnoFino

 

[Navin192]

That's CIBIL reporting date, to know more (in-depth info), watch this video -
And follow this thread- https://www.technofino.in/community/threads/credit-card-cibil-reporting-date.375/

i have two doubts bro

regarding those banks who report credit utilisation to bureau on month ends...
1) they will report the utilisation based on last generated bill or current utilisation(month end)?

regarding annual waiver

2) certain credit cards have spend based annual waiver of AMC
for considering the total spends ......the bank looks the combined generated bills of 12 months ?? or combined spends??

becoz if i pay the utilised amount before bill generation everymonth......the combined bills of 12 months will be lower than the criteria for AMC waiver .however my combined spends would be greater than the criteria .

 

[SC_23]

regarding those banks who report credit utilisation to bureau on month ends...
1) they will report the utilisation based on last generated bill or current utilisation(month end)?

Adding to this if credit card og bill cycle was different from the one currently do bank also adjust their cibil reporting date accordingly?

 

[TechnoFino]

i have two doubts bro

regarding those banks who report credit utilisation to bureau on month ends...
1) they will report the utilisation based on last generated bill or current utilisation(month end)?

regarding annual waiver

2) certain credit cards have spend based annual waiver of AMC
for considering the total spends ......the bank looks the combined generated bills of 12 months ?? or combined spends??

becoz if i pay the utilised amount before bill generation everymonth......the combined bills of 12 months will be lower than the criteria for AMC waiver .however my combined spends would be greater than the criteria .

1. Your uses till month end (not according to any bill cycle).
2. Combined spends

Adding to this if credit card og bill cycle was different from the one currently do bank also adjust their cibil reporting date accordingly?

Maximum bank adjust accordingly (example- icici)

 

[AsB]

I also use Google Tasks to remind me of the due date.

I just make a reminder on the date that I want to make the Credit Card payment (mostly a day after the bill generation date). Just to be on the safe side, I make two copies of the same (so, in total 3 reminders) in each subsequent day.

 

[CCgeek]

If you have one or two credit cards, then managing those cards are not that difficult. But what if you have more than 5 credit cards?
In this case, I'd recommend you to maintain some Excel sheets for managing all your credit cards properly.
I personally maintain 3 excel sheets for managing all my 40 credit cards.

1. For tracking credit cards important details
2. For racking credit card bill payment tracking
3. For tracking spend-based offer

I'm uploading my excel sheet format here. You can download and use it if you want.

Though I already use excel to maintain the CC records, these sheets are really helpful. Thanks for sharing!

 

[Kush]

Thank you so much for sharing. Great way yo manage everything through excel

 

[Shubhanshusharma4690]

If you have one or two credit cards, then managing those cards are not that difficult. But what if you have more than 5 credit cards?
In this case, I'd recommend you to maintain some Excel sheets for managing all your credit cards properly.
I personally maintain 3 excel sheets for managing all my 40 credit cards.

1. For tracking credit cards important details
2. For racking credit card bill payment tracking
3. For tracking spend-based offer

I'm uploading my excel sheet format here. You can download and use it if you want.

Not able to open excels

 

[TechnoFino]

Not able to open excels

OS you are using?

 

[Chegg]

Not able to open excels

@TechnoFino yes, unable to open in ms excel. It says "Protected" & no opening. But i can open using google sheets

 

[SC_23]

Maximum bank adjust accordingly (example- icici)

In my case its SBI can we cross check at what date it reports to cibil as I don't remember the original bill date.

 

[TechnoFino]

@TechnoFino yes, unable to open in ms excel. It says "Protected" & no opening. But i can open using google sheets

Open using Google sheet save a copy

 

[vaibhav111]

does anyone know RBL bank cibil reporting date? is it month end ? I'm updating my current excel file i forget to add this detail

 

[hashiro7]

does anyone know RBL bank cibil reporting date? is it month end ? I'm updating my current excel file i forget to add this detail

Credit Card CIBIL Reporting Date

Hello everyone, If you are holding multiple credit cards, and wants to keep your credit utilisation ration under 30% then you should know, on which date your card issuers report your card uses data to CIBIL. To know more about how to maintain credit utilisation ratio under 30% or lower watch...

www.technofino.in

RBL - MONTH END 30/31

 

[35manikanta]

If you have one or two credit cards, then managing those cards are not that difficult. But what if you have more than 5 credit cards?
In this case, I'd recommend you to maintain some Excel sheets for managing all your credit cards properly.
I personally maintain 3 excel sheets for managing all my 40 credit cards.

1. For tracking credit cards important details
2. For racking credit card bill payment tracking
3. For tracking spend-based offer

I'm uploading my excel sheet format here. You can download and use it if you want.

And don't forget to watch this video -

Thank you Sumanta, i have asked you for this excel sheet in twitter and happy that you made a video and also shared the same here....really helpful...