answer should be in this boxes:
4 Assessment Task Manual Accounting Electric-bike Store ances Mailings Review View Table Design Layout Tell me A 21 T AaBbCaddi ABC AaBbCodi AaBbccbd AaBbceDd No Spacing Heading 1 A 1 a Normal Chart of accounts You can find your chart of accounts in the excel document in the CANVAS shell Electric-Bike store Pty Ltd Trial Balance as at 31st January 2020 Credit Debit 27,513.00 12,830.00 23,840.00 1,650.00 245.00 4,500.00 300.00 Account Number 1001 1010 1020 1030 1035 1040 1110 1111 1120 1121 2001 2010 2011 2020 2021 2035 3001 3010 3050 Account name Cash at Bank Accounts Receivable Inventory Prepaid Rent Prepaid Insurance Stationery Supplies Computers Accumulated Depreciation - Office Computers Warehouse Equipment Accumulated Depreciation - Warehouse Equipment Accounts Payable Wages Payable PAYG payable Cleaning Payable Utilities Payable Prepaid Revenue Share Capital Retained Earnings Dividends 25,000.00 15,200.00 20,640.00 2,230.00 45,000.00 12,208.00 95,578.00 95,578.00 Focus MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store Review View Table Design Layout Tell me References Mailings AL AalbCandi AalbCandi AaBbceDd AaRbCcDd homme No Spacing Heading 1 A de Headings Transactions: February 2020 Date Description 3 Paid rent to Land Lord Pty Ltd for the next 2(two) months - $4,000 Pald Cash for vehicle expenses- $420 to Toyota Ltd 6 Received payment from Collingwood Cycles Pty Ltd for January account. 7 Received and paid electricity bill from Citipower for January $395 9 Paid E-Bikes Pty Ltd. for January account. 11 Paid Merida Electric Cycles Ltd. for January account. 11 Received payment from E-volution Cycles Pty Ltd for January account. 11 Pay day. Sarah was paid for 69 hours and Zlatko was paid for 68 hours, which includes wages owing from January Sales Invoice sent to Lawerencia Bikes for the following items: 8x CSB, 6 X TEB Lawerencia Bikes returned 1 TEB, due to an order mistake, the goods were returned to inventory. 14 Cash sales to Collingwood Cycles Ply Ltd Pty Ltd Inventory sold: 6 x CSB and 8 x TEB 17 Paid Optus invoice for Telephone Expenses $480 24 Purchased more inventory 14 x CSB, 12 x TEB, on credit 26 Returned 3 CSB to E-Bikes Pty Ltd due to the inventory being damaged 25 Pay day. Sarah was paid for 62 hours and Zlatko was paid for 64 hours. 25 The Lawerencia Bike Pty Ltd paid for items purchased on 12 February 28 Borrowed money from the DEF bank, $15,000 at an interest rate of 7% 12 13 Adjustments at 29th February 2020 1. Depreciation of computer equipment is $1,800 per annum. 2. Depreciation of Warehouse equipment is $2,100 per annum. 3. Accrued wages: Sarah - 26 hour and Zlatko 26 hours. 4. Stationery on hand at 29 February 2020 totalled $ 205. 5. The portion of prepaid insurance expired as of 29 February 2020 is $150. MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store Terences Mailings Review View Table Design Layout Tell me AaBbced Aa Bbccdi A -A- AaBb Cadil AabbCodi AalbCeDd Normal No Spacing Heading 2 Heading Part A: Manual Recording (25%) IMPORTANT: Part A Manual Recording To record transactions manually, you must use the Excel files provided on the unit Canvas. Handwritten work or Excel files other than the Excel files provided on the unit Canvas are not eligible for submission Required: 1. Record the opening balances as at 14 February 2020 in the appropriate general ledger accounts 2. Record February month's transactions in the general journal and post these to the general ledger. 3. Record end of month adjustments in the general journal and post these to the general ledger. 4. Prepare a Trial Balance after end of month adjustments as at 29" February 2020 Important Information 1. To record transactions manually, you must use the Excel files provided on the unit Canvas. Handwritten work or Excel files other than the Excel files provided on the unit Canvas are not eligible for submission. 2. The assignment must be accompanied with an assignment cover sheet listing your full name and student identification number. 3. It is the student's responsibility to keep a backup copy of the assignment until all the assignment process is completed and marks are on Canvas. 4. Any assignments handed in late will be penalised as explained in the course guide. Focus MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store Review View Table Design Layout Tell me erences Mailings ABDde A v T AaBbCodi ABCcDd! AaBbCcDd AaBbCcDd Nora No Spacing Heading 2 The DUE DATE for this assignment is 3 April 2020 at 5.30pm Headings P Case Study Background Electric-Bike Store Pty Ltd (ABN 12 345 678 901) operates as a company and you are the accountant for them. Electric Bike Store Pty Ltd is a wholesale business specialising in electronic equipment made in Australia. The business is in its first month of the new year which started on 1 February 2020. Business Background The business was established by Maurice Moneybags from his garage and has now expended to a small warehouse and two part time employees. Maurice believes that with careful management that the business could expand to have a regular workforce within a few months and is looking to expand the operation soon. The products that are sold are exclusively available to Electric-Bike Store Pty Ltd, so the aim is to expand the reputation of the products on offer. Another aim is to have an online business specialising in cycling products within 2 years Page 1 of 6 Employees Electric-Bikes Store Pty Ltd employs two casual assistants. Sarah Shinysox works as a sales person, and Zlatko Logistix works in the warehouse filling orders. Each employee works MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store Layout Tell me References Mailings Review View Table Design ..A Aalb Codi AalbCodi Aalbceod AaBbceod Name Ne face Heating Heading AaRCEDE Heading Employees Electric-Bikes Store Pty Ltd employs two casual assistants. Sarah Shinysox works as a sales person, and Zlatko Logistix works in the warehouse filling orders. Each employee works between 30 to 40 hours per week, depending on the demand and the timing of the shipments of inventory Payday is every second Thursday. The following information is used to calculate their wages: Name Role Tax file number Gross pay- Per hour ($) 32 Sarah Shinysox Sales Person 123 456 789 Zlatko Logistix Warehouse assistant 30 234 567 890 At the 31 January the business owed the employees 35 hours to Sarah and 37 hours to Tony. Goods and Services Tax (GST) There is no GST applied in this part of the assignment. All transactions should be recorded without of GST Merchandise Inventory The following is a list of closing inventory and the suppliers as at January 31" Quantity Item Description Cost Sale Supplier on hand Code Price Price 16 CSB City speed E-bike $800 $1,350 E-Bikes Pty Ltd 12 TEB Two seat E-Bike $920 $1,520 Merida Electric Cycles MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store References Mailings Review View Table Design Layout Tell me 8 !!! D-A- AaBb Cedi Abadi AaBbced AaBbcend Normal No Spacing Heading a Aabende Heading 3 St P Description Quantity Item on hand Code CSB 16 City speed E-bike Cost Sale Supplier Price Price $800 $1,350 E-Bikes Pty Ltd $920 $1,520 Merida Electric Cycles 12 TEB Two seat E-Bike Pty Ltd The required inventory is purchased mostly on credit under the terms of payment required by the suppliers. The business has a good relationship with each of the suppliers once the company places an order, the suppliers will deliver them free of charge the same day. Due to the good relationship the suppliers have offered discount terms, indicated below; Page 2 of 6 Suppliers account balances as at 31 January 2020: Name Address ABN Terms Account Date of of Balance Purchase Credit 2/15 $9,600 24 January net 30 E-Bikes Ply Ltd 21 Macquarie St Melbourne 3000 45 667 778 638 Merida Electric 56 778 880 999 35 Lorimer si South Melbume 2/15 net 30 $11,040 15 January MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store References Mailings Review View Table Design Layout Tell me Aav po 2. D-A- AaBCeDdl AaBbceDdl ABCcDd AaBbccd harma No Spacing Heading 1 Heading 2 Aa Bbcode Heading Suppliers account balances as at 31 January 2020: Name Address ABN Account Balance Date of Purchase Terms of Credit 2/15 net 30 E-Bikes Pty Ltd 21 Macquarie St Melboume 3000 45 667 778 888 $9,600 24 January 56 778 889 999 Merida Electric Cycles Pty Ltd $11,040 15 January 35 Lorimer St South Melbourne 3205 2/15 net 30 Customer information: Electric-Bike Store Pty Ltd sells most of its inventory strictly on a cash basis, but the business has three credit customers. The valued customers have been offered discount terms and these terms of payment are listed below. The outstanding account balance and the date of their purchase is also indicated in the account information Name Address ABN 60 50430 201 Collingwood Cycles Pty Ltd E-volution Cycles Pty Ltd Lawerencia E- Bikes Ply Ltd 50 999 555 886 Terms Date of Account of Invoice Balance Credit 1/15 net 26 $91060 30 January 1/15 net 19 $2,870 30 January Net 30 $0 450 Bourke SE Melbourne 3000 300 Smith street Collingwood 3068 296 Riverdale road Camberwelt 3021 89 911 222 333 MacBook Air Autosave OB-u. Assessment Task Manual Recording - TEMPLATE-2 Home fox Insert Draw Page Layout Formulas Data Review View Tell me ? -A Deine Name Auto-sum Recently Financial Logical Date & Leksp & Math & Used Time Reference Create from Selection Thig Functions x fx Insert Punction Trace Precedents Trace Dependents Show FRemove Arrow Formula More 9 B C D E F C 1 Enter name of business here GENERAL JOURNAL 2 3 4 Transactions for February 2020 Date Account Name Post reference Debit Credit 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Chart of accounts General Journal General Ledger Trial Balance Read MacBook Air Assessment Task Manual Recording - TEMPLATE-2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share IA Da Nare To Cat Now hiert Farvet Auto- Recently wancial Lagical Used Date Loop MS More Time Reference Trig Runcing Crestro Selection Dependent Coulson Option Ceowate She B7 xf HERBS . GENERAL LEDGER ACCOUNTS Assets GENERAL LEDGER ACCOUNTS labies GENERAL LEDGER ACCOUNTS Cash at bank De Description Det 100 Balance Accounts Payable Date Description De 2001 Balance SH 4201 Crede Sul be Description 11 Date Despion Debit Wages Payable Date Destion 2010 De Credit SRICH 07 Disc Date Desert Od Geane Payable Base Description De Cred 23 31 3D Balas DOR is Accounts Receive Cost of Sales Date Decoration 1000 Electricity Puyable Description 2021 Debt Det Credit 20 Telecommunication Date De Debu Credit Balence Dute Din 1 2002 Urimalarati Date 1000 Dr Credit wery Date Despre CE Dane De Prepaid 2005 Sanct D General Journal Chao General Ledger + Trial Balance Home Insert Draw Page Layout Formulas Data Review View Tell me here @ 9 Den an Trace Precedente Trace Dependents I C Inse Function Test De Lookup Maths Reference Trig More Function Cretrom Show Error-checking Au Recedy Financial Logist Used X Calculation Case Shar B7 41 Prepaid Rent Date Description Debit Credit 10.30 Balance 2201 50 Loan ABC Bank Dute Description Det su Date Desert Det GE SL Prepaid in - Date Description 54 Debit Credit Balance / Share Capital Date Description Debit Credit Date Description G Balance 3040 se Stationary supplies Date Description Debit Rates Date Desc SLO D Credit Ba Date De De Computer 4 Date Description 1110 Balance De Credit Dividende De Description 1050 Balne 5140 pa Duter 1511 A Compet Accum bep Date Description be Credit Data 1130 Orice 1 bat G De Balance Description De Deo Officement Accor Dep Destro De Cred Dute Des be base Det - Dute Dertion Trance General Ledger Gener Journal Chart of accounts Assessment Task Manual Recording - TEMPLATE-2 Home Insert Draw Page Layout Formulas Data Review View Tell me x A. w Datum ve Trece Precedents Trace ends Auto-sum Recently Financial Legal Used Date Lup Muh This More Punctions Chat B7 ex fx A M . TE DE Oude Dicement Acum Dep Date Description Balance Dute De ELLE Date Description Debit Date De D 10 9 w York Acum Dep Date Description D Dane Description Balance 1140 Warehouse pent as Date Description Cute Beson De 3 100 Dane De 1141 Warehouse Actu Dep Date Description C Cr De Mor Vehicles Dane Description 1:11 Ban 1141 s Motor Vehicles De 114 Date Description Cr IL General Ledger General Journal Chart of accounts Insert Draw Page Layout Home Formulas Data Review View Tell me BRE De 0 ? A e Text Insert Function Date & Lookup & Maths & Time Reference Trig More Functions Cr Auto-sum Recently Financial Logical Used x x AS2 D Credit 1 Enter the business name here 2 Trial Balance as at 28th February 2020 Account 3 Nurnber Account name Debit 4 1001 Cash at Bank 5 1010 Accounts Receivable 6 1020 Inventory 7 1030 Prepaid Rent 8 1035 Prepaid Insurance 9 1040 Stationery Supplies 10 1110 Computers 11 1111 Accumulated Depreciation - Office Computers 12 1140 Warehouse Equipment 13 1141 Accumulated Depreciation - Warehouse Equip. 14 2001 Accounts Payable 15 2010 Wages Payable 16 2011 PAYG payable 17 2020 Cleaning Payable 18 2025 Prepaid Revenue 19 2201 Loan - Best Bank 20 3001 Share Capital 21 3010 Retained Earnings 22 4001 Sales 23 4002 Sales returns and allowances 24 4010 Discount Received 25 5001 Cost of Goods Sold 26 5010 Discount Allowed 27 5020 Transportation costs 28 5100 Wages Expense 29 5110 Rent Expense 30 5120 Telecommunication Expense 31 5130 Electricity expense 32 5140 Insurance Expense 33 5150 Advertising Expense 5160 Vehicle Expense 5170 Cleaning Expense Chart of accounts General Journal General Ledger + Trial Balance Ready AutoSave Home Insert Draw Page Layout Formulas View Tell me Data Review fo ? Define Name A le Text Insert Function Create from Auto-sum Recently Financial Logical Used More Functions Date & Lookup & Maths & Time Reference Trig G22 4 x B D E 1 2 CHART OF ACCOUNTS ENTER BUSINESS NAME HERE Account Name Assets 3 4 Account 5 Number 6 1000 7 8 1001 9 1010 10 1020 11 1030 12 1035 13 1040 14 1100 15 16 1110 17 1111 18 19 1120 20 1121 21 1130 1131 Current Assets Cash at Bank Accounts Receivable Inventory Prepaid Rent Prepaid Insurance Stationery Supplies Non-Current Assets WDV Office Computers Computers Accumulated Depreciation - Office Computers WDV Office Equipment Office Equipment Accumulated Depreciation - Warehouse Equipment WDV Forklift Forklift Accumulated Depreciation - Forklift WDV Warehouse Equipment Warehouse Equipment Accumulated Depreciation - Warehouse Equipment WDV Motor Vehicles Motor vehicles Accumulated Depreciation - Motor Vehicles Current Liabilities Accounts Payable suppliers) Wages Payable Cleaning Payable Electricity Payable Telecommunications Payable Utilities Payable Prepaid Revenue Non-current Liabilities 23 24 25 26 27 28 29 1140 1141 1150 115) 31 2001 2010 2020 2021 33 35 2022 56 2023 2025 Chart of accounts General Journal General Ledger Trial Balance AutoSave Assessment Ta H 5 v 5 , Draw Home Insert Formulas Review View Page Layout Data Tell me v Define Name fox llo ? A Auto-sum Recently Financial Logical Text Usad Insert Function Data & Lookup & Maths & Time Reference E Create from More Functions Trig G22 X fx A B D F E 30 31 32 33 34 35 36 37 2001 2010 2020 2021 2022 2023 2025 Current Llabilities Accounts Payable (suppliers) Wages Payable Cleaning Payable Electricity Payable Telecommunications Payable Utilities Payable Prepaid Revenue Non-current Liabilities Bank Loan 38 2201 39 40 Shareholder's funds 41 42 43 3000 3001 3010 Share Capital Retained Earnings Dividends 3050 44 45 45 Income Sales Sales returns and allowances Discount Received Gain on the sale of assets Expenses 50 51 52 53 54 55 56 4000 4001 4002 4010 4100 5000 5001 5010 5020 5100 5110 5120 5130 5140 5150 5160 5170 5180 5190 5200 5250 5300 57 58 59 Cost of Goods Sold Discount Allowed Transportation costs Wages & Salaries Expense Rent Expense Telecommunication Expense Electricity expense Insurance Expense Advertising Expense Vehicle Expense Cleaning Expense Stationery Expense Utilities Expense Depreciation Expense Loss on the sale of assets Interest Expense 60 61 63 54 65 66 57 Chart of accounts General Journal General Ledger Trial Balance + 4 Assessment Task Manual Accounting Electric-bike Store ances Mailings Review View Table Design Layout Tell me A 21 T AaBbCaddi ABC AaBbCodi AaBbccbd AaBbceDd No Spacing Heading 1 A 1 a Normal Chart of accounts You can find your chart of accounts in the excel document in the CANVAS shell Electric-Bike store Pty Ltd Trial Balance as at 31st January 2020 Credit Debit 27,513.00 12,830.00 23,840.00 1,650.00 245.00 4,500.00 300.00 Account Number 1001 1010 1020 1030 1035 1040 1110 1111 1120 1121 2001 2010 2011 2020 2021 2035 3001 3010 3050 Account name Cash at Bank Accounts Receivable Inventory Prepaid Rent Prepaid Insurance Stationery Supplies Computers Accumulated Depreciation - Office Computers Warehouse Equipment Accumulated Depreciation - Warehouse Equipment Accounts Payable Wages Payable PAYG payable Cleaning Payable Utilities Payable Prepaid Revenue Share Capital Retained Earnings Dividends 25,000.00 15,200.00 20,640.00 2,230.00 45,000.00 12,208.00 95,578.00 95,578.00 Focus MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store Review View Table Design Layout Tell me References Mailings AL AalbCandi AalbCandi AaBbceDd AaRbCcDd homme No Spacing Heading 1 A de Headings Transactions: February 2020 Date Description 3 Paid rent to Land Lord Pty Ltd for the next 2(two) months - $4,000 Pald Cash for vehicle expenses- $420 to Toyota Ltd 6 Received payment from Collingwood Cycles Pty Ltd for January account. 7 Received and paid electricity bill from Citipower for January $395 9 Paid E-Bikes Pty Ltd. for January account. 11 Paid Merida Electric Cycles Ltd. for January account. 11 Received payment from E-volution Cycles Pty Ltd for January account. 11 Pay day. Sarah was paid for 69 hours and Zlatko was paid for 68 hours, which includes wages owing from January Sales Invoice sent to Lawerencia Bikes for the following items: 8x CSB, 6 X TEB Lawerencia Bikes returned 1 TEB, due to an order mistake, the goods were returned to inventory. 14 Cash sales to Collingwood Cycles Ply Ltd Pty Ltd Inventory sold: 6 x CSB and 8 x TEB 17 Paid Optus invoice for Telephone Expenses $480 24 Purchased more inventory 14 x CSB, 12 x TEB, on credit 26 Returned 3 CSB to E-Bikes Pty Ltd due to the inventory being damaged 25 Pay day. Sarah was paid for 62 hours and Zlatko was paid for 64 hours. 25 The Lawerencia Bike Pty Ltd paid for items purchased on 12 February 28 Borrowed money from the DEF bank, $15,000 at an interest rate of 7% 12 13 Adjustments at 29th February 2020 1. Depreciation of computer equipment is $1,800 per annum. 2. Depreciation of Warehouse equipment is $2,100 per annum. 3. Accrued wages: Sarah - 26 hour and Zlatko 26 hours. 4. Stationery on hand at 29 February 2020 totalled $ 205. 5. The portion of prepaid insurance expired as of 29 February 2020 is $150. MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store Terences Mailings Review View Table Design Layout Tell me AaBbced Aa Bbccdi A -A- AaBb Cadil AabbCodi AalbCeDd Normal No Spacing Heading 2 Heading Part A: Manual Recording (25%) IMPORTANT: Part A Manual Recording To record transactions manually, you must use the Excel files provided on the unit Canvas. Handwritten work or Excel files other than the Excel files provided on the unit Canvas are not eligible for submission Required: 1. Record the opening balances as at 14 February 2020 in the appropriate general ledger accounts 2. Record February month's transactions in the general journal and post these to the general ledger. 3. Record end of month adjustments in the general journal and post these to the general ledger. 4. Prepare a Trial Balance after end of month adjustments as at 29" February 2020 Important Information 1. To record transactions manually, you must use the Excel files provided on the unit Canvas. Handwritten work or Excel files other than the Excel files provided on the unit Canvas are not eligible for submission. 2. The assignment must be accompanied with an assignment cover sheet listing your full name and student identification number. 3. It is the student's responsibility to keep a backup copy of the assignment until all the assignment process is completed and marks are on Canvas. 4. Any assignments handed in late will be penalised as explained in the course guide. Focus MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store Review View Table Design Layout Tell me erences Mailings ABDde A v T AaBbCodi ABCcDd! AaBbCcDd AaBbCcDd Nora No Spacing Heading 2 The DUE DATE for this assignment is 3 April 2020 at 5.30pm Headings P Case Study Background Electric-Bike Store Pty Ltd (ABN 12 345 678 901) operates as a company and you are the accountant for them. Electric Bike Store Pty Ltd is a wholesale business specialising in electronic equipment made in Australia. The business is in its first month of the new year which started on 1 February 2020. Business Background The business was established by Maurice Moneybags from his garage and has now expended to a small warehouse and two part time employees. Maurice believes that with careful management that the business could expand to have a regular workforce within a few months and is looking to expand the operation soon. The products that are sold are exclusively available to Electric-Bike Store Pty Ltd, so the aim is to expand the reputation of the products on offer. Another aim is to have an online business specialising in cycling products within 2 years Page 1 of 6 Employees Electric-Bikes Store Pty Ltd employs two casual assistants. Sarah Shinysox works as a sales person, and Zlatko Logistix works in the warehouse filling orders. Each employee works MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store Layout Tell me References Mailings Review View Table Design ..A Aalb Codi AalbCodi Aalbceod AaBbceod Name Ne face Heating Heading AaRCEDE Heading Employees Electric-Bikes Store Pty Ltd employs two casual assistants. Sarah Shinysox works as a sales person, and Zlatko Logistix works in the warehouse filling orders. Each employee works between 30 to 40 hours per week, depending on the demand and the timing of the shipments of inventory Payday is every second Thursday. The following information is used to calculate their wages: Name Role Tax file number Gross pay- Per hour ($) 32 Sarah Shinysox Sales Person 123 456 789 Zlatko Logistix Warehouse assistant 30 234 567 890 At the 31 January the business owed the employees 35 hours to Sarah and 37 hours to Tony. Goods and Services Tax (GST) There is no GST applied in this part of the assignment. All transactions should be recorded without of GST Merchandise Inventory The following is a list of closing inventory and the suppliers as at January 31" Quantity Item Description Cost Sale Supplier on hand Code Price Price 16 CSB City speed E-bike $800 $1,350 E-Bikes Pty Ltd 12 TEB Two seat E-Bike $920 $1,520 Merida Electric Cycles MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store References Mailings Review View Table Design Layout Tell me 8 !!! D-A- AaBb Cedi Abadi AaBbced AaBbcend Normal No Spacing Heading a Aabende Heading 3 St P Description Quantity Item on hand Code CSB 16 City speed E-bike Cost Sale Supplier Price Price $800 $1,350 E-Bikes Pty Ltd $920 $1,520 Merida Electric Cycles 12 TEB Two seat E-Bike Pty Ltd The required inventory is purchased mostly on credit under the terms of payment required by the suppliers. The business has a good relationship with each of the suppliers once the company places an order, the suppliers will deliver them free of charge the same day. Due to the good relationship the suppliers have offered discount terms, indicated below; Page 2 of 6 Suppliers account balances as at 31 January 2020: Name Address ABN Terms Account Date of of Balance Purchase Credit 2/15 $9,600 24 January net 30 E-Bikes Ply Ltd 21 Macquarie St Melbourne 3000 45 667 778 638 Merida Electric 56 778 880 999 35 Lorimer si South Melbume 2/15 net 30 $11,040 15 January MacBook Air 4 Assessment Task Manual Accounting Electric-bike Store References Mailings Review View Table Design Layout Tell me Aav po 2. D-A- AaBCeDdl AaBbceDdl ABCcDd AaBbccd harma No Spacing Heading 1 Heading 2 Aa Bbcode Heading Suppliers account balances as at 31 January 2020: Name Address ABN Account Balance Date of Purchase Terms of Credit 2/15 net 30 E-Bikes Pty Ltd 21 Macquarie St Melboume 3000 45 667 778 888 $9,600 24 January 56 778 889 999 Merida Electric Cycles Pty Ltd $11,040 15 January 35 Lorimer St South Melbourne 3205 2/15 net 30 Customer information: Electric-Bike Store Pty Ltd sells most of its inventory strictly on a cash basis, but the business has three credit customers. The valued customers have been offered discount terms and these terms of payment are listed below. The outstanding account balance and the date of their purchase is also indicated in the account information Name Address ABN 60 50430 201 Collingwood Cycles Pty Ltd E-volution Cycles Pty Ltd Lawerencia E- Bikes Ply Ltd 50 999 555 886 Terms Date of Account of Invoice Balance Credit 1/15 net 26 $91060 30 January 1/15 net 19 $2,870 30 January Net 30 $0 450 Bourke SE Melbourne 3000 300 Smith street Collingwood 3068 296 Riverdale road Camberwelt 3021 89 911 222 333 MacBook Air Autosave OB-u. Assessment Task Manual Recording - TEMPLATE-2 Home fox Insert Draw Page Layout Formulas Data Review View Tell me ? -A Deine Name Auto-sum Recently Financial Logical Date & Leksp & Math & Used Time Reference Create from Selection Thig Functions x fx Insert Punction Trace Precedents Trace Dependents Show FRemove Arrow Formula More 9 B C D E F C 1 Enter name of business here GENERAL JOURNAL 2 3 4 Transactions for February 2020 Date Account Name Post reference Debit Credit 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Chart of accounts General Journal General Ledger Trial Balance Read MacBook Air Assessment Task Manual Recording - TEMPLATE-2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share IA Da Nare To Cat Now hiert Farvet Auto- Recently wancial Lagical Used Date Loop MS More Time Reference Trig Runcing Crestro Selection Dependent Coulson Option Ceowate She B7 xf HERBS . GENERAL LEDGER ACCOUNTS Assets GENERAL LEDGER ACCOUNTS labies GENERAL LEDGER ACCOUNTS Cash at bank De Description Det 100 Balance Accounts Payable Date Description De 2001 Balance SH 4201 Crede Sul be Description 11 Date Despion Debit Wages Payable Date Destion 2010 De Credit SRICH 07 Disc Date Desert Od Geane Payable Base Description De Cred 23 31 3D Balas DOR is Accounts Receive Cost of Sales Date Decoration 1000 Electricity Puyable Description 2021 Debt Det Credit 20 Telecommunication Date De Debu Credit Balence Dute Din 1 2002 Urimalarati Date 1000 Dr Credit wery Date Despre CE Dane De Prepaid 2005 Sanct D General Journal Chao General Ledger + Trial Balance Home Insert Draw Page Layout Formulas Data Review View Tell me here @ 9 Den an Trace Precedente Trace Dependents I C Inse Function Test De Lookup Maths Reference Trig More Function Cretrom Show Error-checking Au Recedy Financial Logist Used X Calculation Case Shar B7 41 Prepaid Rent Date Description Debit Credit 10.30 Balance 2201 50 Loan ABC Bank Dute Description Det su Date Desert Det GE SL Prepaid in - Date Description 54 Debit Credit Balance / Share Capital Date Description Debit Credit Date Description G Balance 3040 se Stationary supplies Date Description Debit Rates Date Desc SLO D Credit Ba Date De De Computer 4 Date Description 1110 Balance De Credit Dividende De Description 1050 Balne 5140 pa Duter 1511 A Compet Accum bep Date Description be Credit Data 1130 Orice 1 bat G De Balance Description De Deo Officement Accor Dep Destro De Cred Dute Des be base Det - Dute Dertion Trance General Ledger Gener Journal Chart of accounts Assessment Task Manual Recording - TEMPLATE-2 Home Insert Draw Page Layout Formulas Data Review View Tell me x A. w Datum ve Trece Precedents Trace ends Auto-sum Recently Financial Legal Used Date Lup Muh This More Punctions Chat B7 ex fx A M . TE DE Oude Dicement Acum Dep Date Description Balance Dute De ELLE Date Description Debit Date De D 10 9 w York Acum Dep Date Description D Dane Description Balance 1140 Warehouse pent as Date Description Cute Beson De 3 100 Dane De 1141 Warehouse Actu Dep Date Description C Cr De Mor Vehicles Dane Description 1:11 Ban 1141 s Motor Vehicles De 114 Date Description Cr IL General Ledger General Journal Chart of accounts Insert Draw Page Layout Home Formulas Data Review View Tell me BRE De 0 ? A e Text Insert Function Date & Lookup & Maths & Time Reference Trig More Functions Cr Auto-sum Recently Financial Logical Used x x AS2 D Credit 1 Enter the business name here 2 Trial Balance as at 28th February 2020 Account 3 Nurnber Account name Debit 4 1001 Cash at Bank 5 1010 Accounts Receivable 6 1020 Inventory 7 1030 Prepaid Rent 8 1035 Prepaid Insurance 9 1040 Stationery Supplies 10 1110 Computers 11 1111 Accumulated Depreciation - Office Computers 12 1140 Warehouse Equipment 13 1141 Accumulated Depreciation - Warehouse Equip. 14 2001 Accounts Payable 15 2010 Wages Payable 16 2011 PAYG payable 17 2020 Cleaning Payable 18 2025 Prepaid Revenue 19 2201 Loan - Best Bank 20 3001 Share Capital 21 3010 Retained Earnings 22 4001 Sales 23 4002 Sales returns and allowances 24 4010 Discount Received 25 5001 Cost of Goods Sold 26 5010 Discount Allowed 27 5020 Transportation costs 28 5100 Wages Expense 29 5110 Rent Expense 30 5120 Telecommunication Expense 31 5130 Electricity expense 32 5140 Insurance Expense 33 5150 Advertising Expense 5160 Vehicle Expense 5170 Cleaning Expense Chart of accounts General Journal General Ledger + Trial Balance Ready AutoSave Home Insert Draw Page Layout Formulas View Tell me Data Review fo ? Define Name A le Text Insert Function Create from Auto-sum Recently Financial Logical Used More Functions Date & Lookup & Maths & Time Reference Trig G22 4 x B D E 1 2 CHART OF ACCOUNTS ENTER BUSINESS NAME HERE Account Name Assets 3 4 Account 5 Number 6 1000 7 8 1001 9 1010 10 1020 11 1030 12 1035 13 1040 14 1100 15 16 1110 17 1111 18 19 1120 20 1121 21 1130 1131 Current Assets Cash at Bank Accounts Receivable Inventory Prepaid Rent Prepaid Insurance Stationery Supplies Non-Current Assets WDV Office Computers Computers Accumulated Depreciation - Office Computers WDV Office Equipment Office Equipment Accumulated Depreciation - Warehouse Equipment WDV Forklift Forklift Accumulated Depreciation - Forklift WDV Warehouse Equipment Warehouse Equipment Accumulated Depreciation - Warehouse Equipment WDV Motor Vehicles Motor vehicles Accumulated Depreciation - Motor Vehicles Current Liabilities Accounts Payable suppliers) Wages Payable Cleaning Payable Electricity Payable Telecommunications Payable Utilities Payable Prepaid Revenue Non-current Liabilities 23 24 25 26 27 28 29 1140 1141 1150 115) 31 2001 2010 2020 2021 33 35 2022 56 2023 2025 Chart of accounts General Journal General Ledger Trial Balance AutoSave Assessment Ta H 5 v 5 , Draw Home Insert Formulas Review View Page Layout Data Tell me v Define Name fox llo ? A Auto-sum Recently Financial Logical Text Usad Insert Function Data & Lookup & Maths & Time Reference E Create from More Functions Trig G22 X fx A B D F E 30 31 32 33 34 35 36 37 2001 2010 2020 2021 2022 2023 2025 Current Llabilities Accounts Payable (suppliers) Wages Payable Cleaning Payable Electricity Payable Telecommunications Payable Utilities Payable Prepaid Revenue Non-current Liabilities Bank Loan 38 2201 39 40 Shareholder's funds 41 42 43 3000 3001 3010 Share Capital Retained Earnings Dividends 3050 44 45 45 Income Sales Sales returns and allowances Discount Received Gain on the sale of assets Expenses 50 51 52 53 54 55 56 4000 4001 4002 4010 4100 5000 5001 5010 5020 5100 5110 5120 5130 5140 5150 5160 5170 5180 5190 5200 5250 5300 57 58 59 Cost of Goods Sold Discount Allowed Transportation costs Wages & Salaries Expense Rent Expense Telecommunication Expense Electricity expense Insurance Expense Advertising Expense Vehicle Expense Cleaning Expense Stationery Expense Utilities Expense Depreciation Expense Loss on the sale of assets Interest Expense 60 61 63 54 65 66 57 Chart of accounts General Journal General Ledger Trial Balance +
