![]() ![]() So split these monthly budget items into 4 weeks, ie $600 groceries a month becomes $150 a week on groceries. This account is for you to use in your day to day. I typically choose Wednesday after many years of trial and error, but in reality you can choose any day. You setup a reoccurring transfer to come out of your “Fixed” account once a week. Instead you set up a weekly transfer to a secondary account.Ĭhecking Accojnt 2 is your “Variable” or “Weekly” account. You don’t have groceries or haircuts or discretionary spending taken out of this account, in fact it’s best if you don’t have real easy access to spend money out of this account at all. Your paychecks and other income goes in, and you only have bills and other important expenses come out of it. It all started as I wanted a finance app that would do what I wanted but couldn’t find any so I resorted to learning to use Excel to create what I needed.īasically, anti-budget systems work because you automate everything.Ĭhecking account 1 is your “Fixed” account. I’m expecting it to become more complex someday. With that new value it’ll split it into one of four categories: savings for large expenses (5%), savings for emergencies (5%), investments (20%), and additional payment toward debts (70%).įound videos on YouTube to create a loan amortization spreadsheet which I’ve included, it’ll transfer value from other sheets into it and it’ll give me a new expected payoff date, interested paid and interested expected to be paid by payoff date. So then it will do some calculations for me, where it will find the difference between my income for the month and budget. It began as a simple income/expense tracker where I managed how much I was spending and would make me think afterwards if I really did need that purchase.Ĭouple of years later it’s grown to include a budget of X amount that’ll include all my bills and living expenses. It’s slowly been evolving to meet my finance goals and expectations. I did something similar where I created an excel spreadsheet couple years ago from a YouTube video I watched. So my question is, how are you guys working with your spreadsheets? Do you sit down monthly and do a specific budget or do a budget now that you intend to hold for each month? How does that then reflect in your spreadsheets? If anyone has a nice starting point for me to go off I would love that too! ![]() Looking online it seems most are a monthly budget which gives me a couple of tabs all for a dedicated month but if I want a continuous tracker for the year I would need 12 of those books which seems inefficient to me. To help with keeping track I'm thinking I will lift out 5-6 "risk categories" (groceries, entertainment etc) into an app that I track "live with every spend" and then transfer the result into the excel sheet. What I see in my head now is something similar but instead of just comparing month to month I will have an additional column that is my budget for the month that I track against. Today I am more tracking than budgeting, essentially filling in my expenses after the fact in a spreadsheet that have one column per month so that I can compare easily month to month. Going to get into more proper budgeting this year and looking for some advise on good excel layouts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |