Skip to content
CalculatorZilo Logo
  • Home
  • CalculatorsExpand
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
CalculatorZilo Logo
Home / Adjusted Trial Balance Calculator
Accounting Calculators

Adjusted Trial Balance Calculator

Published onOctober 1, 2025 Updated onOctober 27, 2026 1:15 pm

The unadjusted trial balance proves the ledger adds up. It does not prove the ledger is right. Rent paid in advance still sits in an asset account after part of it has expired, wages earned by staff sit unrecorded until payday, and equipment quietly loses value all year with no entry at all. The adjusted trial balance is the worksheet that fixes that: every account from the unadjusted trial balance, every adjusting entry applied, and a fresh pair of totals that must balance before a single financial statement is drawn up.

The Adjusted Trial Balance Calculator below keeps the exact method of the long-running tool on this page: for each account, the adjusted debit is the unadjusted debit plus the adjustment debit, and the adjusted credit is the unadjusted credit plus the adjustment credit, with all six column totals carried through. It is pre-filled with a complete worked example, eight accounts, two adjusting entries, and totals that balance at $33,000, so you can see the finished worksheet before you replace it with your own books. Add rows for more accounts, and the totals update as you type.

Adjusted Trial Balance Calculator
Apply adjusting entries to the unadjusted trial balance and prove the totals
Account ?The general ledger account name, in chart-of-accounts order: assets, liabilities, equity, revenue, then expenses. New accounts created by an adjusting entry (such as Salaries Expense) get their own row. Unadj. Debit ($) ?The account’s debit balance on the unadjusted trial balance, before any adjusting entries. Leave blank if the account carries a credit balance. Unadj. Credit ($) ?The account’s credit balance on the unadjusted trial balance. Leave blank if the account carries a debit balance. Adj. Debit ($) ?The debit side of the adjusting entries touching this account: accrued expenses, expired prepaids, and depreciation expense all enter here on their expense or asset rows. Adj. Credit ($) ?The credit side of the adjusting entries touching this account: accumulated depreciation, salaries payable, and unearned revenue earned all enter here. Adjusted Debit ($) Adjusted Credit ($)
Totals$0.00$0.00$0.00$0.00$0.00$0.00
Adjusted trial balance verdict
$0.00
Total adjusted debits$0.00
Total adjusted credits$0.00
Difference (debits minus credits)$0.00
Unadjusted totals$0.00
Total adjustments$0.00

Quick Answer

Quick answer: An adjusted trial balance applies the adjusting entries to the unadjusted balances, account by account: adjusted debit = unadjusted debit + adjustment debit, and adjusted credit = unadjusted credit + adjustment credit. On the pre-filled example, a business with $30,000 of unadjusted debits and credits records two adjustments (depreciation of $1,000 and accrued salaries of $2,000) and lands on a balanced adjusted trial balance of $33,000 = $33,000, ready for the income statement and balance sheet.

Key takeaways

  • The adjusted trial balance is the last checkpoint before the financial statements: if the adjusted totals do not balance, nothing built on them can be right.
  • Every adjusting entry touches one income statement account and one balance sheet account, which is why two new accounts (Salaries Expense and Depreciation Expense) appear in the example that were not on the unadjusted list.
  • Balancing proves arithmetic, not accuracy. A balanced worksheet can still hide a missing adjustment or an amount posted to the wrong account.
  • Keep the columns separate. This worksheet never nets an account across the debit and credit columns, so you can trace every adjusted balance back to its unadjusted balance plus its adjustments.
On this page
  • Quick Answer
  • Where the adjusted trial balance sits in the accounting cycle
  • The method, step by step
  • Worked example: depreciation and accrued salaries
  • The five adjusting entry families this worksheet exists for
  • When it does not balance: reading the difference
  • What competing calculators miss
  • Frequently asked questions
  • Add This Calculator to Your Website
  • References

Where the adjusted trial balance sits in the accounting cycle

The accounting cycle has a strict order, and the adjusted trial balance has exactly one place in it. Transactions are journalized and posted to the ledger all period long. At period end, the bookkeeper first prepares the unadjusted trial balance to prove the ledger's debits equal its credits. Only then are adjusting entries written and posted, because until the unadjusted totals are known to balance, an error could be hiding in the day-to-day postings rather than in the adjustments. The adjusted trial balance is the second proof, run on the updated balances, and it is the direct source document for the financial statements: every number on the income statement and balance sheet traces to a row of it.

