Skip to content

BlogHub

Trial balance: Meaning, example, and how to prepare one

19 min read

Key takeaways

  • A trial balance lists the ending balance of every general ledger account at one date in debit and credit columns, and total debits must equal total credits.
  • In the worked example, 19 accounts total $424,000 on each side, and four adjusting entries raise both totals to $431,500 and cut year-to-date net income from $16,800 to $12,800.
  • A trial balance that balances can still be wrong, because omitted entries, wrong accounts, reversed entries, and duplicates all leave debits equal to credits.

A trial balance is a report that lists the ending balance of every general ledger account at a specific date, in a debit column and a credit column whose totals must match. Getting it right gives you a clean start for adjustments, catches posting errors early, and keeps your close on schedule. This guide covers a full example, the three types, preparation steps, the balance sheet comparison, and how to fix a trial balance that won't balance.

  • Debit balance: The normal balance of assets, expenses, and dividends or owner's drawings
  • Credit balance: The normal balance of liabilities, equity, revenue, and contra-asset accounts such as accumulated depreciation
  • Temporary accounts: Revenue, expense, and dividend accounts, which are reset to zero by closing entries at year-end

Trial balance example

This trial balance example lists 19 accounts for one company at October 31, 2026, and total debits and credits both equal $424,000. Example: A software company with a calendar fiscal year runs its trial balance after October's transactions post and before any adjusting entries. Revenue and expense accounts show year-to-date balances from January 1, 2026. All amounts are illustrative.

Unadjusted trial balance, October 31, 2026

Account numberAccount nameDebitCredit
1000Cash84,500
1100Accounts receivable42,300
1200Prepaid insurance3,000
1500Equipment60,000
1510Accumulated depreciation12,000
2000Accounts payable18,700
2200Deferred revenue24,000
3000Common stock50,000
3100Retained earnings73,300
3200Dividends5,000
4000Subscription revenue210,000
4100Services revenue36,000
5000Hosting expense31,500
6000Salaries expense142,000
6100Rent expense20,000
6200Software expense9,400
6300Insurance expense4,500
6400Depreciation expense9,000
6500Marketing expense12,800
Total424,000424,000

How to read it:

  • Debit side: Assets of $189,800 ($84,500 + $42,300 + $3,000 + $60,000) + dividends of $5,000 + expenses of $229,200 = $424,000
  • Credit side: Accumulated depreciation of $12,000 + liabilities of $42,700 + equity of $123,300 + revenue of $246,000 = $424,000
  • Net income so far: $246,000 of revenue − $229,200 of expenses = $16,800 for January through October, before adjustments
  • Retained earnings: The $73,300 is the balance on January 1, 2026. This year's earnings stay in the revenue and expense accounts until year-end closing entries move them into retained earnings.
  • Accumulated depreciation: It's an asset account with a credit balance, because it's a contra account that reduces equipment

What are the three types of trial balance?

The three types are the unadjusted, adjusted, and post-closing trial balance, and each is prepared at a different point in the accounting cycle. They use the same format and differ only in which entries have posted.

TypeWhen you prepare itAccounts includedWhat it's forHow often
Unadjusted trial balanceAfter the period's transactions post, before adjusting entriesAll accounts, with revenue and expenses year to dateFinding missing entries and starting reconciliationsEvery month
Adjusted trial balanceAfter adjusting entries, before the financial statementsAll accounts, with final balances for the periodPreparing the income statement and balance sheetEvery month
Post-closing trial balanceAfter the year-end closing entriesAssets, liabilities, and equity onlyProving the ledger balances before the new year opensOnce a year

What is the main purpose of an unadjusted trial balance?

An unadjusted trial balance confirms that recorded transactions balance and gives you the list of balances to reconcile and adjust. The example above is an unadjusted trial balance.

Is an unadjusted trial balance supposed to balance?

Yes. Every journal entry has equal debits and credits, so an unadjusted trial balance must balance too. Balancing only proves the arithmetic, though: accruals, depreciation, and deferrals for the period are still missing until you post adjustments.

