Free Personal Finance Worksheets: 12 Printable Templates

Monthly budget worksheet with unassigned line and 50/30/20 comparison

Free Personal Finance Worksheets: 12 Templates in One Workbook

Reading about money is useful, but the real change happens when you put your own numbers on a page. This free workbook gives you 12 personal finance worksheets in a single file, from a monthly budget to an annual financial checkup. The sheets are linked, so your budget feeds your monthly review and your yearly checkup pulls the headline numbers from the other sheets.

Get the free workbook: Personal Finance Worksheets: 12 Templates in One Workbook

Open the link, then choose File > Make a copy to save your own editable version. You can also download it as an Excel file with File > Download > Microsoft Excel (.xlsx).

How the workbook works

A Contents tab at the front links to every worksheet. The cells are colour-coded:

  • Blue cells are yours to fill in.
  • Green cells pull numbers from other sheets automatically.
  • Yellow cells are assumptions you can change.

The numbers in the sheets are samples, so replace them with your own. All formulas are already built in.

The 12 worksheets

1. Monthly Budget Worksheet

List your expected income, then assign every dollar to Needs, Wants, Savings or Debt Payoff. An "Unassigned" line shows whether you have reached $0, which is the goal of a zero-based budget. A 50/30/20 comparison below shows how your plan stacks up against that popular rule.

2. Annual Financial Goals Planner

Write down your goals for the year. For each one, the sheet shows the months left, the amount remaining and the monthly amount you need to set aside to get there.

3. Net Worth Tracker

List your assets and liabilities, and update them across six columns, such as every 2 months or twice a year. The sheet shows the change from period to period and draws a net worth trend chart, so you can see whether you are moving forward.

4. Emergency Fund Calculator

Enter your essential monthly expenses and your target number of months. The sheet calculates your target, the gap, your progress and how many months it will take to reach it at your current saving pace.

5. Debt Repayment Tracker

List each debt with its balance, interest rate and minimum payment. The sheet estimates monthly interest, shows the percentage paid off, suggests a highest-rate-first order (the avalanche method) and includes a monthly balance log so you can watch the totals fall.

6. Savings Goal Tracker

Each savings goal gets its own progress bar, remaining amount and months to go. This is useful for goals like a holiday, a gadget, school fees or a deposit.

7. Credit Health Checklist

Track recurring credit tasks, such as checking your credit report, reviewing statements and setting up autopay. Each task shows Overdue or On track based on its last-done date. A card utilization table flags any card using too much of its limit.

8. Insurance Review Checklist

Record each policy with its coverage, premium, last reviewed date and next review date. A "did anything change?" life-event checklist (marriage, a new baby, a new home, a job change) reminds you when your cover may need updating.

9. Investment Planning Checklist

List your accounts and compare your target mix with your current mix. The sheet shows how much to rebalance, and it includes a review schedule and a yes/no checklist of good investing habits.

10. Retirement Planning Worksheet

Enter your accounts, contribution rate, any employer match and your target amount. The sheet shows your progress and gives a projected balance. The projection uses an assumed return that you can change, and it is only an estimate, so test a lower rate as well.

11. Monthly Money Review

At the end of each month, this sheet pulls your spending against your budget from Worksheet 1, then walks you through a short checklist and a "changes for next month" area.

12. Annual Financial Checkup

Once a year, this sheet pulls headline numbers from the other worksheets. It has a review tracker for all 11 other sheets and space to set goals for next year.

Which worksheet should you start with?

You do not need to complete all 12 at once. A good order:

  1. Monthly Budget to know where your money goes
  2. Emergency Fund Calculator to set your first savings target
  3. Debt Repayment Tracker, if you owe money
  4. Net Worth Tracker to see your starting point
  5. Goals Planner and Savings Goal Tracker to give your savings a purpose
  6. Insurance, Credit and Investment checklists once the basics are in place
  7. Retirement Planning to look further ahead
  8. Monthly Review each month and Annual Checkup each year to stay on track

Assumptions used in the workbook

Some sheets use default assumptions, shown in yellow so you can change them:

  • A 30% guideline for credit card utilization
  • A 5-point threshold for when to rebalance investments
  • 12-month review cycles for insurance and other checks
  • A 5% assumed annual return on the retirement projection

These are common rules of thumb, not advice for your situation. Change them to suit you.

Tips for using the worksheets

  • Make a copy first. The original is view-only, so save your own version before typing.
  • Keep your copy private. Do not share your copy publicly, because it will hold your personal financial details.
  • Set a reminder. Pick the same day each month for your review. Ten minutes is enough.
  • Be honest and rough. An approximate number you update beats a perfect one you never enter.
  • Use your own currency. The samples use dollars, but you can replace the numbers with any currency.

Frequently asked questions

Are these worksheets really free?
Yes. You can copy the workbook to your own Google account or download it as an Excel file.

Do I need Excel?
No. It works in Google Sheets. It can also be downloaded as an .xlsx file for Excel. If you use Excel, check that the Net Worth chart displays correctly.

Can I print the sheets?
Yes. Use File > Print in Google Sheets or Excel, and choose the sheet you want.

Is my data shared with you?
No. When you make your own copy, only you can see what you type, as long as you don't share it.

Do the worksheets give financial advice?
No. They are tools for organizing your own numbers. Projections are estimates only.

Keep learning

About the Author

Montu Das is the editor and founder of Smart Money Guide. He worked as a financial associate at MetLife in Sylhet, Bangladesh. Verify his MetLife Bangladesh advisor profile.

Previous Post
No Comment
Add Comment
comment url