Budget Smarter Budget Spreadsheet | Download | Personal Finance

[@lucasvanduyn9142]

do you have an excel version of this template

[@whyworksmarternotharder]

Coming Wednesday!!!

[@ShoRon36]

@@whyworksmarternotharder I just purchased the Google Dashboard version, how do I get the Excel version (my preference)?

[@whyworksmarternotharder]

@@ShoRon36 can you message me on the Etsy platform and We will work that out

[@ShoRon36]

@@whyworksmarternotharder can do, thanks.

[@derekroderick3543]

how do you download the excell sheet?

[@Bentakill]

Thank you so much for providing these templates for budgeting. I’m like most people and just spend haphazardly after every paycheck without knowing how much I am actually spending. Thank you seriously.

[@MARIASANTOS-nn3yj]

when I watch excel budget template i just follow it , and watch over and over again , and it work for what I need..Thanks working like a Pro now

[@OGChadney]

So excited for this! Just purchased your debt snowball and google sheet extended templates!!

[@Satao254]

Am glad you are back and thank you for making the template downloadable. Best budget template on KZbin

[@whyworksmarternotharder]

Thanks for the positive feedback!! Glad you like it!

[@jdanpey]

Your ideas are so helpful and saved me having to spend $$$ on Quicken every year!!

[@whyworksmarternotharder]

Love it!! Love hearing that!! Thanks for the feedback!

[@stuntcat8714]

Again, great videos. I have multiple businesses which I've been running for about 3 years by the seat of my pants. So I'm glad I found this. I just need to figure out how to make it work for my multiple variable income streams. But this gets me on my way. Thank you.

[@meh0312]

I had seen your previous video and purchased the enhanced template. I was glad to see you had this video. This is perfect. I have been using a basic spreadsheet that did some of this on a rudimentary level. I wanted to step it up, and this template has almost everything on my wish list.

[@whyworksmarternotharder]

**Regarding Semi Monthly pay periods (1st and 15th). Semi monthly not currently an option. You could enter that income source 2 times. Once monthly on the first and once monthly on the 15th!!

[@ArtWeSewInLuvCreations]

Thank you so much for creating this template! It is exactly what our household needed.

[@whyworksmarternotharder]

I’m so happy to hear this! Seriously! It’s why I do it!!

[@SaadonAksah]

Awesome! Thanks for sharing this! 👍

[@katl6426]

Thank you for a budget that actually allows for fortnightly income not monthly! All the ones I've seen only have monthly & it's very annoying as many expenses are also fortnightly to fit the income

[@thedvguy]

This is a very good plan. I would add a clothing budget line item. It's something that you have to do periodically. It's good to budget fir it. Thanks! this was great!

[@AudioBrainCleanse]

NOOOO I loved making them with you!!!!

[@Fscmco]

I like something that uses Envelopes, electronic obviously. So I can deposit money into the various envelopes and withdraw when the expense comes due. In the mean time I accumulate the deposits until needed.

[@Alex-B2357]

Hello this budget tracker is phenomenal, thank you. I will be purchasing the file from your Etsy store to show my support. I realize this reads like I’m a robot but I’m a real person with a family and a W2 job. Thank you again.

[@Padolas]

Great work, I'm definitely gonna use this! Do you have a spreadsheet for multiple accounts, where I can transfer between accounts?

[@annaisakiwi]

So love this! BUT... I need more income lines - any chance? PLEASE

[@Lauderdaleballaaaa]

Is there a way to add more cells under "Fixed Expenses" on page "Fixed Categories Setup"? Apparently I have to many bills lol. Purchased the Pro version on Etsy

[@MatthewOchoa]

Not yet. From what I saw in some of his responses, you can add those in the Variable Expenses.

[@TimMfillinIn]

Done, been using the self build, glad to have this! Just purchased!

[@whyworksmarternotharder]

Awesome! Thank you!

[@99bogatyrs99]

The thread below left me kind of confused. Is there an Excel version? If so, how do I get it? Thanks; I love your work.

[@njuhmbunwe6701]