Adjusted trial balance

An adjusted trial balance is the unadjusted trial balance plus the period's adjusting entries, and it's the source of the financial statements. In the example, four adjustments take both totals from $424,000 to $431,500, as the worksheet in the adjustments section below shows line by line.

Post-closing trial balance

A post-closing trial balance is run after the year-end closing entries move revenue, expenses, and dividends into retained earnings. Only permanent accounts remain, so any revenue or expense balance on it means a closing entry is missing.

What is the purpose of a trial balance?

A trial balance proves that total debits equal total credits in the general ledger and gives you one list of balances to review, adjust, and report from. Each use helps a different step of the close:

  • Check the double entry: Equal totals confirm that every posted debit has a matching credit
  • Start the review: One page of balances shows abnormal signs, unexpected movements, and accounts that should be zero
  • Plan adjustments: Balances such as prepaid insurance and deferred revenue tell you which adjusting entries the period needs
  • Build the statements: The adjusted version maps line by line to the income statement and balance sheet
  • Hand off to others: Auditors, tax preparers, and consolidation teams start from the trial balance

Most accounting software won't post an entry whose debits and credits differ. In a system like that, the trial balance's main value is the review of balances, not the arithmetic check.

What are the three rules of a trial balance?

The three rules are: list every general ledger account that has a balance, put each balance in its normal column, and confirm that total debits equal total credits. They're a teaching convention, so textbooks phrase them in slightly different ways.

Account typeNormal balanceColumnIn the example
AssetsDebitDebitCash, $84,500
Contra assetsCreditCreditAccumulated depreciation, $12,000
LiabilitiesCreditCreditAccounts payable, $18,700
EquityCreditCreditCommon stock, $50,000
Dividends or drawingsDebitDebitDividends, $5,000
RevenueCreditCreditSubscription revenue, $210,000
ExpensesDebitDebitSalaries expense, $142,000

An account with an abnormal balance goes in the other column. A cash account that's overdrawn by $2,000, for example, is listed as a $2,000 credit.

The three golden rules of accounting are different: they apply to journal entries, not the trial balance.

  • Personal accounts: Debit the receiver, credit the giver
  • Real accounts: Debit what comes in, credit what goes out
  • Nominal accounts: Debit expenses and losses, credit income and gains

What is the trial balance formula?

The trial balance formula is total debit balances = total credit balances, which expands to assets + expenses + dividends = liabilities + equity + revenue, with contra accounts on the side opposite their category.

With the example's numbers:

  • Debits: $189,800 assets + $229,200 expenses + $5,000 dividends = $424,000
  • Credits: $42,700 liabilities + $123,300 equity + $246,000 revenue + $12,000 accumulated depreciation = $424,000

The formula is the accounting equation rearranged. Before closing, assets = liabilities + equity + (revenue − expenses − dividends). Move expenses and dividends to the left side, and you get the trial balance formula.

What is not included in a trial balance?

A trial balance leaves out individual transactions, accounts with zero balances, and anything not yet recorded in the general ledger. Knowing the gaps tells you what to check before you rely on it.

  • Individual transactions: The general ledger holds the detail, and the trial balance shows only ending balances
  • Zero-balance accounts: These are often left off the report
  • Unrecorded entries: Accruals, depreciation, and revenue earned but not yet billed appear only after you post them
  • Ending inventory under a periodic system: It appears only after an adjusting entry records it
  • Subtotals: There's no gross profit, net income, or total assets line, because the report isn't a financial statement
  • Items that never hit the ledger: Commitments, unrecorded contingencies, and other disclosures that belong in the notes to the financial statements

How do you prepare a trial balance?

