Home » Organize-Your-Life 101

Envelope Budgeting 101

22 August 2008 2 Comments
Found this really beautiful reflection for the 25th Death Anniversary of Ninoy Aquino. This is by Fr. Jojo Magadia, SJ, Provincial Superior of the Society of Jesus in the Philippines. He talks about what Ninoy means for us 25 years later. Click here to read the homily.

I am really excited about this post. I found this new software/excel spreadsheet called Excel Check Register Spreadsheet w/ Envelope Budgeting. That’s a mouthful I know, but I will be explaining it here, and I can assure you that it will make budgeting a lot easier for you and it’s really just cool to use. I know, I know, I’m a nerd and I get excited by these things.

What is Envelope Budgeting?

Envelope budgeting is a method where you take your income, convert it into cash, and then allocate your cash into different envelope categories. These envelopes are labeled for various categories of spending including required spending, such as your mortgage, groceries, and medical bills, and discretionary spending, such as eating out, entertainment, and shopping. As you divide your cash into envelopes, you can immediately see what on-hand cash you have to pay bills, make purchases, and contribute to your savings.

To use envelope budgeting, first establish spending categories for your budget and then set spending limits for the categories. As with any personal budget, when you add up the spending categories the total must not exceed your monthly income.

Using one envelope per spending category, write the name of each category and the monthly budgeted amount on the envelopes. If you are paid weekly or bimonthly, divide the total monthly amount for each category by the number of pay periods you have and record that number on the envelope as well.

Why Envelope Budgeting?

Envelope budgeting is simple to set up and manage if organized correctly. It may take some getting used to as this system is so unlike the traditional method of budgeting that most people are familiar with.

By funding the different envelopes you see exactly how you can spend your money until your next pay period. This forces you to spend only what you can and rely less on paying bills with a credit card and incurring more debt.

Benefits of Envelope Budgeting

  • Pre-pay your upcoming bills by funding your bill envelope.
  • Discover where and how you are spending and adjusting spending habits accordingly.
  • Envelope budgeting is a well-organized spending management system – no assumptions, no guessing on where money is being spent and when to pay bills.
  • Makes saving money easier by funding a savings envelope.
  • Never overspend – your pre-allocated envelopes only lets you spend what you have. If an envelope does not have the funds needed to pay a bill or to make a purchase, money from another envelope can be transferred to ensure it can be paid off without overspending.
  • Discipline – the envelope budgeting system teaches you to be on top of your financial situation. By eliminating guess work and assumptions you know where you are financially and can make intelligent decisions about purchasing decisions.
  • Automated Envelope Budgeting

    Now this is the fun part.

    I found this really cool and nifty excel spreadsheet that automates the principles I talked about above. This means that you no longer need to have actual envelopes you keep hidden in your closet or table.

    How to do it?

    First, download the excel spreadsheet here.

    The spreadsheet allows you to separate your checking account’s balance — your money — into any of up to twenty-five different spending “envelopes.” All deposits and withdrawals from your account show up as transactions in one or more of your envelopes.

    Name, rename, and re-rename your envelopes to your heart’s content. Transfer money between envelopes with a few keystrokes.

    Some things to remember while you’re working with this spreadsheet:

  • You’ll enter data in white or light-beige cells only.
  • You don’t enter a single STARTING BALANCE, per se. Instead, create whatever envelopes you need, and then allocate your checking account’s current balance among them until the spreadsheet’s STARTING BALANCE matches that of your bank account. (In other words, your checking account’s balance is always the sum total of what’s in your envelopes.)
  • Enter debits (outflows/expenses) as negative amounts.
  • Enter credits (inflows/income) as positive amounts.
  • The TRANSACTION AMOUNT and ACCOUNT BALANCE columns are completed for you automatically. Just allocate each transaction to its correct envelope(s) and the AMOUNT and BALANCE columns take care of themselves!
  • The spreadsheet can handle up to just over 500 transactions. But you’ll be better off, starting a new spreadsheet well before that so the file doesn’t get too large.
  • Possible Envelope Labels:
    Here are suggestions on what to label your envelopes:

  • Groceries – would probably include Household Supplies and Toiletries
  • Loans
  • Utilities – electricity and water bills
  • Automotive – car maintenance and gasoline—unless you want to make its very own envelope.
  • Credit Card – monthly credit card payment allocation
  • Rent
  • Miscellaneous
  • Savings
  • The key is to have envelopes that represent your major expenses. Everything else I just put under Miscellaneous. I also like to have a Savings envelope. At the start of every pay day, I put a certain amount to that envelope and allocate the rest of my income to all the other expense envelopes. At the end of the month, I transfer whatever is left in the other envelopes to the Savings envelope.

    Split Transactions
    Let’s say your visit to the mall totalled up to P620. Of that, P300 went to your dinner expense, you brought load for P200, and you watched a movie for P120. Your spreadsheet entry would look like this:

    Saving for Major but Irregular Expenses
    Sometimes, we have bills that we do not pay monthly. Let’s say you’re a blogger and that you need to pay P3000 every year for hosting. You can either “cram” the expense or you can set aside P250/month for the next 12 months so you can renew your domain without feeling any pinch at all.

    Moving Money From One Envelope to Another
    You don’t want this to happen of course. But there are times when it’s necessary to move money from one envelope to another. If you need to transfer P500 from one envelope to another for example, just subtract the amount you wish to transfer from one envelope (-500), and add that same amount to the envelope that needs it (+500). The overall account balance is not changed.

    I’m doing this envelope budget system myself, and I really like how I feel more in control of my budgeting. And it’s fun to use! I think we all just need to give it time. It will probably take a few months to perfect your envelope system. Don’t give up after a month or two if it’s not clicking. You’ll get the hang of it and see how beneficial the envelope system is as you dump debt, build wealth, and achieve financial peace!

    Good luck!

    Every Friday is Organize-Your-Life 101 Day at AngPeregrino.Com.
    Shop CleanAir4Life Today!

    2 Comments »

    • shiko-chan said:

      uy eric! gusto ko idownload yung spreadsheet pero walang lumilitaw! :( kelangang-kelangan ko pa naman. hihi ;)

    • -Ang Peregrino- (author) said:

      hey andi!

      hmm… i tried the link myself, and it worked when i clicked on it.

      try it again; sometimes, that site itself has problems yata.

      just leave a message if it doesn’t talaga and i’ll give you the link myself.

      thanks!

    Whatchathink?!

    Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

    Be nice. Keep it clean. Stay on topic. No spam.

    You can use these tags:
    <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.

    Powered by WordPress | Entries (RSS) | ©2006-2008. Ang Peregrino™ and Eric Dominic Santillan. Some rights reserved. Under Creative Commons License | Arthemia theme by Michael Jubel