I will like to purchase. Please can you elaborated on the difference between the basic version and the extended? I will like to know my options to see that which best fits my needs . Thank you. Hopefully you see this message and respond.

[@Drizz1717]

Interested. Can you do an overview video about the extended version.

[@tibbakabugu6107]

I bought this on Etsy and it has been extremely useful. I'm experiencing a problem with your Query Formula ($0 Based Budget Checking tab, Cell C3). It pulls all of the fixed expenses from the fixed categories set up, but only up to row 36; anything below that row isn't included (pulled) onto the $0 Based Budget Checking tab, giving me an incorrect running balance. Could you please share the formula that fetches up to at least Row 150 from the Fixed Categories Set up tab? I'm having difficulty and require assistance.

[@whyworksmarternotharder]

The formulas are in the background. Any additional fixed expenses would need to be added in the variable tab

[@allendivine8725]

Your videos are awesome learned so much. Is there a way to keep track of debt and savings balances

[@whyworksmarternotharder]

Coming soon!!

[@allendivine8725]

@@whyworksmarternotharder iF I wanterd to add a savings account to this. can I use the instructions from your previous video to do this ( will it work)

[@whyworksmarternotharder]

@@allendivine8725 should!!

[@allendivine8725]

Thanks

[@mohammedosman88]

Thank you so much, I have just purchased the dashboard included one - I like the idea of the spreadsheet but as I mostly use credit and pay in full every month, I am not sure I can get a real feel of my balance in checking account - any suggestions?

[@whyworksmarternotharder]

I do the same thing. I budget an estimated amount each month for my CC.

[@juliuspresley9982]

For the fix income source should I put my net income or gross income?

[@RegAU_4214]

I live in Australia where the date format is dd/mm/yyyy. Is it easy to change the format in the template?

[@WagyuYeti]

I think I must be overlooking the info. What does the colors changing in the running balance column mean? What triggers the color changes?

[@cook6052]

Do you have a plan to add .CSV files to import data from CC and Debit cards or have a suggestion that would add the column fields? I'm a retired financial advisor and love the format....great job!

[@alphonsogee]

So, you mention in the beginning of the video about people asking if it could be downloaded. I was waiting for that info but didn't hear it. Did I miss that part? I would love to be able to just download it. Thanks!

[@whyworksmarternotharder]

There is a link in the description

[@IreneBTV]

@@whyworksmarternotharder I thought it's free

[@davidziaja]

Hi there! I love your budget spreadsheet, but once I get to row 38 on the template it stops getting picked up by the based budget tracker. Is there a correct way to add rows for more fixed expenses without compromising the formulas?

[@nickgamez7192]

Thank you so much for making this template available for download. I am running into a wall though. I was able to get it, download it, and make a copy, but when I exit out of Sheets and go back in later, the budget doesn't show. Not does the original Sheet that I make a copy from. Am I doing something wrong on my end? Thank you!

[@nickgamez7192]

nvm I figured it out Thank you

[@tuckercook6464]

im not sure if you are going to see this but i purchased your budget and for some reason on the 0 based budget and the adjustment tab its starts at 1900-1918 then its transtions to the correct time is there a issue with the doc or can i fix it

[@tuckercook6464]

that was my bad i forgot a date

[@kaylacaldwell9480]

Absolutely amazing spreadsheet, thank you! One question: what do you do if a fixed expense or income changes?

[@allendivine8725]

go to the adjustments to fixed tab and put it under the actual amount on the income or expense side.

[@cassandraarmstrong6273]

I have a drop-down for all 12 months for groceries, fuel, fast food, and misc shopping. How can I enter a different value for each month in a specific cell?

[@arielonnis1]

Great, but how do you calculate the monthly variable-debits because of inflation? The only fixed amount use to be salary

[@whyworksmarternotharder]

On the adjustments to fixed tab

[@stephenharris6769]

I've been using the basic version for a while. I was wondering if there is a way to format the forecast so that it either creates a cell for todays date and jumps to it, or it jumps to the next payday. I'm just trying to prevent scrolling down and catching up to todays date range every time I open the document.

