Skip to content

BlogGuide

Adjusted trial balance: Example and how to prepare one

19 min read

Key takeaways

  • An adjusted trial balance lists every account balance after adjusting entries post, and it's the report you build the income statement, statement of retained earnings, and balance sheet from.
  • In the worked example, six adjusting entries totaling $1,780 take the trial balance from $47,500 to $48,855 on each side and raise net income from $1,660 to $2,200.
  • Balanced totals don't prove the balances are right, so you also tie each account to support, check that net income matches across the worksheet, and confirm retained earnings still shows last year's closing balance.

An adjusted trial balance is a list of every general ledger account and its balance after adjusting entries are posted, and it's the report you prepare the financial statements from. Getting it right gives you statements that tie to the ledger, catches missed accruals before leadership sees the numbers, and keeps your close audit-ready. This guide works through one company's six adjustments side by side, sorts them by type, then builds its statements, the 10-column worksheet, and the checks that prove it's correct.

Adjusted trial balance example

In this example, six adjusting entries totaling $1,780 take the trial balance from $47,500 to $48,855 and raise net income from $1,660 to $2,200. Seeing all three sets of balances in one table shows exactly what each adjustment changed.

Example: An engineering services firm with about $35 million in annual revenue closes its fiscal year on June 30, 2026. Its monthly closes already recorded July through May, so the entries below are the June and year-end adjustments. All amounts are illustrative and in thousands of dollars ($000).

Unadjusted trial balance, adjustments, and adjusted trial balance, June 30, 2026 ($000)

AccountUnadjusted debitUnadjusted creditAdjustment debitAdjustment creditAdjusted debitAdjusted credit
1000 Cash4,2504,250
1100 Accounts receivable6,8006,800
1150 Unbilled receivables(4) 780780
1190 Allowance for doubtful accounts120(6) 95215
1300 Prepaid insurance270(2) 45225
1500 Equipment3,6003,600
1590 Accumulated depreciation1,350(3) 601,410
2000 Accounts payable2,1502,150
2100 Accrued wages(1) 420420
2400 Deferred revenue960(5) 380580
2700 Note payable2,4002,400
3000 Common stock1,0001,000
3200 Retained earnings5,2805,280
4000 Service revenue34,240(4) 780, (5) 38035,400
5000 Salaries and wages expense23,980(1) 42024,400
5100 Subcontractor expense3,9503,950
6000 Rent expense2,1602,160
6100 Insurance expense495(2) 45540
6200 Depreciation expense660(3) 60720
6300 Bad debt expense(6) 9595
6400 Interest expense144144
6900 Other operating expenses1,1911,191
Total47,50047,5001,7801,78048,85548,855

The number in brackets is the adjusting entry that changed the line. A debit adjustment raises a debit balance and lowers a credit balance, and a credit adjustment does the reverse.

The six adjusting entries in journal format

Each entry below is dated June 30, 2026, and touches one income statement account and one balance sheet account. For how each type is built and reviewed, see adjusting entries.

EntryAccountDebitCredit
(1) Accrue unpaid wagesSalaries and wages expense420
Accrued wages420
(2) Expense one month of insuranceInsurance expense45
Prepaid insurance45
(3) Record June depreciationDepreciation expense60
Accumulated depreciation60
(4) Accrue unbilled revenueUnbilled receivables780
Service revenue780
(5) Recognize earned deferred revenueDeferred revenue380
Service revenue380
(6) Raise the bad debt allowanceBad debt expense95
Allowance for doubtful accounts95
Total1,7801,780
  • Entry 1: Staff earned $420 of wages in the last pay period of June, but payroll runs in July. These are accrued expenses.
  • Entry 2: The annual insurance policy costs $45 a month. Six months were left at May 31, so one moves to expense and $225 of prepaid expenses remains for July through November.
  • Entry 3: Monthly depreciation on equipment is $60, which brings the year's expense to $720.
  • Entry 4: Engineers delivered $780 of June hours that won't be invoiced until July, so the firm records accrued revenue as an unbilled receivable.
  • Entry 5: Clients prepaid for project milestones, and $380 of that work was completed in June. That portion moves out of deferred revenue and into revenue.
  • Entry 6: The receivables aging supports an allowance of $215, so the $120 balance rises by $95.

What the adjustments changed:

  • Net income: Unadjusted, it's $34,240 of revenue − $32,580 of expenses = $1,660. Adjusted, it's $35,400 − $33,200 = $2,200.
  • Bridge: Revenue entries add $1,160 ($780 + $380), and expense entries add $620 ($420 + $45 + $60 + $95). $1,660 + $1,160 − $620 = $2,200.
  • New accounts: Three lines had no balance before adjustment: unbilled receivables, accrued wages, and bad debt expense.
  • Totals: They rise by $1,355, not $1,780, because entries 2 and 5 reduce existing balances by $45 and $380. $1,780 − $425 = $1,355.

