I’ve been tracking my spending for 7+ years now and I am proud to share with you the latest Personal Finance Budget & Expense Sheet. 😀
In this sheet, you will need to input all numbers in purple, including salary, health, savings goal, living expenses, flexible expenses, etc. Includes TAX CALCULATIONS so your yearly net amount can be as accurate as possible (although it will never be quite there, so use this sheet as an awesome estimator).
Once again, disclaimers: this is an estimation tool and is in no way shape or form a replacement for your personal advisor or accountant / tax preparer.
(1) This sheet is not going to match your tax refund exactly, but it gives a good basis as to what it would be like
(2) This sheet includes tax calculations for NYC residents. If you reside elsewhere, you will have more money leftover than the last number in this sheet.
(3) This sheet also assumes you take the STANDARD deduction (6200), which… if your NYS tax paid is greater (row 38 + 44), you will be ITEMIZING. (Sheet is currently in the making).
Related post: Monitoring Your Spending
Don’t be a victim of yourself and see this happen –>money flying away (money flying away)
View the Budget & Expense Sheet
Duplicate a copy in your personal Gmail account (File –> Create a Copy).
If you found this useful, care to Venmo me (@winniem) some coffee money so I can work on those feature requests? 😉
Features to be updated
- Itemized deductions (this includes charity, medical expenses, self-employment credits, etc)
- Student loan payment / tax deduction
- Suggestions? Please comment below
2.23.2016 – With any Google Sheet, the revision history is there. For any changes, I will update this blog post about what the change is.
A quick history on my crazy personal finance and tracking habits:
2009: The oldest sheet I can find and this was a basic sheet with date, item, cost. I can’t remember why I started tracking my expenses but since then, it’s been a habit ever since!
2010 & 2011: Expanded columns to indicate my spending specific to each payment type: cash, checking account 1, checking account 2, credit card. I also tracked start and end balances month-to-month
2012: Going from the Google Sheets to Mint since it logs expenses from my credit card anyway. Then realizing it wasn’t always matching the time it was executed.
2013: Decided to move over to Expensify so I could create my own categories (because Mint has a ton) and logged each expense and soon as it happened.
Also when I decided to create a smarter yearly budget sheet with tax calculations and monthly budget amounts (vs actual spend pulled from Expensify).
2014: More robust sheet with tax break out by federal, NYS, NYC, fixed costs, and disposable income (aka flex budget). Still updating monthly spend amounts pulled from my Expensify inputs.
2015: Fine tuning the sheet, still using Expensify monthly inputs.
2016: Moving back to Mint and using their categories because inputting each expense is a PAIN, especially since I use my credit card more than cash.Tags: budget, excel, expenses, tax