[@whyworksmarternotharder]

You could hide older cells or hit CTRL+F and then type todays date

[@martinlund3093]

Great content and exactly what i need! But, i live in Denmark (Scandinavia) and have a different date format and currency. Also my setup is in danish. Will the free template guide with your formulas and different date format+currency? I know its easier to download the template, but i love the learning by doing it myself :)

[@PaulThacker-ro7bp]

Hi Andrew, can you purchase the extended version in excel? Thanks Paul

[@HeidiB2018]

Hello, how can I add more more rows in fixed category setup?

[@ReneeThompson-mo4qj]

❤ this video I would love a copy please.

[@the09websta1]

Well done! Thank you.

[@oupaswoodshop1325]

Excellent budget, definitely going to improve my spending 🙄

[@whyworksmarternotharder]

Perfect!

[@ubersticks]

I am comfortable with both Excel and Google Sheets --- should I prefer one over the other?

[@whyworksmarternotharder]

They are both good!

[@ubersticks]

@@whyworksmarternotharder Ok I purchased the Excel version..... some very impressive Excel and VBA-fu in that sheet! Some comments and questions: I have a kickass PC (32GB DDR5 i9-12900K) and it takes about 3 seconds to "Add Expenses" and to "Update Budget Smarter" each -- very irritating when iterating on some setup info. Also I need to add some more Fixed Expenses to the Setup, so I inserted a line near my existing medicare expenses -- this newly inserted line looked fine, caused no obvious errors, but it was not included when "Add Expenses" was pressed ?!? This shakes my confidence a bit. Is inserting lines not allowed in the setup table? How to get more lines?

[@turalgasimov5557]

Thanks for sharing this!!! Is it possible to change the currency?

[@whyworksmarternotharder]

Yes!! File, options, currency. It’s in the how to tab!

[@garetholson4537]

Thank you so much this is going to help me out so much

[@terrifouch8088]

How do I obtain a copy of your Excel version of Budget Smarter Budget template?

[@whyworksmarternotharder]

worksmarterstore.etsy.com/listing/1290604847

[@Meocross]

@@whyworksmarternotharder Please add this link to your description. I should buy this excel one as well, my parents are threatening to take away my $200 allowance if i don't take this budgeting seriously!

[@livinginsaccounty]

Awesome video. What’s the difference between the basic template & extended? It says “dashboard included” but what does that mean? In your video did you use the basic or extended sheet?

[@whyworksmarternotharder]

The video is the basic version. The extended has categories and a dashboard that lets you see your spending habits. Shows details about min,max,average balance, top expenses and income vs expense. Also can look at trends with any expense. Pretty cool actually. Categories are completely customizable too! I think it’s great value…but I might be a bit bias.

[@livinginsaccounty]

@@whyworksmarternotharder does sound cool. Thank you for creating this.

[@Drizz1717]

I love the original budget, so what's different about this one?

[@MatthewOchoa]

Can I change the date of when I received my expected income/expenses in the adjusted to fix? Someitmes my paychecks come in a day or 2 different than my expected date.

[@brokedownsuperman]

Can’t wait to use this

[@whyworksmarternotharder]

So glad!

[@peaceout1914]

Is there an option that can tell you where to pull money from for certain bills. Say I put in $300 earned, can it tell me to allocate certain amounts for specific bills? Not sure if I am explaining it right.

[@willarreola18]

How to add more rows to fixed expenses?

[@whyworksmarternotharder]

Right now there is only 25. You can add them manually to the the variable expenses

[@Drizz1717]

I have sinking funds that I put into savings account, then move to checking account when the time is right. How would you go about this?

[@j.rootsthebarber]

Would be awesome if you made a tracker for self employed people in the service industry . I never go below making 4k a month usually 4-7k a month but still want to plan in a organized manner. Any tips ?

[@whyworksmarternotharder]

I would estimate low and adjust as you go. Basically budget on the lower end

[@drthimas85]

I had that same question but im just going to add in the adjustment part.

[@mattschorr1666]

