cancel
Showing results for 
Search instead for 
Did you mean: 

Perils of tracking CCs using spreadsheet

tag
Open123
Super Contributor

Re: Perils of tracking CCs using spreadsheet


@IncrsCreditScore wrote:

I refuse to do auto payments.  Therefore, I asked each bank to change the due date so that all of the cards have the same due date.  That makes it so much easier for me since I sit down at the computer and pay the ones that have a balance at the same time.  Also, I pay them all about one week before they are due.

 

Many years ago, I did use auto payments.  However, one time we were strapped for money and forgot about the auto payment.  The payment went through then bounced because there was not that much cash in our checking account.  As soon as we found out, we stopped all auto payments.  The thing about auto payments is that you tend to forget about them and that can cause problems.


This is the main reason I don't use auto-pay.  At any given time, I never have more than a few hundred in my checking accounts.

Message 31 of 49
LadyJEsq
Established Contributor

Re: Perils of tracking CCs using spreadsheet


@NRB525 wrote:

For those who are timing their credit card payments (is that the statement or the expected due date of the statement payment?) to the timing of your paycheck, this seems like it's cutting it close?

 

I prefer to have enough extra cash (a form of savings) in my checking accounts so that the timing of my bills and CC payments is not dependent on when my next paycheck is coming in. With the large payments like mortgage or rent, obviously there is some timing consideration, but for regular bills, part of a good financial plan is building up savings of 6 months or more for those items.

 

With my tracking of autopayments and scheduled payments, if I don't have the money already in my account for bills scheduled to be funded 30 days out, leaving allowance also for monthly utility bills I know are coming, I get really nervous and have to figure out where I need to get that cash from now.


This makes no sense to me. Just because some of us prefer to spread payments out to correspond to when we get our paycheck, has no bearing on our ability to save. Nor does it mean that paying said CC bill is dependent on that check. I'm not even sure how you drew such a conclusion. I, for one, have more than 6mths in savings, and I have a sizable emergency fund. Both of which are separate from my 401(k) and investments.

 

