Prepare a trial balance

Assignment Help Accounting Basics
Reference no: EM13903982

The following trial balance provides the closing balances of all accounts as at 31 December 2012 which are the opening balances of those accounts as of 1 January 2013.

Hi -Fi Way

Trial Balance

As of 31 December 2012

Account #

Account

YTD Debit ($)

YTD Credit ($)

1-1110

Cheque Account

84,406

 

1-1180

Undeposited Funds

0

 

1-1190

Electronic Clearing Account

0

 

1-1200

Accounts Receivable

 38,445

 

1-1210

Less Provision for Doubtful Debts

 

769

1-1300

Inventory

 136,120

 

1-1400

Office Supplies

441

 

1-1500

Prepaid Rent

0

 

1-3110

Property & Equipment at Cost

 54,000

 

1-3120

Property & Equipment Accum Dep

 

22,094

2-1200

Accounts Payable

 

33,726

2-1310

GST Collected

 

5,116

2-1330

GST Paid

 6,806

 

2-1410

Salaries Payable

 

0

2-1420

PAYG Withholding Payable

 

1,860

2-1700

Interest Payable

 

0

2-1800

Short Term Loans

 

0

2-2100

Bank Loans

 

48,000

3-1100

Share Capital

 

40,000

3-8000

Retained Earnings

 

190,257

3-9000

Current Year Earnings

 

         0

3-9999

Historical Balancing

 

                      0

4-1100

Sales Revenue

 

102,314 

5-1100

Cost of Sales/Cost of Goods Sold

71,620

 

6-1100

Depreciation Expense

22,094

 

6-1800

Office Supplies Expense

2,861

 

6-1930

Salaries Expense

17,812

 

6-2100

Rent Expense

0

 

6-2200

Telephone Expense

3,924

 

6-2420

Electricity Expense

3,990

 

6-2500

Bank Charges

33

 

6-2600

Bad Debts Expense

1,104

 

8-1000

Interest Income

 

0

9-1000

Interest Expense

480

 

 

TOTAL

444,136

444,136

Goods and services tax (GST): The company is a registered entity for GST purposes and accounts for GST on an accrual basis. As a small business, Hi-Fi Way pays GST in quarterly instalments and no GST is due to be remitted in the month of January. The prices of goods and services that are subject to GST are quoted inclusive of 10% GST.

First transaction: On 2 January 2013, Hermione issued Cheque no. 4007 to Office Supplies Warehouse for the purchase of $2,200 (includes 10% GST) worth of equipment.

Early January 2013

Date      Transaction description

2              Issued Cheque No. 4008 for $1,540 (includes 10% GST) to Discount Office Supplies for the cash purchase of office supplies.

2              Obtained a loan of $15,000 from Uncle Claudio (a family relative of Hermione Fowler) at a simple interest rate of 6% per year, Cheque No. 121, ID #CR000001. The principal and interest on the loan are payable in six months time.

3              Issued Cheque No. 4009 for $6,468 to Big Telco in payment of Purchase #341 (Supplier Inv#263).

3              Received Cheque No. 221 from Jerry Technology for $10,648, which is the full amount outstanding on their account, ID #CR000002.

3              Purchased 9 units Swish Phones from Mega Tech at $1,177 each (includes 10% GST), Purchase #344, Supplier Inv#922. Issued Cheque No. 4010 for $5,600 to this supplier for this particular invoice at the time of the purchase.

5              Realised that the entry above for the purchase of 9 Swish Phones was incorrect.  The correct entry should have been: Purchased the following items from JCN Electrical, Purchase #344, Supplier Inv#922:9 units Swish Phones at $1,177 each (includes 10% GST), and 8 units Mieca camera lenses at $1,760 each (includes 10% GST).  Issued Cheque No. 4010 for $5,600 to this supplier for this particular invoice at the time of the purchase.  You will need to reverse the incorrect entry made on 3 January and then make the correct entry.

5              Sold the following items on credit to Hypertronics, Invoice #3532:

2 units MX620 notebook computers for $2,420 each (includes 10% GST) (standard cost $1,470 [no GST])

3 units ZII game consoles for $2,750 each (includes 10% GST) (standard cost $1,670 [no GST]).

$4,400 was received immediately, Cheque No. 642, with the rest due to be received during the last week of the month. Note that MYOB automatically assigns ID #CR000003 to this cash receipt.

7              Record an entry to transfer the amount recorded in the Undeposited Funds account (that is, all cheques received from 1 January to 6 January inclusive) into the Cheque Account, ID #CR000004.

Mid January 2013

Date      Transaction description

8              Purchased 9 units MX620 notebook computers from Big Telco at $1,617 each (includes 10% GST), Purchase #345, Supplier Inv#746.

8              Made a cash sale to Hypertronics, Invoice #3533 for the following items:

5 units MX620 notebook computers for $2,420 each (includes 10% GST) (standard cost $1,470 [no GST])

4 units Mieca camera lenses for $2,640 each (includes 10% GST) (standard cost $1,600 [no GST]).

Received Cheque No. 647 for $22,660 from this customer. Note that MYOB automatically assigns ID #CR000005 to this cash receipt.

