Prepare a bank reconciliation statement for mel traders

Assignment Help Other Subject
Reference no: EM132984131

HI5001 ACCOUNTING FOR BUSNISS DECISIONS

Question 1 Mac Ltd. provides legal advice to customers for fees. On 30 June 2020, Mac Ltd. completed its first year of operations. Some of the ledger account balances of the business, before any financial year end (30 June) adjustments, are provided below:

 

$

Fees Revenue

354,000

Rent Expense

17,568

Electricity Expense

6,768

Wages Expense

130,560

Advertising Prepaid

2,160

No adjusting entries have been made to these accounts at any time during the year. An analysis of the business records reveals the following.
1. The total Fees Revenue recorded includes $1,800 that was prepaid by a client as a deposit for legal advice to be provided in July 2020.
2. The balance in Advertising Prepaid represents the amount paid for an advertising on a legal magazine for 6 months. The agreement with the publisher of the magazine covers the period 1 May 2020 to 31 October 2020.
3. The Electricity Expense ledger balance does not include the amount for June 2020. The account amounted to $1,260 and was received and paid during July.
4. The firm's lease agreement for the office premises commenced from 1 July 2019. The agreement indicates a rent of $1,220 per month is to be paid on the first day of each month. In addition, an annual amount equal to 0.2% of the entity's total fees revenue earned each year should be paid. This extra rental is payable within 15 days of the end of the reporting period.
5. The entity hired part-time employees. Wages are paid fortnightly on Fridays (5 working day each week and each pay period covers Monday from preceding week to Friday in the pay week). In 2020, 30 June falls on a Tuesday and the wages for the two-week pay period ended on Friday 3 July 2020 is $9,360. All employees worked the normal office hours during the two--week pay period.

Required:
a) Journalise the necessary adjusting entries at the end of the period.
b) Apply the knowledge that you have learned from Lecture 4, using an example to explain the differences between cash basis and accrual basis accounting, and further discuss why adjusting entries are necessary.

Question 2
You are the bookkeeper of Mel Traders. You undertake a bank reconciliation at the end of every month. Mel Traders received its bank statement for the month ending 31 May 2021. The bank reconciliation at the end of April showed a deposit in transit of $11,700 and two outstanding cheques (no. 663 for $3,060and no. 671 for $6,300). The adjusted cash balance in the entity's records was $106,305 debit at the end of April.

Below are the entity's May bank statement and the entity's book records that indicate the deposits made and cheques written during the month of May:

AU Bank - Bank Statement

For the period 01/05/2021 - 31/05/2021

Mel Traders

 

 

 

Dr

Cr

Balance $

 

 

 

Balance brought forward

 

 

103,965

CR

1

May

Deposit

 

11,700

115,665

CR

3

May

Deposit

 

10,620

126,285

CR

 

May

Cheque # 682

4,680

 

121,605

CR

6

May

Deposit

 

6,120

127,725

CR

8

May

# 671

6,300

 

121,425

CR

9

May

Deposit

 

7,560

128,985

CR

12

May

Deposit

 

3,780

132,765

CR

 

May

# 684

6,300

 

126,465

CR

13

May

# 683

15,300

 

111,165

CR

15

May

Deposit

 

14,580

125,745

CR

 

May

# 687

13,320

 

112,425

CR

20

May

Deposit

 

5,040

117,465

CR

22

May

# 685

12,240

 

105,225

CR

26

May

Deposit

 

13,680

118,905

CR

29

May

# 686

11,340

 

107,565

CR

30

May

# 680

7,740

 

99,825

CR

31

May

interest

 

345

100,170

CR

31

May

Transaction fees

195

 

99,975

CR

Mel Traders' Book Records

Date

Deposits made

Cheques written

 

 

$

No.

$

May

3

10620

# 679

4320

 

6

6120

# 680

7740

 

9

7560

# 681

6210

 

12

3780

# 682

4680

 

15

14580

# 683

15300

 

20

5040

# 684

6300

 

26

13680

# 685

12240

 

29

11340

# 686

6480

 

 

$ 72,720

# 687

13320

 

 

 

 

$ 76,590

The cash at bank account balance on 31 May was $102,435.

In reviewing cheques, a mistake was discovered: Cheque no. 686, written for insurance expenses of $11,340, was recorded in the general journal as $6,480.

Required:
a) As the entity does not use special journals, prepare the necessary general journal entries to bring the cash at bank account up to date as at 31 May 2021.
b) Prepare a bank reconciliation statement for Mel Traders at 31 May 2021. Please ensure you indicate the balance of each amount with either a debit or credit in the bank reconciliation statement.

Question 3
The information in the following table relates to the accounts receivable and allowance for doubtful debts of Prime Moving Ltd. The company's accounting period ends on 30 June each year. The company policy is to provide an allowance for doubtful debts at the rate of 3% of accounts receivable at 30 June each year. The balance of the Allowance for Doubtful Debts account on 1 July 2019 was $14 000. The following information is given for the year ending 30 June 2020 and 30 June 2021, in order to determine the bad debts expense for each year and the balance of allowance for doubtful debts at the end of each year.

 

2020

2021

Accounts receivable (ending balance at 30 June)

$560,000

$630,000

Bad debts written off during the year

