How to Track your Money – Monthly Budget Spreadsheet – Google Sheets Template, Monthly Money Tracker | Onlyinvesting.info

By onlyinvesting.info Sep 10, 2022



I wanted to create a Monthly Budget Spreadsheet that included my Income, Savings, Investments, Bills and Expenses all inside the same tab, so I came up with this layout. I hope you like it!

📌 Link to Purchase:

📌 Since a lot of you have been asking for an Excel version, I collaborated with the shop @alphatwoseven to bring the Excel version to life 🎉
You can find the Excel version here:
** Please note that by buying the Google Sheets version you only get access to the Google Sheets file. If you plan to use it in Excel please visit the shop @alphatwoseven to find the Excel adaptation.

This Monthly Budget Spreadsheet includes the following sections:
– Income.
– Savings.
– Investments.
– Debts.
– Bills and Subscriptions (within the same table)
– Expenses
– Summaries

This template will ONLY work in Google Sheets.

#personalfinance #monthlybudget #moneytips #moneymanagement

Related Post

49 thoughts on “How to Track your Money – Monthly Budget Spreadsheet – Google Sheets Template, Monthly Money Tracker | Onlyinvesting.info”
  1. I really love your spreadsheet since it helped me have more visibility into my money flow. I just have one question: where do I keep track of my credit card bill? I understand that expenses is the amount I incurred, but would the credit card fall under Bill & Subscription section, or Debt?

  2. I came here to learn how to make this on my own and ended up just buying the template 😂😂😂😂 thank you girl!!!!!!

  3. I have a question for you: I noticed that you've recorded all your expenses in dollars. I'm curious to know if you've ever considered converting the currency to a different one. If so, I would love to learn how to convert it to Philippine peso and change the color theme if possible. 😊

  4. Hey ty so muh for your lovely videos! They're mind blowing! When will you create a tutorial on how to make this? Im so excited for your tutorial videos! They are well done! I was wondering if you can also show a video on how you can do a digital planner for 12 months! That would be great! NEW SUBSCRIBER DEFINITELY! ❤❤

  5. This is incredible! Thank you so much. Just purchased on Etsy 😊 what would you do in the case where you have a few annual subscriptions? What would be the best way to incorporate those into this budget system? Thanks again

  6. Now this is a true Girl Boss! I had a few problems opening and sorting out the spreadsheet as i have never done anything like it before. Our Boss Girl walked me through it and after numerous lovely emails i was well happy and satisfied! i Highly recommend our beautiful lady and her amazing spreadsheets 💯✨️🥰

  7. Hi! Really love this template, super functional and looks easy to use!

    How would you recommend tracking a major purchase or vacation? For example, if you had previously saved up for the purchase, it will appear that you went over your income for this month (which is technically true, but not a reason for a red flag since you had actually saved up for it). Appreciate this video and thanks for your answer!!

  8. Question here… I was going over the budget and should I remove 401k from the investment section because it takes it away from our income in the cash flow summary?

  9. Hi, this looks amazing, thank you! The monthly tracker will really help me. However some of my bills are quarterly, how can I add this to the tracker please?

  10. What an amazing tutorial and a spreadsheet. I only have one question, when it comes on putting your income sources, are you putting them on gross income or net income??? Assuming someone with a regular job and investment or side hustle,for a job it will be tax right away, in short, net income. On the other hand, making an income on investments and side hustle, such as, capital gains and dividends is I consider gross income. Also, it will only be tax on filing season. Which part of the income should I put on the spreadsheet, the gross/pre tax or the net/after taxes to make everything accurate??? Thank you and have a great day.

  11. This is beyond incredible and would have taken so much work to set up! Is there a way to view all your income, expenses, and savings for the year by pooling all the information across the months?

  12. I just purchased it, but let me know what is the purpose of not assigned cell in customize here sheet. I don’t really use that one, but if I delete that not assigned cell in customize here sheet, there are occasional blank cell in main spreadsheet. What is the purpose of it, and how can I make the main sheet not use that not assigned cell??

  13. I love this template and I'm thinking about getting it. I saw that you have an annual template too, but I like this one better. Is it possible to add an annual tab to this template?

  14. Hi, I hope you could answer this question. I'm planning to sell spreadsheet template on esty. I wonder, how can I hide and secure the format of my digital products? Thanks in advance

  15. I bought this spreadsheet and my first complete month August 2023 was very eye opening and really so easy to use. I really like this. One suggestion is to have balances of the payment accounts. if someone is looking for a budget spreadsheet I STRONGLY suggest you try this one.

  16. Hi! I'm from Philippines and I just purchased your monthly budget spreadsheet, I'd like to change the currency to Philippine Peso. How do I do that? Please let me know.

    Thank you!

  17. Hi there, just purchased your spreadsheet! For each month, do you just make a new copy? or is there a way to keep all 12 months on one spread document? thanks!

  18. Very nice spreadsheet, I am trying to create one myself as well like your annual sheet.
    I want to highlight total and row of transaction if category or description is empty.

    How can I do that, I will really appreciate if you help.

  19. I've just purchased your sheet and I'm coming up against a problem (I think?). I have sinking funds and some of the expenses I'd be tracking would be paid from those sinking funds and not from my monthly income. How do I appropriately track those so that they're accounted for and that my sinking funds accounts are accurate? For example, next month I have to put new tires on my car. I've saved up for that in a sinking fund throughout the last year. When I go to pay for them, I'm pulling the money from that account, not from the funds from my paycheck. I'm worried that if I track in my expenses, it'll look like I'm going over budget when I'm really not.

  20. Hello, your template was incredible! I tried crafting something similar, but it just didn't come together. I was wondering if you offer any paid courses or guidance on creating these kinds templates. I saw your video on 'How to Build an Income and Expense Tracker from Scratch – Google Sheets TUTORIAL,' which was great, but I'm specifically interested in learning how to build such templates. Can you help me with this?

  21. I'm so glad I found your channel! Really helpful and inspiring. I made a mission for myself this year to create a sheet that will work for me and help me track my finances. I would really like to know how you made it work with the checkboxes in the Bills and Subscriptions table. Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *