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
- Asset$34,700
- Expense$22,450
How to use it
- 1List every account with its type.
- 2Enter unadjusted balances in the debit or credit column.
- 3Post accruals, prepayments and depreciation in the adjustment columns.
- 4Check Difference is zero, then use the adjusted balances for your statements.
In this workbook
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
- 1List every account with its type.
- 2Enter unadjusted balances in the debit or credit column.
- 3Post accruals, prepayments and depreciation in the adjustment columns.
- 4Check Difference is zero, then use the adjusted balances for your statements.
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.