What financial report can be prepared based on trial balance

Assignment Help Financial Accounting
Reference no: EM13840505

Establish & Maintain Accrual Accounting System

Critical Assessment Task 1 - Case Study

? You must complete this task correctly to demonstrate competency in this unit.

1. You are the accountant at BestPages Pty Ltd, a newly commencing newsagency and bookstore focused on the sale of newspapers, magazines, books and basic consumer products. The Store to be based in downtown Springfield will be one of the first since the local Boundaries bookstore closed recently. Mr Samuel Clements is the owner of the business and he has just purchased an old site, in Springfield that he plans to improve and make useable as the newsagency site. The owner is purchasing the site for $150,000, building for 50,000 and fixtures for $45,000. Mr Clements makes a contribution of $130,000, and will take out a mortgage for the remaining sum of $145,000.

You establish the following chart of accounts;

Assets Liabilities

1100 Cash

1111 Accounts Receivable

1122 Land & Grounds

1133 Buildings

1144 Fixtures & Equipment

2200 Accounts Payable

2201 Contra Accounts Payable

2211 Term Loan/Mortgage

Revenue Owner's Equity

4400 Income from Sales

4401 Contra Control Sales Returns

4402 Contra Control Sales Discounts

4411 Income from Rental

3300 Owners Capital

Expenses

5500 Salaries Expense

5511 Amenities and Services Expenses

5522 Marketing and Advertising Expenses

5533 Repairs and Maintenance Expenses

5544 General, Misc. & Other Expenses

5555 COGS

The following occurred over the course of the accounting period:

May 1 The owner (Mr Clements) makes a deposit of $130,000 into the company bank account for the purpose of acquiring the building, land and fixtures.

May 2 The owner purchases the site for $150,000, building for $50,000 and fixtures for $45,000. Mr Clements takes out a mortgage for the remaining sum of $145,000.

May 3 Mr Clements then paid for a commercial to be produced and aired in the following month on local radio promoting his new newsagency. The Advertisement cost $500 to produce and $200 per play on KBBL, Springfield. Mt Clements wants 5 plays. He is required to pay a 10% deposit now for the production and airtime. The balance is due in 45 days.

May 4 Mr Clement decides to have a launch party, and purchases the following general supplies:
Promotional flyers and cards

Mailing costs

Food

Beverages Decorations $400

$500

$300

$200

$300

May 29 The business purchased inventory worth $30,000 on credit;

May 30 The owner then pays the appointed staff for the services rendered. Staff costs total $20,000 per month.

May 30 The company makes sales totalling 80,000 while the cost associated with those goods was 20,000 (these goods were purchased during the period). Of these goods $5000 was returned to the company, the COGS of the returned items were $1000.

In addition to the $80,000 sales, a once off service based sale of $10,000 was made with a discount of 10% of the $10,000 provided for early repayment, which the customer made (so the customer paid $9000). The invoice was issued on the 7th May and paid on the 10th May.
May 30 The company receives its electricity bill of $200, and pays the bill.

The company received a maintenance bill from the cleaning company that manages the cleaning and maintenance of the site for $400. The company pays the bill.

Required: complete the relevant entries within the ledger accounts provided. Generate a trial balance for the company.

GENERAL LEDGER - BestPages Pty Ltd (BP)

1100 - Cash

Date Particulars Folio Dr Cr Balance

1110 - Inventory

Date Particulars Folio Dr Cr Balance

1122 - Land & Grounds

Date Particulars Folio Dr Cr Balance

1133 - Buildings

Date Particulars Folio Dr Cr Balance

1144 - Fixtures and equipment

Date Particulars Folio Dr Cr Balance

1155 - Accounts Receivable

Date Particulars Folio Dr Cr Balance

2200 - Accounts payable

Date Particulars Folio Dr Cr Balance

2201 - Contra Acc. Payable Control Account

Date Particulars Folio Dr Cr Balance

2211 - Term Loan Payable

Date Particulars Folio Dr Cr Balance

3300 - Owners Capital

Date Particulars Folio Dr Cr Balance

3301 - Owners Drawings

Date Particulars Folio Dr Cr Balance

4400 Income from Sales

Date Particulars Folio Dr Cr Balance

4401 Contra Control Sales Returns

Date Particulars Folio Dr Cr Balance

4402 Contra Control Sales Discounts

Date Particulars Folio Dr Cr Balance

4411 Income from Rental

Date Particulars Folio Dr Cr Balance

30/05

5500 Salaries Expense

Date Particulars Folio Dr Cr Balance

5511 Amenities and Services Expenses

Date Particulars Folio Dr Cr Balance

5522 Marketing and Advertising Expenses

Date Particulars Folio Dr Cr Balance

5533 Repairs and Maintenance Expenses

Date Particulars Folio Dr Cr Balance

5544 General, Misc. & Other Expenses

Date Particulars Folio Dr Cr Balance

5555 COGS

Date Particulars Folio Dr Cr Balance

Trial Balance

Debit Credit

Cash

Inventory

Accounts Receivable

Land & Grounds

Buildings

Fixtures & Equipment

Accounts Payable

Contra Accounts Payable

Term Loan/Mortgage

Income from Sales

Contra Control Sales Returns

Contra Control Sales Discounts

Income from Rental

Owners Capital

Salaries Expense

Amenities and Services Expenses

Marketing and Advertising Expenses

Repairs and Maintenance Expenses

General, Misc. & Other Expenses

COGS

Total

2. The BestPages Pty Ltd is trading well and now has a number of ongoing purchasers, both retail and wholesale. It currently has no outstanding debtors. During the month a number of new customers start to purchase books in large quantities. Additionally it currently has no outstanding creditors. During the month a number of new purchase of books and related products are made. Purchases expense is used in this question to replace COGS.

