Prepare the bank ledger account

Assignment Help Other Subject
Reference no: EM132304408

Question 1

Retail operations and retail inventory

Spottie Ltd began business on 1 January 2018. The business will sell ‘Spot the dog' soft toys via an online store. The business is not registered for GST. The following transactions occurred during January 2018:

Date:

Details:

1 Jan

Spottie Ltd issued 10,000 x $2 shares to Mr Spot and Mrs Spot.     $20,000 received from the share issue was deposited into the business bank account.

3 Jan

Inventory purchase (400 soft toys) from Plush Toys Ltd on account for $2,400 on terms of n/30.

6 Jan

Sale of inventory (160 soft toys) to Rainbow Preschool on account for $1,600 on terms of n/30.

9 Jan

Inventory purchase (300 soft toys) from Plush Toys Ltd via EFT for $2,100.

12 Jan

Paid Plush Toys Ltd for purchases made on 3 January, via EFT.

15 Jan

Received $1,600 from Rainbow Preschool in payment of their account.

20 Jan

Sale of inventory (200 soft toys) to Sydney Children's Hospital for $2,000 on terms of n/30.

22 Jan

Inventory purchase (150 soft toys) from Plush Toys Ltd on account for $1,050 on terms of 2/10, n/30.

24 Jan

Paid Plush Toys Ltd for purchases made on 22 January, via EFT.

25 Jan

Sale of inventory (200 soft toys) for $2,400 to online customers, with customers paying via EFT.

31 Jan

Mr & Mrs Spot completed a stocktake, and the number of soft toys on hand was 290. 

Required:

i) Mr and Mrs Spot have heard of the two inventory methods - periodic and perpetual methods, and they have also heard of the terms ‘First-in-first-out' and ‘Weighted average cost', but don't really know anything more about them. Prepare a memo to Mr and Mrs Spot explaining each of these methods/terms.

ii) After Mr and Mrs Spot received your memo above, they both agree that the ‘First-in-first-out' method suits their business. They are still undecided about which inventory method should be used (either the perpetual or periodic methods), and have asked you to prepare journal entries for all of the company's transactions for January using the two different methods (using the ‘First-in-first-out' basis), so that they can see how the journal entries differ. Show workings where necessary.

Question 2 Retail operations

This question continues on from question 1 above.

It is now January 2019, and Mr and Mrs Spot have been very busy growing the business of Spottie Ltd over the last year. The business now stocks 20 inventory lines, and employs three full-time staff.

After using a manual accounting system in Excel for SpottieLtd's business, Mr and Mrs Spot have come to you for advice as they consider moving to a computerised accounting system. They believe that they have been spending too much time preparing the accounting records, and a friend recommended that they make the move to ‘Xero' - an online accounting system.

Undertake some research into cloud-based accounting systems, and the ‘Xero' cloud-based accounting system.

Required:

Prepare a business report (for the directors of Spottie Ltd) on cloud-based accounting systems (explaining what they are and how they work), and the suitability of the Xero cloud-based accounting system to SpottieLtd's business. In your discussion, explain how a computerised system like Xero can help the business track and account for inventory. Also highlight three other useful features of Xero that will be beneficial to Mr and Mrs Spot as they seek to save time preparing their accounting records, and monitor and grow their business further.

Note: You must reference using the APA referencing format, and include a reference list at the end of your report.

(Word count: 1000-1500 words)

Question 3

Internal controls - cash

This question continues on from question 1 and question 2 above.

It is now January 2020, and Mr and Mrs Spot have been very successful in growing the business of Spottie Ltd over the last 2 years. The business now stocks over 200 inventory lines, and employs six full-time staff.

As the business continues to grow, you strongly encourage Mr and Mrs Spot to review internal controls over cash receipts and cash payments in the business, to safeguard the business's money.

Mr and Mrs Spot are not overly concerned, as they have never had any issues with cash going missing or being stolen in the past.

Required:

Undertake some research online, looking at cases of employee fraud and/or supplier fraud in Australia. Prepare a letter to Mr and Mrs Spot - discussing the importance of internal controls, and addressing the following:

• Provide a brief overview of 2 recent cases of employee and/or supplier fraud in Australia, explaining how money was stolen from the business. Explain what internal controls could have been implemented to reduce the risk of the fraud occurring. Include a copy of an article relating each case with your letter (or provide website links to the articles in your letter) for Mr & Mrs Spot to review;

• To help Mr & Mrs Spot as they consider reviewing internal controls, outline three internal controls over cash receipts and three internal controls over cash payments that can be implemented in their business immediately. In your discussion, explain how each of these controls helps to reduce the risk of fraud or theft.

Question 4

Bank reconciliations and cash

The bank reconciliation for Party Supplies at 31 July 2018 is shown below:

The August 2018 bank statement appeared as follows:

Party Supplies Ltd's accounting records for August 2018 showed the following:

The current balance in the ‘bank' ledger account (after the above receipts and payments have been entered) is: $17,245.00 + $18,874 deposits - $16,754.50 withdrawals = $19,364.50.

The company's bookkeeper has come to you for help, as she is having trouble reconciling the bank account at 31 August 2018.

Required:

i) Prepare the bank reconciliation for Party Supplies Ltd at 31 August 2018.

ii) Prepare the journal entries to correct any errors made by Party Supplies Ltd, and to record transactions that have not yet been entered into the company's accounting records. (Note: The correction of any errors relating to the recording of cheques should be made to ‘Accounts payable'. The correction of any errors relating to deposits (other than interest received) should be made to ‘Accounts receivable'.)

