Module 5 Completion of The Accounting Process For Service
Module 5 Completion of The Accounting Process For Service
Module 5 Completion of The Accounting Process For Service
WORKSHEET
The worksheet is a columnar sheet of paper used to summarize information needed to make adjusting
and closing entries and to prepare the financial statements. A worksheet is only a tool used by accountants and
is not part of the formal accounting records. A worksheet is used each time financial statements are prepared
either monthly, quarterly, or at the end of accounting year.
This chapter illustrates ten-column worksheet that includes sets of columns for trial balance,
(unadjusted), adjusted trial balance, income statements, and the balance sheets. Each set of columns has a
debit and a credit column.
The steps in the preparation of the work sheet are as follows:
1. Enter the titles and balances of ledger accounts in the Trial Balance columns
2. Enter the adjustments in the Adjustments column. Identify each adjustment with letters
3. Enter adjusted account balance in the Adjusted Trial Balance columns.
4. Extend adjusted balances of revenue and expense accounts from the Adjusted Trial Balance columns
to the Income Statement columns
5. Extend adjusted balances of assets, liabilities and owner’s equity accounts from the Adjusted Trial
Balance columns to the Balance sheet columns
6. Total the income statement columns and the balance sheet columns. Enter the net income or net loss
as a balancing figure in both pairs of columns and again compute the column totals.
1. Re-add the two Balance Sheet columns to see if an error is made in addition. If the two column totals
do not agree, check to see if some balance sheet items are extended incorrectly from the Adjusted
Trial Balance columns.
2. Re-add the Income Statement columns and determine if the correct amount of net income or net loss
for the period is entered in the appropriate columns in the Income Statement and Balance Sheet
columns.
3. Re-add the Adjusted Trial Balance columns. If the totals agree, check to see if each item is transferred
to the correct Income Statement or Balance Sheet columns. If the totals do not agree, make sure that
each adjustment is properly added to or subtracted from the related amount in the Trial Balance
column.
4. Re-add the Adjustments columns.
5. Re-add the Trial Balance columns. If the totals do not agree, review the ledger accounts to find the
error.
The capital statement indicates how net income, shown on the income statement relates to the amount
of owner's capital, shown on the balance sheet under owner's equity.
The Statement of Financial Position (SFP) or Balance Sheet provides the information about the entity's
resources (assets), claims against those resources (liabilities) and the remaining claim, accruing to the owner
(owner's equity) as of the end of a period. This statement is useful in assessing present and future cash flows,
liquidity and long term solvency.
➢ Liquidity refers to the period of time before an asset is converted to cash or until a liability is paid.
➢ Long-term solvency is the riskiness of a company with regard to the amount of liabilities in its
capital structure. Solvency provides information about the company's financial flexibility, that is the
ability of a company to alter cash flows in order to take advantage of unexpected investment
opportunities and needs.
Statement of Financial Position may be prepared in any of the two forms: (1) account form and (2) report
form.
A. Account form - The balance sheet that is presented in account form presents the accounts as in a T-
account, with the assets shown on the left side, and the liabilities and owner's equity on the right side.
B. Report Form - The balance sheet that is presented in report form presents the assets on the top section and
the liabilities and owner's equity at the bottom section of the report.
Assets
Cash P44,850
Accounts Receivable 12,360
Supplies 5,120
Prepaid Insurance 6,600
Prepaid Taxes 2,200
Equipment 25,600
Accumulated Depreciation ( 175)
Total Assets P96,555
The adjusting entries, first recorded in the work sheet, are also recorded in the journal and posted in the
ledger. This is to prove that balances of the accounts in the ledger conform to the balances shown in the
financial statements. The adjusting entries are recorded on the next available space in the journal. These
entries may or may not be explained. If no explanation is required, “Adjusting Entries” are written at the
center of the description column above the first entry. These entries are also posted to the general ledger in the
usual manner, except that the word “Adjusting" is written on the items column to differentiate it from other
posted entries.
The preparation of the work sheet does not eliminate the need to prepare and post adjusting entries
because the work sheet is only an accounting tool and is not part of the formal accounting records. The
adjusting entries of Cruz Service Center are journalized as follows:
The closing entries are series of entries required at the end of the accounting period to bring the
balances of the temporary accounts to zero so that they will be ready to receive data for the next accounting
period. These temporary accounts are the revenues, expenses, and drawing accounts. These accounts are
closed at the end of each period so that we may identify their balances by the year of their occurrence. Hence,
we say the sales of 20X7 must not include the sales of 20X6.
In the closing process, a clearing account called “Income Summary" is used. After all revenue and
expense account balances are transferred to Income Summary, its balance represents the net income or net loss
for the period. Then the balance of the Income Summary account is transferred to the owner's capital account,
resulting in a zero balance in Income Summary. The other terms used are Expense and Revenue Summary or
Profit and Loss Summary.
1. Closing the revenue account(s). The balance in the revenue accounts are transferred to the Income
Summary account by debiting each revenue account for the amount of its balance, and crediting the
income summary account for the total revenue.
2. Closing the expense accounts. The balances in the expense accounts are transferred to the Income
Summary account by debiting the income summary account for the total expenses, and crediting each
expense account for the amount of its balance.
3. Closing the income summary account. The balance of the income summary account is transferred to
the owner’s capital. A credit balance in the income summary account represents net income and is
closed by debiting income summary and crediting the owner’s capital account. A debit balance in the
income summary account represents net loss and is closed by debiting the owner’s capital account,
and crediting the income summary account.
4. Closing the owner’s drawing account. The balance of the owner’s drawing account is transferred to
the owner’s capital account by debiting the capital account for the amount of the withdrawals, and
crediting the drawing account for its balance.
Module 5 ABM 1203 - Fundamentals of Accountancy, Business and Management 1 7- NAB
The closing entries are recorded on the next available space in the journal right after the adjusting entries.
They are also posted in the usual manner except that the word “Closing” is written on the Items column to
differentiate it from other posted entries. The closing entries
of Cruz Service Center appear as follows:
Debit Credit
Cash P 44,850
Accounts Receivable 12,360
Supplies 5,120
Prepaid Insurance 6,600
Prepaid Taxes 2,200
Equipment 25,600
Accumulated Depreciation P 175
Accounts Payable 19,900
Notes Payable 20,000
Salaries Payable 270
Unearned Service Revenue 1,950
J. dela Cruz, Capital 54,435
Total P 96,730 P96,730
REVERSING ENTRIES
For certain types of adjusting entries, reversing entries are prepared as of the first day of the new
accounting period. They are called reversing entries because they reverse the effects of the adjusting entry to
which they relate. The purpose of reversing entry is to simplify the first entry relating to that same item in the
next accounting period.
Recall the adjusting entry made by Cruz Service Center to recognize accrued salaries of P270. This
adjusting entry is made to record salaries incurred but not yet paid. Illustrated below are the entries from
January 31 through February 10, the next payday, assuming (1) no reversing entry is used, and (2) reversing
entry is used.
(1) Entries when no reversing entry is used (2) Entries when reversing entry is used
Feb. 1 No entry
Salaries Payables 270
Salaries Expense 270
To reverse the adjusting
entry on Jan. 31
Feb. 10 Salaries Payable 270
Salaries Expense 1,330 Salaries Expense 1,600
Cash 1,600 Cash 1,600
Paid salaries of employees
Paid salaries of employees
The adjusting entries as of January 31 are the same whether or not a reversing entry is used.
The reversing entry dated February 1, is the exact reverse of the debit and credit used in the adjusting
entry. The use of the reversing entry simplifies the entry made on February 10. There is no need to
remember that accrued salary of P270 was already recorded. When the company paid P1,600, the
entry is simply a debit to Salaries Expense and a credit to Cash for P1,600.
Module 5 ABM 1203 - Fundamentals of Accountancy, Business and Management 1 11- NAB
The end result in the accounts is the same whether or not a reversing entry is used. The T-
accounts that follow will prove this. The beginning balance in the Salaries Payable results from the
adjusting entry made on January 31.
Not all adjusting entries are reversed on the first day of the new accounting period. Ideal
entries for reversals are those relating to situations where cash is paid and received in an adjusting
entry. Such items would include accrued expenses and unbilled revenues. We do not reverse
adjustments for items that will not result in a subsequent receipt or payment of cash, such as the
adjustment for depreciation.
Adjusting entries for prepaid expenses recorded under the expense method, and unearned
revenues recorded under the revenue method are reversed. Since the closing entries made at the end
of the period affect the revenue and expense accounts, reversing entries are needed to revert back to
the original method used; namely, the expense method for prepaid expense and the revenue method
for unearned revenue. A general rule to follow is that all adjusting entries that increase assets or
liabilities are reversed. Adjusting entries that decrease assets and liabilities are not reversed.
EXERCISES
Exercise 1
The trial balance of Mahal Kita Interiors at February 28, 2019:
Debit Credit
Cash P 31,800
Accounts Receivable 56,700
Supplies 26,400
Prepaid Insurance 3,450
Equipment 48,900
Accumulated Depreciation - equipment P 39,300
Building 64,200
Accumulated Depreciation - building 15,750
Land 42,450
Accounts Payable 33,900
Interest Payable
Wages Payable
Unearned Service Revenue 15,750
Notes Payable 33,600
Ayaw Nya, Capital 118,650
Ayaw Nya, Drawing 6,300
Service Revenue 30,150
Depreciation Expense- Equipment
Depreciation Expense- Building
Wages Expense 4,800
Insurance Expense
Interest Expense
Utilities Expense 1,650
Advertising Expense 450
Supplies Expense
Total P287,100 P287,100
Additional data:
a. Depreciation for the month of February; equipment, P900 and building, P450.
b. Accrued wages expense, P300.
c. Supplies on hand, P21,450.
d. Prepaid insurance expired during February, P750.
e. Accrued interest expense, P150.
f. Unearned service revenue earned during February, P7,350.
g. Accrued advertising expense, P150 (credited to Accounts Payable).
Module 5 ABM 1203 - Fundamentals of Accountancy, Business and Management 1 12- NAB
h. Accrued service revenue, P1,650.
Requirements:
1. Prepare a ten-column worksheet for Mahal Kita Interiors.
2. Prepare at the back of the worksheet the following:
a. Income statement.
b. Statement of changes in owner’s equity.
c. Balance sheet.
d. Journalize the adjusting and closing entries
e. Post-closing trial balance.
Exercise 2
The May 31, 2018 trial balance of 2Moons Surveyors is presented as follows:
2Moons Surveyors
Trial Balance
May 31, 2018
Cash P 210,000
Accounts Receivable 930,000
Prepaid Advertising 360,000
Engineering Supplies 270,000
Survey Equipment 1,890,000
Accumulated Depreciation- S.E. P 640,000
Accounts Payable 190,000
Unearned Survey Revenues 120,000
Notes Payable 500,000
P’Beam, Capital 1,120,000
P’Beam, Drawing 700,000
Survey Revenues 6,510,000
Salaries Expense 3,270,000
Rent Expense 960,000
Insurance Expense 250,000
Utilities Expense 160,000
Miscellaneous Expense 80,000
Total P9,080,000 P9,080,000
The following information pertaining to the year-end adjustment is available:
a. The P360,000 prepaid advertising represents expenditures made on Nov. 1, 2017 for monthly
advertising over the next 18 months.
b. A count of the engineering supplies at May 31, 2018 amounted to P90,000.
c. Depreciation on the surveying equipment amounted to P160,000.
d. One-third of the unearned survey revenues has been earned at year-end.
e. At year-end, salaries in the amount of P140,000 have accrued.
f. Interest of P60,000 on the notes payable has accrued at year-end.
Requirements:
1. Prepare a ten-column worksheet for Mahal Kita Interiors.
2. Prepare at the back of the worksheet the following:
a. Income statement.
b. Statement of changes in owner’s equity.
c. Balance sheet.
d. Journalize the adjusting and closing entries
e. Post-closing trial balance.
Exercise 3
Classify the accounts listed below as permanent or temporary, and indicate whether or not each
account is closed at the end of the accounting period. Also, indicate the financial statement in which
each account will appear.
Module 5 ABM 1203 - Fundamentals of Accountancy, Business and Management 1 13- NAB
Closed Balance Income
Account Title Permanent Temporary
Yes No Sheet Statement
Example: Building X X X
1. Rent expense
2. Prepaid Insurance
3. Accounts Receivable
4. Supplies Expense
5. Accumulated Depreciation
6. Interest Payable
7. Service Revenues
8. Notes Payable
9. Depreciation Expense
10. Noel, Capital
Exercise 4
Listed below are the ledger accounts appearing in the adjusted trial balance columns of a worksheet from
Newwiee Company. On the space provided, indicate in which column of the worksheet the amount in each
account will be extended by entering the following letters: A. Income statement, debit; B. Income statement,
credit; C. Balance sheet, debit; D. Balance sheet, credit.
1. Cash 11. Accounts receivable
2. Buildings 12. Interest Expense
3. Salaries expense 13. Interest Revenues
4. Mortgage payable 14. Unearned revenues
5. Prepaid insurance 15. Office Supplies
6. Equipment 16. Withdrawals
7. Utilities expense 17. Interest payable
8. Land 18. Accum. Depreciation
9. Service revenues 19. Rent expense
10. Salaries payable 20. Accounts payable
Module 5 ABM 1203 - Fundamentals of Accountancy, Business and Management 1 14- NAB