July 29, 2025
Expense tracking is essential, especially for those using their credit cards frequently. Credit cards offer convenience and flexibility that allow users to make purchases without an immediate cash outflow. However, these perks also come with potential consequences. Without expense tracking on your credit card use, it can be easy to lose track of spending and accumulate debt.
Consistently tracking expenses enables users to manage their spending and avoid common pitfalls associated with credit card misuse. But let’s be real, not everyone wants to dive straight into expense tracking apps. Maybe you’re not ready to share your data online, or the technology is challenging to adopt.
That’s where a DIY expense tracker comes in—it’s simple, practical, and free.
In this guide, we’ll walk you through how to make your very own credit card expenses tracker using either Excel or Google Sheets. It’s easier than you think. And if you’re not sure how to start, don’t worry. We’ve also linked some ready-made templates so you can get a head start.
DIY Expense Trackers vs. Apps
While budgeting apps are convenient and often loaded with features, some Filipinos still prefer going old-school with spreadsheets—and for good reason.
A DIY expense tracker gives you total control. You decide the categories, the formulas, the layout, and how your data is displayed. There’s no need to worry about privacy since you’re not syncing sensitive financial information online. It’s also a great option if you want to avoid distractions or data limits that come with mobile apps.
Unlike apps that sometimes require subscriptions for complete access, spreadsheets are completely free and customizable. You can create something that suits your budgeting style without in-app purchases, ads, or upgrade prompts.
Plus, there’s something valuable and fulfilling about manually entering your daily expenses. It makes you more aware of your spending habits and helps you build discipline. Manual expense tracking also encourages you to pause and rethink your purchases, especially if you have multiple credit cards to monitor. It’s budgeting with intention, not automation.
Who Should Try a DIY Tracker
You don’t need to be a spreadsheet expert to track your expenses. A DIY expense tracker is perfect for:
- Anyone looking for a straightforward, private way to track.
- Freelancers or small business owners
- People who don’t want to rely on apps
- First-time credit card holders who want to understand their spending (check out this guide on credit cards for beginners)
Tools You’ll Need for a DIY Expense Tracker
All you need is a computer or smartphone and access to:
- Microsoft Excel (or any spreadsheet software you like)
- Google Sheets (great for access across multiple devices)
You can use either; it depends on your preference. For online collaboration or mobile access, Google Sheets wins. For offline use and more advanced tools, Excel is your friend.
How to Create an Expense Tracker in Google Sheets
Here’s a step-by-step guide on how to create an expense tracker in Google Sheets.
1. Set up your sheet and name it
Open a new spreadsheet in Google Sheets. Click on the file name in the top-left corner and rename it to something like “2024 Expense Tracker” or “Monthly Budget Log.”
2. Decide your tracking frequency
Will you be tracking daily, weekly, or monthly? A daily tracker might need more rows and date breakdowns, while a monthly version might summarize data more. Learn more about the differences between a daily vs. monthly expense tracker.
3. Create your expense input columns
Set up the following columns:
- Date: Column A. This will record the date of each transaction.
- Category: Column B. Examples: Food, Transportation, Utilities, Subscriptions, etc.
- Description: Column C. Use this to write details about the purchase (e.g., Jollibee lunch, Meralco bill).
- Amount: Column D. Enter how much you spent.
- Payment Method: Column E. Did you use cash, credit card, or GCash? For credit cards, you can further categorize them depending on the bank and/or interest rates.
- Notes: Column F. Optional, but great for tagging irregular expenses or adding reminders.
4. Add dropdowns for consistency
Use Data > Data validation to create dropdown lists for Category and Payment Method. This makes data entry faster and ensures consistency when filtering or calculating.
5. Format for clarity and visibility
Here are some formatting tips to ensure clarity and visibility:
- Header row: Bold the headers and give them a background color.
- Column widths: Adjust column widths so all text fits nicely.
- Currency format: Highlight the Amount column and go to Format > Number > Currency.
- Conditional formatting: Highlight big-ticket expenses (e.g., over ₱1,000) by setting color rules.
6. Add totals and summaries
Like an expense tracker app, Google Sheets can provide you with summaries and statistics on your spending.
- Monthly total: Use =SUM(D2:D100) (adjust range as needed).
- Per-category total: Use =SUMIF(B:B,”Food”,D:D) to calculate how much you’ve spent on food, for example.
- Visuals: Insert a chart or pie graph to break down expenses by category (Insert > Chart).
This gives you a big picture of your spending habits and where to make adjustments as necessary.
7. Connect a Google Form for easier entry (optional)
If you’re always on the go and can’t bring a laptop, build a Google Form connected to the Sheet. Log expenses through your phone and they’ll automatically appear in your tracker. You can also import data from bank CSV exports or e-wallet statements.
8. Test your tracker and update regularly
Test your tracker with sample data. Check if formulas work, dropdowns are functioning, and your visuals are easy to interpret. Then commit to updating your tracker regularly for best results.
Is Google Sheets too confusing? Check out these free templates to get started easily:
How to Create an Expense Tracker in Excel
Excel is an ideal platform for customization and offline access. Here’s a detailed guide on how to create a credit card expenses tracker using Excel:
1. Launch a new workbook
Open Microsoft Excel and start with a blank workbook. Save the file with a relevant name like “2024 Budget Tracker” or “Personal Expenses Log.”
2. Set up your columns
Create column headers such as:
- Date: When the transaction occurred
- Item: What you spent on
- Category: Type of expense (e.g., Food, Transportation, Utilities)
- Amount: Total spent per entry
- Payment Type: Cash, Credit Card, GCash, etc.
- Notes: Optional, for remarks like bill due dates or one-time purchases
Format your headers by bolding the text and using a different fill color to distinguish them easily.
3. Turn your data into a table
Highlight your data range and go to Insert > Table. Tables make it easier to sort, filter, and add formulas. Excel will auto-format your table with headers, which helps with readability.
4. Add data validation (optional)
To keep data clean and consistent, use Data Validation to create dropdowns for categories and payment types. This is especially helpful when you begin analyzing trends.
5. Add calculations
Use formulas like =SUMIFS(D:D,C:C,”Food”) (totals all expenses under the ‘Food category; change as needed) and =SUM(D2:D100) (calculates the total of all your expenses). You can also create separate cells for weekly or monthly budget totals.
6. Use pivot tables for insights
Create a Pivot Table for deeper insights into your spending:
- Select your full table, then go to Insert > Pivot Table.
- Drag “Category” to Rows, and “Amount” to Values.
7. Add visuals
Use Excel’s built-in charts, such as pie charts for category breakdowns and line charts for tracking expenses over time, to make your data more engaging and digestible.
8. Apply conditional formatting
Use Home > Conditional Formatting to color-code expenses. For instance, you can highlight any transaction over ₱1,000 in red or apply different colors for various categories.
9. Save and update regularly
Don’t forget to save your workbook regularly and back it up. Update your entries daily or weekly for best results.
Want to skip setup? Check out these free Excel templates:
Know Where Your Money Goes
Ready to take control of your finances? Start with a DIY expense tracker today. No downloads, no fuss. Just you, your money, and a spreadsheet that works for you.
Creating your own credit card expenses tracker may seem intimidating at first, but it’s actually one of the most empowering things you can do.
For more practical financial advice, keep exploring Cards.ph.