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

  Xyz has a code section 754 election in effect and x sells

xyz has a code section 754 election in effect and x sells her interest to w for 30000 cash. however the land was

  Describe the respective roles of the securities and

describe the respective roles of the securities and exchange commission sec and the internal revenue service irs in the

  X company estimates that 1700 direct labor hours will be

x company has the following estimated costs for the year direct materials 62800 direct labor 23800 factory supplies

  Prepare a schedule to show the balance

On January 3, 2011, Jenkins Corp. acquired 40% of the outstanding common stock of Bolivar Co for $1,200,000. This acquisition gave Jenkins the ability to exercise significant influence over the investee.

  Incremental analysis of jefferson plaza hotel

The Jefferson Plaza Hotel is a deluxe four star establishment. Late on Friday, it had 10 of its 200 rooms available when the desk clerk received a call from the Riley Hotel.

  Ollies olive oil began business in 2010 during which it

ollies olive oil began business in 2010 during which it produced 104000 quarts of olive oil. in 2010 the company sold

  From the information given compute the depreciation charge

jon seceda furnace corp. purchased machinery for 315000 on may 12007. it is estimated that it will have a useful life

  Calculate the netinterest revenue for the year

A $1,000 bond, paying interest annually on December 31, is purchased on January 1 at 110 as a long-term investment. The life of the bond is 5 years. Prepare entries for the first year and use the straight-line method of premium amortization. Also..

  A company established a petty cash fund of 100 on september

a company established a petty cash fund of 100 on september 1. on september 10 the petty cash fund was replenished when

  In addition to her employment vanessa sells cosmetics on

1 what is vanessas filing status?2 what is vanessas agi?3 does vanessa claim the standard deduction or itemized? what

  What is the updated principal balance

Paris Company buys a building on a plot of land for $100,000, paying $20,000 cash and signing a 20-year mortgage note for $80,000 at 6%. Monthly payments are $570. The first monthly payment was made in January, 2013. After the first payment, what ..

  The bakery produces tea cakes it uses a process costing

the bakery produces tea cakes. it uses a process costing system. in march its beginning inventory was 450 units which

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