That internal-document status matters. As AccountingCoach puts it in its explainer, the adjusted trial balance is not a financial statement; it is the listing whose balances will be reported on the statements. Nobody outside the business ever sees it, which is precisely why it is the right place to catch problems: the audience is the person about to publish the statements, not a reader of them.

It also explains a small mystery for students: accounts appear between the two trial balances that were not there before. Adjusting entries routinely create accounts, Salaries Payable and Depreciation Expense in the example above, because the events they record (wages earned but unpaid, wear on equipment) had no ledger presence during the period. Tracking balances account by account across the period is the same discipline behind running totals like the average ledger balance calculator: the ledger is only trustworthy when every movement in it can be explained.

The method, step by step

1

Start from the unadjusted trial balance. List every account with its debit or credit balance exactly as the ledger stands before adjustments. Prove the two columns total the same; in the worked example, $30,000 against $30,000. If they do not, fix the ledger first.

2

Enter the adjusting entries in the middle columns. Put the debit side of each entry in the Adj. Debit column of the debited account's row, and the credit side in the Adj. Credit column of the credited account's row. The two adjustment columns must also total the same ($3,000 against $3,000 in the example), because every entry is a complete double entry.

3

Carry each row across. Adjusted debit = unadjusted debit + adjustment debit; adjusted credit = unadjusted credit + adjustment credit. Accounts untouched by any adjustment carry across unchanged, like Cash at $15,000.

4

Prove the adjusted columns. Total the two adjusted columns. They must be equal: $33,000 against $33,000 in the example. Only then do the balances flow to the financial statements, revenue and expense rows to the income statement, asset, liability, and equity rows to the balance sheet.

The formulas: Adjusted debit = unadjusted debit + adjustment debit. Adjusted credit = unadjusted credit + adjustment credit. The worksheet balances when the sum of all adjusted debits equals the sum of all adjusted credits. Keep each account in its own columns and never net a row across both sides; the traceability is the point.

Worked example: depreciation and accrued salaries

Using the pre-filled defaults, here is exactly what the calculator returns, verified against its code. The business closes the period with three asset accounts and the owner's capital on the unadjusted trial balance, then records the two most common adjusting entries in all of bookkeeping:

AccountUnadj. DebitUnadj. CreditAdj. DebitAdj. CreditAdjusted DebitAdjusted Credit
Cash$15,000$15,000
Accounts Receivable$5,000$5,000
Equipment$10,000$10,000
Accumulated Depreciation$0$1,000$1,000
Salaries Payable$0$2,000$2,000
Capital$30,000$30,000
Salaries Expense$0$2,000$2,000
Depreciation Expense$0$1,000$1,000
Totals$30,000$30,000$3,000$3,000$33,000$33,000

Read the two entries out of the middle columns. Depreciation: debit Depreciation Expense $1,000, credit Accumulated Depreciation $1,000, recording the period's wear on the equipment without touching the Equipment account itself (the same charge a salary depreciation calculator schedules for an individual asset, here hitting the worksheet in aggregate). Accrued salaries: debit Salaries Expense $2,000, credit Salaries Payable $2,000, recording wages the staff have earned but payday has not yet reached. Both entries obey the pattern every adjusting entry obeys: one income statement account and one balance sheet account, never two of the same kind.

$33,000
Balanced adjusted totals on the worked example
$3,000
Total adjustments, debits and credits alike
2 entries
Depreciation and accrued salaries do all the work
8 accounts
Six carried from the unadjusted list, two created by entries

The five adjusting entry families this worksheet exists for

Nearly every adjustment you will ever enter belongs to one of five families. The worked example uses two of them; the other three follow the same two-column pattern, and the walkthrough at Accounting Exams Mastery, preparing the adjusted trial balance, organizes its examples the same way:

FamilyWhat happenedTypical entry
Accrued expensesCost incurred, not yet paid or recordedDebit expense, credit payable (the salaries entry above)
Accrued revenuesRevenue earned, not yet billed or recordedDebit receivable, credit revenue
Deferred (prepaid) expensesPaid in advance, part now expiredDebit expense, credit prepaid asset
Deferred (unearned) revenuesPaid by customers in advance, part now earnedDebit unearned revenue, credit revenue
Depreciation and amortizationLong-lived asset consumed over the periodDebit depreciation expense, credit accumulated depreciation

Two of the families fix timing in one direction (cash moved first, recognition follows) and two fix it in the other (recognition first, cash follows), while depreciation stands apart as an allocation rather than a timing fix. When a worksheet refuses to balance, the error almost always sits inside one entry: a debit entered with no matching credit, or an amount typed into the adjustment column of the wrong account. Which is why the failure case deserves its own look.

When it does not balance: reading the difference

