One of the best ways to be in control of your life is to know what your financial picture looks like all the time. Not having control brings on sadness, fear and depression. If you can see tough things coming a few months down the road, you can prepare for them. You the spreadsheet to plug in your grocery spending, clothing allowance or whatever you feel you need better control of.
Click on the link above to download. If you have Excel, it will automatically open there, otherwise it will go into your Download file. I did this in excel, but if you don’t have that, you can download it to Google Docs. If you are new to Google Docs, here’s what to do:
First you must have a google account; Start with a gmail account. In the upper right corner, you’ll see a block of 9 little squares. Click on that and navigate to “Drive”. Choose New, Google Sheets. When the spreadsheet opens, choose Open. Navigate to your download folder and find the file called Personal Cash Flow.
I use this personal cash flow statement religiously. There are formulas where you need them.
The first thing you’ll do is enter expected income. Enter your expected expenses. You can change anything to personalize the spreadsheet.
In column C, cell 30, you will enter the amount of money you have in your account at this time. You’ll see the numbers change! Keep adjusting and be honest. Don’t fool yourself. If you at the end of a pay period and you have less actual money than what the spreadsheet says, then change it in the cell 30 of the column week you are in.
Good luck and I hope this helps! Any questions, please comment. Let’s all help each other.