Accounting Trial Balance Worksheet: How It Works

How-to basics · Updated November 22, 2026

An accounting trial balance worksheet is an internal working paper that organizes ledger balances, proposed adjusting entries, and the figures used to prepare financial statements. It helps an accountant check that debit and credit totals agree after adjustments, but it is not itself a financial statement or proof that every transaction is correct.

What a trial balance worksheet is

After transactions have been recorded in the general ledger, each account has a balance. A trial balance lists those balances in debit and credit columns. A trial balance worksheet takes that information further by arranging it in a multi-column format so the effects of period-end adjustments and the preparation of financial statements can be reviewed together.

The worksheet is generally an optional accounting tool rather than a required report with one universal format. A business may use a paper form, a spreadsheet, or a report generated by its accounting software. Its main audience is the people preparing or reviewing the accounts; it is not normally distributed to investors or customers as a published statement.

In a traditional accounting cycle, the worksheet is prepared after the unadjusted trial balance and before the financial statements and closing entries. It provides a visible bridge between ledger balances and reported results. That bridge is useful because adjusting entries can affect several accounts, and the worksheet lets the preparer inspect those effects before posting entries or finalizing reports.

Why businesses use one

A worksheet brings several related tasks into one place: checking the initial ledger totals, recording proposed adjustments, calculating adjusted balances, and sorting those balances into income statement or balance sheet columns. This can make the close easier to review and can reveal a transposition, missing entry, or misclassified account before statements are produced.

It is particularly helpful when period-end adjustments are numerous or when more than one person reviews the accounting. For example, an accountant can note an adjustment to supplies, show the resulting supplies expense and remaining asset balance, and then see where each adjusted balance belongs in the statements. A reviewer can follow the calculation without repeatedly switching between separate reports.

A balanced worksheet is a useful arithmetic check, not a guarantee of accurate books. An omitted transaction, a debit posted to the wrong debit account, or an equal error on both sides can leave debit and credit totals equal. The worksheet should be considered alongside source documents, reconciliations, account analysis, and review procedures.

Common columns and layout

A classic ten-column worksheet has five debit-and-credit pairs. The headings are often arranged in this order:

  • Unadjusted trial balance: The ledger balances before period-end adjustments.
  • Adjustments: The debit and credit sides of proposed adjusting entries.
  • Adjusted trial balance: Account balances after the adjustments are included.
  • Income statement: Adjusted revenue and expense balances.
  • Balance sheet: Adjusted asset, liability, and equity balances.

Each account appears on its own row, with its name at the left. A heading or total row may be included for each pair of columns. Some worksheets use fewer columns, omit sections that are not needed, or add columns for particular reporting requirements. The ten-column arrangement is a common teaching and bookkeeping format, not a rule that every organization must follow.

Contra accounts, such as accumulated depreciation, normally carry a balance opposite to the related asset. Their balances still go in the appropriate debit or credit column based on their normal balance. Follow the organization’s chart of accounts and established presentation conventions rather than assuming that every asset-related account is a debit.

How to prepare it step by step

  1. Bring in ledger balances. List every account and its unadjusted debit or credit balance. Check that the total debit and credit columns agree before making adjustments.
  2. Identify required adjustments. Review items such as accrued expenses, accrued revenue, prepaid costs, supplies used, depreciation, and unearned revenue. Each adjustment should have a basis, such as a calculation, supporting document, or accounting policy.
  3. Enter both sides of each adjustment. Record the debit and credit amounts in the adjustment columns on the rows for the affected accounts. The adjustment columns should balance when all entries are included.
  4. Calculate adjusted balances. Combine the unadjusted amount with the adjustments, taking account of which side each amount occupies. Place the resulting account balance in the adjusted trial balance debit or credit column, not both.
  5. Sort adjusted balances into statement columns. Put revenue and expense accounts in the income statement columns. Put assets, liabilities, and equity accounts in the balance sheet columns.
  6. Check totals and review the result. Confirm that the adjusted trial balance balances and investigate differences. Review the statement columns and any net income or net loss calculation before preparing final reports.

Adjustments on the worksheet are not automatically posted to the general ledger. In a manual process, the accountant typically prepares and approves the journal entries separately and posts them as appropriate. In accounting software, workflows vary: some systems use adjustment entries directly, while others provide a worksheet or adjustment review report.

A simple adjustment example

Suppose a business has a supplies asset balance of $1,000 before its month-end review. A count and supporting records indicate that $600 of supplies has been used. The adjustment is a $600 debit to supplies expense and a $600 credit to supplies. On the worksheet, the adjustment credit reduces the supplies asset to $400, while the expense appears in the income statement columns.

The adjustment does not change cash, and the two adjustment amounts are equal. It does change the period’s reported expense and the asset remaining at the reporting date. This illustrates why the worksheet is useful: it shows both sides of the adjustment and their different destinations in the statements. The $400 remaining asset is not calculated by adding $600 to the original balance; the credit adjustment reduces the $1,000 debit balance.

