Use the Ledger Balances to Prepare an Adjusted Trial Balance

Mitchell Franklin; Patty Graybeal; and Dixon Cooper

Once all of the adjusting entries have been posted to the general ledger, we are ready to start working on preparing the adjusted trial balance. Preparing an adjusted trial balance is the sixth step in the accounting cycle. An adjusted trial balance is a list of all accounts in the general ledger, including adjusting entries, which have nonzero balances. This trial balance is an important step in the accounting process because it helps identify any computational errors throughout the first five steps in the cycle.

As with the unadjusted trial balance, transferring information from T-accounts to the adjusted trial balance requires consideration of the final balance in each account. If the final balance in the ledger account (T-account) is a debit balance, you will record the total in the left column of the trial balance. If the final balance in the ledger account (T-account) is a credit balance, you will record the total in the right column.

Once all ledger accounts and their balances are recorded, the debit and credit columns on the adjusted trial balance are totaled to see if the figures in each column match. The final total in the debit column must be the same dollar amount that is determined in the final credit column.

Let’s now take a look at the adjusted T-accounts and adjusted trial balance for Printing Plus to see how the information is transferred from these T-accounts to the adjusted trial balance. We only focus on those general ledger accounts that had balance adjustments.

Printing Plus Adjusted Trial Balance, January 31, 2019. Debit accounts: Cash $24,800; Accounts Receivable 1,200; Interest Receivable 140; Supplies 400; Equipment 3,500; Dividends 100; Supplies Expense 100; Depreciation Expense Equipment 75; Salaries Expense 5,100; Utility Expense 300; Total Debits $35,715. Credit accounts: Accumulated Depreciation: Equipment 75; Accounts Payable 500; Salaries Payable 1,500; Unearned Revenue 3,400; Common Stock 20,000; Interest Revenue 140; Service Revenue 10,100; Total Credits $35,715. To the right of the adjusted trial balance are ten T-accounts, highlighting the January 31 adjusting entries, with lines connecting the balances of the T-accounts to the adjusted trial balance. The ten T-accounts, in order, are: Interest Receivable, debit balance 140. Supplies, debit balance 400. Accumulated Depreciation: Equipment, credit balance 75. Salaries Payable, credit balance 1,500. Unearned Revenue, credit balance 3,400. Service Revenue, credit balance 10,100. Interest Revenue, credit balance 140. Supplies Expense, debit balance 100. Salaries Expense, debit balance 5,100. Depreciation Expense Equipment, debit balance 75.

For example, Interest Receivable is an adjusted account that has a final balance of $140 on the debit side. This balance is transferred to the Interest Receivable account in the debit column on the adjusted trial balance. Supplies ($400), Supplies Expense ($100), Salaries Expense ($5,100), and Depreciation Expense–Equipment ($75) also have debit final balances in their adjusted T-accounts, so this information will be transferred to the debit column on the adjusted trial balance. Accumulated Depreciation–Equipment ($75), Salaries Payable ($1,500), Unearned Revenue ($3,400), Service Revenue ($10,100), and Interest Revenue ($140) all have credit final balances in their T-accounts. These credit balances would transfer to the credit column on the adjusted trial balance.

Once all balances are transferred to the adjusted trial balance, we sum each of the debit and credit columns. The debit and credit columns both total $35,715, which means they are equal and in balance.

Printing Plus Adjusted Trial Balance, January 31, 2019. Debit accounts: Cash $24,800; Accounts Receivable 1,200; Interest Receivable 140; Supplies 400; Equipment 3,500; Dividends 100; Supplies Expense 100; Depreciation Expense: Equipment 75; Salaries Expense 5,100; Utility Expense 300; Total Debits $35,715. Credit accounts: Accumulated Depreciation: Equipment 75; Accounts Payable 500; Salaries Payable 1,500; Unearned Revenue 3,400; Common Stock 20,000; Interest Revenue 140; Service Revenue 10,100; Total Credits $35,715.

After the adjusted trial balance is complete, we next prepare the company’s financial statements.

Cash or Accrual Basis Accounting?

You are a new accountant at a salon. The salon had previously used cash basis accounting to prepare its financial records but now considers switching to an accrual basis method. You have been tasked with determining if this transition is appropriate.