What is an adjusted trial balance?

An adjusted trial balance is an internal report listing each account's ending balance after adjusting entries, in debit and credit columns that must total the same. Knowing what it is, and what it isn't, helps you use it at the right point in the close.

  • Adjusting entries: Period-end journal entries that record revenue earned and expenses incurred in the period, such as accruals, deferrals, depreciation, and allowances
  • Unadjusted trial balance: The same list of balances before those entries post
  • Adjusted trial balance: The final list of balances for the period, also called the pre-closing trial balance

The adjusted trial balance shows every account with a balance: assets, contra assets, liabilities, equity, dividends, revenue, and expenses. Retained earnings still shows its opening balance, because the year's net income sits in the revenue and expense lines until closing entries post.

Penn State's Financial and Managerial Accounting text (2021, with figures from OpenStax) lists preparing the adjusted trial balance as the sixth step in the accounting cycle. It comes after adjusting entries are journalized and posted, and before the financial statements.

What is the purpose of an adjusted trial balance?

The adjusted trial balance proves the ledger balances after adjusting entries and gives you the final balances for the financial statements. It also serves as the review point before you lock the period.

  • Prove the ledger balances: Total debits equal total credits after every adjustment has posted
  • Feed the financial statements: Every income statement and balance sheet line comes from it
  • Support review and audit: Reviewers tie each balance to a reconciliation or schedule before sign-off, and auditors start from it

AccountingTools notes in a March 8, 2026 article that the cash flow statement needs more information than the adjusted trial balance provides.

Adjusted vs unadjusted trial balance: What's the difference?

An unadjusted trial balance shows balances before adjusting entries, and an adjusted trial balance shows them after, ready for the financial statements. Comparing the two shows you the full effect of the adjustments.

Unadjusted trial balanceAdjusted trial balance
When you prepare itAfter the period's transactions postAfter adjusting entries post, before closing entries
Includes accruals, deferrals, and depreciation for the period?NoYes
What it's forFinding missing entries and planning adjustmentsPreparing the financial statements
Accounts with a balance in the example1922
Totals in the example$47,500$48,855
Net income in the example$1,660$2,200

"Trial balance" on its own can refer to any of the three: unadjusted, adjusted, or post-closing.

Unadjusted trial balance example

The first two columns of the example are the unadjusted trial balance: 19 accounts at June 30, 2026, totaling $47,500 on each side, in the same chart of accounts order as the adjusted version. It must balance, because every posted entry has equal debits and credits, but it isn't ready for the statements until the adjustments post.

To go from unadjusted to adjusted, add or subtract each line's adjustments on the same row:

  • Service revenue: $34,240 + $780 + $380 = $35,400 credit
  • Deferred revenue: $960 − $380 = $580 credit
  • Prepaid insurance: $270 − $45 = $225 debit
  • Accrued wages: $0 + $420 = $420 credit, a new line

How to prepare an adjusted trial balance

You prepare an adjusted trial balance by posting the period's adjusting entries to the unadjusted balances and rerunning the report until every balance is final. Following the same steps each period keeps the result consistent across preparers.

  1. Run the unadjusted trial balance: Use the period-end date and the right entity, then confirm debits equal credits
  2. Identify the adjustments: Review accruals, prepaid and deferred balances, depreciation, allowances, and any reconciliation differences
  3. Journalize and post each adjusting entry: Date it on the last day of the period and attach the schedule or calculation that supports it
  4. Rerun the trial balance: In an accounting system, the adjusted trial balance is the standard trial balance report run after the adjustments post
  5. Check it: Confirm totals match and tie each balance to support, using the checks below
  6. Prepare the financial statements: Build the income statement first, then retained earnings, then the balance sheet

In a monthly close, you prepare an adjusted trial balance at every month-end. Revenue and expense lines carry year-to-date balances, so the month's income statement uses the period activity, while the balance sheet uses the month-end balances.

What adjustments go into an adjusted trial balance?

The adjustments are accruals, deferrals, estimates, and reclassifications, and most of them move an amount between an income statement account and a balance sheet account so the period shows what it earned and what it used. The type of adjustment also tells you whether the trial balance totals will rise.