Suppose the depreciation entry above is half-posted: the $1,000 credit reaches Accumulated Depreciation, but the $1,000 debit to Depreciation Expense is forgotten. The worksheet now totals $32,000 of adjusted debits against $33,000 of adjusted credits, a difference of exactly $1,000, and the calculator's verdict names the amount and points at the usual cause. The size of the difference is diagnostic information, not just an alarm:

Differences that point at the error

  • Difference equals one adjustment exactly: a one-sided entry, one half of a double entry never posted (the case above).
  • Difference is twice an adjustment: an amount posted to the wrong side, debited where it should have been credited, doubling its effect.
  • Difference divides by 9: a transposition, two digits swapped when typing (for example 1,540 entered as 1,450, a difference of 90).
  • Difference equals an unadjusted balance: a whole account row skipped when carrying balances across.

Errors balancing cannot catch

  • A missing adjustment: if an entry was never written at all, both sides are absent and the worksheet still balances.
  • An amount posted to the wrong account on the correct side: totals agree, statements are still wrong.
  • Two compensating errors that cancel each other out.
  • A wrong amount used consistently in both halves of the entry.

This is the honest limit of the tool, and it is the same limit the classic worksheet literature teaches: Bean Counter's trial balance worksheet tutorials make the point that totals prove postings, not judgment. A balanced adjusted trial balance means the statements may proceed; it does not certify that every accrual was remembered. The daily discipline behind balances that stay provable all period, rather than only at period end, is the habit tools like the average daily balance calculator are built around in their own domain: small, regular checks beat one heroic cleanup.

A note on accounts with amounts on both sides: in this worksheet an account's adjusted debit and adjusted credit are computed independently (unadjusted plus adjustments, per column) and are never netted against each other. That matches the worksheet method taught in accounting courses: if a data-entry slip puts amounts in both columns of one row, both columns show it, and the imbalance it usually creates is exactly the signal that finds the slip.

What competing calculators miss

We checked what actually ranks for this search before rebuilding this page. The striking finding: there is barely a competing calculator at all. The results are spreadsheet templates to download, homework-answer sites, and textbook chapters, and each leaves a different gap.

Winning move 1: a working worksheet in the browser, not a file to download. The top results hand you an Excel or PDF template and leave the arithmetic to your spreadsheet skills, or walk a single fixed example with the numbers already filled in. This page is the tool itself: type your own accounts and adjustments and the adjusted columns and all six totals compute as you go, with spare rows one click away.

Winning move 2: the complete six-column method, unadjusted through adjusted. Simpler tools and most templates show only the final adjusted listing, which hides the one thing a student or bookkeeper needs to verify: how each adjusted balance was reached. Here the unadjusted columns, the adjustment columns, and the adjusted columns all stay visible with their own totals, so every row can be traced left to right.

Winning move 3: a verdict that diagnoses, not just a total. Template files total the columns and stop; if the totals disagree, you are on your own. This calculator states Balanced or Not Balanced, names the exact difference, and the page explains how to read that difference (one-sided entry, wrong-side posting, transposition) to find the error instead of hunting row by row.

Winning move 4: the limits are stated on the page. No competing page we found admits what a balanced trial balance cannot prove. This one does, in its own section: missing entries, wrong-account postings, and compensating errors all survive a balanced worksheet. Knowing what your checkpoint cannot catch is what makes the checkpoint worth trusting.

Frequently asked questions

An internal worksheet listing every general ledger account and its balance after adjusting entries have been posted at the end of an accounting period. Its debit and credit totals must be equal, and its balances are the direct source for the income statement and balance sheet. It is not itself a financial statement.

Column by column: adjusted debit = unadjusted debit + adjustment debit, and adjusted credit = unadjusted credit + adjustment credit. Accounts untouched by adjusting entries carry across unchanged. This calculator keeps the two sides separate and never nets them, so every adjusted balance can be traced back to its parts.

Timing and content. The unadjusted trial balance is prepared before adjusting entries and proves the raw ledger balances. The adjusted trial balance is prepared after the adjusting entries for accruals, deferrals, and depreciation have been posted, and it is the version the financial statements are built from. New accounts created by adjusting entries appear only on the adjusted version.

