By having your own personalized free budget spreadsheet you can keep your personal finances organized and control your spending and debt. A well tuned personal finance spreadsheet can help you plan your financial future. All of this sounds good? Well, next you’re probably thinking where can you find the best budget spreadsheet? No worries, we’ll give you the best budget spreadsheet that’s free in 2020 below:
How To Use It:
– Download the spreadsheet here.
- Blue text = manual type for current/past numbers
- Green text = manual type for future numbers
- Black Text = Formula driven
- Blue fill with black type = manual type for future numbers (budget)
To update the monthly budget sheet:
Go to the transactions section of www.mint.com
Scroll to the bottom and click export all transactions
This Company Will Give You $100 for Opening a Free Account
Simply sign up for Aspiration, and the free banking app will give you cash for free, you just relax while it gives you $100 just for opening a new debit card. There’s no catch. This bank account is legit and only takes two minutes to sign up for an account.
Follow these simple steps to add a $100 bonus to your new account:
- Open your Aspiration Spend & Save Account and fund your account with at least $10.
- Use your Aspiration debit card to make at least $1,000 of cumulative transactions within the first 60 days of opening your account. There’s no need to spend extra money — just use your card to buy groceries and pay your utilities.
- You’re good to go! Keep your eyes peeled for that $100, which will appear in your account within 120 days.
Copy and paste the data in the transactions tab
Update the row labels (column A) on the Monthly budget sheet to match your categories on mint
Every month, drag the formulas over your manually typed budget numbers
To update the income sheet:
Fill in past info from past W2’s that you have saved
Update health insurance numbers
To update the asset sheet:
Add in your contributions in the top section based upon account type
Add in your net worth balances
Update assumptions in AP19 and AP20
Most of the sheet is formula driven and relies upon an export from www.mint.com
- This spreadsheet is amazing. But the tax and the SSI portions are subject to government policy changes since it won’t stay the same in perpetuity, therefore, how do you keep it so that each column year is referencing the correct tax policies for that year? Also, the admin maintenance of this sheet beyond this year seems like it might take up a lot of time?
- I’m seriously impressed. Good job!
- It’s rather easy to adjust the sheet. Of course, policies are subject to change, but they rarely do in serious ways. Thus using what is and increasing by inflation is bound to give a reasonable forecast.