Skip to content
The title slide and first slides of the Bookkeeping Year-End Tracker template

Bookkeeping Year-End Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Bookkeepers, small business owners who keep their own books and accountants who close several sets of accounts use this tracker. The Reconciliation tab is a grid of accounts and months with checkboxes and a percent done per account. The Adjustments tab lists journal entries by type with an approval status. The Open items tab lists unresolved questions along with who owns them and when they are due. The Dashboard totals adjustments and counts what is still open.

Set up the accounts on the Reconciliation tab in December or earlier, then tick months as statements are matched. Work backward from the oldest unticked month, since an old gap hides problems in every later month. Record each adjusting entry as you make it and get a second person to approve it where you can. Lock the books once the Open items tab is empty.

Useful for

  • See which accounts and months are not yet reconciled
  • Keep a clear list of year-end adjusting entries
  • Clear every open question before the books are closed

What's included

  • 5 tabs: Dashboard, Reconciliation, Adjustments, Open items, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Reconciliation: a grid
  • Adjustments: a table
  • Open items: a table
  • 2 charts that update as you type
  • 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 Reconciliation 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 I do at year end in my books?

Reconcile every bank, card and loan account, record accruals and prepaid items, review unpaid and unmatched items, and get entries approved. Use the three working tabs here to see where you stand.

What is an adjusting entry?

It is a journal entry made at the end of a period to record costs or income in the right period, such as wages earned but not yet paid. The Adjustments tab groups them by type so you can total each kind.

How do I track items I cannot match?

Add each one to the Open items tab with the month, an owner and a deadline. Set the status to Waiting if you need something from another person and Cleared once it is resolved.

  • #tax-tracker
  • #bookkeeping-year-end-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…