When the income statement columns are totaled, revenues and expenses may not be equal. If revenue exceeds expenses, the difference is net income. In the traditional worksheet, that amount is entered as a debit in the income statement columns to make their totals agree, and as a credit in the balance sheet columns. For a net loss, the direction is reversed. This is a worksheet balancing presentation; it does not mean net income is a new expense or that the worksheet itself records a journal entry.

Building a worksheet in Microsoft Excel

In Microsoft Excel for Microsoft 365 on Windows, a basic worksheet can use columns A through G: account name, unadjusted debit, unadjusted credit, adjustment debit, adjustment credit, adjusted debit, and adjusted credit. Use one account per row and keep source amounts on the correct side. Format the amount columns consistently, and label the reporting period clearly. Excel for Mac has the same basic cell formulas; ribbon placement and some keyboard shortcuts differ. Excel for the web also supports ordinary formulas, although some desktop interface features may differ.

For a row where B2 contains the unadjusted debit, C2 the unadjusted credit, D2 the adjustment debit, and E2 the adjustment credit, enter this in F2 to calculate an adjusted debit balance: =MAX(0,B2+D2-C2-E2). If B2 is 1000, E2 is 600, and C2 and D2 are blank or zero, the formula returns 400. In G2, using the same layout, enter =MAX(0,C2+E2-B2-D2); the same example returns 0 for the adjusted credit. Copy the formulas down for the remaining account rows.

These formulas assume that each account has one net balance and that amounts have been entered in the correct debit or credit columns. They calculate a net balance and put it on one side; they do not validate whether an adjustment is justified or whether an account has been classified correctly. If both adjusted debit and adjusted credit formulas produce positive amounts for one row, review the inputs and design rather than treating that as a normal account balance.

For a small illustrative total, assume adjusted debit balances of 400, 1,200, and 800 are in F2:F4, with the total in F5. Enter =SUM(F2:F4) in F5; it returns 2,400. A corresponding credit total can be calculated from the adjusted credit column. Compare the two totals, and use a visible difference check or conditional formatting if helpful. Equal totals are an important check, but they do not establish that every transaction is complete or correctly classified.

Common errors and what a balanced total cannot show

When totals fail to agree, check the worksheet systematically instead of changing amounts simply to force a balance. Common causes include:

  • An adjustment was entered on only one side, or the debit and credit amounts differ.
  • A balance was copied into the wrong column, or a digit was transposed while copying it.
  • An adjustment was included twice, or an account was accidentally omitted.
  • A formula range stops before the final account row, leaving some balances out of the total.
  • A formula or manual calculation nets an account incorrectly, especially when balances on opposite sides are involved.

If totals do agree, important errors can still remain. A transaction may be missing entirely; an equal debit and credit may both be posted to the wrong accounts; or an incorrect amount may have been entered on both sides. A trial balance also does not establish that cash agrees with a bank statement, that receivables are collectible, or that an asset’s recorded value is appropriate. Those questions require other checks and supporting evidence.

Worksheet, trial balance, and financial statements compared

A trial balance is the list of ledger account balances and their debit and credit totals at a particular date. An accounting trial balance worksheet is a working paper that may include that list plus adjustments, adjusted balances, and statement classifications. A financial statement is a report prepared from the accounting records, such as an income statement or balance sheet. These terms are related, but they are not interchangeable.

The worksheet is also different from the general ledger. The ledger contains the account activity and balances; the worksheet summarizes selected balances for analysis and preparation. Nor is a worksheet the same as a bank reconciliation, which compares cash records with a bank statement, or a post-closing trial balance, which is prepared after temporary accounts have been closed. These tools serve different stages and checks in the accounting process.

Frequently Asked Questions

Is a trial balance worksheet the same as a trial balance?
No. A trial balance lists account balances and debit and credit totals. A worksheet may include that unadjusted trial balance, but it usually adds adjustment columns, adjusted balances, and financial-statement columns.

Does a balanced trial balance worksheet prove there are no errors?
No. It shows that the listed debit and credit amounts balance arithmetically. It cannot reveal every omission, account classification error, or transaction posted equally to the wrong accounts.

Are adjusting entries posted directly on the worksheet?
The worksheet can show proposed adjustments, but it is not itself the ledger. Whether entries are posted separately or entered through accounting software depends on the organization’s process and system.

What is a ten-column worksheet?
It is a traditional layout with five debit-and-credit pairs: unadjusted trial balance, adjustments, adjusted trial balance, income statement, and balance sheet. Other layouts may use fewer or additional columns.

Can I make a trial balance worksheet in Excel?
Yes. A spreadsheet can list accounts, balances, adjustments, and formulas for adjusted totals. Use formulas carefully, keep debit and credit inputs distinct, and independently review supporting records because a spreadsheet cannot confirm that the accounting entries are valid.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.