Hello, welcome to finance newsfinance news - One is to provide professional knowledge of foreign exchange, to understand the foreign exchange market, foreign exchange transactions, foreign exchange assets and foreign exchange investors preferred site learning.

free credit card payment spreadsheet

Release time:2018-01-13

Pin3+1ShareShares 4For those like me that love to collect credit card rewards and  travel everywhere for free, keeping track can become difficult and cumbersome. Among the bonus requirements, reward structures, annual fees, and application deadlines, there are many things to pay attention to. At any given time, I have about 15-20 active credit cards for just myself. Each year, I will open 5-10 new cards and subsequently also cancel 5-10 credit cards since I do not want to pay the annual fee. This practice is called “churning” and can become stressful and difficult to manage. I’ve created a spreadsheet in Excel that will solve all your problems!   Why use a spreadsheet to track Credit Cards?Unless you have a legitimate business, most of us don’t have enough regular day to day spend to acquire any meaningful amount of bonuses. Even with a lucrative card like the Chase Sapphirewhere you earn 3x on dining and travel, to get $1,000 worth of rewards, you’d have to spend $25,000. That’s a lot of money for the average person. However, the sign on bonus is a cool 100,000 points which is worth $1,500. The requirement to get these points is to spend only $4,000 within 3 months. A much better return on your money! Of course the Sapphire Reserve has a ton of other benefits as well but for the most part, I sign up for a credit card and will usually discard after I’ve collected the bonus. The above example is just 1 credit card. I’m always applying for new credit cards to get the bonus and therefore, my spreadsheet tracks everything from credit limits, credit score impact variables, time to next annual fee, and more.   Credit Card Rewards and churning Excel spreadsheetThe spreadsheet I created focuses specifically on credit card bonuses and churning. As I’ve written before, it’s not about spending money on the credit card, as much as it is about pocketing the sign on bonuses.  It’s simple, yet effective. It will help you avoid paying excessive annual fees, remind you when your bonus period expires, and track canceled cards. There’s numerous columns in this spreadsheet that captures everything you need to know about the card you just signed up for. To download it, click the button below! Download Credit Card Spreadsheet The spreadsheet is in Google Sheets because if I update it in the future, it will be easy to access. It’s easy to download it and use with Microsoft Excel as well. To download offline, click the red button above, then click file < download as < Microsoft Excel   Using the Credit Card churning spreadsheetAs someone that works with spreadsheets regularly, I’ve included some functionality like conditional formatting and formulas that an Excel novice might not understand. I will explain everything necessary for those wanting to get the full use out of the spreadsheet. For the most part, anyone with any excel experience should just follow my inventory and copy/delete rows accordingly to populate your inventory accordingly. Bank: The credit card providerCard Name: The name of the credit cardType: Whether it is a personal or business card. Business cards do not affect your personal credit reportCard Type: Visa, Mastercard, American Express, Discover etc.Opened: Date card was first openedCredit Limit: Credit limit you were approved for. This factors heavily into your total credit limit.Inquiry?: Credit inquiries stay on your credit report for two years. This affects your credit score, and business cards are not includedUses the Opened ColumnAge: How long you’ve had the credit card for and factors into your credit score’s average age of credit calculationUses the Opened ColumnAnnual Fee: The annual fee associated with the credit card. Put $0 if there is no feeFirst year waived?: Many cards waive their first year’s fee but some do not (Chase Sapphire Reserve, Delta AMEX Platinum, Chase Hyatt etc.)Next fee date: Uses formulas to calculate when your next fee date isUses the Opened and Annual Fee columnDays until next fee date: Uses formulas to calculate how many days are left until your next feeUses the Next fee date and Annual Fee columnsRewards Name: Name of the card’s rewards networkBonus: Sign-on bonus of the card you applied forMinimum Spend: How much you must spend to get the bonus aboveTime Frame: How long you have to spend the minimum amount required (in days)Estimated Value: This is just an estimated rewards amount I calculated based on how I would use the rewards. Feel free to changeDays Until Bonus Expires: Uses formulas to computer how many days are left for you to hit your minimum spendUses the bonus and time frame columnsBonus Received: When you received your bonus. There is conditional formatting here that will turn the cell green when you input a date.Current Rewards Balance: Your current rewards balance of the credit cardRewards Detail: Details of the rewards structure (excluding the bonus)Best way to redeem: The most ideal way of using the rewards earned.Keep card past 1y: For the credit card churners, this column is a placeholder for you to decide if you want to keep the card after 1y. This is based on whether you think an annual card is worth keeping.  Do NOT edit the cells in gray so to preserve the formula integrity.   What do the other worksheets do?The main sheet is named “Current Inventory” which is your active inventory of credit cards. I also added a few more worksheets. Potential Cards: Anything I plan on getting in the foreseeable future. All fields are the same as the ones in the main sheet. Canceled Cards: It’s important to track canceled cards. Not only will this be a good gauge for my credit score, but many credit card bonuses reset after 24 months. That means, I will know when in the future, I can re-apply for the same card and get the bonus again. Credit Score: Straight forward. Track your credit score by using the credit score tools that every bank now provides for free. Allcards: A list of all active credit cards out there courtesy of the wonderful people at Reddit.   I hope this helps you out as you work your way to endless rewards and free travel! If you have any questions about the spreadsheet, please leave a comment below! Share1TweetPin3+1ShareShares 4Relatedbest way to track credit cardscredit card bonuscredit card bonus spreadsheetCredit card churningcredit card churning spreadsheetcredit card excelcredit card excel spreadsheetcredit card inventorycredit card spreadsheethow to keep track of credit cardskeep track of credit cardsspreadsheet for credit card churningtrack credit card inventorytracking credit cardsThe Ultimate Spreadsheet To Track Credit Card Churning2017-01-312017-12-04https://johnnyafrica.com/wp-content/uploads/2017/05/logomakr_9duj3n.pngJohnny Africahttps://johnnyafrica.com/wp-content/uploads/2017/01/credit-cards14.jpg200px200pxAboutJohnnyI’m a dual Canadian-American who moved out of my comfortable life in Manhattan to move abroad and travel the world. I’m a bit obsessed with scuba diving, churning credit cards so I never pay to fly, and eating the most questionable of foods in the most peculiar of places. My bucket list is the world, and some day I might make it there.

 

