Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial Statements & ReportingGeneral Ledger & Trial BalanceTrial Balance

SpreadsheetGeneral Ledger & Trial BalanceFree

Trial Balance

Closing balances by account in debit and credit columns with a balance check and totals by statement section.

Shown with sample data

Colour

Trial Balance

Closing balances by account in debit and credit columns with a balance check and totals by statement section.

Adjusted debits
$57,150
Adjusted credits
$57,150
Difference
$0
Must be zero
Profit for the period
$9,050
Adjusted debit by type
  • Asset$34,700
  • Expense$22,450

How to use it

  1. 1List every account with its type.
  2. 2Enter unadjusted balances in the debit or credit column.
  3. 3Post accruals, prepayments and depreciation in the adjustment columns.
  4. 4Check Difference is zero, then use the adjusted balances for your statements.

In this workbook

  • About
  • What’s included
  • How to use

About this template

Prove the books balance before you prepare statements. Enter each account’s unadjusted balance and any adjusting entries; the worksheet produces the adjusted trial balance, confirms debits equal credits and totals income and expenses to show the profit for the period.

Who it’s for

  • Month-end and year-end close
  • Preparing statements by hand
  • Teaching adjustments

What’s included

  • Trial balance sheet: Unadjusted balances, adjustments and adjusted balances.
  • Summary by Type sheet: Adjusted debit and Adjusted credit and the number of entries for each type, calculated from the Trial balance sheet.

How to use it

  1. 1List every account with its type.
  2. 2Enter unadjusted balances in the debit or credit column.
  3. 3Post accruals, prepayments and depreciation in the adjustment columns.
  4. 4Check Difference is zero, then use the adjusted balances for your statements.
Related searchestrial balanceadjusted trial balanceperiod enddebits creditsaccounting worksheet

Details

Format
Spreadsheet
Category
General Ledger & Trial Balance
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetGeneral Ledger & Trial BalanceFree

Trial Balance

Closing balances by account in debit and credit columns with a balance check and totals by statement section.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
General Ledger & Trial Balance
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