Five families cover almost everything: accrued expenses (incurred, unpaid), accrued revenues (earned, unbilled), deferred expenses (prepaid, partly expired), deferred revenues (collected in advance, partly earned), and depreciation or amortization (allocating an asset's cost). Every adjusting entry touches one income statement account and one balance sheet account.

Read the difference. If it equals one adjustment exactly, half of an entry is missing. If it is twice an adjustment, an amount went to the wrong side. If it divides by 9, suspect a transposed digit. The calculator shows the exact difference in its verdict; recheck the adjusting entries before the carried balances, because that is where period-end errors concentrate.

No. Balancing proves that total debits equal total credits, nothing more. A completely missing adjusting entry, an amount posted to the wrong account on the correct side, or two errors that cancel out all leave a balanced worksheet with wrong balances. It is a necessary checkpoint before preparing statements, not a certificate of accuracy.

Because adjusting entries record events the daily bookkeeping never touched. Accrued wages create Salaries Payable and Salaries Expense; depreciation creates Depreciation Expense and grows Accumulated Depreciation. If an event had no account during the period, its account is born in the adjustments columns, which is why this worksheet lets you add rows.

The financial statements are prepared directly from it: revenue and expense balances flow to the income statement, and asset, liability, and equity balances flow to the balance sheet. After the statements, closing entries zero the temporary accounts, and a post-closing trial balance proves the ledger one last time before the next period opens.

Add This Calculator to Your Website

Embed the Adjusted Trial Balance Calculator on your own site. Pick a size to preview it live, then copy the code.

Powered by Calculator Zilo

References

  1. AccountingCoach, "What is an adjusted trial balance?" - the definition used on this page: an internal document listing general ledger account titles and balances after adjustments, whose debit and credit totals must be equal, and whose balances are what get reported on the financial statements. AccountingCoach: What Is an Adjusted Trial Balance?. Accessed October 2026.
  2. Accounting Exams Mastery, "Preparing the Adjusted Trial Balance" (Accounting Fundamentals, Completing the Accounting Cycle) - the step sequence followed here: gather the unadjusted trial balance, record adjusting entries for accruals and deferrals, update balances, and prove the adjusted totals. Accounting Exams Mastery: Preparing the Adjusted Trial Balance. Accessed October 2026.
  3. Bean Counter (Dave Marshall), "Trial Balance Worksheets" - the classic worksheet tutorial covering the trial balance, adjustments, and adjusted trial balance column sets, and the point that column totals prove the accuracy of postings. Bean Counter: Trial Balance Worksheets. Accessed October 2026.
  4. Pearson, "Unadjusted vs Adjusted Trial Balance Explained" (Financial Accounting channel) - the textbook treatment of the difference between the two trial balances, the matching principle behind adjusting entries, and why the adjusted version is the one statements are prepared from. Pearson: Unadjusted vs Adjusted Trial Balance. Accessed October 2026.
  5. Accounting Capital, "What is Adjusted Trial Balance?" - the side-by-side comparison of adjusted and unadjusted trial balances, including the point that the adjusted version presents the true and fair position of the ledger accounts after all necessary entries. Accounting Capital: What Is Adjusted Trial Balance?. Accessed October 2026.

Related calculators

Accounting CalculatorsSales to Working Capital Ratio CalculatorEvery dollar of sales a business makes has to be carried for a while by money tied up in stock, unpaid customer invoices and the gap before suppliers are paid.Accounting Calculators Mca Calculator Give this calculator four numbers: the advance amount, the factor rate, the payback period and the payment...Accounting CalculatorsUnderpayment Penalty Calculator An underpayment penalty calculator answers two questions in order: do you actually owe the IRS a penalty for paying too little during the year, and if so, roughly how much?Accounting CalculatorsForm 2210 Penalty CalculatorA Form 2210 penalty calculator figures the IRS underpayment penalty the same way the form itself does: quarter by quarter, at the IRS rate in effect for each period.Accounting CalculatorsDiminishing Value Depreciation Calculator Straight-line depreciation spreads an asset’s cost evenly, but most assets lose value fastest in their first years.Accounting CalculatorsPercentage Profit CalculatorMargin and markup describe the same profit with different denominators, and confusing them is one of the most expensive pricing mistakes a seller can make.

We use cookies to analyze traffic. You can accept or decline cookies below. Learn more

calculatorzilo

CalculatorZilo

Free calculators for everyday life. No signup, no cost, just answers.

Categories

Finance Math Health & Fitness Education Science Real Estate Chemistry Browse all calculators

Popular tools

Mortgage Payment Calculator BMI Walking Calculator Salary Per Minute Calculator Percentage Off Calculator

Company

About Us Contact Us Privacy Policy Terms and Conditions
Disclaimer Cookie Policy DMCA Policy Affiliate Disclosure FAQ Accessibility Statement

© 2026 CalculatorZilo • Free calculators for everyone

  • Home
  • Calculators
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
Search