8,400

0

Allowance for doubtful debts at 1 July (Beginning of the period)

(a)

(d)

Bad debts expense for the year

(b)

(e)

Allowance for doubtful debts at 30 June (Ending balance)

(c)

(f)

Required:
a) Determine the missing amounts in the table.
b) Discuss how the following accounts are recognised or disclosed in the entity's financial statements and their effect on the financial statements.
• discount allowed
• discount received
• bad debts expenses
• bad debts recovered
c) Show the relevant section of the balance sheet prepared at 30 June 2021.

Question 4
You are the senior accountant for a shoe wholesaler that uses the periodic inventory method. You have determined the following information from your company's records, which you assume is correct:
1. Inventory of $296,064 was on hand at the start of the year.
2. Purchases for the year totalled $2,028,000. Of this, $1,694,400 was purchased on account; that is, accounts payable was credited for this amount at the time of the purchase.
3. A year-end inventory count revealed inventory of $389,760

Required:
a) Assume that the company uses periodic inventory system, calculate cost of sales.
b) Assume now that your company uses the perpetual method of inventory control, and that your records show that $1,857,990 of inventory (at cost) was sold during the year. What is the adjustment needed to correct the records, given the inventory count in item 3 above?
c) What might the need for this adjustment indicate about company operations?
d) Assume that during the year, total inventory was sold for $3,360,000 on credit. What would be the entries to record the sales transaction under periodic inventory control system? What would be the entries to record the sales transaction under perpetual inventory control system?

Question 5
Adam's mowing Limited purchased a group of new lawnmowers for $26,000 at 1 July 2020. As the accountant of the business, you have estimated that the mowers are to last five years and to have $650 residual value at that point. The entity's business plan projects cutting 6,000 lawns over the five years, with per-year projections of 650, 1,300, 1,460, 2,140 and 550 lawns over the five years.

Required:
a) Calculate the accumulated depreciation balance at the end of the second year using each of the following depreciation bases. Show your working.
• straight-line
• diminishing balance (52 per cent rate)
• units-of-production.
b) You are asked by the owner of the business which depreciation basis would result in the entity paying less tax at the end of the second year and so you should adopt that method for the mowers as it would save cost for the entity. Provide appropriate response to the owner's question and request.
c) If the 52 per cent reducing balance method is used, accumulated depreciation will be $25,350 at the end of the fifth year. Suppose that, on the first day of the sixth year, all the lawnmowers are sold as junk for $100 cash in total. Ignoring income taxes, calculate the loss on sale that would be recorded that day.

Question 6
The following events occurred during the year ended 30 June 2020 for Electrical Limited.
a) On 1 June 2020, Electrical Ltd. signed a three-month 9% per annum bills payable to purchase a new equipment costing $576,000. Interest and principal are paid at maturity.
b) On 29 June 2020, Electrical Ltd. received deposit in advance of $10,000 from a construction company for completing the electrical work for a new project during the next 6 months.
c) Electricity charges of $50,000 from 24 April to 23 June are payable on 10 July.
d) Electrical's main product is backed by warranty. Sales of this product for the year totalled $445,000. The opening balance of provision for warranty claims was $15,900. During the year, Electrical's warranty expense was $47,550 and claims paid to customers totalled $37,800.
e) June sales totalled $252,000. Electrical Ltd. collected GST of 10% on this amount. This is due to be paid to the tax office by the seventh day of the following collection.
f) On 30 June 2020, Electrical Ltd. took out a loan for $150,000 from AUZ Bank. Repayments of principal are scheduled evenly over a five-year period. Interest on the loan is paid in the year it is incurred.

Required:
For each item, indicate the account name and the amount to be included as a current liability on Electrical's balance sheet prepared at 30 June 2020. (show your working for your calculation for each amount).

Reference no: EM132984131

Questions Cloud

Describe at least four leadership characteristics : Describe at least four leadership characteristics that in your opinion will be critical for a manager working within the travel and tourism sector
List five principles of effective delegation : Explain two problem-solving techniques that can be used by teams. Support your answer with appropriate reasoning/effectiveness of each of the techniques
List five waste reduction techniques : Explain the relationship between operational efficiency and financial sustainability in own words Working hard on operational efficiency is obviously leading.
What are key performance indicators : Quality assurance takes a company-wide approach. Discuss what this includes in your own words. What are Key Performance Indicators (KPIs)?
Prepare a bank reconciliation statement for mel traders : Prepare a bank reconciliation statement for Mel Traders at 31 May 2021. Please ensure you indicate the balance of each amount with either
What is the firm times interest earned ratio for tvg : In the past year, TVG had revenues of $3.01 million, cost of goods sold of $2.51 million, What is the firm's times interest earned ratio?
Determine silly pool current firm value : Determine Silly Pool's current firm value. A firm's debt capacity is limited by factors such as growth, asset structure, earning volatility, macro conditions.
Which of statements concerning accrued benefits in qualified : Which of the statements concerning accrued benefits in qualified plans is (are) correct? In a defined benefit plan, the participant's accrued benefit
What amounts for SoftPlus appear in financial statements : If the marketing software was undervalued by $34,000, what amounts for SoftPlus would appear in PanTech's December 31, 2017, consolidated financial statements

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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