TypeWhat it recordsEntryEffect on the totalsIn the example
Accrued expenseA cost incurred but not yet billed or paidDebit expense, credit a liabilityBoth rise by the amount(1) Wages, $420
Accrued revenueRevenue earned but not yet billedDebit a receivable, credit revenueBoth rise by the amount(4) Unbilled hours, $780
Prepaid expense usedA cost paid in advance that the period consumedDebit expense, credit the prepaid assetNo change(2) Insurance, $45
Deferred revenue earnedCash received in advance for work now deliveredDebit deferred revenue, credit revenueNo change(5) Milestones, $380
DepreciationThe share of an asset's cost used this periodDebit depreciation expense, credit accumulated depreciationBoth rise by the amount(3) Equipment, $60
Credit loss allowanceReceivables you don't expect to collectDebit bad debt expense, credit the allowanceBoth rise by the amount(6) Allowance, $95
ReclassificationAn amount sitting in the wrong accountDebit the right account, credit the wrong oneNo change when both accounts have the same normal balanceNone this period

The rule behind the totals column: an entry raises both totals when it increases a debit-balance account and a credit-balance account. It leaves them unchanged when both accounts carry the same kind of balance, because one goes up and the other goes down in the same column. In the example, entries 2 and 5 are the two that leave the totals unchanged.

How the accounting standards shape three of the entries

Three of the six entries turn on specific paragraphs of the FASB Accounting Standards Codification, the source of US GAAP:

  • Unbilled receivables (entry 4): ASC 606-10-45-4 defines a receivable as a right to consideration that is unconditional, meaning only the passage of time is required before payment is due. Hours already delivered under a time-and-materials contract usually meet that test, so they're a receivable before you invoice. If payment still depends on something other than time, such as finishing a milestone, record a contract asset instead.
  • Deferred revenue (entry 5): ASC 606-10-45-2 presents cash received before you deliver as a contract liability. As you deliver, the earned part moves to revenue.
  • Allowance (entry 6): Trade receivables fall under ASC 326-20, the current expected credit loss (CECL) model, which calls the account the allowance for credit losses. Many companies still use the older name, allowance for doubtful accounts. An aging schedule, adjusted for current conditions and reasonable and supportable forecasts, is a common way to estimate it.

Which adjusting entries reverse next period?

Accruals are often reversed on the first day of the next period, while deferrals and estimates aren't. In the example, entries 1 and 4 could reverse on July 1, 2026 ($000):

EntryAccountDebitCredit
Reverse (1), July 1Accrued wages420
Salaries and wages expense420
Reverse (4), July 1Service revenue780
Unbilled receivables780

When the July payroll posts in full to salaries expense, the reversal's $420 credit offsets the June portion, so July shows only July's wages. The same happens when the July invoice for June's hours credits service revenue. Prepaid insurance, deferred revenue, depreciation, and the allowance don't reverse, because next month starts from their adjusted balances. Reversing is optional. For when it helps and how to set it up, see reversing entries.

When is an adjustment too small to post?

Many teams set a threshold for booking accruals to keep the close moving, such as skipping invoices below a set amount. Treat that threshold as a review trigger, not a bright line. SEC Staff Accounting Bulletin No. 99 (1999), written for public companies, says exclusive reliance on any percentage or numerical threshold has no basis in the accounting literature or the law, and that qualitative factors can make small amounts material. Keep a list of what you didn't book, so you can judge whether the total is material in both amount and nature.

How do you go from an adjusted trial balance to the income statement and balance sheet?

Revenue and expenses go to the income statement, net income rolls into retained earnings, and assets, liabilities, and equity go to the balance sheet. Building them in that order lets each statement feed the next.

Account typeNormal balanceGoes toExample lines
RevenueCreditIncome statementService revenue
ExpensesDebitIncome statementSalaries, subcontractors, rent, insurance, depreciation, bad debt, interest, other
DividendsDebitStatement of retained earningsNone this year
Retained earnings (opening)CreditStatement of retained earnings3200 Retained earnings
AssetsDebitBalance sheetCash, receivables, unbilled receivables, prepaid insurance, equipment
Contra assetsCreditBalance sheet, netted against the related assetAllowance for doubtful accounts, accumulated depreciation
LiabilitiesCreditBalance sheetAccounts payable, accrued wages, deferred revenue, note payable
Common stockCreditBalance sheet3000 Common stock

Income statement

Income statement, fiscal year ended June 30, 2026 ($000)

LineAmount
Service revenue35,400
Salaries and wages24,400
Subcontractors3,950
Rent2,160
Depreciation720
Insurance540
Bad debt95
Other operating expenses1,191
Total operating expenses33,056
Operating income2,344
Interest expense144
Net income2,200

Statement of retained earnings

Statement of retained earnings, fiscal year ended June 30, 2026 ($000)