When you go through the records you notice that this transition will greatly impact how the salon reports revenues and expenses. The salon will now report some revenues and expenses before it receives or pays cash.

How will change positively impact its business reporting? How will it negatively impact its business reporting? If you were the accountant, would you recommend the salon transition from cash basis to accrual basis?

Why Is the Adjusted Trial Balance So Important?

As you have learned, the adjusted trial balance is an important step in the accounting process. But outside of the accounting department, why is the adjusted trial balance important to the rest of the organization? An employee or customer may not immediately see the impact of the adjusted trial balance on his or her involvement with the company.

The adjusted trial balance is the key point to ensure all debits and credits are in the general ledger accounts balance before information is transferred to financial statements. Financial statements drive decision-making for a business. Budgeting for employee salaries, revenue expectations, sales prices, expense reductions, and long-term growth strategies are all impacted by what is provided on the financial statements.

So if the company skips over creating an adjusted trial balance to make sure all accounts are balanced or adjusted, it runs the risk of creating incorrect financial statements and making important decisions based on inaccurate financial information.

Key Concepts and Summary

  • Adjusted trial balance: The adjusted trial balance lists all accounts in the general ledger, including adjusting entries, which have nonzero balances. This trial balance is an important step in the accounting process because it helps identify any computational errors throughout the first five steps in the cycle.

Multiple Choice

(Figure)What critical purpose does the adjusted trial balance serve?

  1. It proves that transactions have been posted correctly
  2. It is the source document from which to prepare the financial statements
  3. It shows the beginning balances of every account, to be used to start the new year’s records
  4. It proves that all journal entries have been made correctly.

(Figure)Which of the following accounts’ balance would be a different number on the Balance Sheet than it is on the adjusted trial balance?

  1. accumulated depreciation
  2. unearned service revenue
  3. retained earnings
  4. dividends

C

Questions

(Figure)What is the difference between the trial balance and the adjusted trial balance?

The adjusted trial balance is the summary of account balances after the adjustments have been posted, so it reflects the corrected balances of all accounts.

(Figure)Why is the adjusted trial balance trusted as a reliable source for building the financial statements?

Exercise Set A

(Figure)Prepare an adjusted trial balance from the following adjusted account balances (assume accounts have normal balances).

Accounts Payable 6,600; Accounts Receivable 12,750; Administrative Expense 49,150; Cash 28,900; Common Stock 15,000; Prepaid Insurance 8,800; Service Revenue 78,000.

(Figure)Prepare an adjusted trial balance from the following account information, considering the adjustment data provided (assume accounts have normal balances).

Accounts Payable 11,700; Accounts Receivable 17,100; Administrative Expense 54,800; Cash 44,800; Common Stock 30,000; Prepaid Insurance 16,000; Service Revenue 91,000.

Adjustments needed:

Salaries due to administrative employees, but unpaid at period end, $2,000

Insurance still unexpired at end of the period, $12,000

Exercise Set B

(Figure)Prepare an adjusted trial balance from the following adjusted account balances (assume accounts have normal balances).

Accounts Payable 22,400; Accounts Receivable 45,750; Administrative Expense 57,700; Cash 56,500; Common Stock 40,000; Prepaid Rent 8,750; Revenue 106,300.

(Figure)Prepare an adjusted trial balance from the following account information, considering the adjustment data provided (assume accounts have normal balances).

Accounts Payable 10,075; Accounts Receivable 15,500; Cash 64,575; Common Stock 31,000; Fees Earned Revenue 82,000; Operating Expense 38,000; Supplies 5,000.

Adjustments needed:

  • Physical count of supplies inventory remaining at end of period, $2,150
  • Taxes payable at end of period, $3,850

Problem Set A

(Figure)Prepare an adjusted trial balance from the adjusted account balances; solve for the one missing account balance: Cash (assume accounts have normal balances).

Accounts Payable 19,000; Accounts Receivable 23,760; Cash ?; Common Stock 38,000; Dividends 9,000; Equipment 20,000; Prepaid Insurance 21,466; Land 45,000; Notes Payable 61,000; Retained Earnings 18,815; Insurance Expense 19,689; Service Revenue 90,550; Supplies 5,250; Salaries Expense 51,000.

(Figure)Prepare an adjusted trial balance from the following account information, considering the adjustment data provided (assume accounts have normal balances). Equipment was recently purchased, so there is neither depreciation expense nor accumulated depreciation.

