prepare the ledger accounts-trial balance-balance sheet , Accounting Basics

A part of Deeper Coral's income is earned from conducting diving lessons. 

Level

Lesson Type

Fee per hour

I

Introductory

$40

II

Intermediate

$50

III

Advanced

$55

Each level contains 4 lessons, at one hour per lesson spread over 4 consecutive Saturday's.  For example, a student would normally complete 12 lessons to graduate with a Level III Certificate in Diving.  The lessons are quoted inclusive of GST.  Joanna and Katerina conduct the lessons on Saturdays.

Name

Address

Account Balance

Dive's Manufacturing

Lot 5, Cooper Street, Spotswood

$1540

Artec Industries

425 Sydney Road, Coburg

$594

Right Coral Pty Ltd

Factory 11, Williamsville Business Complex

$880

GTK Publishers

87 Circular Drive, Spotswood

$1320

Stewart Screen Printing

Factory 5, Williamsville Business Complex

$220

Each of the above account balances represents deliveries of inventory received on February 25th.  Both Dive's Manufacturing and Artec Industries offer Deeper Coral the following terms - 5% 10 days, net 30 days, while the other suppliers all offer 2% 15 days, net 30 days.

Customer Information:

Deeper Coral sells most of its inventory strictly on a cash basis, but the business has two credit customers.  Terms of payment for these customers is 5% 10 days, net 30.

Name

Address

Date Last Invoice

Account Balance

Williamsville TAFE

14 Bligh Street, Williamsville, VIC 3292

Feb 27

$2350

Williamsville Secondary College

47 Buckley Road, Williamsville, VIC 3292

Feb 25

$1940

Trial Balance as at February 28th, 2011.

 

 

 

 

Account

Debit

Credit

 

 

 

Bank

16372

 

Stock

7026

 

Accounts Receivable

4290

 

Accounts Payable

 

4554

Motor Vehicle

22500

 

Accumulated Depreciation on MV.

 

6750

Diving Equipment and Boat

38900

 

Accumulated Depreciation on DE & B.

 

11670

Shop Fittings

5750

 

Accumulated Depreciation on SF.

 

575

GST Collected

 

4266

GST Paid

2837

 

Owners Capital

 

61252

Shop Lease

14400

 

Amortisation of Shop Lease

 

2400

Loan - ANZ Bank, Williamsville

 

20000

PAYG Tax Payable

 

540

Wages Payable

 

 68

 

$112075

$112075

Required:

Part 1: Prepare the ledger accounts as per the trial balance with the opening balances including subsidiary ledgers..

Part 2: Record the transactions for the month of March 2011.  Be careful to open any new accounts that you require.

Part 3: Prepare  the following reports in  one Excel file:

(i)  Trial Balance as at March 31st, 2011 (after all adjustments)

(ii)  Income Statement for March 2011.

(iii) Balance Sheet as at March 31st, 2011.

(iv) The General Ledger Accounts for

a.    Cash at Bank

b.    Accounts Receivable

c.    Stock Asset

d.    Accounts Payable

e.    Tax Payable

Posted Date: 3/12/2013 2:59:53 AM | Location : United States







Related Discussions:- prepare the ledger accounts-trial balance-balance sheet , Assignment Help, Ask Question on prepare the ledger accounts-trial balance-balance sheet , Get Answer, Expert's Help, prepare the ledger accounts-trial balance-balance sheet Discussions

Write discussion on prepare the ledger accounts-trial balance-balance sheet
Your posts are moderated
Related Questions
Q. Example of T-accounts? Suppose that the last day of December 2010 falls on a Monday this expense account doesn't show salaries earned by employees for the last day of the mo

Q. A company would not acquire treasury stock a. in order to reissue shares to officers. b. as an asset investment. c. in order to increase trading of the company's stock. d. to ha

J Green''s financial position at 1 May 2008 was as follows bank 2,910 cash 160 equipment 5,900 premises 25,000 creditors R smith 890 t thomas 610 debtors j car

Q. Explain accounting cycle? Creditors, Investors as well as Managers use these statements in evaluating management's past decisions and as a basis for making future decisions.

What are examples of deferred revenue expenditure? Ans) It is an expenditure the advantage of which will be realized over a period and not during the present period. Ex-Heavy Ad

began his business with equipment valued at $40,000 and place $400,000 in the business checking account. what are the accounts affected?

2013, May 1st: 1 started in bnusiness with capital in cash of 1,800 and 4,200 in the bank. 2nd: Bought goods on credit from: j.Ward 600, P.Green 515

ledger is said to be the principal book entry and the transactions can even be directly entered into the ledger account. elaborate on the statement and explain why journal is neces

How can I capitalize my patents? My company has applying for a patent and I want to capitalize the research and development expenditures. I know it will cost some legal charges and

Explain in detail about the MERCHANDISE INVENTORY Cost of merchandise purchased during an accounting period is debited to Purchases account. To determine VALUE of the goods on