Skip to content
The title slide and first slides of the Trial Balance Worksheet template

Trial Balance Worksheet

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

At the end of a month a bookkeeper lists every ledger balance and checks that debits and credits agree. This trial balance worksheet does that on one page. The Accounts tab takes a code, a name, a type and one amount in the debit or credit column. A row check warns you when an amount appears on both sides, which is the most common slip when balances are copied by hand.

The Trial Balance tab totals both columns, shows how far apart they are and prints Balanced or Out of balance. A chart compares debits and credits for each of the five account types, so you can see which type holds the problem. The sample is a small shop with 23 accounts that balances to the cent; replace it with your own ledger figures.

Useful for

  • Prepare month-end books before sending them to an accountant
  • Find the type of account behind an out-of-balance ledger
  • Teach double entry with a worked sample

What's included

  • 3 tabs: Accounts, Trial Balance, How to use
  • Accounts: a table
  • Trial Balance: a dashboard with 4 summary figures
  • 1 chart 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 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 is a trial balance?

It is a list of every account with its ending balance in a debit or credit column. If the two column totals match, the ledger is internally consistent.

What if my trial balance does not balance?

Read the difference on the Trial Balance tab. Look for a balance entered on the wrong side, an amount on both sides, a missing account or two digits swapped.

Does balancing mean my books are right?

No. An amount posted to the wrong account still balances. The trial balance catches arithmetic and one-sided entries, not every kind of mistake.

  • #bookkeeping
  • #trial-balance-worksheet
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bookkeeping templates

See all 6

Also in Finance

All finance templates
Get this template

Preparing your template…