This month, the Money Blog Network’s group project is budgets. I’m not in the MBN, but I’ve decided to post a blog about my method for creating a cash flow budget. It’s far more effective for my husband and me than a traditional category-based budget. MBN lists several other budget posts on their site, if you want to test a few different budgeting, and anti-budgeting, methods.

The Monthly Budget by Category
My husband and I use Quicken to track our daily spending. About once a year, my husband and I run out a Quicken budget, just to see how our actually monthly category spending has changed. Then we copy it into Excel so we can play with the numbers: how much more we would have if we paid off this loan or reduced that expense.

This is an example of what that would look like. If I were studying this, I would see that I could cut the dining budget and might consider reducing utilities expenses if possible.

Sample Monthly Budget by Category

The monthly budget is a helpful way to get an idea of how and where we spend money on average, but it isn’t necessarily useful for planning our monthly cash flow. The budget averages out our expenses rather than showing the blips as they actually occur. For example, auto-insurance isn’t paid monthly, but it appears that way in a budget. We have to plan for the blips, not the even keel budget. Instead of a line-item budget, we use a cash flow statement to plan our monthly bills and spending.

The Cash Flow Budget
The cash flow budget is a much better picture of our expected income and expenses for the month. These are actual bills we must pay, rather than categories that may vary every month. For example, if it’s an auto insurance month, then we know to reduce our spending in other areas to make up the difference. It also helps us plan our debt repayment because we know how much we’ll have leftover at the end of the month.

This is a sample of a cash flow budget for February. You’ll note that the numbers above don’t match the numbers here. There are two reasons: 1. I made many of the numbers up, and 2. Most of our recurring charges (utilities, cell phone, gym, etc.) are on one of the credit cards, so we don’t pay them as a separate monthly bill through our checking account.

Expected bills with variable due dates (like a bi-monthly utility) go at the bottom because we know they’re coming at some point, but not when.

At the beginning of the month, we look at our Quicken account balances for variable bills like credit cards and ballpark the payment amounts in our cash flow chart. We adjust with exact figures as the month proceeds and the bills come in. At the end of the month, we take the end number and add it to our debt payments for the next month. Once our debts are gone (except some student loans), that end number will go towards other goals like savings or investments.

In addition, it helps us see where the bills fall in relation to our income. For example, if we plan to make a big credit card payment, but know that the deposit that covers it doesn’t occur until two days later, we can reduce the payment. Then we can schedule another payment after the deposit.

Creating a Cash Flow Budget
If you want to create a cash flow budget, follow these simple steps:

  1. Get out your checkbook register.
  2. Create an excel chart with payment dates and amounts for all expenses for the last six months. Rather than the generic terms I use above, use the names of the payments, like Amex, Discover, and Sallie Mae.
  3. Use three columns for each month like in the above chart. We go across the sheet for each new month rather than down so several months fit on the screen at once. Although you’ll have to tweak it as time progresses, this gives you a good overview of when your various bills are due.
  4. Just before each month, review the expected expenses for that month and make adjustments for changes in your finances. Also review the previous month and carryover any remaining balance to the next month.
  5. At the end of the sixth month, copy the last month over to new columns and update the dates and amounts for month seven.

Once you get used to this system, you’ll probably find that you feel more comfortable with your finances because you always have a snapshot view of them. It doesn’t require special software and no one else has access to your data. If you don’t have Excel, you can use an OpenOffice or GoogleDocs spreadsheet, instead. This is very different from the system I used when I was single, but I much prefer it. Give it a try, you might like it!

Comments

15 Responses to “Creating a Cash Flow Budget”

  1. MBN Group Writing Project: Budgets : MoneyBlogNetwork on February 23rd, 2008 7:05 am

    [...] * SoundMoneyMatters: Creating A Cash Flow Budget [...]

  2. Aaron on October 28th, 2008 10:55 am

    This is very similar to what my wife and I do. It’s the best system we’ve found. We use Google Docs, so we can access the spreadsheet wherever we are.

  3. Aryn on October 28th, 2008 4:59 pm

    Aaron – that’s brilliant! I don’t know why I never thought of that. I’ll mention it to my husband tonight.

  4. Kerri on November 16th, 2009 4:23 pm

    Great post. There’s no other way to come to terms with your financial reality than to spell it all out like this. While Excel and Google Docs are options, there’s a new Web site out there that’s even simpler and will store and track your information over time, called DebtSpark (http://www.debtspark.com). It offers a simple starting-off point for understanding spending–how income, expenses and debt payments coexist.

  5. home budget spreadsheet on December 17th, 2009 9:43 am

    Umn Hmn That s very simple template. For me I like to do on the nice paper or nice form. I think that it relax when we do.

  6. littmann stethoscope on September 9th, 2014 9:57 pm

    Do you have a spam problem on this website; I also am a blogger, and I was wondering
    your situation; we have created some nice procedures and we
    are looking to exchange methods with other folks, be sure to shoot me an email
    if interested.

  7. official hcg diet plan on September 10th, 2014 4:31 am

    Quality articles is the crucial to be a focus for the people
    to pay a quick visit the site, that’s what this website is providing.

  8. seo powersuite coupon on December 14th, 2014 1:21 am

    I was very happy to uncover this great site.
    I wanted to thank you for ones time for this particularly wonderful read!!
    I definitely really liked every bit of it and I have you
    saved to fav to check out new stuff on your web site.

  9. Test Bank Economic on March 18th, 2016 2:35 pm

    I do consider all of the ideas you’ve offered in your post.
    They’re very convincing and will certainly work. Still, the posts are too brief for newbies.
    May you please lengthen them a little from subsequent time?

    Thank you for the post.

  10. Test Bank Biology on March 22nd, 2016 2:35 pm

    If you desire to obtain much from this paragraph then you have to apply these strategies to your won blog.

  11. south san francisco dentist on May 13th, 2016 5:20 am

    I do not know whether it’s just me or if everybody else encountering issues with your
    site. It seems like some of the written text on your posts are running off the screen. Can someone else please provide feedback and let
    me know if this is happening to them too?
    This could be a issue with my web browser because
    I’ve had this happen previously. Thanks

  12. Business Events Deutschland on September 18th, 2016 5:19 pm

    keep up the excellent work, I read few posts
    on this web site and I conceive that your website
    is rattling interesting and has got circles of fantastic information.

  13. eventkalender berlin on October 8th, 2016 5:21 pm

    Pretty element of content. I just stumbled upon your website
    and in accession capital to assert that I acquire actually enjoyed account your blog posts.
    Any way I’ll be subscribing to your feeds or even I success you get
    admission to constantly fast.

  14. Internet Messe on January 18th, 2017 2:53 am

    I very glad to find this web site on bing, just what I was looking for
    : D too saved to fav.

  15. Libby on April 6th, 2017 1:31 am

    Good post. I study one thing more challenging on totally different blogs everyday.
    It’ll always be stimulating to learn content from different writers and
    follow just a little one thing from their store.

    I’d want to make use of some with the content
    material on my weblog whether or not you don’t mind. Natually I’ll give you a hyperlink in your web blog.
    Thanks for sharing.

Leave a Reply




Current Accounts



My blog is worth $16,371.66.
How much is your blog worth?


Finance Blogs - BlogCatalog Blog Directory