Accounting 1 Review Series Worksheet Exercises
Accounting 1 Review Series Worksheet Exercises
Accounting 1 Review Series Worksheet Exercises
INSTRUCTION
Discuss Steps 5 to 8 of the Accounting Cycle
1
THE ACCOUNTING CYCLE
Step 5 - Worksheet
This step is simply about plotting the items in the unadjusted trial balance on the worksheet.
In a manual accounting system, a worksheet is a large columnar sheet of paper specifically designed to tip
To illustrate Figure 1, may buy a one-piece
conveniently arrange all the accounting information required at the end of a period. The worksheet is 12-column worksheet from a local school
used to check whether ledger accounts are balanced and adjusted. The satisfactory completion of a supplies store. then simply copy the column
worksheet provides assurance that all the details of the end-of-period accounting procedures were headings in Figure 1 onto the worksheet.
properly brought together. The worksheet serves as the source in the preparation of financial
statements and other closing and adjusting entries.
The body of the worksheet contains five pairs of money columns. A sample of a worksheet is shown
below:
2
Name of the Company
Worksheet
For the period (monthy/year) ended Unadjusted Trial Adjustments Adjusted Trial Statement of Income Statement of
, 20 Balance Balance Position Financial Position
DR CR DR CR DR CR DR CR DR CR
Statement of Financial Position Accounts
Cash
Accounts Receivable
Inventory
Office Equipment
Accum Deprn - Off Eqpt
Land
Intangible Assets
Accounts Payable
Owner’s, Capital
Owner’s, Withdrawal
Income Statement Accounts
Sales
Sales Returns and Allowances
Sales Discounts
Interest Income
Purchases
Purchase Returns and Allowances
Purchase Discounts
Freight In
Salaries Expense
Supplies Expense
Utilities Expense
Pedro Matapang who started his Matapang Computer Repairs General Journal
business on February 14, 2016. The following transactions transpired Date Account Title and Explanation Ref Debit Credit
in February 2016:
2/14/16 Cash 200,000
1. February 14, 2016 - Pedro Matapang invested PHP200,000 into
Matapang, Capital 200,000
his Matapang Computer Repair business.
To record the initial investment of
2. February 15, 2016 - Pedro purchased one computer unit from owner
XY Computer Store to be used for his business. He issued P. Matapang
check number 001 amounting to PHP25,000.
2/15/16 Office Equipment 25,000
3. February 16, 2016 - Pedro hired Juana Magaling, an
experienced secretary. Cash 25,000
4. February 17, 2016 – Repaired the computer of Jean and To record the purchase of 1
collected PHP10,000. computer unit
5. February 18, 2016 – Repaired the computer of Mike; however,
Mike will pay PHP15,000 only on March 18, 2016. 2/17/16 Cash 10,000
6. February 19, 2016 – Pedro purchased Office Supplies from MM Service Revenue 10,000
Merchandise amounting to PHP5,000 on account. Pedro will
To record receipt of cash from customer
pay this on March 30, 2016.
7. February 25, 2016 – Paid the salary of Juana amounting 2/18/16 Accounts Receivable 15,000
to PHP4,000.
Service Revenue 15,000
The entries to record the above transactions are on the right: To record services rendered to a
customer on account
Cash 4,000
230,000 230,000
This now represents the first two money columns in the worksheet.
that will benefit the use of the asset. In the exercise above, the equipment will be used by Matapang
for five years. Proper accounting procedures dictates that the cost of PHP25,000 should be spread over
five years.
There are several methods or formulas to compute the amount of depreciation. The simplest is the
straight line method. The formula is Annual Depreciation : ( Acquisition Cost – Salvage or Residual
Value) / Useful Life. Applying this formula to the exercise:
Annual Depreciation = (25,000-1,000) / 5
= PHP4,800
If the accounting period being reported by Matapang is for the month ending February 29, 2016,
the adjusting entry to record this depreciation in the books of Matapang is:
General Journal
Date Account Title and Explanation Ref Debit Credit
2/29/16 Depreciation Expense 200
Accumulated Depreciation-Office Eqpt 200
The depreciation expense of PHP200 was derived by computing the monthly depreciation of
PHP400 (Annual Depreciation of PHP4,800/12 months) and multiplying the PHP400 by one-half
since the equipment was acquired in the middle of February.
#2 Deferred Expenses or Prepaid Expenses. These are items that have been initially recorded as
assets but are expected to become expenses over time or through the operations of the business.
Exercise - Adjusting entries to record deferred expenses or prepaid expenses
tip
Recall that on February 19, 2016 Matapang purchased PHP5,000 worth of office supplies on account. In higher accounting subjects, this approach
By the end of the month, PHP2,000 worth of these supplies are still unused. is referred to as the expense method of
recording, where the expense account is
The February 19, 2016 entry to record the purchase on the account of office supplies was already initially used to record the transaction.
posted to the general ledger and included in the balances, as shown in the unadjusted trial balance
above. The entry was shown only for illustration purposes.
General Journal
Date Account Title and Explanation Ref Debit Credit
2/19/16 Supplies Expense 5,000
Accounts Payable 5,000
To record the purchased of office supplies on account
The “Supplies” account debited on February 29, 2016 above is an asset account and represents the
tip
value of supplies unused as of the end of February 2016. If these journal entries are posted to the In higher accounting subjects, this approach
general ledger, the following should be the balance of each account: is referred to as the asset method of
recording, where the asset account is
Account Title Debit Credit initially used to record the transaction.
Supplies 2,000
General Journal
Date Account Title and Explanation Ref Debit Credit
2/19/16 Supplies 5,000
Accounts Payable 5,000
To record the purchased of office supplies
Supplies 3,000
If these entries are posted in the general ledger, the following should be the balances of each account:
Notice that even with the different approaches in recording the transactions in the journal entries, the
balances in the general ledger will always be the same whether you used the first approach or the
second approach.
#3 Deferred Income or Unearned Income. These are items that have been initially recorded as tip
liabilities but are expected to become income over time or through the operations of the business. The “Unearned Service Revenue” account
was not included in the Chart of Accounts
Exercise – Adjusting entries to record deferred or unearned income illustrated in ABM1 Chapter ___ (Types of
On February 15, 2016 Matapang entered into a contract with Makisig to maintain the computers of Major Accounts). Additional account titles
maybe added to this chart if the need
Makisig for two months starting on February 15, 2016 up to April 15, 2016. On the same date, Makisig arises. Unearned Service Revenue will fall
paid the total contract amount of PHP40,000 in full. The entries to record and adjust the books are: under the liabilities classification.
In the February 29, 2016 entry above, as of end of February 2016, Matapang has already earned the
service revenue for the first 15 days, thus an adjusting entry is recorded.
General Journal
Date Account Title and Explanation Ref Debit Credit
2/15/16 Cash 40,000
Unearned Service Revenue 40,000
To record receipt of full payment for the two-month
service contract with Makisig