4.4: The work sheet
- Page ID
- 19999
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)
( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\id}{\mathrm{id}}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\kernel}{\mathrm{null}\,}\)
\( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\)
\( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\)
\( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)
\( \newcommand{\vectorA}[1]{\vec{#1}} % arrow\)
\( \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow\)
\( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vectorC}[1]{\textbf{#1}} \)
\( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)
\( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)
\( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)
The work sheet is a columnar sheet of paper or a computer spreadsheet on which accountants summarize information needed to make the adjusting and closing entries and to prepare the financial statements. Usually, they save these work sheets to document the end-of-period entries. A work sheet is only an accounting tool and not part of the formal accounting records. Therefore, work sheets may vary in format; some are prepared in pencil so that errors can be corrected easily. Other work sheets are prepared on personal computers with spreadsheet software. Accountants prepare work sheets each time financial statements are needed—monthly, quarterly, or at the end of the accounting year.
This chapter illustrates a 12-column work sheet that includes sets of columns for an unadjusted trial balance, adjustments, adjusted trial balance, income statement, statement of retained earnings, and balance sheet. Each set has a debit and a credit column. (See Exhibit 20.)
Accountants use these initial steps in preparing the work sheet. The following sections describe the detailed steps for completing the work sheet.
• Enter the titles and balances of ledger accounts in the Trial Balance columns.
• Enter adjustments in the Adjustments columns.
• Enter adjusted account balances in the Adjusted Trial Balance columns.
• Extend adjusted balances of revenue and expense accounts from the Adjusted Trial Balance columns to the Income Statement columns.
• Extend any balances in the Retained Earnings and Dividends accounts to the Statement of Retained Earnings columns.
• Extend adjusted balances of asset, liability, and capital stock accounts from the Adjusted Trial Balance columns to the Balance Sheet columns.
Instead of preparing a separate trial balance as we did in Chapter 2, accountants use the Trial Balance columns on a work sheet. Look at Exhibit 20 and note that the numbers and titles of the ledger accounts of MicroTrain Company are on the left portion of the work sheet. Usually, only those accounts with balances as of the end of the accounting period are listed. (Some accountants do list the entire chart of accounts, even those with zero balances.) Assume you are MicroTrain's accountant. You list the Retained Earnings account in the trial balance even though it has a zero balance to (1) show its relative position among the accounts and (2) indicate that December 2010 is the first month of operations for this company. Next, you enter the balances of the ledger accounts in the Trial Balance columns. The accounts are in the order in which they appear in the general ledger: assets, liabilities, stockholders' equity, dividends, revenues, and expenses. Then, total the columns. If the debit and credit column totals are not equal, an error exists that must be corrected before you proceed with the work sheet.
As you learned in Chapter 3, adjustments bring the accounts to their proper balances before accountants prepare the income statement, statement of retained earnings, and balance sheet. You enter these adjustments in the Adjustments columns of the work sheet. Also, you cross-reference the debits and credits of the entries by placing a key number or letter to the left of the amounts. This key number facilitates the actual journalizing of the adjusting entries later because you do not have to rethink the adjustments to record them. For example, the number (1) identifies the adjustment debiting Insurance Expense and crediting Prepaid Insurance. Note in the Account Titles column that the Insurance Expense account title is below the trial balance totals because the Insurance Expense account did not have a balance before the adjustment and, therefore, did not appear in the trial balance.
Work sheet preparers often provide brief explanations at the bottom for the keyed entries as in Exhibit 20. Although these explanations are optional, they provide valuable information for those who review the work sheet later.
The adjustments (which were discussed and illustrated in Chapter 3) for MicroTrain Company are:
• Entry (1) records the expiration of USD 200 of prepaid insurance in December.
• Entry (2) records the expiration of USD 400 of prepaid rent in December.
• Entry (3) records the using up of USD 500 of supplies during the month.
• Entry (4) records USD 750 depreciation expense on the trucks for the month. MicroTrain acquired the trucks at the beginning of December.
MicroTrain acquired the trucks at the beginning of December
• Entry (5) records the earning of USD 1,500 of the USD 4,500 in the Unearned Service Fees account.
• Entry (6) records USD 600 of interest earned in December.
• Entry (7) records USD 1,000 of unbilled training services performed in December.
• Entry (8) records the USD 180 accrual of salaries expense at the end of the month.
Often it is difficult to discover all the adjusting entries that should be made. The following steps are helpful:
• Examine adjusting entries made at the end of the preceding accounting period. The same types of entries often are necessary period after period.
• Examine the account titles in the trial balance. For example, if the company has an account titled Trucks, an entry must be made for depreciation.
• Examine various business documents (such as bills for services received or rendered) to discover other assets, liabilities, revenues, and expenses that have not yet been recorded.
• Ask the manager or other personnel specific questions regarding adjustments that may be necessary. For example: "Were any services performed during the month that have not yet been billed?"
MICROTRAIN COMPANY Work Sheet For the Month Ended 2010 December 31 |
|
|||||||||||||||
Acct. |
Account Titles |
Trial Balance |
|
Adjustments |
Adjusted Trail Balance |
|
Income Statement |
Statement of Retained Earnings |
|
Balance Sheet |
|
|||||
No. |
|
Debit |
Credit |
|
Debit |
Credit |
Debit |
Credit |
|
Debit |
Credit |
Debit |
Credit |
|
Debit |
|
100 |
Cash |
8,250 |
|
|
|
|
8,250 |
|
|
|
|
|
|
|
8,250 |
|
103 |
Accounts Receivable |
5,200 |
|
|
(7) 1,000 |
|
6,200 |
|
|
|
|
|
|
|
6,200 |
|
107 |
Supplies on Hand |
1,400 |
|
|
|
(3) 500 |
900 |
|
|
|
|
|
|
|
900 |
|
108 |
Prepaid Insurance |
2,400 |
|
|
|
n) 200 |
2,200 |
|
|
|
|
|
|
|
2,200 |
|
112 |
Prepaid Rent |
1,200 |
|
|
|
(2) 400 |
BOO |
|
|
|
|
|
|
|
800 |
|
150 |
Trucks |
40,0 0 0 |
|
|
|
|
40,000 |
|
|
|
|
|
|
|
40,000 |
|
200 |
Accounts Payable |
|
730 |
|
|
|
|
730 |
|
|
|
|
|
|
|
|
216 |
Unearned Service Fees |
|
4,500 |
|
(5) 1,500 |
|
|
3,000 |
|
|
|
|
|
|
|
|
300 |
Capital Stock |
|
50,000 |
|
|
|
|
50,000 |
|
|
|
|
|
|
|
|
310 |
Retained Earnings 2010 December 31 |
|
—0- |
|
|
|
|
—0— |
|
|
|
|
-0- |
|
|
|
320 |
Dividends |
3,000 |
|
|
|
|
3,000 |
|
|
|
|
3,000 |
|
|
|
|
400 |
Service |
|
|
|
|
(5) 1,500 |
|
|
|
|
|
|
|
|
|
|
|
Revenue |
|
10,700 |
|
|
(7) 1,000 |
|
13,200 |
|
|
13,200 |
|
|
|
|
|
505 |
Advertising Expense |
50 |
|
|
|
|
SO |
|
|
50 |
|
|
|
|
|
|
506 |
Gas and Oil Expense |
690 |
|
|
|
|
660 |
|
|
680 |
|
|
|
|
|
|
507 |
Salaries Expense |
3,600 |
|
|
(3) 130 |
|
3,7S0 |
|
|
3,780 |
|
|
|
|
|
|
511 |
Utilities Expense |
150 |
|
|
|
|
ISO |
|
|
150 |
|
|
|
|
|
|
|
|
65,930 |
65,930 |
|
|
|
|
|
|
|
|
|
|
|
|
|
512 |
Insurance Expense |
|
|
|
(1) 200 |
|
200 |
|
|
200 |
|
|
|
|
|
|
SIS |
Rent Expense |
|
|
|
(Z) 400 |
|
400 |
|
|
400 |
|
|
|
|
|
|
518 |
Supplies Expense |
|
|
|
(3) 500 |
|
500 |
|
|
500 |
|
|
|
|
|
|
521 |
Depreciation Expense- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trucks |
|
|
|
(t) 750 |
|
750 |
|
|
750 |
|
|
|
|
|
|
151 |
Accumulated Depreciation- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trucks |
|
|
|
|
(t) 750 |
|
750 |
|
|
|
|
|
|
|
|
121 |
Interest Receivable |
|
|
|
m 6O0 |
|
600 |
|
|
|
|
|
|
|
600 |
|
418 |
Interest Revenue |
|
|
|
|
(6) 500 |
|
600 |
|
|
GOO |
|
|
|
|
|
206 |
Salaries Payable |
|
|
|
|
(S) 180 |
|
ISO |
|
|
|
|
|
|
|
|
|
|
|
|
|
5,130 |
5,130 |
53,400 |
6S,4G0 |
|
6,510 |
13,800 |
|
|
|
|
|
|
Net Income |
|
|
|
|
|
|
|
|
7,290 |
|
|
7,290 |
|
|
|
|
|
|
|
|
|
|
|
|
|
13,800 |
13,800 |
3,000 |
7,29C |
|
|
|
|
Retained Earnings, 2010 December 31 |
|
|
|
|
|
|
|
|
|
|
4,290 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7,290 |
7,29C |
|
53,950 |
|
Exhibit 20: Completed worksheet
(1) To record insurance expenses for December.
(2) To record rent expenses for December.
(3) To record supplies expenses for December.
(4) To record depreciation expenses for December.
(5) To transfer fees for service provided in December from the liability account to the revenue account.
(6) To record one month's interest revenue.
(7) To record unbilled training services performed in December.
(8) To accrue one day's salaries that were earned but are unpaid.
After all the adjusting entries are entered in the Adjustments columns, total the two columns. The totals of these two columns should be equal when all debits and credits are entered properly.
After MicroTrain's adjustments, compute the adjusted balance of each account and enter these in the Adjusted Trial Balance columns. For example, Supplies on Hand (Account No. 107) had an unadjusted balance of USD 1,400. Adjusting entry (3) credited the account for USD 500, leaving a debit balance of USD 900. This amount is a debit in the Adjusted Trial Balance columns.
Next, extend all accounts having balances to the Adjusted Trial Balance columns. Note carefully how the rules of debit and credit apply in determining whether an adjustment increases or decreases the account balance. For example, Salaries Expense (Account No. 507) has a USD 3,600 debit balance in the Trial Balance columns. A USD 180 debit adjustment increases this account, which has a USD 3,780 debit balance in the Adjusted Trial Balance columns.
Some account balances remain the same because no adjustments have affected them. For example, the balance in Accounts Payable (Account No. 200) does not change and is simply extended to the Adjusted Trial Balance columns.
Now, total the Adjusted Trial Balance debit and credit columns. The totals must be equal before taking the next step in completing the work sheet. When the Trial Balance and Adjustments columns both balance but the Adjusted Trial Balance columns do not, the most probable cause is a math error or an error in extension. The Adjusted Trial Balance columns make the next step of sorting the amounts to the Income Statement, the Statement of Retained Earnings, and the Balance Sheet columns much easier.
Begin by extending all of MicroTrain's revenue and expense account balances in the Adjusted Trial Balance columns to the Income Statement columns. Since revenues carry credit balances, extend them to the credit column. After extending expenses to the debit column, subtotal each column. MicroTrain's total expenses are USD 6,510 and total revenues are USD 13,800. Thus, net income for the period is USD 7,290 (USD 13,800—USD 6,510). Enter this USD 7,290 income in the debit column to make the two column totals balance. You would record a net loss in the opposite manner; expenses (debits) would have been larger than revenues (credits) so a net loss would be entered in the credit column to make the columns balance.
Next, complete the Statement of Retained Earnings columns. Enter the USD 7,290 net income amount for December in the credit Statement of Retained Earnings column. Thus, this net income amount is the balancing figure for the Income Statement columns and is also in the credit Statement of Retained Earnings column. Net income appears in the Statement of Retained Earnings credit column because it causes an increase in retained earnings. Add the USD 7,290 net income to the beginning retained earnings balance of USD 0, and deduct the dividends of USD 3,000. As a result, the ending balance of the Retained Earnings account is USD 4,290.
Now extend the assets, liabilities, and capital stock accounts in the Adjusted Trial Balance columns to the Balance Sheet columns. Extend asset amounts as debits and liability and capital stock amounts as credits.
Note that the ending retained earnings amount determined in the Statement of Retained Earnings columns appears again as a credit in the Balance Sheet columns. The ending retained earnings amount is a debit in the Statement of Retained Earnings columns to balance the Statement of Retained Earnings columns. The ending retained earnings is a credit in the Balance Sheet columns because it increases stockholders' equity, and increases in stockholders' equity are credits. (Retained earnings would have a debit ending balance only if cumulative losses and dividends exceed cumulative earnings.) With the inclusion of the ending retained earnings amount, the Balance Sheet columns balance.
When the Balance Sheet column totals do not agree on the first attempt, work backward through the process used in preparing the work sheet. Specifically, take the following steps until you discover the error:
|
MICROTRAIN COMPANY |
|
|
|
Income Statement |
|
|
For the Month Ended 2010 December 31 |
|
||
Revenues: |
|
|
|
Service Revenue |
|
|
$13,200 |
Interest Revenue |
|
|
600 |
Total Revenue |
|
|
$13,800 |
Expenses: |
|
|
|
Advertising Expense |
|
$ 50 |
|
Gas and Oil Expense |
|
680 |
|
Salaries Expense |
|
3,780 |
|
Utilities Expense |
|
150 |
|
Insurance Expense |
|
200 |
|
Rent Expense |
|
400 |
|
Supplies Expense |
|
500 |
|
Depreciation Expense—Trucks |
750 |
|
|
Total Expense |
|
|
6,510 |
Net Income |
|
|
$ 7,290 |
Exhibit 21: Income statement
• Re-total the two Balance Sheet columns to see if you made an error in addition. If the column totals do not agree, check to see if you did not extend a balance sheet item or if you made an incorrect extension from the Adjusted Trial Balance columns.
• Re-total the Statement of Retained Earnings columns and determine whether you entered the correct amount of retained earnings in the appropriate Statement of Retained Earnings and Balance Sheet columns.
• Re-total the Income Statement columns and determine whether you entered the correct amount of net income or net loss for the period in the appropriate Income Statement and Statement of Retained Earnings columns.
An accounting perspective:
Uses of technology
Electronic spreadsheets have numerous applications in accounting. An electronic spreadsheet is simply a large blank page that contains rows and columns on the computer screen. The blocks created by the intersection of the rows and columns are cells; each cell can hold one or more words, a number, or the product of a mathematical formula. Spreadsheets are ideal for creating large work sheets, trial balances, and other schedules, and for performing large volumes of calculations such as depreciation calculations. The most popular spreadsheet program is Microsoft Excel®. Free spreadsheet programs are also available from companies such as Google and Zoho.