14           Received a purchase order from Pikea, Customer PO#3949, Invoice #3534. The following items are required to be shipped by 24 January 2013:

5 units MX620 notebook computers at $2,420 each (includes 10% GST) (standard cost $1,470 [no GST])

5 units Swish Phones at $1,760 each, (includes 10% GST) (standard cost $1,070 [no GST]) .

15           Purchased 10 units ZII game consoles from Big Telco for a list price of $1,837 each (includes 10% GST), Purchase #346, Supplier Inv#668. Issued Cheque No. 4011 for the full payment of this purchase.

15           Issued Cheque No. 4012 for $5,500 (includes 10% GST) to pay Advanced Property Management for three month's worth of rent in advance.

17           Sold merchandise on credit to Jerry Technology, Invoice #3535. The items sold were:

3 units Mieca camera lenses for $2,640 each (includes 10% GST) (standard cost $1,600 [pre GST])

3 units ZII game consoles for $2,750 each (includes 10% GST) (standard cost $1,670 [no GST]).

17           Ordered 9 units Swish Phones for $1,177 each (includes 10% GST), from Mega Tech, Purchase #347, Supplier Inv#SO747.

20           Received 9 units Swish Phones, Purchase #347. These items were ordered from Mega Tech for $1,177 each (includes 10% GST), Supplier Inv#SO747.

21           Record an entry to transfer the amount recorded in the Undeposited Funds (that is, all cheques received from 7 January to 20 January inclusive) account into the Cheque Account, ID #CR000006.

REQUIRED:

  1. Open Ledger accounts (T-format or Running-balance format) for the above accounts and enter the balances as per the Trial Balance.
  2. Record the transactions listed below in the General Journal, using the accounts listed in the Trial Balance.
  3. Post the transactions from the General Journal to the Ledger accounts.
  4. Prepare a Trial Balance as at 21 January 2013

Reference no: EM13903982

Questions Cloud

Compute the activity-based overhead rate for each pool : What is the benefit to Acme Manufacturing of applying activity-based costing to its R&D activity for both                     in-house and outside charging purposes?
Calculated using 4d entertainment’s existing costing system : Using activity-based costing (ABC), calculate the profitability of the Zenith and Pinnacle models. 2. Explain briefly why these numbers differ from the profitability of the Zenith and Pinnacle models.
Prepare consolidated worksheet : Prepare Consolidated Worksheet
Demand curve facing the firm is relatively elastic : Does this mean that the demand curve facing the firm is likely to be relatively elastic or relatively inelastic? What does this imply about the ability of the firm to ‘mark up’ its price above marginal cost?
Prepare a trial balance : Open Ledger accounts (T-format or Running-balance format) for the above accounts and enter the balances as per the Trial Balance.Record the transactions listed below in the General Journal, using the accounts listed in the Trial Balance.
Journalize the transactions for the month : Journalize the transactions for the month and Compute cost of goods manufactured.
Discuss economic theory and the available empirical evidence : Discuss whether economic theory and the available empirical evidence justifies high executive compensation.
Bird flu and christmas season influence the equilibrum price : What are the possible reasons for the price rise mentioned in the news article? Use one demand and supply model to illustrate how bird flu and Christmas season influence the equilibrium price and output in the egg market.
Calculate the effective rate of production for steel industr : Calculate the effective rate of production for steel industries. Question files are available when you purchase as they are images.

Reviews

Write a Review

Accounting Basics Questions & Answers

  You borrow 1000 from me today and promise to repay a lump

you borrow 1000 from me today and promise to repay a lump sum of 1000 to me at the end of 3 years and pay interest on

  After two weeks the money box appeared to be getting full

flint hills middle school wants to raise money for a new sound system for its auditorium. the primary fund-raising

  Alternatively the employee can take 29000 at the date of

davenport inc. offers a new employee a lump-sum signing bonus at the date of employment. alternatively the employee can

  Straightforward variance analysis lo 5 arrow enterprises

straightforward variance analysis l.o. 5 arrow enterprises uses a standard costing system. the standard cost sheet for

  Cutting and finishing component kits are produced in the

ogden office outfitters began making high-quality office furniture in january. the companys executive desks are

  How many years required to invest money to supplement plan

Assume Starla wants to accumulate $100,000by her retirement date. Will she achieve her goal if she invests $44,000 today and earns 7%?

  A corporation received its charter and began business this

a corporation received its charter and began business this year. the company is authorized to issue 50000 shares of 100

  Which of the following isolated events will not change

A firm has $100 of average inventory, operating profit of $500 and sales of $1,500. Its days in inventory is: Which of the following isolated events will NOT change the quick ratio for a manufacturer

  Finished goods inventoy at the end of nov was 1500 units

finished goods inventoy at the end of nov was 1500 units. ending finished goods inventory is equal to 25 percent of the

  For february sales revenue is 250000 sales commissions are

for february sales revenue is 250000 sales commissions are 6 of sales the sales managers salary is 50000 advertising

  Wal-mart and net income

What does it mean if a company such as Wal-Mart has net income, increasing total assets, and a lower return on assets? Is this a good thing or a bad thing?

  Arlandria inc has bought a new server and is having to

arlandria inc. has bought a new server and is having to decide what to do with the old one. the cost of the old server

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd