Need to create a project schedule? Try our Gantt Chart template!

Weekly and Bi-Weekly Budgeting Solutions

Solutions for Weekly Budgeting

I’ve been getting requests for weekly and bi-weekly versions of my budget templates. One approach is to just modify a monthly version to make it work for a weekly budget (Solution 1). But, I’ve also added two new weekly budget spreadsheets (Solutions 2 & 3).

Solution 1: Converting a Monthly Budget to a Weekly Budget

Personal Monthly Budget

For some budget templates, the only thing that makes them “monthly” vs. “weekly” is the label at the top of the worksheet. You can convert the following budget templates to weekly versions by simply changing the title of the template:

You can make copies of the worksheets, as new tabs in your workbook, to create budgets for more than one week.

Solution 2: NEW Weekly Budget Planner

Weekly Budget Planner

Most people have both fixed and variable expenses. Spreadsheets like my personal budget and family budget planners can be helpful for listing expenses in the month that they will occur. That’s where the new weekly budget planner comes in.

It’s possible to just change the labels in the family budget planner to week numbers instead of months. But, for a weekly budget you’d likely want more than just 12 columns. That type of change is a bit more difficult, so I created a new Weekly version of the Family Budget Planner that includes 26 columns. That allows you to plan either a year ahead for a bi-weekly budget or 6 months ahead for a weekly budget.

Solution 3: NEW Weekly Money Manager

Weekly Money Manager

I created this template as a cross between my monthly budget template and the more powerful money management template. The goal for this weekly money manager was to simplify the customization of categories while maintaining the power of listing Transactions for multiple accounts.

There is no Help worksheet included with this template, but the Help worksheet in the money management template can explain the principles needed to enter Transactions.