To prepare a trial balance, post the period's entries, list each general ledger account's ending balance as a debit or credit, total both columns, and confirm they match. Following the same steps each period keeps the report consistent across preparers.

  1. Post the period's entries: Close the subledgers, such as payables, receivables, and payroll, and post their entries to the general ledger
  2. Set the date and scope: Choose the as-of date, the entity, and the accounting book
  3. Pull each account's ending balance: Start from the opening balance and add the period's activity on each side
  4. List accounts in chart of accounts order: Assets, liabilities, equity, revenue, then expenses
  5. Put each balance in its column: Debit balances on the left and credit balances on the right
  6. Total both columns: Total debits must equal total credits
  7. Review the balances: Look for abnormal signs, clearing accounts that should be zero, and balances that moved more than expected

How to create a trial balance from general ledger accounts

Each line on the trial balance is one general ledger account's ending balance. Example: Two accounts from the example, for October 2026:

AccountOpening balance, October 1October debitsOctober creditsEnding balance, October 31
1000 Cash61,200 debit98,40075,10084,500 debit
2000 Accounts payable15,900 credit19,50022,30018,700 credit

Cash: $61,200 + $98,400 − $75,100 = $84,500. Accounts payable: $15,900 + $22,300 − $19,500 = $18,700. Repeat this for every account, and the ending balances become the trial balance.

Trial balance format

A trial balance has a three-line heading: the company name, the report name, and the as-of date. Below it are four columns: account number, account name, debit, and credit. Totals sit at the bottom. Accounts follow the chart of accounts order, which puts balance sheet accounts first and income statement accounts second.

Balance method vs totals method

Most trial balances use the balance method, sometimes called a trial balance of balances: each account shows one net balance, as in the example. The totals method lists each account's total debits and total credits instead, and some textbooks add a third format that shows both. Each format must balance.

Example: Two accounts from the example at October 31, 2026, in both formats.

AccountBalance method: debitBalance method: creditTotals method: debitTotals method: credit
1000 Cash84,500159,60075,100
2000 Accounts payable18,70019,50038,200

Cash's debit total of $159,600 is the $61,200 opening balance plus $98,400 of October debits. Accounts payable's credit total of $38,200 is the $15,900 opening balance plus $22,300 of October credits. The balance method is shorter and maps straight to the financial statements, which is why most accounting software reports use it.

What are trial balance adjustments?

Trial balance adjustments are the adjusting entries you post after the unadjusted trial balance to record accruals, deferrals, depreciation, and prepaid expenses used up. For how each type is built and reviewed, see adjusting entries.

Example: The company posts four adjustments for October 2026.

AdjustmentDebitCreditAmount
1. October depreciation6400 Depreciation expense1510 Accumulated depreciation1,000
2. October insurance used6300 Insurance expense1200 Prepaid insurance500
3. Subscription revenue earned2200 Deferred revenue4000 Subscription revenue4,000
4. October wages not yet paid6000 Salaries expense2100 Accrued wages6,500
Total12,000

What the adjustments change:

  • Totals: Both columns rise from $424,000 to $431,500, an increase of $7,500 ($1,000 + $6,500). Adjustments 2 and 3 move amounts within the same column, so they don't change the totals.
  • Net income: $16,800 − $1,000 − $500 + $4,000 − $6,500 = $12,800 year to date
  • New account: Accrued wages appears with a $6,500 credit, which the unadjusted trial balance didn't have
  • Deferred revenue: Cash a customer pays before you deliver is a contract liability under ASC 606 (ASC 606-10-45-2), so adjustment 3 moves the $4,000 earned in October out of deferred revenue and into revenue

Trial balance worksheet: From unadjusted to adjusted

A trial balance worksheet puts the unadjusted balances, the adjustments, and the adjusted balances side by side, so you can see how each account moved. Example: The same company's 20 accounts after October's four adjustments.

