ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How to Use a Simple Spreadsheet to Keep Track of Credit Cards

Updated on January 6, 2011

Many of us have more than one credit card to our names. It’s best to limit the number of credit cards that you use but that’s a story for another time. For now, let’s talk about how you can keep track of your credit cards when you’ve got half a dozen or more that you’re using. It may seem tough but you can actually use a really simple spreadsheet system to get everything all organized.

Why Organize Your Credit Cards

Before we look at how to create such a spreadsheet system, let’s look at some of the reasons that it is smart to put such a system in place. Those reasons include:

o It allows you to visually see exactly how many credit cards you have along with what your balances, interest rates and monthly payments are. This can assist you immensely in budgeting. It can also help you get a good overview of what your financial obligations are at the current time.

o It provides you with a single place where you can check to see what your credit options are. Have you ever had to make a big purchase and so you spent an hour calling up each of your credit card companies to see what cards had enough money available on them to make the purchase? An organized informational spreadsheet for your credit cards prevents you form ever having to waste your time on that again.

o It’s a great place to keep track of your passwords and PIN numbers. At the end of this article I’ll let you know how to password protect your Excel spreadsheet so that this important information remains safe and secure.

o It’s also a good place to store the phone numbers for all of your credit card companies. If your credit cards are ever stolen then you can refer to your spreadsheet to make sure that you contact all of your lenders so that they can freeze your accounts.

Creating the Spreadsheet

In a basic spreadsheet system like Excel, you will want to create the following informational columns:

o The name of the credit card including identifying information. (So don’t just put Mastercard, put “Capital One Mastercard”.

o Account number.

o Credit card expiration date.

o Total credit line.

o Total amount owed.

o Total available credit.

o Interest rate.

o Minimum monthly payment.

o Contact information for the card holder. You can find this information right on the back of the card in the form of a toll free number. The company’s website information should be there as well.

o Your password to access the website for that credit card. Many people get frustrated because they forget their account information and then can’t sign on to get real time information about their accounts.

o Your PIN number to utilize the credit card at ATMs.

Additional information that you might also like to include in columns on the spreadsheet:

o Information about rewards programs including the terms of the program and how many points you have

o Amount available for cash advance. On some cards this is the same as the total amount available but on other cards the amount differs. If you think that you may need to access cash then having this information can be helpful.

o Additional interest rates. The regular column would be your APR for purchases but you may want to include the rate for balance transfers and cash advances.

o Date when promotional periods are set to end. For example, if you accepted a balance transfer at 0% then make sure you note on your spreadsheet when that grace period is over and what the new rate will be at that time.

o Fees. If you know that you frequently have problems with overdraft fees or late fees then you’ll want to include what those charges are on your spreadsheet. Also make sure to note any annual fees and when those come due.

o When your bills are due each month. Some people find it helpful to know the exact date that their bills will be due in order to prevent late payments.

How to Password Protect your Spreadsheet

You are putting a lot of important financial information into one document so it is crucial that you protect that information. One way to do that is to add password protection to your spreadsheet.

This is the information if you want to Password Protect a file in Excel 2007. There are variations for different programs:

o Open the file. If your file is named something that makes it easy to see that it is financial information then you should re-name it something else so that you’ll remember what it is but nobody else will recognize as financial information. Think about it, would you be more interested in snooping in a document titled “academic research” or “my credit card information”. Think carefully about choosing a boring title that no one will recognize as a file filled with financial information.

o Go to the tab labeled review.

o Select the option that says “protect workbook”. (Note that you can also protect the specific worksheet that you’re working on but it’s best to protect the entire workbook).

o Create a password. You will want to create a unique and complex password that other people cannot guess. It should include symbols, numbers, capital letters and lowercase letters. Make sure that this password is not stored anywhere on your computer. Ideally, it should remain in your head only! Take precautions at all times to protect your credit card information so that you don’t become a victim of identity theft.

Using your Spreadsheet

Once you have all of this information safely stored on your computer, you can use it to keep track of your credit cards. Make sure that you update it monthly to reflect any changes to your accounts.


Submit a Comment
  • profile image

    Jimmie Patterson 

    7 years ago

    Thanks for the suggestions you are sharing on this blog. Another thing I want to say is the fact getting hold of some copies of your credit profile in order to check accuracy of any detail is the first measures you have to execute in repairing credit. You are looking to cleanse your credit reports from harmful details errors that ruin your credit score.

  • Hello, hello, profile image

    Hello, hello, 

    9 years ago from London, UK

    A good idea and thank you for the tip.

  • Simone Smith profile image

    Simone Haruko Smith 

    9 years ago from San Francisco

    P.S. You should totally upload a template for people to see into a Table Capsule!

  • Simone Smith profile image

    Simone Haruko Smith 

    9 years ago from San Francisco

    Thanks for creating the Hub! I track my credit cards carefully and think it's an important practice. I appreciate your creating a helpful guide to help get people started!

  • htodd profile image


    9 years ago from United States

    nice hub ..Thanks for it

  • saket71 profile image


    9 years ago from Delhi, India

    Thanks for the hub. As the tax season is around and tax deductions take toll on the monthly incomes, and I am all set to the annual re-discovery of my financial foolishness, the timing of the this blog is opt. Hope the hit next year would be padded better.

  • AskAshlie3433 profile image


    9 years ago from WEST VIRGINIA

    Thank you so much! This will really help me with organization. That is one of my big faults.


This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

Show Details
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
ClickscoThis is a data management platform studying reader behavior (Privacy Policy)