To track your budget for the next week, you would make a copy of the worksheet tab. Then update the time period, clear out the transactions, and update the carry over balances.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
36 comments… add one
  • Excited to test drive the new weekly budget tool. Is something up though with the fomula’s starting in D7? I have it set to weekly, and it seems to be adding the ‘7’ to both the month and not the day, so after January 8, I get August 15th. I’m not smart enough to fix that on my own!

    Reply
    • @Sandy, I was unable to produce the result you were seeing using Excel 2003 and Excel 2010, but I did find a bug in the formulas in row 7 of the weekly-budget-planner.xls file. I’ve uploaded a new version.

      Reply
  • hi,

    i try to use ur tool (Money Manager) and i cant find the list of ** ACCOUNTS ** to change some entrys. For Example Babscard into ALsCard…. where can i change that?

    ‘Thnx

    Reply
  • I absolutely love your excel templates

    Thanks,
    John

    Reply
  • Would like to use the Weekly Budget Planner and change to bi-monthly. Can’t figure out how to do that. Could you help? I get paid on the 15th and last day of each month.

    Thanks,
    Jay

    Reply
    • @Jay … You can enter dates manually in row 8 instead of using the formulas for changing the dates. You could then delete row 7.

      Reply
  • Do you happen to have any solutions for a household budgeting system whereby one income is steady and the other income varies from month to month due to self employment?

    It can be 2-3 months before I get a check, however my wife is paid bi-weekly. Just wondering if you had any ideas. I would like to have a profit/loss for my business, and then set a budget after business expenses, taxes, etc have been allocated for.

    Your website is absolutely amazing and I really like what you’re doing. I have been using the money manager, but feel that while it does a good job, it doesn’t offer exactly the solution that I need.

    Reply
    • @Jerod, Hmmm … the money manager is what I would have suggested because it allows you to enter different income/expenses for each month of the year to handle variable income. What exactly is it about the budget worksheet in the money manager that doesn’t work for your situation?

      Reply
  • When entering my monthly income on the budget tab, I used gross; however, when entering my deposit on the transaction tab, I used the actual deposited (net) amount. When looking at the report tab, it appears I have not met my budget. How do you take this into account? Do I not enter gross income with deductions (taxes, 401K, fsa, etc.) listed below:?

    Reply
    • @Polly, if you do need to keep track of the amounts withheld from your check as “expenses” then you could enter a paycheck as a split transaction with the gross amount deposited into the income category and the amounts withheld listed as payments to various expense categories.

      Reply
      • Then the account balance on the transaction tab is not correct? Or do I need to do two transactions for these “expenses” – one as an expense against the income going into checkings and one as a deposit into the expense account (savings, 401K, etc)?

        Reply
        • @Polly, it’s hard to know exactly what to tell you without knowing how you have your accounts and budget categories set up. You can email me with more specifics. If you had 401K as an expense category (as opposed to an “Account” that you are tracking), then a simple split transaction example would be total income of 1000 deposited into Checking (Account=Checking, Deposit=1000, Category=Wages) and then 100 entered as a Payment from Checking to the 401K category (Account=Checking, Payment=100, Category=401K), which would result in a net deposit into Checking of 900, but the report would show Wages of 1000 and 401K expense of 100.

  • Hi, I use OpenOffice. When I try to copy the sheets to new tabs to create a workbook for the year, I find that I cannot print any but the original sheet. All formulas work fine, just no option to print any but the original. What am I doing wrong?

    Reply
    • @Karen, you might try removing the existing print areas and redefining them. But if that doesn’t work, I’m not sure what would be going on in OpenOffice to prevent you from printing.

      Reply
  • I downloaded the budget worksheet for open office. I love it. Easy to use and adapt. I have created my own in the past but wanted to find something a little more user friendly to share with others.

    Thank you
    Salley

    Reply
  • I am currently using the weekly budget spreadsheet and this is very handy where I can record each individual transaction. However, I am wanting to record each individual transaction for the whole month instead of weekly. The dilemma I am having is there isn’t enough transaction area for the whole month. Would you be able to upload or tell me how I can copy and paste a couple more of the transaction sheets so that everything is still figured within the formulas?

    Thank you!
    David

    Reply
    • @David, I assume you are talking about the weekly-money-manager.xls file. If so, try selecting cells F66:M100 then right-click on cell F66, select Insert and then “Shift cells down”. This should end up giving you room for more transactions and keep the other formulas working.

      Reply
  • Hi, I’m wondering if the biweekly version on the Family Budget planner might ever be available for Google Drive?

    Reply
    • @Rachel, I’ve highlighted this template in my list of templates to convert to Google Drive. However, I wouldn’t hold my breath on that. You could try uploading the xlsx version to Google Drive.

      Reply
  • I love your weekly budget planner where you can change it to bi weekly! Its what I’ve been looking for. The only thing I wish it had… 1. a section or tab for actual verses budgeted and 2. a section where I can plug in bills that are paid on the same day every month along with my bi weekly bill payments. Otherwise, its perfect! Do you have something like this? Thank you so much!!!

    Reply
    • @Monica, The weekly-money-manager.xlsx file shows actual versus budgeted. You might be able to copy the weekly-budget-planner.xlsx worksheet into that same workbook and then with some lookup functions and cell references combine the worksheets somehow. That would take quite a bit of work, though. I don’t have anything for the biweekly/weekly budget planner or money manager that automatically adds amounts for bills on specific days of the month. Such a thing is possible I’m sure, but I don’t have anything like that right now.

      Reply
  • First off great Spreadsheet!
    I am using the Weekly Money Manager and I can’t seem to change the categories in the expenses section and have them reflect in the drop-down menu in the ledger. I had no problem changing income categories or changing the “Other_#” categories.

    Reply
    • @Chad, If you download it and the only thing you change is cell A28 (Electricity), then the drop-down lists in the Category column of the ledger will update. However, none of the cells in the Category column that currently say “Electricity” will update. That would need to be done manually.

      Reply
  • Hello, and thank you for some great Excel templates! I’m looking for something with a visual component to a budget. For example, the grid of income and expenses is great. I would like to be able to make a list of entries, such as mortgage $1000 on Jan 1, Payday $800 1/5, electric $100 1/10, payday $800 1/19, etc. Then, not only do the items hit the right categories on the table, I can see a calendar of January and see when I have money and when I don’t. Perhaps then I can see days when I need to plan ahead. Is this too cumbersome to create? Does it already exist? Thank you!!

    Reply
    • @Michael … Interesting idea. I don’t have anything right now that links budgeting to a calendar, but I think that would be fun to build, so I’ll get back to you when I do it.

      Reply
  • I really like the spreadsheet, it has definitely helped me to see that I need to change some of the due dates on my CCs, so that we can spread our money out, without feeling broke all the time.

    I like the calendar idea alot also. Bank of America has it so you can see when bills are due, just fyi.

    Reply
  • Thanks for all the work you’ve done on these spreadsheets. I’m using the Money-manager for excel 2003 and in the Budget tab whenever I change to “year to date” I get an error “#NAME?” in all the actual and difference categories. If I go back to Monthly budget it does not change, the error is still there. Even using the UNDO button the error stays.???

    Reply
    • @JimmyG, perhaps the “ytd” named range was deleted in your file by accident. Select cell F4 in the Report worksheet and see if the Name Box shows “ytd” … if it doesn’t, enter “ytd” into the Name Box. You can Google “Excel Named Ranges” to learn more about how to use and define named ranges.

      Reply
  • Okay, I need a little help. I have entered everything into Money Manager 2003. I was so happy when everything was working. When I looked at the figures closer, I realized I had not included what I call our 5th weeks, two each year. I had already given the different categories a Week 1 & 2 and Week 3 & 4 sub-category, so I simply went in and added a Week 5 and entered the amounts in April and August.
    This works fine for the Budget and the Categories, but not for the Register. Please tell me there is a formula that will make the Week 5 categories work without having to transfer to another form! The Budget is so impressive, enlightening and helpful. I was so looking forward to putting my figures into the Transaction file and tracking actual expenses when I found this hiccup. I hope you can get back with me soon. I pinned Money Manager to my Pinterest page. I love your spreadsheets!

    Reply
    • @sql … I assume you are using the weekly money management template, but I’m just not following what you are doing and asking. If you can email me with more details and attach a copy of your file I may be able to help if I have time (keeping in mind that this is a free spreadsheet, so tech support is extremely limited, especially when it comes to help with customization).

      Reply
  • hello, I’m trying to use the Weekly Money Manager but the Transaction entries aren’t updating in the Expenses section. It was working when first downloaded but after stopped working when I changed and added new items to Expenses.
    Can you help me?
    Thank you for the template,

    Phunsog

    Reply
    • @Phunsog, I’d probably need to see a copy of the file to figure out what might be going on. You can find my email on the About page.

      Reply
  • Love the templates and excited to get a budget going. I do have one issue though, not sure if I’m doing something incorrectly?

    None of the formulas auto update, as in, when I enter a number that should affect another cell, nothing happens. If I click on the cell that should have changed, and then click on the entry field at the top so I can see the formula, and then press enter, the formula will take effect.

    Can you help?

    Reply
    • @Makyla, My guess is that your worksheet is set to calculate manually for some reason. Go to Formulas > Calculation Options and choose “Automatic”

      Reply
      • Thanks for the quick response, that fixed it!

        Reply

Leave a Comment