AccountUnadjusted debitUnadjusted creditAdjustment debitAdjustment creditAdjusted debitAdjusted credit
1000 Cash84,50084,500
1100 Accounts receivable42,30042,300
1200 Prepaid insurance3,0005002,500
1500 Equipment60,00060,000
1510 Accumulated depreciation12,0001,00013,000
2000 Accounts payable18,70018,700
2100 Accrued wages6,5006,500
2200 Deferred revenue24,0004,00020,000
3000 Common stock50,00050,000
3100 Retained earnings73,30073,300
3200 Dividends5,0005,000
4000 Subscription revenue210,0004,000214,000
4100 Services revenue36,00036,000
5000 Hosting expense31,50031,500
6000 Salaries expense142,0006,500148,500
6100 Rent expense20,00020,000
6200 Software expense9,4009,400
6300 Insurance expense4,5005005,000
6400 Depreciation expense9,0001,00010,000
6500 Marketing expense12,80012,800
Total424,000424,00012,00012,000431,500431,500

Each adjusted balance is the unadjusted balance plus or minus its adjustments. Salaries expense, for example, is $142,000 + $6,500 = $148,500. Check that each of the three column pairs balances before you build the statements.

Trial balance vs balance sheet: What's the difference?

A trial balance is an internal report that lists every account's balance to prove the ledger balances, while a balance sheet is a financial statement showing assets, liabilities, and equity. Some people call the trial balance a "trial balance sheet," but the two are different reports.

Trial balanceBalance sheet
What it isInternal working reportFinancial statement
PurposeProve debits equal credits and support the closeShow financial position to leadership, lenders, and investors
AccountsEvery account, including revenue, expenses, and dividendsAssets, liabilities, and equity only
FormatDebit and credit columnsAssets = liabilities + equity, with subtotals
Contra accountsListed separatelyNetted, such as equipment net of depreciation
Retained earningsOpening balance for the year, before closingEnding balance, including this year's net income less dividends
Totals in the example$431,500 each side (adjusted)$176,300 total assets

The income statement comes from the same report: it takes the revenue and expense lines. In the example, $250,000 of adjusted revenue − $237,200 of adjusted expenses = $12,800 of net income.

Is a trial balance a financial statement?

No. A trial balance is an internal report you use to prepare the financial statements. Under US GAAP, those are the balance sheet, the income statement, and the statement of cash flows, plus the changes in each equity account. ASC 505-10-50-2 requires that equity disclosure whenever both a balance sheet and an income statement are presented, either as a separate statement or in the notes.

How do you go from a trial balance to a balance sheet?

Take the asset, liability, and equity lines from the adjusted trial balance, net the contra accounts, and roll retained earnings forward. With the example's adjusted balances at October 31, 2026:

Balance sheet lineAmount
Cash84,500
Accounts receivable42,300
Prepaid insurance2,500
Equipment, net ($60,000 − $13,000)47,000
Total assets176,300
Accounts payable18,700
Accrued wages6,500
Deferred revenue20,000
Total liabilities45,200
Common stock50,000
Retained earnings ($73,300 + $12,800 − $5,000)81,100
Total equity131,100
Total liabilities and equity176,300

The bridge from the trial balance is $431,500 of debits − $237,200 of expenses − $5,000 of dividends − $13,000 of accumulated depreciation = $176,300. The depreciation is netted against equipment.

Trial balance vs general ledger: What's the difference?

The general ledger records every transaction in every account, while the trial balance lists only each account's ending balance at one date. You build the trial balance from the general ledger.

General ledgerTrial balance
DetailEvery posted entry, with date, reference, and amountOne ending balance per account
LengthThousands of lines for a busy monthOne line per account
UseTracing and supporting a balanceChecking totals and reviewing balances

What errors does a trial balance detect?

A trial balance detects errors that make debits and credits unequal: one-sided entries, balances in the wrong column, transposed digits, addition mistakes, and missing accounts. Each one leaves a difference you can measure.

ErrorExampleEffect on the totals
One-sided entryA $2,400 software bill imported with the debit but not the credit to accounts payableDebits exceed credits by $2,400
Balance in the wrong columnPrepaid insurance of $3,000 listed as a creditCredits exceed debits by $6,000
TranspositionSoftware expense of $9,400 listed as $4,900Debits fall short by $4,500
SlideMarketing expense of $12,800 listed as $1,280Debits fall short by $11,520
Addition errorThe debit column added incorrectlyTotals differ by the addition error
Account left offDividends of $5,000 missing from the listDebits fall short by $5,000

