A1:F23fxAND COUNTIF IF N OR ROUND SUM SUMIF
Trial Balance — the first rows of the actual spreadsheet
Trial Balance
The opening rows of the file you get — sample data included, not a mock-up.

Finance template

Trial Balance

Debits against credits with a balanced check, unusual-side flags and net profit from the same list.

$12one payment, yours to keep
  • ✓Instant download
  • ✓Every later version free
  • ✓Commercial use
  • ✓No watermark
21
live formulas, each one recalculated and checked
6
columns: Code, Account, Type, Debit, Credit, Usual side?
6
figures worked out for you

Need more than one? All 13 Finance templates for $39 — $200 bought separately. All 70 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 20 November 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 21 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No watermark, and you can use it commercially.

About this Trial Balance template

A trial balance lists every account's closing balance as either a debit or a credit, and the two columns should agree. This Excel template totals both columns, shows the difference and reads Balanced only when they match to the cent.

Each account has a type (asset, liability, equity, income or expense), so the template can flag balances sitting on an unusual side, such as an expense with a credit balance, and work out income, expenses and net profit from the same list.

Good for

  • →Checking the books balance before preparing accounts
  • →Accounting students learning the trial balance format
  • →Small businesses doing a month-end check

What it works out for you

Checks

  • →Difference (debits - credits)
  • →Status
  • →Accounts on an unusual side
  • →Income
  • →Expenses
  • →Net profit

What is inside the Trial Balance template

The table has 6 columns. Calculated columns fill themselves in; the rest are yours to type over.

  • →Code
  • →Account
  • →Type
  • →Debit
  • →Credit
  • →Usual side?

How to use the Trial Balance in Excel

One row per account with its closing balance in either Debit or Credit. The status shows "Balanced" only when both columns agree to the cent.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.

Functions and formulas it uses

Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.

ANDCOUNTIFIFNORROUNDSUMSUMIF

Questions about the Trial Balance

Why is an account marked Unusual?

Assets and expenses normally carry debit balances; liabilities, equity and income normally carry credit balances. Unusual means the balance is on the other side. That can be correct, as with accumulated depreciation, but it is worth checking.

Does Balanced mean the books are right?

It means debits equal credits. A trial balance cannot catch an entry posted to the wrong account with the right amount, or a transaction left out entirely.

How is net profit worked out?

Income credits less income debits, minus expense debits less expense credits. It uses the Type column, so give every account a type.

What you get with the Trial Balance

  • ✓21 formulas, every one recalculated and checked
  • ✓Opens with sample rows already filled in
  • ✓Excel, Google Sheets and LibreOffice Calc
  • ✓Set up to print on one page wide
  • ✓Commercial use, no attribution needed
  • ✓Every later version included free

Get the Trial Balance for $12

One payment. The file downloads straight away, and every later version of it is yours at no extra cost.

Buying a few? All 13 Finance templates for $39, or all 70 for $99.

More finance templates

See all Finance →