Like you Open, I never have more than enough to pay my bills in my checking account. And that's also why I chose my bank's bill pay option over setting up separate autopays (I'm also not a fan of any institution having access to my bank account). I can see pending payments as far out as just over a month, so there's no way I'll forget about a pending payment. I can edit payments if necessary, including the pay by date.

**FICO 8 Scores EQ EX TU **


Message 32 of 49
NRB525
Super Contributor

Re: Perils of tracking CCs using spreadsheet


@LadyJEsq wrote:

@NRB525 wrote:

For those who are timing their credit card payments (is that the statement or the expected due date of the statement payment?) to the timing of your paycheck, this seems like it's cutting it close?

 

I prefer to have enough extra cash (a form of savings) in my checking accounts so that the timing of my bills and CC payments is not dependent on when my next paycheck is coming in. With the large payments like mortgage or rent, obviously there is some timing consideration, but for regular bills, part of a good financial plan is building up savings of 6 months or more for those items.

 

With my tracking of autopayments and scheduled payments, if I don't have the money already in my account for bills scheduled to be funded 30 days out, leaving allowance also for monthly utility bills I know are coming, I get really nervous and have to figure out where I need to get that cash from now.


This makes no sense to me. Just because some of us prefer to spread payments out to correspond to when we get our paycheck, has no bearing on our ability to save. Nor does it mean that paying said CC bill is dependent on that check. I'm not even sure how you drew such a conclusion. I, for one, have more than 6mths in savings, and I have a sizable emergency fund. Both of which are separate from my 401(k) and investments.

 

Like you Open, I never have more than enough to pay my bills in my checking account. And that's also why I chose my bank's bill pay option over setting up separate autopays (I'm also not a fan of any institution having access to my bank account). I can see pending payments as far out as just over a month, so there's no way I'll forget about a pending payment. I can edit payments if necessary, including the pay by date.


I come from the perspective of having some 27 payments for various credit cards, excluding utilities and mortgage, so for me, attempting to line those all up to my paychecks (every two weeks, not twice a month BTW) is literally herding cats. To keep the cats from getting out of control, I build up reserves directly in the checking accounts, in anticipation of known payments.

 

The advantage of letting the CCC initiate the autopayment, once it is properly set up, it is on THEM to initiate the transaction, they know the transaction is in process, and the risk of forgetting the transfer is removed from my mind. I owe them the money anyway, and they only take out what is on my authorized autopayment.

High Bal Jan 2009 $116k on $146k limits 80% Util.
Oct 2014 $46k on $127k 36% util EQ 722 TU 727 EX 727
April 2018 $18k on $344k 5% util EQ 806 TU 810 EX 812
Jan 2019 $7.6k on $360k EQ 832 TU 839 EX 831
March 2021 $33k on $312k EQ 796 TU 798 EX 801
May 2021 Paid all Installments and Mortgages, one new Mortgage EQ 761 TY 774 EX 777
April 2022 EQ=811 TU=807 EX=805 - TU VS 3.0 765
Message 33 of 49
LadyJEsq
Established Contributor

Re: Perils of tracking CCs using spreadsheet


@NRB525 wrote:

@LadyJEsq wrote:

@NRB525 wrote:

For those who are timing their credit card payments (is that the statement or the expected due date of the statement payment?) to the timing of your paycheck, this seems like it's cutting it close?

 

I prefer to have enough extra cash (a form of savings) in my checking accounts so that the timing of my bills and CC payments is not dependent on when my next paycheck is coming in. With the large payments like mortgage or rent, obviously there is some timing consideration, but for regular bills, part of a good financial plan is building up savings of 6 months or more for those items.

 

With my tracking of autopayments and scheduled payments, if I don't have the money already in my account for bills scheduled to be funded 30 days out, leaving allowance also for monthly utility bills I know are coming, I get really nervous and have to figure out where I need to get that cash from now.


This makes no sense to me. Just because some of us prefer to spread payments out to correspond to when we get our paycheck, has no bearing on our ability to save. Nor does it mean that paying said CC bill is dependent on that check. I'm not even sure how you drew such a conclusion. I, for one, have more than 6mths in savings, and I have a sizable emergency fund. Both of which are separate from my 401(k) and investments.

 

Like you Open, I never have more than enough to pay my bills in my checking account. And that's also why I chose my bank's bill pay option over setting up separate autopays (I'm also not a fan of any institution having access to my bank account). I can see pending payments as far out as just over a month, so there's no way I'll forget about a pending payment. I can edit payments if necessary, including the pay by date.


I come from the perspective of having some 27 payments for various credit cards, excluding utilities and mortgage, so for me, attempting to line those all up to my paychecks (every two weeks, not twice a month BTW) is literally herding cats. To keep the cats from getting out of control, I build up reserves directly in the checking accounts, in anticipation of known payments.



If that's what works for you, that's fine. It still doesn't make the way others do it flawed.

 


@NRB525 wrote:


 

The advantage of letting the CCC initiate the autopayment, once it is properly set up, it is on THEM to initiate the transaction, they know the transaction is in process, and the risk of forgetting the transfer is removed from my mind. I owe them the money anyway, and they only take out what is on my authorized autopayment.


There is still no advantage of having a CCC autopayment, over a bank's bill pay option. WIth both options, a payment is initiated, and most bank have relationships with the CCCs, so they know the transaction is in process, and there is no risk of forgetting. And just because you owe them the money anyway, IMO, doesn't mean that allows them access to your bank account. And I've heard of many instances where autopay withdrew more than one payment a month or the like. Now, I've heard these stories in relationship to SL payments (which ironically, the double payment won't count as next month's payment, so the individuals just made an additional payment (and given the considerably costly payment, that could really put someone in a bind)), but it was enough to turn me off to such a payment option. But that's just me. What works for you, works for you, and I'm happy that it does, but it's not the only way.

**FICO 8 Scores EQ EX TU **


Message 34 of 49
Open123
Super Contributor

Re: Perils of tracking CCs using spreadsheet


@LadyJEsq wrote:
And that's also why I chose my bank's bill pay option over setting up separate autopays (I'm also not a fan of any institution having access to my bank account). I can see pending payments as far out as just over a month, so there's no way I'll forget about a pending payment. I can edit payments if necessary, including the pay by date.

Couldn't agree more on this point.  

 

I will never be comfortable with anyone having access to my bank accounts.  Matter of fact, I'm so paranoid, I leave only a few hundred at a time with the rest in separate brokerage accounts.  If anyone wants to "suck" my money out, it'll take (1) a court order, and (2 ) an additional order to liquidate my securities.  

Message 35 of 49
NRB525
Super Contributor

Re: Perils of tracking CCs using spreadsheet


@LadyJEsq wrote:


 



If that's what works for you, that's fine. It still doesn't make the way others do it flawed.

 

I try to make all my statements from the perspective of what I would do, and generalizations about what is good financial management. In some of the earlier posts in this thread, it wasn't clear whether other reserves of funds were available or the paycheck was the sole funding source. If that is the case, great, then the reserves are being stored up for a rainy day. Or short cash months.


@NRB525 wrote:


 

The advantage of letting the CCC initiate the autopayment, once it is properly set up, it is on THEM to initiate the transaction, they know the transaction is in process, and the risk of forgetting the transfer is removed from my mind. I owe them the money anyway, and they only take out what is on my authorized autopayment.


There is still no advantage of having a CCC autopayment, over a bank's bill pay option. WIth both options, a payment is initiated, and most bank have relationships with the CCCs, so they know the transaction is in process, and there is no risk of forgetting. And just because you owe them the money anyway, IMO, doesn't mean that allows them access to your bank account. And I've heard of many instances where autopay withdrew more than one payment a month or the like. Now, I've heard these stories in relationship to SL payments (which ironically, the double payment won't count as next month's payment, so the individuals just made an additional payment (and given the considerably costly payment, that could really put someone in a bind)), but it was enough to turn me off to such a payment option. But that's just me. What works for you, works for you, and I'm happy that it does, but it's not the only way.


And I've had situations where the autopay I set up from my CCC to draw from my bank account wasn't processed correctly, and in that instance is easier to talk with the CCC to clear up the misunderstanding. Yes, you can push a payment from your bank, but my autopayments initiated from my CCC can also adapt to PIF the exact amount on the statement if my charges for the month are less than the fixed estimate amount I have set up for the autopayment. As more of my 20-something cards get to PIF status, having the CCC request that amount becomes an advantage Smiley Happy

High Bal Jan 2009 $116k on $146k limits 80% Util.
Oct 2014 $46k on $127k 36% util EQ 722 TU 727 EX 727
April 2018 $18k on $344k 5% util EQ 806 TU 810 EX 812
Jan 2019 $7.6k on $360k EQ 832 TU 839 EX 831
March 2021 $33k on $312k EQ 796 TU 798 EX 801
May 2021 Paid all Installments and Mortgages, one new Mortgage EQ 761 TY 774 EX 777
April 2022 EQ=811 TU=807 EX=805 - TU VS 3.0 765
Message 36 of 49
vanillabean
Valued Contributor

Re: Perils of tracking CCs using spreadsheet


@LadyJEsq wrote:
 I'm also not a fan of any institution having access to my bank account

 

Do you have a bad experience to support this?

 

Message 37 of 49
LadyJEsq
Established Contributor

Re: Perils of tracking CCs using spreadsheet


@Anonymous-own-fico wrote:

@LadyJEsq wrote:
 I'm also not a fan of any institution having access to my bank account

 

Do you have a bad experience to support this?

 


I didn't realize I needed "support" for my opinion. Smiley LOL But, yes, I did have friends who had bad experiences, as stated above.

**FICO 8 Scores EQ EX TU **


Message 38 of 49
Open123
Super Contributor

Re: Perils of tracking CCs using spreadsheet


@LadyJEsq wrote:

@Anonymous-own-fico wrote:

@LadyJEsq wrote:
 I'm also not a fan of any institution having access to my bank account

 

Do you have a bad experience to support this?

 


I didn't realize I needed "support" for my opinion. Smiley LOL But, yes, I did have friends who had bad experiences, as stated above.


For me, it's just common sense.  Why would I ever make it easier for anyone or entity to take my money?  In a separate brokerage, it would require (1) a court order, then (2) another order to liquidate securities, since the brokerage Firm will not liquidate without authorization.

 

Whoever wants my money, I want to make it as difficult as possible.  So, tons of brokerages spread out, trusts, etc....

Message 39 of 49
Anonymous
Not applicable

Re: Perils of tracking CCs using spreadsheet

Nice thread hijack from the O.P. to this last page. I'm not a fan of autopay, but I'm not going to preach about why I'm not. To each their own.

 

I also use a spreadsheet and I can proudly say in my 55 years of existence, and the last 5 years using a spreadsheet, I've never missed a payment. Stuff will happen, like recently when I accidentally let a $10.05 charge on my Lowes card report. I like to PIF before they report. Not a big deal but for some reason my EQ actually went up right after it reported! 

 

Glad you caught it O.P.!

Message 40 of 49
Advertiser Disclosure: The offers that appear on this site are from third party advertisers from whom FICO receives compensation.