Need all the chats with proper account numbers. GST is inclusive. any issues call me on 0470294267
MBS544 ACCOUNTING PROCESSES SEMESTER 1, 2020 ASSIGNMENT Instructions: You are required to complete this assignment which is worth 20 marksin groups of 3 students. The assignment is to be submitted via the submission portal set up on LMS under session 10. Each assignment will be carefully marked by the same person and students are advised to make sure they reference their written work appropriately to avoid any problems with plagiarism or collusion. It is important that students do this assignment themselves and do not copy from other students. If you are unsure about any aspects of this assignment, please email your tutor for assistance. Only one submission is required for each group but individuals are advised to do the assignment themselves so they understand the process which will be examined at the end of the course. It is each group’s responsibility to ensure that the final report is neatly presented, marks will be deducted for poor presentation. You are expected to use references where appropriate to support your analysis. Students are encouraged to work in groups and to maintain contact via email or social media. Groups are not expected or required to meet in person. Any students who are adversely affected by this requirement are advised to contact the Unit Coordinator. External students can choose to do the assignment with another external student or they can complete the assignment on their own. External students are required to submit their assignment through the assignment portal set up on LMS. Business Background Zennith’s Musical Instruments Pty Ltd has been in business in Peth since July 2013. The Company was started by David Zennith and operates a shop which sells musical instruments on a wholesale basis to other businesses on credit and cash terms. The Company’s share capital consists of 1,134,000 ordinary shares, issued at $1 each, that are owned by various members of the Zennith family. The company enjoys a combination of staff to operate the business. The company has a financial year end of 30 June and prepares adjusting entries at the end of the financial year. The business is registered with the ATO for the goods and services tax (GST), and its Australian Business Number (ABN) is 78 303 238978. It reports and pays amounts owing for GST quarterly via the business activity statement (BAS). The business has elected to use the accrual basis of accounting for both accounting and GST purposes. Accounting policies BAD AND DOUBTFUL DEBTS The business uses the direct write-off method when accounting for bad bets as they only occur infrequently. INVENTORY The business maintains a periodic inventory system. PREPAYMENTS Expenses paid in advance for their use, such as insurance, are initially recorded as assets. Any used portion at the end of period is entered into the journal as an expense. PROPERTY, PLANT AND EQIUPMENT The business has adopted the ATO rates of depreciation for all depreciated assets. These rates are based on the ATO’s estimate of useful life. The straight-line method is used for the calculation of depreciation on these assets. Amounts calculated are rounded to the nearest dollar. ACCOUNTING RECORDS To ensure efficiency of its accounting procedures, the company uses the following special journals to maintain its accounting records. · General journal (GJ): to record all transactions that cannot be recorded in the special journals ( NOTE: All purchase and sales returns are recorded in the general journal ) · Sales journal (SJ): to record all sales of goods or services on credit, and GST collected · Purchases journal (PJ): to record all credit purchases of goods for resale, and GST paid · Cash receipts journal (CRJ): to record all receipts of cash, including cash sales of goods or services. · Cash payments journal (CPJ): to record all payments made on the business’s cheque account, including cash purchases of goods for resale. · Accounts receivable and accounts payable subsidiary ledgers; separate accounts are maintained for each customer and each supplier · General ledger: separate accounts are maintained for income, expense, asset, liability and equity accounts. ACCOUNTING PROCEDURES On a daily basis, all relevant source documents are collected and transactions recorded in the appropriate journals. Transactions recorded in the ‘other accounts’ columns and all entries relating to accounts or inventory items in the subsidiary ledgers are posted daily. On a monthly basis, special journals are totalled and posted after the bank statement has been received and any missing items have been recorded. A worksheet is then prepared from the general ledger and a monthly income statement and balance sheet are produced, together with schedules of accounts receivable and accounts payable. At the endof the year, adjusting and closing general journal entries are prepared and posted to the general ledger accounts. The chart of accounts includes the following accounts: 151Accumulated depreciation – Showroom Fittings, 201Interest Payable, 202Utilities Payable, 203Wages Payable, 204Salaries Payable, 205 Income Tax Payable, 206 Dividends Payable, 302 Dividends Declared, 303 Profit or Loss Summary, 602 Depreciation Expense – Showroom Fittings, 603 Depreciation Expense – Equipment, 604 Supplies Expense, 605 Rent Expense, 606 Insurance Expense, 608 Interest Expense, 610 Income Tax Expense, 614 Bad Debts Expense. An Unadjusted Trial Balance and Chart of Accounts at 31 May 2019 has the following account balances. All accounts have normal debit and credit balances. UNADJUSTED TRIAL BALANCE as at 31 May 2019 NO ACCOUNT NAME Debit ($) Credit ($) 100 Cash at Bank 570,017.7 101 Accounts Receivable Control 261,954 102 Store Supplies 151,011 103 Inventory 781,200 104 Prepaid Store Rent (paid 1 March 2019) 739,620 105 Prepaid Insurance (paid 1 Nov 2018) 11,340 110 GST Paid 436,747.5 150 Showroom Fittings 510,300 160 Equipment 173,250 161 Accumulated Depreciation - Equipment 85,050 200 Accounts Payable Control 168,953.4 211 GST Collected 400,591.8 250 Mortgage Loan (due 31 July 2043) 606,942 300 Share Capital 1,134,000 NO ACCOUNT NAME Debit ($) Credit ($) 301 Retained Profits 963,522 400 Sales Revenue 4,045,734 402 Sales Returns 8,757 405 Discount Received 24,192 500 Purchases 1,926,855 502 Purchase Returns 10,143 600 Freight-Out 2,898 601 Wages Expense – Sales Staff 968,121 607 Advertising Expense 43,848 609 Utilities Expense 58,464 611 Sundry Expenses 3,024 612 Salaries Expense – Office Staff 760,662 613 Discount Allowed 31,059 7,439,128.2 7,439,128.2 Schedule of Accounts Receivable as at 31 May 2019 Note: Zennith’s Musical Instruments offers all customers Credit Terms 2/10, n/30 unless otherwise stated. Acc No. Account Invoice date Amount ($) 101-1 Bach Cellos 27 May 104,781.60 101-2 Mozart Guitars 16 May 52,945.20 101-3 Brahms Pianos 23 April 71,656.20 101-4 Beethoven Trumpets 11 May 32,571 261,954 Schedule of Accounts Payable as at 31 May 2019 Acc No. Account Invoice date Terms Amount ($) 200-1 Strauss Synthesisers 29 May 2/10, n/60 47,817 200-2 Vivaldi Violins 22 May 1/10, n/45 121,136.40 168,953.40 The following transactions occurred during June 2019and are inclusive of GST where relevant Week 1 1– Bach Cellos paid the entire balance of its account that was still outstanding. – Delivered goods to Mozart Guitars for $75,121.20 and issued invoice #910. Issued Cheque #153 to pay $8,316 for delivery costs of inventory to their premises. 3 – Paid the amount owing to Strauss Synthesisers. Cheque #154 was sent. 4 – Total cash sales for the week were $21,205.80. Week 2 8 – Brahms Pianos paid $30,076.20 toward the amount it owes us. 9 – Made a purchase from Vivaldi Violins for $64,449 for boutique lighting. The date of invoice was 8 June. Invoice No. VV08. 9 – The firm issued Cheque #155 for the purchase of store supplies amounting to $6,098.40. 10 – Bach Cellos purchased inventory of $75,675.60. Invoice #911 was issued. 11 – Some of the boutique light fittings purchased on 7 June from Vivaldi Violins were the wrong design. Returned inventory in exchange for a Credit Note of $20,790. 12 – Total cash sales for the week were $28,967.40. Week 3 15 – Purchased inventory from Strauss Synthesisers for $106,029. The invoice was dated 14 June. Invoice No. SS14. 15 - Paid office staff salaries of $73,458. Cheque #157 was issued for payment. Cheque #158 was issued to pay sales staff wages, $62,370. 16 – Sold inventory to Brahms Pianos for $136,798.20 on invoice #912. Issued Cheque #156 to pay for delivery costs of $10,395. 16 –18 – The company issued Cheque #159 to pay the amount still owing to Vivaldi Violins. 19 – Total cash sales for the week were $27,512.10. Week 4 22 – Brahms Pianos returned $25,918.20 of inventory purchased on 14 June. Issued a Credit Note for the transaction. 23 – Issued Cheque #160 $12,600 to pay for the annual gift the Company donates to the Smith Foundation Charity Fund. The gift is to be recorded as a sundry expense in the accounts. 24 – Purchased inventory from Vivaldi Violins worth $103,257. The date of the invoice was 22 June. Invoice No. VV09. 25 – Received the total amount owing from Brahms Pianos. 26 – Total cash sales for the week were $43,243.20. Week 5 28 – Mozart Guitars paid the entire balance of its still outstanding account. 29 – Reduced $83,160 of the amount owing to Vivaldi Violins and Cheque #161 was issued. 29 – A dividend of $177,100 was declared to the Company shareholders. However, the dividend will not be paid until September 30, 2019. Paid sales staff wages, $62,370 and Cheque #162 was issued to meet the payment. 30 – Issued additional shares to the owners of the Company for cash, and $126,000 was received and banked. Total cash sales for the week were $25,779.60. INSTRUCTIONS · You are required to create your own accounting records to record this information. You can use Word or Excel. If you have any doubts about how to set up any accounting records, please refer to your textbook. Chapter 6 of your textbook is relevant for special journals and control accounts. Please ensure that your final submission is in a suitable format for printing. List general ledger accounts underneath each other rather than across the page so that if your assignment needs to be printed for marking, it does not have to be reformatted. You may be penalised if your assignment has to be reformatted for printing. · Record the