I created this finance tracking sheet a few months ago and my family members and friends have found it very helpful for them. Since we are approaching a new year, I thought that this sheet would potentially be helpful for other people as well.
This finance tracking sheet which allows you to track all of your transactions, both spending and income. Below, I will be going over how each tab works:
**Sheet**
[https://docs.google.com/spreadsheets/d/1SdtChqxlmuiWmzpP5szXAFj3cm86FoGDznFiiDrgutk/edit#gid=0](https://docs.google.com/spreadsheets/d/1SdtChqxlmuiWmzpP5szXAFj3cm86FoGDznFiiDrgutk/edit#gid=0)
**Key**
* This tab holds your personal spending and income categories
* Change/add your own spending categories in column A
* Change/add your own income categories in column B
**Spending by Day**
* This tab is used to track your daily spending
* Choose the budget category, date and amount for each transaction
* You can also add notes to give more details about each transaction
**Income by Day**
* This tab is identical to the ‘Spending by Day’ tab, except it is used for your income
**Spending Report**
* This tab displays a summary table and chart for your spending
* If no month and/or year are chosen, then the lifetime data is shown
**Income Report**
* This tab is identical to the ‘Spending Report’ tab, except it is used for your income
**Net Worth**
* This tab allows you to track your net worth throughout the year
* Change the categories in column H to your personal assets
* At the end of each month, insert the amount you have for each category
I hope this sheet helps some of you to keep track of your spending and help you to be more aware of what and where you are spending your money! Please feel free to comment about any suggestions you might have for this sheet.
