Hi, I have been using this spreadsheet for a few years to track my expenses and for budgeting. I based it on my playing around with YNAB.
The Budget sheet is used for budgeting similar to YNAB. Only edit the Budgeted column for each category for each month. The rest are calculated based on your expenses. The amount you can budget is based on your income for the month, the budget from last month and the spending from last month.
The Expenses sheet is for planning your budget. The first column of this Sheet is also used as your categories.
The Year sheet is a summary of your expenses, income and savings.
The Consolidate sheet is used to check your numbers against your bank and credit cards accounts.
Expenses and income are tracked in the sheets for each month.
In my spreadsheet I treat credit cards as cash, so it does not have the features of YNAB when it comes to carrying a balance on credit cards.
The current numbers are just examples to show how it works.
Enjoy.
Submitted January 02, 2017 at 08:46AM by ELGrandMatador http://ift.tt/2hHcIjU
