Write a brief report to julie and katy

Assignment Help Accounting Basics
Reference no: EM131377743

Task - Requirements:

Stage 1

Use the spreadsheet template provided to complete the following requirements.

When using the spreadsheet you are required to provide the links from the General Ledger Accounts to the Live Trial Balance.

1. Link the balances of the General Ledgers to the Live Trial Balance

2. Enter the transactions into the appropriate Special Journals.

3. Important: After each transaction that particular journal should be in balance. If it is not, fix it before recording the next transaction.

4. Do the Bank Reconciliation and enter transactions as required.

5. Post (Link) the transactions from the Special Journals to the appropriate General Ledger Accounts the balances of which should flow to the Live Trial Balance.

6. Important: Posting should be done from the total of each column unless recorded in "Other Account" column.

7. Important: Post the entire journal and check that the Live Trial Balance is in balance before moving to the other journals. If it is not in balance, fix it before moving on.

8. Copy the Live Trial Balance and create a Fixed Trial Balance using Special Paste Values into your worksheet.

9. Do the adjustments into and complete the worksheet
- Note well: the worksheet is a separate document. No linking is permitted from the worksheet to any of the financial statements. It is used as a checking mechanism that ensures your financial statements prepared in step 13 match the worksheet.

10. Journalise the adjustments in the General Journal and post to the General Ledgers. Check that the Live Trial Balance is in Balance  before moving to the next transaction. If it is not in balance, fix it before moving on.

11. After all adjustments have been posted the Live trial Balance should be the same as the adjusted trial balance of the worksheet.

12. Copy the Live Trial Balance worksheet and create a Fixed Trial Balance worksheet using Special Paste Values into the worksheet.

13. Use the Fixed Trial balance to help you complete a Profit & Loss statement, Statement of Partners Equity and a Balance Sheet for month of trading.

Stage 2

Write a brief report to Julie and Katy commenting on the financial performance of the business:

Calculate the following financial ratios and provide comments -
o Current ratio
- Industry average is 5:1
- Accounting Norm is 3:1
o Quick ratio
- Industry average is 4 : 1
- Accounting Norm is 1:1

Calculate and provide a cash flow statement for the first month of trading.

Using academic references (recorded using Harvard Referencing style) list and briefly explain the registrations and legal requirements that Julie and Katy would have undertaken to establish the business name and partnership.

