free excel templates budget monthly household bills

Free excel templates budget monthly household bills how to#
Free excel templates budget monthly household bills download#

In the second section you describe your expense and put in how often it is paid. For example, you might have a yearly pool membership or a quarterly subscription.

But sometime committed expenses can be of different durations too. So are any subscriptions you have like Netflix or Gym memberships.Ĭommitted expenses are usually monthly – think your phone bill or subscriptions. So for example, your mortgage is a committed expense. What is a committed expense? A committed expense is an expense that you already know in advance what the amount is and it comes out on a regular basis. In this part you need to put in all your committed expenses. Next add in you r committed expensesįor this next part, having a copy of your bank and credit card statements handy can be quite helpful. Once you put this number into the spreadsheet in the lines “Net paycheck 1” and “Net paycheck 2” with the frequency, the template will automatically calculate the equivalent weekly amount for your income and it shows this number at the top next to “Average Weekly Income”.

You can choose “Weekly”, “Every Two Weeks”, “Twice a Month”, “Monthly”, “Every 3 Months”, or “Every 6 Months”. Next choose how often you are paid from the dropdown in the spreadsheet. First input your regular incomeįirst thing to do is to get a copy of your paychecks and fill in the how much you get paid. After putting in your income and expenses, the spreadsheet will calculate their weekly equivalents and let you know what you can safely spend in a week. This is where you will put in all your recurring income and expenses. So to start, open the sheet called “Safe-to-Spend”. The first step in creating a weekly budget is to understand what you “Safe-to-Spend” number is.

Free excel templates budget monthly household bills how to#

(It syncs with your bank and credit cards to keep your Safe-to-Spend number up-to-date!)īelow are the instructions on how to use the weekly budget template spreadsheet to calculate a weekly budget for yourself and then use the spreadsheet to track your personal spending. If you get tired of using a spreadsheet to track of your weekly spending, we suggest giving our weekly budget app a try. It behaves much the same way that our app does but in a spreadsheet instead.

Free excel templates budget monthly household bills download#

You can download our weekly budget template as an Excel document (.xlsx) or open it as a Google Sheet to calculate your Safe-to-Spend and then track of your spending on a weekly basis. If you would like to try and do the same thing but with a spreadsheet instead, you are in luck! We created Weekly as an app to help you stay on track with your personal finances using a weekly budget.