LineAmount
Retained earnings, July 1, 20255,280
Add: Net income2,200
Less: Dividends0
Retained earnings, June 30, 20267,480

Balance sheet

Balance sheet, June 30, 2026 ($000)

LineAmount
Cash4,250
Accounts receivable, net of $215 allowance6,585
Unbilled receivables780
Prepaid insurance225
Total current assets11,840
Equipment, net of $1,410 accumulated depreciation2,190
Total assets14,030
Accounts payable2,150
Accrued wages420
Deferred revenue580
Total current liabilities3,150
Note payable2,400
Total liabilities5,550
Common stock1,000
Retained earnings7,480
Total equity8,480
Total liabilities and equity14,030

Total assets of $14,030 equal liabilities of $5,550 plus equity of $8,480. The balance sheet uses the ending retained earnings of $7,480, not the $5,280 on the adjusted trial balance.

Adjusted trial balance worksheet (10-column worksheet)

A 10-column worksheet has five pairs of debit and credit columns: unadjusted trial balance, adjustments, adjusted trial balance, income statement, and balance sheet. It puts the whole path from ledger to statements on one page, so you can trace any number.

ColumnsSectionWhat goes in it
1 and 2Unadjusted trial balanceLedger balances before adjustments
3 and 4AdjustmentsEach adjusting entry, labeled with its entry number
5 and 6Adjusted trial balanceUnadjusted balance plus or minus the adjustments
7 and 8Income statementRevenue in the credit column, expenses in the debit column
9 and 10Balance sheetAssets and dividends in the debit column, contra assets, liabilities, and equity in the credit column

To complete it:

  1. Enter the unadjusted trial balance: List every account and confirm columns 1 and 2 total the same
  2. Enter the adjustments: Post each entry's debit and credit with its number, and confirm columns 3 and 4 total the same
  3. Calculate the adjusted balances: Combine each line and confirm columns 5 and 6 total the same
  4. Extend each adjusted balance: Move it to the income statement or balance sheet columns, keeping it on the same side
  5. Total the last four columns: The difference between the income statement columns is net income, or a net loss if debits are larger
  6. Enter net income to balance: Add it to the income statement debit column and the balance sheet credit column, then confirm both pairs balance

The bottom of the example's worksheet looks like this ($000):

RowIncome statement debitIncome statement creditBalance sheet debitBalance sheet credit
Column totals33,20035,40015,65513,455
Net income2,2002,200
Totals35,40035,40015,65515,655

Both pairs of columns are off by the same $2,200 before the net income row, which confirms the extension is correct. Columns 5 and 6 total $48,855, which is $33,200 + $15,655 on the debit side and $35,400 + $13,455 on the credit side. The worksheet is an internal working paper, not a financial statement, and the adjusting entries still have to be posted to the ledger.

Adjusted trial balance format

An adjusted trial balance has a three-line heading with the company, report title, and date, then columns for account number, name, debit, and credit. A consistent format makes the report easy to review and compare month over month.

  • Heading: Company name, report title, and the period-end date, such as June 30, 2026
  • Order: Chart of accounts order: assets, liabilities, equity, revenue, then expenses
  • Columns: Account number, account name, debit, and credit. A side-by-side version adds unadjusted and adjustment columns, as in the example.
  • Totals: Total debits and total credits, which must match

Adjusted trial balance in Excel

You can build the side-by-side format in Excel with seven columns and two formulas. Put the account in column A, unadjusted balances in B and C, adjustments in D and E, and adjusted balances in F and G.

CellFormulaWhat it does
F2=MAX(0,(B2+D2)-(C2+E2))Returns the adjusted debit balance, or zero
G2=MAX(0,(C2+E2)-(B2+D2))Returns the adjusted credit balance, or zero
B24 to G24=SUM(B2:B23), copied acrossTotals each column
H24=F24-G24Must equal zero
I24=D24-E24Must equal zero

Copy F2 and G2 down every account row. Each line then shows its balance in one column only, and the check cells flag any adjustment entered on one side.

What is a 4-column trial balance?

A 4-column trial balance shows each account's beginning balance, total debits, total credits, and ending balance for the period. Oracle's JD Edwards documentation (2026) describes its Four Columns Trial Balance report with those four columns.

This format helps you review an adjusted trial balance, because the debit and credit columns show how much each account moved, including adjustments. A two-column trial balance shows only the ending debit or credit balance.

How do I know if my adjusted trial balance is correct?

Your adjusted trial balance is correct when debits equal credits and every balance ties to support, such as a reconciliation, schedule, or subledger. Running the same checks each period catches errors before they reach the statements.

