Home›Templates›Accounting & Small Business Spreadsheets›Trial Balance
Preview of the Trial Balance template

Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets

Free template

Trial Balance Format (Excel & PDF)

List every account's closing balance as a debit or credit; the totals and difference update as you type.

✓ A4✓ 35 account rows✓ Agreement check✓ Excel & PDF

Opens in your browser. No Excel needed, no signup.

Free for personal and commercial use · No watermark · Updated November 2026

Guide

About this trial balance template

A trial balance lists the closing balance of every ledger account at a date, with debit balances in one column and credit balances in the other. If the bookkeeping is complete and correct, the two totals are equal. It is the step between your ledgers and the final accounts, the profit and loss statement and the balance sheet. This sheet has codes, sample accounts and 35 rows, totals both columns and shows "Agreed ✓" or the exact difference.

How to prepare a trial balance

  1. 1

    Click "Edit online", or download the Excel file.

  2. 2

    Balance off each ledger account at the period end.

  3. 3

    Enter each account with its code, putting debit balances in Debit and credit balances in Credit. Delete the sample rows you don't need.

  4. 4

    Check that the totals agree. If they don't, the difference shows how much to look for.

  5. 5

    Use the figures to prepare your profit and loss statement and balance sheet.

Tips when the trial balance does not agree

Debit or credit?

Assets, expenses and drawings are normally debits; liabilities, capital and income are normally credits.

Divide by 9

If the difference divides exactly by 9, look for two digits swapped (for example 54 entered as 45).

Halve the difference

A difference of twice an amount often means that amount was put on the wrong side.

It can agree and still be wrong

An entry missed on both sides, or posted to the wrong account, won't show up as a difference.

Frequently Asked Questions

Yes. Download the Excel or PDF version, or edit it online for free, with no signup and no watermark.

In double-entry bookkeeping every transaction has an equal debit and credit, so the totals of all balances must be equal.

Usually the opening stock and purchases are in the trial balance and closing stock is added when preparing final accounts, unless it was already adjusted in the ledger.

35 rows are ready. Insert rows inside the table to add more; the totals will include them.

Tools that help

📗

Excel to PDF

Convert Excel spreadsheets to PDF with all sheets preserved

Use Tool→
📊

PDF to Excel

Extract tables from PDF into editable Excel spreadsheets

Use Tool→
%

Percentage Calculator

Calculate percentages, increase, decrease, and ratios

Use Tool→
💱

Currency Converter

Convert between 150+ world currencies with live rates

Use Tool→

More accounting & small business spreadsheets

Expense Report template preview

Expense Report

Claim business expenses with category totals and advances.

ExcelPDF
Inventory / Stock Sheet template preview

Inventory / Stock Sheet

Stock in, stock out, closing stock and reorder alerts.

ExcelPDF
Monthly Business Budget template preview

Monthly Business Budget

Budget vs actual for income and expenses, with profit.

ExcelPDF
Cash Book template preview

Cash Book

Daily cash in and out with a running balance.

ExcelPDF
Price List template preview

Price List

Products and services by category, with discounts.

ExcelPDF
Daily Sales Report template preview

Daily Sales Report

Bills, payment methods and end-of-day cash check.

ExcelPDF
Salary Sheet (Payroll) template preview

Salary Sheet (Payroll)

Monthly payroll for all staff: gross, deductions, net pay.

ExcelPDF
Project Plan (Gantt Chart) template preview

Project Plan (Gantt Chart)

Tasks, owners, dates and a 12-week Gantt chart.

ExcelPDF
Income & Expense Tracker template preview

Income & Expense Tracker

Small business money in and out, running balance, profit by category.

ExcelPDF
Profit and Loss Statement template preview

Profit and Loss Statement

Income statement with gross, operating and net profit.

ExcelPDF
Balance Sheet template preview

Balance Sheet

Assets, liabilities and equity with a balance check.

ExcelPDF
Trading Account template preview

Trading Account

Dr/Cr trading account that works out gross profit or gross loss.

ExcelPDF
Cost Sheet template preview

Cost Sheet

Prime cost to sales, with cost per unit at every level.

ExcelPDF
Cash Flow Statement template preview

Cash Flow Statement

Indirect-method cash flow: operating, investing and financing.

ExcelPDF
Bank Reconciliation Statement template preview

Bank Reconciliation Statement

Match the cash book to the bank statement, with an automatic check.

ExcelPDF
Ledger template preview

Ledger

Ledger account with running Dr/Cr balance, plus a T-format sheet.

ExcelPDF