How To Make A Budget In Excel


When it comes to budgeting, few things are more of a mental and emotional hurdle than actually taking the time to write everything down. Even if you’re the kind of diligent person who doesn’t mind keeping track of the things they buy, it can still be a huge bummer to actually sit down and look at where your money is going each week.

But there is also a definite benefit in keeping track of it all manually — as opposed to with an automated app — if only because it forces you to really consider each purchase, as well as feel the joy of manually entering each bit of income (particularly when you have multiple gigs or side jobs, which vary month-to-month). Budgeting with Excel (or, in this case, Google Sheets) is a perfect exercise in getting your shit together and holding yourself accountable, while becoming generally more organized in the process.

In this week’s video, Lauren, master of all things spreadsheets, breaks down how she uses one to keep track of everything she spends and earns, and plan months (and even years) ahead for her various money goals. With her easy-to-follow instructions, even complete organizational hot messes like Chelsea can start getting over their fear of using Excel.

  • jdub

    Love this! I have a “debts owing” spreadsheet on which I schedule all bill payments and count down to when it’s all paid off. I’m up to April at this point, and it’s really satisfying to see all the dark lines crossing things out when they’re scheduled to be fully paid off! It’s great to see another option, thanks for this Lauren!

  • Annelie

    Thank you so much. I used to hate excel and dealing with my money filled me with so much dread, that I never really started at all. But following you tutorial I ended up loving it and experimenting with my long term money goals.