CheckWhat to confirmIn the example
Totals matchTotal debits equal total credits$48,855 on each side
Adjustments balanceEvery entry, and the adjustment columns, balance$1,780 on each side
Totals change by the expected amountAdjustment total minus entries that reduced an existing balance$1,780 − $45 − $380 = $1,355
Net income agreesIncome statement and balance sheet columns differ by the same amount$2,200 in both
Retained earnings is unchangedIt equals last year's closing balance, with no current-year activity$5,280
Normal balancesNo asset with a credit balance or liability with a debit balance unless you can explain itNone
Schedules tiePrepaid, deferred revenue, accrual, allowance, and fixed asset balances match their schedulesPrepaid insurance: 5 months × $45 = $225
Movements make senseLarge changes from the prior month or budget have an explanationEntries 4 and 5 explain the $1,160 revenue increase

Balanced totals don't prove the balances are right. AccountingTools notes in the same March 8, 2026 article that errors can remain when the totals match. Examples include an omitted transaction, an entry posted to the wrong account, or two errors that offset each other. Account reconciliation ties each balance to support, and flux analysis flags the movements that need an explanation.

What is not included in an adjusted trial balance?

An adjusted trial balance doesn't include transaction detail, closing entries, or the year's ending retained earnings. It's a summary of account balances, so anything that needs a closer look comes from the ledger or subledgers.

  • Transaction detail: It shows balances only. Individual entries sit in the general ledger and journals.
  • Subledger detail: It shows the receivables total, not the balance owed by each customer
  • Closing entries and income summary: These come after the statements are prepared
  • Ending retained earnings: It shows the opening balance, and current-year income stays in the revenue and expense lines
  • Zero-balance accounts: Report settings can hide them, so check the settings if an expected account is missing
  • Anything not recorded: A missed accrual or unbooked invoice won't appear, which is why you tie balances to support

Is an adjusted trial balance the same as a balance sheet?

No. An adjusted trial balance lists every account, including revenue and expenses, while a balance sheet shows only assets, liabilities, and equity, grouped for readers.

The numbers differ too. The example's adjusted trial balance totals $48,855, but total assets on the balance sheet are $14,030. The balance sheet leaves out $33,200 of expenses and $35,400 of revenue, and it uses ending retained earnings. It also nets $1,625 of contra assets ($215 + $1,410) against receivables and equipment: $48,855 − $33,200 − $1,625 = $14,030 of assets.

Common adjusted trial balance mistakes and how to correct them

The mistakes that slip through are adjustments posted to the wrong period, account, or side, because the totals still balance. Knowing what each one looks like helps you find it before sign-off.

MistakeWhat it looks likeHow to correct it
Adjustment dated in the next periodAn accrual dated July 1 is missing from JuneReverse it and repost it dated June 30
Reversing entry dated in the current periodThe accrual posts and reverses in June, so its net effect is zeroMove the reversal to the first day of the next period
Debit and credit swappedEntry 5 posted backward leaves revenue $760 short, twice the entryReverse the wrong entry and post the correct one
Wrong accountWages accrued to accounts payable instead of accrued wagesPost a reclassification entry between the two accounts
Contra account nettedAllowance or accumulated depreciation missing as its own lineKeep contra accounts as separate credit balances
Current-year income posted to retained earningsRetained earnings differs from last year's closing balanceReverse the entry so income stays in revenue and expenses until closing
Closing entries posted too earlyRevenue and expense lines show zeroPrepare the statements from the trial balance run before closing

To correct an error, follow the same steps each time:

  1. Find the source: Trace the balance to the entry that caused it
  2. Post a correcting entry: Reverse and repost instead of editing a posted entry, so the audit trail stays complete
  3. Rerun the adjusted trial balance: Repeat the checks above
  4. Update the statements and worksheet: Make sure every number still ties
  5. Document the fix: Note what changed and why, for the reviewer and the auditors

What is the next step after the adjusted trial balance?

The next step is preparing the financial statements, then posting closing entries at year-end and running a post-closing trial balance. Each month's close usually stops after the statements and the month-end reporting pack, because closing entries are a year-end step.

Closing entries move revenue, expense, and dividend balances into retained earnings, so the next year starts with those accounts at zero. In the example, closing would take retained earnings from $5,280 to $7,480, the same ending balance as the statement of retained earnings.

How we approach it

Our Close Agent prepares the adjusting entries behind an adjusted trial balance, such as accruals and prepaids, as balanced entries with the workpaper behind each one. A named approver approves the exact lines before anything posts to your ERP, and the month can't lock until every task is signed off and every entry is cleared. If you want that prep done 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.