Accounts Payable 9,500; Accounts Receivable 14,260; Cash 22,222; Common Stock 30,000; Dividends 5,000; Equipment 12,000; Prepaid Insurance 25,444; Land 20,000; Notes Payable 26,000; Retained Earnings 12,815; Insurance Expense 12,689; Service Revenue 89,550; Supplies 2,750; Salaries Expense 53,500.

Adjustments needed:

  • Salaries due to employees, but unpaid at the end of the period, $2,000
  • Insurance still unexpired at end of the period, $12,000

(Figure)Prepare an adjusted trial balance from the following account information, and also considering the adjustment data provided (assume accounts have normal balances). Equipment was recently purchased, so there is neither depreciation expense nor accumulated depreciation.

Accounts Payable 26,000; Accounts Receivable 8,000; Cash 29,000; Common Stock 33,000; Dividends 9,000; Equipment 68,000; Notes Payable (due next month) 29,000; Salaries Expense 42,000; Salaries Payable 2,000; Service Revenue 75,000; Supplies 5,000; Transportation Expense 4,000.

Adjustments needed:

  • Remaining unpaid Salaries due to employees at the end of the period, $0
  • Accrued Interest Payable at the end of the period, $7,700

Problem Set B

(Figure)Prepare an adjusted trial balance from the adjusted account balances; solve for the one missing account balance: Dividends (assume accounts have normal balances). Equipment was recently purchased, so there is neither depreciation expense nor accumulated depreciation.

Accounts Payable 9,000; Accounts Receivable 16,032; Cash 20,450; Common Stock 24,000; Dividends ?; Equipment 29,000; Prepaid Insurance 9,444; Land 34,000; Notes Payable 8,000; Retained Earnings 31,315; Insurance Expense 12,689; Service Revenue 82,500; Supplies 9,700; Salaries Expense 51,500.

(Figure)Prepare an adjusted trial balance from the following account information, considering the adjustment data provided (assume accounts have normal balances). Building and Equipment were recently purchased, so there is neither depreciation expense nor accumulated depreciation.

Accounts Payable 3,600; Accounts Receivable 45,333; Building 156,000; Cash 50,480; Common Stock 110,000; Dividends 18,000; Equipment 33,500; Fees Earned Revenue 225,430; Land 18,000; Supplies Expense 5,123; Notes Payable 85,500; Retained Earnings 60,606; Salaries Expense 151,900; Supplies 6,800.

Adjustments needed:

  • Physical count of supplies inventory remaining at end of period, $3,300
  • Customer fees collected in advance (payments were recorded as Fees Earned), $18,500

(Figure)Prepare an adjusted trial balance from the following account information, and also considering the adjustment data provided (assume accounts have normal balances).

Accounts Payable 18,000; Accounts Receivable 4,000; Investments 88,000; Cash 19,000; Common Stock 30,000; Dividends 16,000; Prepaid Insurance 20,000; Insurance Expense 8,000; Land 26,000; Notes Payable (long term) 55,000; Salaries Expense 37,000; Sales Revenue 115,000.

Adjustments needed:

  • Accrued interest revenue on investments at period end, $2,200
  • Insurance still unexpired at end of the period, $12,000

Thought Provokers

(Figure)Assume you are employed as the chief financial officer of a corporation and are responsible for preparation of the financial statements, including the adjusting process and preparation of the adjusted trial balance. The company is facing a slow year, and after your adjusting entries, the financial statements are accurately reflecting that fact. However, as you are discussing the matter with your boss, the chief executive officer (CEO), he suggests that you have the power to make further adjustments to the statements, and that you should use that power to “adjust” the profits and equity into a stronger position, so that investor confidence in the company’s prospects will be restored.

Write a short memo to the CEO, stating your intentions about what you can and/or will do to make the financial statements more appealing. Be specific about any planned adjustments that could be made, assuming that normal period-end adjustments have already been reflected accurately in the financial statements that you prepared.

Glossary

adjusted trial balance
list of all accounts in the general ledger, including adjusting entries, which have nonzero balances

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Use the Ledger Balances to Prepare an Adjusted Trial Balance Copyright © 2020 by Mitchell Franklin; Patty Graybeal; and Dixon Cooper is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book