← All prebuilt solutions
Personal Finance

Net Worth Tracker

Everything you own and owe in one place – and how it grows month by month

£20

Secure checkout. Your download link is sent as soon as payment clears.

Net Worth Tracker

Overview

Your net worth is simply everything you own minus everything you owe. It's the single best measure of whether your finances are moving in the right direction – better than your salary, your bank balance or the value of your home on its own. This workbook lists every asset and debt you have, records their balances once a month, and turns those snapshots into a clear picture: your net worth today, how it has changed over the last month and year, who owns what, how much of it you could actually get your hands on in an emergency, and how close you are to the targets you set yourself.

Price
£20
Who it’s for
Personal Finance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Balances

Your list of assets and debts and the balance of each, month by month. What you do: add items once, then type balances every month.

Balances
Monthly Summary

Step 2

Monthly Summary

Every month added up: totals, net worth by owner, liquidity, ratios, changes, and assets and debts by category. Also holds the data behind the charts. What you do: nothing to enter.

Step 3

Targets & Milestones

Your net worth target with on-track status, and up to 12 milestones. What you do: enter a target, a date and your milestones.

Targets & Milestones
Setup

Step 4

Setup

Names, first snapshot month, student loan setting, your share of joint items, essential spending, category names and a helper to value final salary pensions. What you do: fill in once; revisit if your circumstances change.

Who it is for

Made for people like you

  • Example – text
  • Individuals – A complete personal balance sheet that updates in a few minutes a month.
  • Couples – Assets and debts tagged as yours, your partner's or joint – with net worth for each and 'your share'.
  • Savers and investors – Asset allocation, liquidity and month-by-month growth across ISAs, pensions and investments.
  • Anyone paying down debt – Debt totals, debt-to-asset ratio and milestones such as 'debts under £200,000'.

Quick start

Up and running in minutes

  1. Example – text
  1. Setup – Enter your household name, your name and your partner's (if any), the month of your first snapshot, whether to count student loans, and your essential monthly spending.
  2. List what you own – On the Balances sheet, add one row per account or asset in the top block – current accounts, savings, ISAs, pensions, investments, your home, other property, cars, business shares and anything else of value. Choose the owner, category and liquidity from the drop-downs.
  3. List what you owe – In the lower block add every debt – mortgages, loans, credit cards, car finance, student loans – again with owner, category and liquidity.
  4. Type this month's balances – In the month column for your first snapshot, type the current balance of each item. Debts are entered as positive numbers.
  5. Read the Dashboard – Your net worth, totals, ratios and charts update instantly.
  6. Set a target – On Targets & Milestones, enter a net worth target and date and add the milestones you want to celebrate.
  7. Repeat monthly – Once a month, copy the previous month's column to the next one and update the figures that have changed. It takes ten minutes.

Key features

  • Up to 60 assets and 30 debts – cash, ISAs, pensions, investments, property, vehicles and business interests – each tagged by owner, category and liquidity.
  • Monthly snapshots for up to 10 years (120 months), with net worth, liquid net worth, debt-to-asset ratio and month-on-month and year-on-year change worked out for you.
  • Net worth by owner (you, your partner and joint), asset allocation and liquidity, with an option to leave student loans out.
  • A net worth target with on-track status, a milestone tracker that finds the month you hit each goal, and a dashboard with charts over time.

What’s included

  • Dashboard – Your net worth at a glance
  • Setup – Names, start month and categories
  • Balances – What you own and owe, month by month
  • Monthly Summary – Every month added up
  • Targets & Milestones – Your goals and when you hit them
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions