The pie chart will update once you change the period to filter by. Click on the B43 cell and choose the period from the drop-down list. It lets you filter out expenses by a certain period. The expense tracker Google Sheets looks as follows: If the default ones are okay, then skip this step. Here you need to specify your categories for income and expenses. On the Expense Tracker sheet, you’ll see the grouped rows for income and expenses. Import your income/expenses – the sheet where you can manually or automatically import data about your revenues and expenses.This sheet also contains the breakdown of income and expenses by categories/months. Expense Tracker – the sheet with the tracker itself: it allows you to filter out expenses by categories according to the selected period.The expense tracker was designed in Google Sheets and consists of two sheets: Google Sheets spending tracker template explained Does it sound enticing? Then check out the personal Google Sheets expense tracker template, which is available for your use for free. Based on the analysis, you’ll be able to decrease expenses and increase savings. Examples of categories include food, insurance, utilities, etc. The idea is pretty simple: you need to categorize expenses by category and analyze how much you spend on each. If you prefer using a spreadsheet, Google offers a free to-do list tracker template for Google Sheets.Tracking expenses is the only way to make sure that your money does not go down the drain. You can easily make such a list in Google Keep, Evernote, or Apple Notes. If your bills are simple, but you want peace of mind that you won’t forget to pay any of them, you could put them on a simple to-do list. Learn more | Open in Google Sheets | Download for Excel Bonus: Use This Simple To-Do List Spreadsheet for Bill Tracking This very simple template is a good place to start for building your own custom bill tracking spreadsheet. Learn more | Download for Excel Bill Tracking Spreadsheet Starter Template This bare-bones bill payment checklist for Microsoft Excel is easily customized and prints nicely. View the Monthly Budget Template Simple Bill Pay Schedule Spreadsheet from Excel Templates
Bar graph visualizations are a nice feature of this template. Google offers a free Monthly Budget tracker that can easily be adapted for tracking bills. Open in Google Sheets | Download for Excel Customizable Monthly Budget Tracker Monthly Budget Tracker from Google On the bill tracker spreadsheet page on, you can also download a free PDF version of this checklist. This simple, printable spreadsheet helps you organize your list of bills, then print a copy to use in your budget planner. Best Free Spreadsheets for Bills Best Bill Payment Tracker for Google Sheets Bill Tracker Spreadsheet from the Tiller CommunityĮasily track bills you manually pay via check or credit card with this flexible, highly visual bill payment template.Įven better, since it comes from the Tiller Community, it’s compatible with spreadsheets powered by Tiller Money Feeds.īill Tracker Worksheet from Vertex42 Vertex42 Bill Tracker Template Here are five free spreadsheets for bills to keep you in control of your cash flow and account balances. Here is a free monthly spreadsheet budget you can download today. Note: A monthly budget can also help you anticipate upcoming and recurring expenses. See your upcoming bills on the go with Excel and Google Sheets mobile apps.Track bills with your spouse or business partner.This can catch inaccuracies, but also help manage cash flow.Ī bill payment tracker spreadsheet is perfect for people who prefer manual tracking, or a combination of automated and manual bill tracking. While automation is a winning financial practice, many people prefer to manually pay their bills. While there are many ways to track and pay your bills (including automatic payments), a simple spreadsheet for bills is a great tool for the job.Ī bill payment spreadsheet can help you track past and future payments, see how much you owe and pay each month, and (where applicable) show the interest rates on each account so you can prioritize payments before you owe excess interest payments.