Skip to content
The title slide and first slides of the Financial Account Inventory template

Financial Account Inventory

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

When someone dies or is ill, the first problem is finding what exists. This inventory lists each account with its type, institution, owner, last four digits only, where the records are kept and a next review date. Counts show open accounts, accounts marked To close and reviews that come up within two months. Sample entries include checking, retirement, a mortgage and a life policy.

The Contacts tab holds the person or department to call at each institution, and the Notes tab explains the things that are not on a statement: where the will is kept, who knows about the safe deposit box and how beneficiary forms are checked. The file deliberately has no field for passwords or full account numbers. Keep those in a password manager.

Useful for

  • Give an executor or relative a map of your accounts
  • Close unused accounts and remember which ones
  • Review beneficiaries on a schedule

What's included

  • 4 tabs: Accounts, Contacts, Notes, How to use
  • Accounts: a table with 4 summary figures
  • Contacts: a table
  • Notes: a table
  • 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

Which details belong in an account inventory?

List each account, the institution, who owns it, the last four digits, where statements are kept and who to contact. Add notes about documents, such as where the will is stored.

Is it safe to store account numbers in a spreadsheet?

Better not to. This file asks only for the last four digits and has no field for passwords. Store credentials in a password manager and tell your executor how to reach it.

How frequently does the list need refreshing?

Go through it every year and again after a move, marriage, new job or new account.

  • #tracker
  • #financial-account-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Finance

All finance templates
Get this template

Preparing your template…