As at the 1st June, Julie Jones and Katy Perry establish a new businessJK Café &Catering (a partnership with 50% equal share in profits to both regardless of Proprietor's Contribution). They register the new business and open a new bank account with the local branch of Eastside Bank. Note the business is also registered for GST.

Adjustments

1. Half of the General Café supplies have been used calculate and record the expense

2. Calculate the outstanding payroll liability

3. Calculate and record the insurance expense

4. Calculate and record the Telephone expense

5. Calculate and record the prepaid rent

6. Calculate and record the depreciation expense for the month

7. A stocktake of the products revealed that there were:
• 6 Highland
• 7 Lowland
• 16 Tea

Attachment:- Requirements.rar

Verified Expert

The paper talks about accounting aspects. Coffee stores accounting for the month has been prepared in this paper. Journal ledger trail balance income statement balance sheet various other register have been prepared herewith.

Reference no: EM131377743

Questions Cloud

Estimate the viscosity of this oil in micro reyns at 180°f : The specific gravity of an oil at 60°F is 0.887. The oil has a viscosity of 65 SUS at 210°F and a viscosity of 550 SUS at 100°F. Estimate the viscosity of this oil in micro reyns at 180°F.
Identify volcanoes or cluster of volcanoes that are hot spot : Identify two volcanic ranges that are on a subduction zone (other than the Cascades). Identify two volcanoes or clusters of volcanoes that are hot spots.
Review the information on pendleton act of 1883 : From the weekly readings, review the types of budgets presented, and respond to the following scenario: A friend who is a city manager once commented that he liked to put a so-called "radio" item within each budget-an item that would make a lot o..
Explain why erp systems include crm and scm components : Be sure to also explain why ERP systems include CRM and SCM components, and the advantages the company can gain by implementing all of the components for a connected corporation.
Write a brief report to julie and katy : ACC506 - Write a brief report to Julie and Katy commenting on the financial performance of the business and calculate and provide a cash flow statement for the first month of trading.
Define a way that you can revamp or reinvent your business : Netflix's business is video rental, but it used technology to revamp its supply chain to completely disrupt the entire video rental industry.- Define a way that you can revamp or reinvent your business using supply chain technologies.
Give the answer of muliple choice question : Alejandro Martinez is responsible for setting up the pay structure for his company. He believes that newly hired employees should not be paid as much as established employees. Accordingly, what type of pay structure should Mr. Martinez use?
Strategies you recommend to help business continue working : What strategies do you recommend to help the business continue working while the supply chain is disrupted by the strike?
How could customers hurt or help your business : How could customers hurt or help your business? Will your employees agree that customers are the most important part of the business?

Reviews

inf1377743

2/6/2017 3:36:56 AM

I simply needed to accept the open door to thank you at the end of the day for you diligent work on the paper. Additionally, thank you for noting my inquiries. I needed to ensure that I didn't miss a concealed social evaluate or some likeness thereof in the assignment, which the inquiry suggested. Thanks.

inf1377743

2/6/2017 3:35:51 AM

Writing Guide and requirement 20856365_1Full WRITING GUIDE.pdf 20856359_1Abbr WRITING GUIDE.pdf 20856356_1Quality Checklist.docx Please understand that I've depended on you for my Term assignments, I have already asked for extension to our decided deadline of yesterday midnight. Rodger Mk 2 Samsang Riccardo Mk 3 See >> SL Invent << Tab.. Pink colour tab 30-Jun Item Number Item On Hand $ 101501 Rodger Mk 2 101502 Samsang 101503 Riccardo Mk 3 Total 0.00 G/Led 1030 Out of balance -

inf1377743

2/6/2017 3:33:07 AM

? Katyprovided catering services for Sippy Animal Rescue on credit and invoiced them for $330.00 - invoice # JKCC0003. A new policy offering discounts for early payment has been implemented – 2/7, n/30.(Don’t forger Subsidiary ledgers) ? The café has revenue from daily sales of $4,400.00 Julie and Katy bank $2,400.00 and keep $1000.00 each as drawings. ? Paid half of the amount owing to Coco Suppliers using Cheque # 0006 ? Employed new staff (Herbert Smith & Vera Smith) to be paid later in the month. Mon Tue Wed Thu Fri Sat Sun 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 SECOND WEEK Julie and Katy recognise that there is a market for the sales of gourmetcoffee productsand coffee machines through their café. They have been advised to split the gourmet products into three categories and use a periodic inventory system on a First in First out (FIFO) basis. The coffee machines will use a perpetual inventory system on a weighted average basis.

inf1377743

2/6/2017 3:32:33 AM

Julie phoned Your Insurance Ltd and arranged for insurance of the new business and paid for oneyear’s coverage drew a cheque # 0004 amount $1,372.80. Purchased general supplies of $110.00 on credit from Coco Supplierswho offer no discounts for early payment. (Don’t forget subsidiary ledger) • Tuesday 2nd June ? Katy drew a cheque # 0005 and paid (Use your own name) $440.00 rent for the first week. ? Katyprovided catering services for Monty’s Cars on credit and invoiced them for $880.00 - invoice # JKCC0001. A new policy offering discounts for early payment has been implemented – 2/7, n/30.(Don’t forger Subsidiary ledgers) • Wednesday 3rd June ? Katyprovided catering services for Sunshine Hospital on credit and invoiced them for $770.00 - invoice # JKCC0002. A new policy offering discounts for early payment has been implemented – 2/7, n/30.(Don’t forger Subsidiary ledgers)

inf1377743

2/6/2017 3:30:03 AM

FIRST WEEK • Monday 1sth June ? Julie deposits cash of $15,000 into the new Bank Account and Katy contributes $2,000 cash and: • Café equipment with a book value of $7,200 • China glass silver and linen book value of $3,600 • Office Equipment book value of $2,200. Asset Method Expected Life Expected Salvage Café Equipment Straight Line 4 Years $0.00 China Glass silver Linen Straight Line 2 Years $0.00 Office Equipment Reducing Balance 3 Years $5.00 (Note as the equipment, china glass silver linen and office equipment have been used in a previous business there is no GST attributed to the contribution). Purchased $1,100 worth of General Café Supplies from Coco Suppliers – issued cheque # 0001. (Asset: 1010) Purchased a computer for $440 – issued cheque #0002. (Office Equipment) Withdrew $50.00 cash from an ATM to establish a petty cash account. (No GST for this transaction) Katy has the telephone installed by Rossini Communications - the contract is for a monthly line rental of $44.00 plus charges for calls made. Cheque # 0003for $132.00 is issued.

inf1377743

2/6/2017 3:29:27 AM

This assignment must be your own individual work, i.e. it is not a group assignment. If it is believed that a student has copied material from another student or any other source without appropriate referencing, the necessary action will be taken under the University’s Student Academic Integrity - Governing Policy: (http://www.usc.edu.au/explore/policies-and-procedures/student-academic-integritygoverning-policy). Please contact your local campus lecturer/tutor if you have any queries. Alternatively, you can post your query to the Discussion Board on the course Blackboard site. Mon Tue Wed Thu Fri Sat Sun 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Note Well: You are to record the transactions from week 1 that you did in Task 2 Part Aplus the rest of the month of Juneusing special journals and running balance accounts instead of the General Journal and “T” account format you used in Part A. The month of June is shown in the calendar above. When you are using the special journals you do not use the General Journal as well! Just the special Journals.

Write a Review

Accounting Basics Questions & Answers

  Manilow corporation operates in an industry that has a high

manilow corporation operates in an industry that has a high rate of bad debts. before any year-end adjustments the

  Net income of 48220 was reported and dividends of 24170

the comparative balance sheets of constantine cavamanlis inc. at the beginning and the end of the year 2014 are as

  Discuss the effect that this event will have on the company

Data Technologies provides maintenance service for computers and office equipment for companies throughout the Northeast.

  Amount relates to the factory

75% of this amount relates to the factory.

  The 20-year bonds mature on december 31 2017 and are

riley co. has outstanding 40 million face amount of 15 bonds that were issued on january 1 1998 for 39000000. the

  Describe the importance of process mapping in a supply

1.describe how you would identify bottlenecks in your value stream? how would you ensure sustained flow through those

  Medical and nursing staff affected the delivery of care

How has the evolution of medical technology, graduate medical education, and the professionalization of medical and nursing staff affected the delivery of care

  Cindy justus is the managing director of the wichita day

cindy justus is the managing director of the wichita day care center. wichita is currently set up as a full-time child

  Better banjos is a small manufacturing company located in

better banjos is a small manufacturing company located in southern arkansas. they specialize in producing high quality

  Journalize the treasury stock transactions

During 1st year of operations Klump Corporation had the following transactions pertaining to its common stock.

  What was the beginning cash balance

In 2006 Bombay Corporation had cash receipts of $14,000 and cash disbursements of $8,000. Their ending cash balance at December 31, 2006 was $22,000. What was their beginning cash balance?

  Wet and wild water company drills small commercial oil

wet and wild water company drills small commercial oil wells. the company is in the process of analyzing the purchase

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