In accounting software that blocks unbalanced entries, these errors usually come from spreadsheets, manual ledgers, and data imports.

What errors are not revealed by a trial balance?

A trial balance can't reveal errors that change debits and credits equally, such as omitted transactions, wrong amounts on both sides, reversed entries, wrong accounts, and duplicates. These need other checks.

ErrorExampleHow you catch it
OmissionThe $3,150 October hosting bill is never recordedAccrual review and vendor statements
Wrong amount on both sidesThe $3,150 bill is recorded as $3,510Matching entries to invoices
ReversalA $4,000 customer payment is debited to accounts receivable and credited to cash, leaving cash $8,000 too lowBank reconciliation
Wrong account of the same typeA $2,400 software charge is posted to marketing expenseReviewing account movements
Wrong type of accountA $7,500 laptop is expensed instead of added to equipmentCapitalization review
Duplicate entryThe same $2,150 bill is posted twiceAccounts payable duplicate checks
Offsetting errorsSalaries expense and services revenue are each overstated by $1,000Reconciliations and movement review
Wrong periodA November invoice is dated October 31Cutoff review
Unposted entryThe $6,500 accrued wages journal is saved as a draft or left waiting for approval, so neither side reaches the ledgerReviewing draft and pending journals before you run the report

Account reconciliation and flux analysis catch these errors. Reconciliations prove each balance against outside support, and flux analysis flags accounts that moved more than expected.

Why doesn't my trial balance balance?

Your trial balance doesn't balance because a debit or credit is missing, misstated, or in the wrong column in the journal, the ledger, or the report. If total debits don't equal total credits, you can't rely on any balance or prepare the financial statements until you find the error.

In accounting software, check the data and the report before the arithmetic:

  • Imports and integrations: A load that posted only one side of an entry
  • Report settings: Different dates, entities, books, or account ranges in the trial balance and the ledger
  • Currency rounding: Small differences from translating foreign currency balances

How do you find an error in a trial balance?

Work from the size of the difference, because it often points to the type of error. Follow these steps in order:

  1. Re-add both columns: Rule out an addition error first
  2. Calculate the difference: Subtract the smaller total from the larger one
  3. Look for the exact amount: An account or entry equal to the difference may be missing or one-sided
  4. Divide the difference by 2: A balance of that amount may be in the wrong column
  5. Divide the difference by 9: If the result is a whole number, look for transposed digits or a slide
  6. Compare with last month: Put both trial balances side by side and look for accounts that changed unexpectedly or disappeared
  7. Trace to the ledger: Match each balance to the general ledger, then the ledger to the journals

Example: Your credits total $427,000 and your debits total $421,000, a $6,000 difference. Half of $6,000 is $3,000, which matches prepaid insurance, and you find it listed as a credit.

Example: Your debits total $419,500 and your credits total $424,000, a $4,500 difference. $4,500 ÷ 9 = $500, a whole number, which points to a transposition: software expense of $9,400 was keyed as $4,900.

How do you fix trial balance errors?

Fix trial balance errors at the source: correct the report for listing errors, post a correcting entry for posting errors, and rerun the trial balance. Every correction needs a short explanation and support, so the reviewer can follow it.

ErrorFixCorrecting entry
Balance listed in the wrong columnCorrect the report or spreadsheetNone
Software charge posted to marketing expenseMove it to the right accountDebit software expense $2,400, credit marketing expense $2,400
Customer payment reversedReverse the error and record it correctlyDebit cash $8,000, credit accounts receivable $8,000
Hosting bill never recordedRecord the accrualDebit hosting expense $3,150, credit accrued expenses $3,150

