Trial Balance preview
Trial Balance sheet with account-level opening, period, and closing debit/credit columns plus a built-in check column that flags imbalances for error-free period close. 1/4

About this trial balance spreadsheet template

This trial balance spreadsheet template helps accountants and bookkeepers perform accurate period-end close with automatic debit/credit balance verification. It includes a structured Trial Balance sheet with account codes, opening balances, period movements, and closing balances across debit and credit columns, plus a built-in Check column that flags any imbalance for immediate review.

A dedicated Adjustments sheet captures period-close entries such as accruals, inventory adjustments, and bank reconciliations with full audit trail fields including reason, owner, supporting documentation, due date, and review status. The Financial Summary and Accounts & Guide sheets round out the workbook for a complete close workflow.

Every cell, formula, and label is fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers. The print-friendly US Letter landscape layout with defined print areas ensures your trial balance and adjustments look professional on paper and in PDF exports.

4 structured sheets

Trial Balance, Adjustments, Financial Summary, and Accounts & Guide for a complete period-close workflow.

Automatic balance check

Built-in Check column verifies that total debits equal total credits at every account level.

Adjustments audit trail

Capture accruals, reconciliations, and corrections with owner, support, due date, and status fields.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers without conversion.

Frequently asked questions
The Trial Balance template is designed for period-end accounting close, including trial balance preparation, debit/credit balance verification, closing adjustments tracking, and financial summary reporting. Customize the sample accounts, amounts, and adjustment entries in WPS Office for your own organization.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the account structure and adjustment tracking logic in a Notion database; for PDF distribution and archiving, export the completed sheets via Adobe Acrobat.
Download the template, open it in WPS Office, and replace the sample chart of accounts, opening balances, period transactions, and adjustment entries with your own financial data. All formulas, labels, and print areas are fully editable.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for month-end close, quarterly financial reviews, audit preparation, and internal management reporting. It is available for personal and commercial projects, subject to the applicable template license.