How To Project Your Cash Flow
I am constantly amazed at the amount of money people waste on bank charges. Overdraft fees are not worth the line of credit they provide. Are you wandering the rough ocean of overdraft? Keep reading for your map to calmer waters.
In a previous article, I addressed overdrawn accounts. The article prompted questions from my clients about their budgets. Most people think budgets are the magical key to solving their money woes. Budgeting helps you project where your money is going, in categories. It acts as a compass. Budgets usually show actual prior year figures versus projected current year figures. However, it is not the only aspect of effective money management. When used in conjunction with navigational tools you’ll sail much smoother.
The most simple and most overlooked navigational tool is a cash flow projection. You can quickly see where your money is going for the current month. It shows how much money you’ll need and when. If you’re one of us living paycheck to paycheck, as Nina mentioned in her recent article, try a cash flow projection. It may be the lighthouse you need to guide you away from trouble.
If you are apprehensive or afraid to look at the numbers, relax, and get comfy. Facing what is actually happening with your money can be freeing. Print these two Excel pages and follow along.
The first is a sample cash flow projection. The starting account balance for the month is $85. Then we added in all the actual bills and their due dates. We added in the two regular paychecks this person receives too. The column on the right automatically calculates the running cash balance.
This sample shows how this person will be low on money the last week of the month. It also shows the monthly expenses exceed the monthly income. It has provided a lot of information and leaves us with some options before it’s too late. Here’s a perfect example of anticipating an overdrawn account.
So take out your bills and dust them off! Open the cash flow template and plug in your numbers. Use all the actual figures you know and add in some extra for leeway.
You’ll see where you stand. If you have a week where your account looks like it will be overdrawn or very low, now may be the time to make payment arrangements for your bills. If it occurs consistently perhaps you can request the dates your bills are due be changed. Can you adjust the dates you get paid? Get creative. A little finagling now may help you avoid overdrawn bank account fees.
Keep using a cash flow projection and steer clear of negative bank accounts. Modify the sample cash flow file to work for you. Or develop and customize your own system. Put yourself in the captain’s seat on the sea of your finances.
We love hearing your money tips and tricks. Share them with Queercents readers below!
I used to have a problem with overdrafts until I started paying attention to this – you are so right. The way I manage it is to use my bill paying software (Quicken) to schedule all transactions 30 days out, including estimates for gas and variable utilities, and any income. It makes it easy to see the lowest point of the next 30 days and make adjustments. For example, I just put in estimated transactions for school supplies and new school clothes and realized I had better scale back some aggressive debt payments.
I’ve figured out my monthly fixed expenses (rent and all bills, *not* food or extra debt repayment) and now I pay them from a separate checking account. Every paycheck I transfer in half of the monthly expenses. Whatever is left in my main account is what I use for debt payment, saving, and living expenses.
This doesn’t erase the need to budget but it does assure me that I will always have the main requirements covered, and makes the cashflow of my day to day requirements much easier to see.