credit card

I have a sheet with my credit card transaction and I'd like to get the interest accrued after each transaction but not necessarily every day. Additionally I want a table to keep track of transactions, payments and interest on a monthly basis.. I'm having trouble with getting the accurate...

Hello, I'm trying to get the utilization of all of my cards. I know the formula is (Amount Owed / Credit Limit * 100) but how do I put that n Excel? Thanks,

Hi All, I like to prepare a credit card import file from a csv file. Based on the code and description, expense gl will be inserted and based on province tax will be calculated. I am trying to figure out how to insert new line to do this calculation automatically. Is there any program i can use...

I have an issue that I need some help with... We try to assign all of our expenses on our American Express cards either to overhead items or we try to job cost them... We download each statement in Excel, and I transfer the bill to a recap sheet as follows: <tbody> Transaction Description...

I need to check if the field that is completed in column W is a number of at least 7 characters. I cannot allow anything different, except when in column V is "TARJETA_CREDITO". In the case the field in column V is "TARJETA_CREDITO" the previous validation needs to be changed to XOR you may see...

I have done a thorough search for the calculation in Excel that gives me the APY for a credit card I have that charges an interest rate of 24.40% BUT also charges me $8.25 per month as one month's cost of the annual fee of $99 - and have found NOTHING. If my balance is $430.38 and the credit...

I would like to write VBA code to log into the below (and other) sites. I would like to then navigate within those sites (clicking links) to get to different pages where I would eventually be able to download Year to Date Statements. I am struggling with determining which commands to use in...

Hi there, When opening a CSV file in Excel that contains a number > 15 digits, the final digit is zeroed (or rounded up). I've been doing some online searches, which have told me *why* it does this and that I should be formatting my data to text (which, if I do it after the fact in Excel, the...

Hi there everyone, I'm having difficulties calculating the interest charged on my credit card. I have a few cards, so it's really troublesome when it comes to calculating the interest rates that will be charged on the next month. (I have very bad financial management) All the Excel gurus out...