Skip to content
The title slide and first slides of the Annual Financial Review template

Annual Financial Review

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

Once a year, most households benefit from looking at everything together instead of one account at a time. The Accounts tab lists assets and debts with a start-of-year and end-of-year balance, then shows net worth and how much it moved. Goals tracks each target with progress as a percent. Insurance lists each policy, its yearly cost and renewal date and counts how many renew in the next ninety days. Action Plan collects what you decide: who does it, by when and whether it is finished.

Pick a quiet evening in December or January and pull the first and last statement for each account. Estimates are fine for a home or a car. The action list turns red when something is past due, so the review does not end as a page of good intentions. Keep one copy per year to see the trend.

Useful for

  • Hold a yearly money meeting with a partner
  • See how net worth changed from January to December
  • Remember which policies renew in the next quarter

What's included

  • 5 tabs: Accounts, Goals, Insurance, Action Plan, How to use
  • Accounts: a table with 4 summary figures
  • Goals: a table with 3 summary figures
  • Insurance: a table with 3 summary figures
  • Action Plan: a table with 3 summary figures
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Accounts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What should be in an annual financial review?

Balances for what you own and owe, progress on your goals, a check of every insurance policy and a brief set of next steps. This workbook gives each of those its own tab so nothing is skipped.

How do I calculate my net worth?

Add up everything you own, subtract everything you owe and compare the result with the same figure a year earlier. The Accounts tab does the sums from the balances you enter.

Which month suits a yearly financial review?

Many people choose December or January, when year-end statements are ready and insurance and tax deadlines are near. Any fixed date you will actually keep works as well.

  • #budget
  • #annual-financial-review
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More budget templates

See all 61

Also in Finance

All finance templates
Get this template

Preparing your template…