The credit card is one of the biggest villains of financial control. Even for those who are reputed to be savers, having a credit card in their hands without control can be the difference between being able to save at the end of the month. So, thinking of helping you out, let’s show you how to make a financial control spreadsheet for your credit card and keep your finances on schedule! Follow:
1. Choose the program
Making your own spreadsheet for controlling your card is interesting because it will be adapted to your reality. The first step to this is to choose which program you will use. Most suitable are Excel, the official Office spreadsheet program, and Google Sheet, which works like a cloud, allowing you to access it from any computer.
2. Creating the Financial Control Worksheet
Your spreadsheet should contain tabs for each month of the year. In these, you must specify all the expenses you had with the credit card in the month mentioned. In each tab, create a table whose columns are: description of the expense (for details what the purchase was), purchase amount, category and installments. At the end, you should enter the sum function to get a sense of how much your bill will be for that month.
3. Determine your main categories
Take a look at your expenses and determine which categories you can divide them into. For example: supermarket, bars and restaurants, transportation, leisure etc. It is with this information that you should fill in the “Category” column of your spreadsheet. It is important to get an idea of how much is being spent on each item and try to keep spending within a certain range. healthy goal that does not hurt your finances and exceeds the limit of the card.
4. Stay tuned for installments
It is common for split purchases when they have a higher value. But if you do, be sure to put it in the spreadsheet by typing in the “installments” column the number of installment payment installments. It is important to remember to transfer this expense to the following months. , until the end of the installments. This way you will know how much you still have to pay for that purchase. And remember: only parcel in the last case!
Installment purchases are a trap to curl up and have a headache in the future. The ideal is always to save money, to be able to get the good view and still to get a discount.
5. Automating the process
Many times we don’t have the time or knowledge to work with a spreadsheet. It requires attention and dedication to keep up to date and bring us benefits. In these cases, automating tracking using a spending control application is a great way out. GuiaBayment, available in Android, iPhone and web versions, is a good example. With it, you can access your smartphone and check your spending anytime, anywhere.
Spending is already broken down by category into a monthly chart, indicating where your biggest spending is. Are you already controlling your credit card? Share your tips in the comments!