Bridging The Gaap

Download BTG’s “Where’s My Money” Excel Budget Template

New and improved in verison 1.1 (click the link for more information about v.1.1, any link on any page will automatically download the latest version of the template): Ability to input and calculate net monthly income from weekly paychecks; ability to calculate specific categories as % of net monthly income (ex: housing, food, savings, etc…)

Do you ever have the feeling that you have no idea where your money goes?

You know you’re spending it, but you just can’t remember where, or when, or how much, right?

Well look no further! The BTG “Where’s My Money” excel budget template was created to help solve just that problem.

There are 6 worksheets in this excel file (you may have to scroll to see them all). They are as follows:

1) Disclaimer: Please read this first, as it contains necessary information as to how to use the template.

2) Fixed Expenses: Fixed expenses are expenses that you must pay. This category includes housing/transportation costs, insurance costs, utilities, subscriptions, and debt repayment.

3) Purchases: this worksheet is where all your VARIABLE expenses will go. Variable expenses include food and anything you buy that does not meet the criteria of a fixed expense (ex: hobby spending, late fees, restaurants, clothing etc…). There is a space for you to input where you purchased the item, so that at the end of the month you can check and see if you spend a disproportionate amount of your income on any one category or store.

4) Savings: This worksheet allows you to track how much you are putting away each month for various categories of saving and investing. The easiest way to ensure you are saving/ for your emergency fund or for extravagancies is to make automatic deposits (click here for more information). This can also be done for investment accounts, depending on the account.

5) Summary: gives you the totals in each category (ex: fixed expenses) and sub category (ex: housing). This worksheet will also tell you what percentage of your income is being spent in each category, and the total amount of money you have spent. The picture below is part of the summary.

6) Under-Over: tells you, based on your Net Monthly Income (after tax) whether or not you are under budget or over budget in a given month, and by how much.

Download BTG’s “Where’s My Money” Excel Budget Template! 

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.