If you can't find a difference before a deadline, some teams post it to a suspense account and keep looking. Clear the suspense account before you lock the period, because an unexplained balance there means a statement line is wrong. If the period is already locked, follow your close policy: post the correction in the current period, or reopen the period with approval. If the error is in financial statements you've already issued, ASC 250 applies. A material error is corrected by restating the prior-period statements (ASC 250-10-45-23), while an immaterial one can usually be corrected in the current period with disclosure, as long as the correction is also immaterial to the current period's results. If it isn't, the affected comparative periods may need to be revised (SEC Staff Accounting Bulletin No. 108). Materiality is a judgment about both the amount and the nature of the error, not a fixed percentage.

How do you make a trial balance in Excel?

To make a trial balance in Excel, list one account per row with debit and credit columns, total each column with SUM, and add a check cell for any difference.

Template layout:

RowABCD
1Company name
2Trial balance
3October 31, 2026
5Account numberAccount nameDebitCredit
6 to 24One account per rowAccount nameDebit balanceCredit balance
25Total=SUM(C6:C24)=SUM(D6:D24)
26CheckFormula below

Check formula for cell D26:

=IF(ROUND(C25-D25,2)=0,"Balanced","Off by "&TEXT(C25-D25,"#,##0.00"))

To build the balances from a general ledger export, paste it on a sheet named GL. Put account numbers in column A, debits in column B, and credits in column C. Then add a helper column E for each account's net balance:

E6: =SUMIFS(GL!$B:$B,GL!$A:$A,A6)-SUMIFS(GL!$C:$C,GL!$A:$A,A6)
C6: =IF(E6>0,E6,"")
D6: =IF(E6<0,-E6,"")

Copy row 6 down to row 24. Positive net balances land in the debit column and negative ones in the credit column, so abnormal balances move to the right side.

How do you run a trial balance in accounting software?

Accounting software builds the trial balance from posted entries on demand: you open the report, set the date and entity, and run it. Where to find it in three common systems:

  • QuickBooks Online: Run the Trial Balance report under Reports, then set the report period
  • QuickBooks Desktop: Run the Trial Balance report from the Reports menu, then set the date range
  • NetSuite: Reports, then Financial, then Trial Balance. Oracle's NetSuite Help Center says retained earnings on this report is the sum of cumulative net income and amounts posted directly to retained earnings, so the report doesn't depend on a year-end closing entry.

Can you automate trial balance reports?

Yes. Cloud accounting systems generate the trial balance from posted entries without manual compilation, and you can save a customized version and export it to Excel. The review is the part that still takes your team's time: tying each balance to support and explaining what moved.

What is the trial balance's role in month-end close?

In the month-end close, the trial balance is the checkpoint between recording and reporting. You run it after transactions post, adjust it, review it, and report from it.

  1. Post the period's activity: Close the subledgers and post their entries
  2. Run the unadjusted trial balance: Confirm it balances and use it as the list of accounts to reconcile
  3. Reconcile balance sheet accounts: Tie each balance to bank statements, subledgers, and schedules
  4. Post adjusting entries: Record accruals, deferrals, depreciation, and corrections
  5. Run and review the adjusted trial balance: Compare each account with the prior month and the budget, and explain changes above your threshold
  6. Prepare the financial statements: Map the adjusted balances to the income statement and balance sheet
  7. Lock the period: At year-end, post closing entries and run the post-closing trial balance

The adjusted trial balance review is the last point where you can correct a balance without reopening the month.

How we approach it

Our Close Agent pulls the trial balance from your ERP and works the reconciliation tasks on your close checklist. It ties the ledger to bank statements, subledgers, invoices, and other source systems, and if something doesn't tie, it shows the exact difference with its amount, date, source, and reference. Every task goes to a named reviewer, and the month can't lock until every task is signed off. If you want that review prepared before your team starts, explore the Close Agent or book a working session.

Share this article

See our agents work through a finance process that matters to your team.

Tell us where the work gets stuck. We’ll walk through how the agents could help.