The Ultimate Spreadsheet To Track Credit Card Churning ...

 

Top 5 Best (Free) Spreadsheets for Paying Off Debt ...
Free Debt Calculator and Spreadsheet from Vertex. ... (Free) ***Spreadsheets*** for Paying Off Debt”, ... How to Pay Off Credit Card Debt ...

 

Credit Card Pay-off Calculator | Free for Excel
Download a free Credit Card Pay-off calculator for Microsoft® Excel® helps to solve for a minimum payments, minimum plus interest payments and minimum plus interest with additional monthly payments.

 

The Ultimate Spreadsheet To Track Credit Card Churning ...
Keep card past 1y: For the credit card churners, this column is a placeholder for you to decide if you want to keep the card after 1y. This is based on whether you think an annual card is worth keeping.

 

The Best Free Debt Reduction Spreadsheets in 2017
Choose from these free debt reduction planning spreadsheets to come up ... The Best Free Debt Reduction Spreadsheets ... to first pay down each credit card to ...

 

Use Snowball Method Spreadsheet To Pay Off Debts
Use Snowball Method Spreadsheet To Pay Off ... Try this handy Excel spreadsheet to generate a custom strategy for becoming debt-free. Just enter your credit cards, ...

 

Spreadsheet for using snowball method to pay off debt ...
Feb 16, 2017 · This free, downloadable spreadsheet ... Researchers say the snowball method is the best way to pay off ... The average household with credit card ...

 

A Free Spreadsheet to Track Your Credit Cards - The Honeymoon Guy
Trying to keep credit card applications and signup bonus spending requirements straight? Then download this free spreadsheet from The Honeymoon Guy.

 

Credit Card Payoff Calculator - Office Templates
Credit Card Payoff Calculator. Easily see what it will take to pay off your credit card at different interest rates and payment amounts with this credit card payoff ...

 

How to Do a Credit Card Tracking Spreadsheet | Sapling.com
Tracking your credit card bills on a spreadsheet can help you pay off high-interest cards and get control of your debt. Computerized spreadsheets make calculations ...

 

Credit Card Payoff Calculator | Excel Templates
Perhaps, this credit card payoff calculator is just an ordinary tool you can find easily online. I have created this tool last year to help me getting a better view ...
  • Disclaimer:
  • The content of the station is collected from the Internet, does not represent the position of the station, its views for the readers.
  • If there is anything wrong with the content of this station, please get in touch with us. This station will be deleted at the first time.