Why does the Google Sheet version automatically update vs. the excel version which requires interaction from the user?

[@whyworksmarternotharder]

Google sheets has query formula

[@MindfulnessOne]

I'm a full-time doordash driver and I take my pay daily. Is there a way to make a daily income?

[@whyworksmarternotharder]

You would add it to the variable sheet

[@brenda9286]

Glad your back... Do you have this in Excel?

[@whyworksmarternotharder]

Coming next!

[@Christopherdiornguyen]

I have a problem with the adjusted to fix tab. It starts with the year 1900 I don’t know how to fix it please help.

[@whyworksmarternotharder]

There’s a simple fix for that. I reached out to you on Etsy.

[@mystique2183]

Is there a way to add multiple checking and savings accounts have the spreadsheet calculate them separately? I have accounts for bills and spending (checking) and emergency and other (savings).

[@whyworksmarternotharder]

You could make multiple copies. One for each checking account. There is a way to add a savings account. kzbin.info/www/bejne/p5eUkGehma2sZqs

[@mystique2183]

@@whyworksmarternotharder Thanks for the response! I'm looking forward to using the spreadsheet. I know it's going to be really helpful.

[@yfjurado]

Good evening... I have a problem with the Budget Smarter_Extended Plan... when I enter the Fixed Categories Setup more than row 36, they are no longer correctly registered to be reviewed in the Adjustments to Fixed sheet... I downloaded it several times and it keeps failing. .. could you please help me to see what happens? thank you

[@whyworksmarternotharder]

Because of all the background formulas, you can’t add additional expenses to set up page. You could add them manually to the variable expenses page.

[@Meocross]

I can now budget for my anime and makeup without looking like a complete fool. Do you know how often i run out of grocery money? Or am too afraid to ask my parents for extra money because i didn't do a looong budget list on pen and paper?

[@whyworksmarternotharder]

Love it! Made my day

[@danroberts5548]

Thanks for the Video. Where can i get it?

[@whyworksmarternotharder]

There is a link in the description of the video!

[@oupaswoodshop1325]

Why is this excel sheet so sluggish after completion? is there something we could change to speed it up? How could we limit the month and balance displays to show only the actual transactions?

[@whyworksmarternotharder]

I think you are talking about another budget video. This one is in Google sheets. It won’t be sluggish.

[@deannatyler3122]

Is there still a download for this?

[@whyworksmarternotharder]

Yes: worksmarterstore.etsy.com/listing/1252378574

[@Aidastitches]

Thank you!

[@afiababy22]

Could u please make an interactive dashboard Thank you

[@whyworksmarternotharder]

The extended version has one

[@rollingthunder4599]

Why do I have to go through all these steps? Because I want to learn how to do this.

[@stevew4079]

Oh wow; thank you!

[@whyworksmarternotharder]

Thank you!!

[@user-bs3fe6jk3v]

How can I change currency on that sheet?

[@whyworksmarternotharder]

support.google.com/a/users/answer/9308758?hl=en

[@rollingthunder4599]

What is the yellow and orange? I could guess, but I want to be sure I'm right

[@whyworksmarternotharder]

Conditional formatting. Basically let’s you know when your balance might be getting low

[@whyworksmarternotharder]

Great question

[@lilredrenethompson76]

Do you have any free ones.

[@whyworksmarternotharder]

Yes you can build your own. Link in description 😏

[@Kolossvs]

Google Spreadsheets Noob question: I'm trying to add more rows at the bottom of the Fixed Expenses area so I can add more items. However, any data I enter is not showing up in the $0 Based Budget_Checking tab - what am I doing wrong? Thanks

[@whyworksmarternotharder]

There is a lot of background formulas. So adding more won’t work. You could add them manually in the variable space. I plan on updating with more expenses down the road

[@PFGFrankly]

ahh nevermind this wont work because my pay is not standern, it can be up to 700 or down to 200. really depends

[@skoobee5570]

love these simple videos - but he goes too fast!

[@whyworksmarternotharder]

You can slow down the speed in the YT settings!!