Open Source Google Budget Sheet
(Original maker @The Frugal Gene)
*Combined the separate monthly summary pages into one single page in a single selectable month. It makes things less cluttered looking.
*Split out income and expenses to separate tabs. Before they were on one page and there was a lot of scrolling back and forth on the page. Plus, when you used the search function, it searched both expenses and income which was unnecessary. Now it’s on a separate sheet for ease.
*Added accounts tracking. Previously, it was done by payment method but now it tracks balances on accounts so you can confirm that everything has been entered correctly. You can also track the balance on accounts.
*Before we didn’t have any tracking on paying off credit card and now there is tracking between transfers to demonstrate that. It tries to track account balance which is more accurate.
*Removed the starting balance and ending balance because it was terribly confusing before. Now it is simply called “Net Saves.”
*The ability to rename months without breaking the sheet if you prefer to look at them in non-English languages such as French or Spanish.
*Introduction of “smart average” which ignores months before you started tracking or that is not yet tracked in order to give you a more accurate average of your spending than just the regular average. The regular average is simply divisible by 12 (months a year total) which isn’t accurate if you were, say only in the month of June.
Click Link to Preview:
Click Link to Make Your Own Copy & Start:
Contact me via e-mail with any questions or comment on the doc.