The monthly events are as detailed;

• 1st June, the business purchases a large quantity of books to satisfy several wholesale orders; the purchase totals $100,000 in value. Payment terms are 45 days from the invoice date.

• 5th June, customer HealthFoods purchases a large quantity of books, totalling $100,000 in worth for their chain of health foods stores. Payment terms are 15 days from the invoice date. This remains unpaid at 30th June.

• 7th June, customer GymPro purchases a large quantity of books, totalling $50,000 in worth for their chain of gymnasiums. Payment terms are 15 days from the invoice date. This remains unpaid at 30th June.

• 9th June, customer HobbyShop purchases a large quantity of books, totalling $50,000 in worth for their chain of enthusiasts' stores. Payment terms are 15 days from the invoice date. This remains unpaid at 30th June

• 10th June, customer Art Academy purchases a large quantity of books, totalling $100,000 in worth for artists' academy. Payment terms are 15 days from the invoice date. This remains unpaid at 30th June.

Required: complete all of the relevant accounting entries relating to these transactions within the ledger accounts below for the month of June. Post an entry to account for Bad and Doubtful debts, which represents 10% of the value of accounts receivable for the month.

1111 - Accounts receivable

Date Particulars Folio Dr Cr Balance

2200 - Accounts payable

Date Particulars Folio Dr Cr Balance

5577- Purchases expense

Date Particulars Folio Dr Cr Balance

4400 - Sales

Date Particulars Folio Dr Cr Balance

4401- Provision for doubtful debts

Date Particulars Folio Dr Cr Balance

5801 - Doubtful debts expense

Date Particulars Folio Dr Cr Balance

3. It is the 31st July, the following month, and BestPages Pty Ltd still has a number of accounts receivable monies outstanding. Only HobbyShop has paid its invoice.

Required: Construct a schedule of debtors, based on the accounts receivable payment received and outstanding. Identify which accounts are past their due date.

4. It is the 15th of August and Mr Clements is a bit concerned about one of the debtors, GymPlus and the likelihood of receiving their payment. What can the company try to do to expedite payment? Describe the recourses available to the company in terms of debt recovery.

5. Mr Clements is a bit concerned about his debtors policies or lack thereof, he asks you the accountant to develop a viable policy in relation to identifying doubtful bets, posting appropriate doubtful debt entries, and follow up with outstanding accounts payable past due.

Required: provide a set of policies that the company could implement in relation to the matters that Mr Clements has raised.

Critical Assessment Task 2 - Written Questions

? You must complete this task correctly to demonstrate competency in this unit.

1. What is a contra deal?

2. Why is it important to have accountability structures in place in relation to contra deals?

3. Are there GST implications in relation to contra deals? Describe potential GST implications.

4. Describe why a sales returns contra account might be useful within a chart of accounts, rather than maintaining a sales account absent of a sales return account? E.g. what are the key benefits associated with such accounts?

5. Seymour runs a website design business and as such is a GST registered designer who accounts for GST on accrual basis and lodges quarterly activity statements. On 30/08/2013, he completed a new website for a client at an agreed charge of $8,800 (including GST). Seymour issued a valid tax invoice on the day of completion and the payment was received on 01/10/2013.

Seymour is advised by ATO to lodge his GST obligations for the Jul/Sep quarter 2013 (July - September). Please advise Seymour whether he should include the GST collected from the new website deal in the GST lodgement.

6. You are the accountant at OfficePlus Pty Ltd. You are identifying outstanding monies owed to the company, what are the relevant accounts and the steps involved in reviewing outstanding debtors?

7. As the accountant of OfficePlus Pty Ltd, an office supplies company, identify that several of the firm's present debtors appear unwilling or unable to pay their outstanding debts. You are considering the steps that could be taken to hasten the recovery of the monies owed.
Required: Provide a plan for the recovery of debt that considers an approach to debt collection involving, firstly OfficePlus directly engaging with the debtors in an empathetic manner, and then alternative actions that may engage specialist collection firms in debt collection.

8. The process of accounting for businesses is moderated by a number of industry codes of practice and standards. Briefly explain the role of the AASB in relation to accounting standard setting?

9. What financial reports can be prepared based on the trial balance?

Reference no: EM13840505

Questions Cloud

How will you use each of these in your future profession : How will you use each of these in your major/future profession? Short paragraph covering the LLOs in your chosen profession. If you aren't sure choose something
Income statement and statement of financial position : Prepare, in a form suitable for presentation to the shareholders of Cratchit plc the Income Statement and Statement of Financial Position for the year ending 30th April 2015 - Importance of the EPS calculation to investors
Average rate of change of the function : Problem 1: Find the average rate of change of the function over the given interval.
Describe potential communication technology tools : Then describe two potential communication technology tools you might use in your public health campaign and explain why these tools would be appropriate for your target audience
What financial report can be prepared based on trial balance : What financial reports can be prepared based on the trial balance? The process of accounting for businesses is moderated by a number of industry codes of practice and standards. Briefly explain the role of the AASB in relation to accounting standar..
Calculate the profit as a percent of the premium paid : Calculate the profit as a percent of the premium paid
Basic excel modeling : Input a formula in cell C2 of the "converted_data" sheet that convert the "time to complete" value in cell C2 of the "raw_data" sheet (and is in seconds) to a corresponding value in minutes. Drag this formula down to cell C29 (on the "converted_da..
Analyzing financial ratios : Analyzing Financial Ratios
Identification of the elements of the promotion mix : Appreciation of the significance of the concept of integrated marketing communications (IMC) and its impact on marketing management. Identification of the elements of the promotion mix and the pros and cons of each element. Connection of the concept..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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