iii) Prepare the ‘bank' ledger account (using the T-Account format) for August 2018, in order to determine the balance in the account after the above journal entries have been recorded and posted.

Question 5

Property, plant and equipment

Storm Ltd acquired an item of equipment on 1 July 2016 at a cost of $800,000. On 30 June 2017, Storm's directors decide to continue using the cost model for equipment. They elect to depreciate the equipment acquired on 1 July 2016 using the straight-line method, over its useful life of five years. The estimated residual value is $40,000.

The remaining useful life is revised on 1 July 2018 - estimated to be six years from 1 July 2018. The estimated residual value is also revised on this date - to $50,000.

The item of equipment is sold on 31 December 2019 for $500,000.

Required:
Prepare journal entries to account for all transactions that took place during the period 1 July 2016 to 31 December 2019, including entries for the acquisition of the equipment, depreciation for each year, and its disposal. Show all relevant dates, narrations and workings.

Attachment:- Assesment.rar

Reference no: EM132304408

Questions Cloud

Name the communities involved to support your answer : In chapter, the focus was on targeting five communities that make up the core field for ICT-enabled policy-making.
Briefly identify or name the two types of public servants : Briefly identify/name the two types of public servants, and explain why it's important for these two types of servants to receive this education?
How the bill of rights addressed the facts of the case : Explain how the Bill of Rights addressed the facts of the case. Explain the outcome of the case. Discuss whether you think the court's interpretation.
Name a few companies that dominate their sector : Name a few companies that dominate their sector through excellence in operations management.
Prepare the bank ledger account : ACC566 Acc Systems and Processes - Charles Sturt University - Prepare a letter to Mr and Mrs Spot - discussing the importance of internal controls
Would you be willing to put your job at risk : At what point would you be a ‘whistleblower' in your company. Would you be willing to put your job at risk? As the CEO of a software company you are under.
Find a newspaper article on a recent software vulnerability : Find a 2018 or 2019 newspaper website article (no academic research articles) on a recent software vulnerability that led to a security breach.
Explain the rights and obligations of each purchaser : Fully describe the commercial paper rules and draw the picture of each transfer and/or negotiation of this paper. What rights does son have as to payment.
Are lessons unique to beth israel deaconess medical center : What lessons about managing organizational change can we take from this experience and apply to other organizations, in healthcare and in other sectors?

Reviews

len2304408

5/13/2019 2:48:44 AM

Question 5: Apply conceptual and technical aspects of accounting to account for non-current assets and prepare relevant business financial statements. Demonstrates a comprehensive understanding of accounting concepts and techniques, and the ability to apply these to a range of practical situations, without flaw. Appropriate calculations and workings are shown, and are logical and well presented.

len2304408

5/13/2019 2:48:36 AM

Question 3: Discuss and apply accounting ideas, concepts and techniques to assist businesses safeguard their assets. Demonstrates a comprehensive understanding of accounting concepts and techniques, and the ability to apply these to a range of practical situations, without flaw. Discussions and explanations presented are exemplary and clear, well justified, and show an in-depth understanding of the topic. Question 4: Apply accounting ideas, concepts and techniques to prepare accounting information that is useful for decision making. Demonstrates a comprehensive understanding of accounting concepts and techniques, and the ability to apply these to a range of practical situations, without flaw. Appropriate calculations and workings are shown, and are logical and well presented.

len2304408

5/13/2019 2:48:29 AM

Question 2: Discuss and apply accounting tools, concepts and techniques to prepare accounting information that is useful for decision making. Demonstrate relevant business communication skills including report writing. Demonstrates a comprehensive understanding of accounting tools, concepts and techniques available to assist managers as they are making business decisions. Discussions and explanations presented are exemplary and clear, well justified, and show an in-depth understanding of the topic. Answers are presented in an appropriate format and are structured exceptionally well. The writing style is succinct, cohesive, easy to read and it is grammatically correct with accurate use of syntax, spelling and punctuation. In-text citations have been included where necessary. APA referencing system has been followed, without flaw.

len2304408

5/13/2019 2:48:20 AM

Criteria High Distinction Question 1: Apply computer software and basic accounting ideas, concepts and techniques to prepare accounting information that is useful for decision making. Discuss, analyse and/or critique accounting techniques and methods used in practice, and financial information that is prepared. Demonstrates the ability to use computer software and spreadsheets to prepare useful accounting information for a variety of users, without flaw. Appropriate calculations and workings are shown, and are logical and well presented. All required Excel spreadsheet features and functions have been applied. Discussions and explanations presented are exemplary and clear, well justified, and show an in-depth understanding of the topic.

len2304408

5/13/2019 2:48:13 AM

This assessment task will assess the following learning outcome/s: • be able to apply conceptual and technical aspects of accounting and prepare relevant business financial statements. • be able to appraise the use of information technology including spreadsheet software in accounting problem solving, and evaluate the Internet as a professional resource. • be able to demonstrate relevant business communication skills including report writing. • be able to contextualise and evaluate accounting information for decision making purposes. Assessment task 2 is designed to give you further opportunity to demonstrate knowledge and skills in more in-depth aspects of accounting and information systems including bank reconciliations, inventory systems, financial reports, accounting for non-current assets, as well as concepts and the application of spreadsheet software to the presentation and solution of accounting problems.

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