Questions:

answer Q in:

make sure post refernce is correct from the trial balance.

Av a Styles Styles Pane Stylos T Dictate Sensitivity Update fron Project Transactions: February 2020 Date 3 4 6 7 9 11 11 11 Description Paid rent to Land Lord Pty Ltd for the next 2(two) months - $4,000 Paid Cash for vehicle expenses- $420 to Toyota Ltd Received payment from Collingwood Cycles Pty Ltd for January account. Received and paid electricity bill from Citipower for January $395 Paid E-Bikes Pty Ltd. for January account. Paid Merida Electric Cycles Ltd. for January account. Received payment from E-volution Cycles Pty Ltd for January account. 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. Cash sales to Collingwood Cycles Pty Ltd Pty Ltd Inventory sold: 6X CSB and 8 x TEB Paid Optus invoice for Telephone Expenses $480 Purchased more inventory 14 x CSB, 12 x TEB, on credit Returned 3 CSB to E-Bikes Pty Ltd due to the inventory being damaged Pay day. Sarah was paid for 62 hours and Zlatko was paid for 64 hours. The Lawerencia Bike Pty Ltd paid for items purchased on 12th February Borrowed money from the DEF bank, $15,000 at an interest rate of 7% 12 13 14 17 24 26 25 25 28 nath Enhan 202 25 25 28 damaged Pay day. Sarah was paid for 62 hours and Zlatko was paid for 64 hours. The Lawerencia Bike Pty Ltd paid for items purchased on 12th February. Borrowed money from the DEF bank, $15,000 at an interest rate of 7% 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 29th February 2020 totalled $ 205. 5. The portion of prepaid insurance expired as of 29th February 2020 is $150. Page 5 of 6 In the CANVAS shell In the excel document from Project 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 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. Xfx B C D E GENERAL JOURNAL Transactions for February 2020 Date Account Name Post reference Debit Credit Thial Balance + Chart of accounts General Ledger General Journal ect destination and press ENTER or choose Paste Home Assessment Task Manual Recording - TEMPLATE-2 Insert Draw Page Layout Formulas Data Review View Tell me Callbl Body 11 ' ' P 13 Wrap 3 T General $% 9 W28 oxfo o il GENERAL LEDGER ACCOUNTS GENERAL LEDGER ACCOUNTS GENERALOGER ACCOUNTS De Der 1001 Date Demon D Det De Dertion 2010 DAN Date De ROHO Date Debi 1010 1 CH Ce Balance 100 Date O C De De C Chat of acco General Ledger Triane + MacBook Air Av a Styles Styles Pane Stylos T Dictate Sensitivity Update fron Project Transactions: February 2020 Date 3 4 6 7 9 11 11 11 Description Paid rent to Land Lord Pty Ltd for the next 2(two) months - $4,000 Paid Cash for vehicle expenses- $420 to Toyota Ltd Received payment from Collingwood Cycles Pty Ltd for January account. Received and paid electricity bill from Citipower for January $395 Paid E-Bikes Pty Ltd. for January account. Paid Merida Electric Cycles Ltd. for January account. Received payment from E-volution Cycles Pty Ltd for January account. 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. Cash sales to Collingwood Cycles Pty Ltd Pty Ltd Inventory sold: 6X CSB and 8 x TEB Paid Optus invoice for Telephone Expenses $480 Purchased more inventory 14 x CSB, 12 x TEB, on credit Returned 3 CSB to E-Bikes Pty Ltd due to the inventory being damaged Pay day. Sarah was paid for 62 hours and Zlatko was paid for 64 hours. The Lawerencia Bike Pty Ltd paid for items purchased on 12th February Borrowed money from the DEF bank, $15,000 at an interest rate of 7% 12 13 14 17 24 26 25 25 28 nath Enhan 202 25 25 28 damaged Pay day. Sarah was paid for 62 hours and Zlatko was paid for 64 hours. The Lawerencia Bike Pty Ltd paid for items purchased on 12th February. Borrowed money from the DEF bank, $15,000 at an interest rate of 7% 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 29th February 2020 totalled $ 205. 5. The portion of prepaid insurance expired as of 29th February 2020 is $150. Page 5 of 6 In the CANVAS shell In the excel document from Project 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 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. Xfx B C D E GENERAL JOURNAL Transactions for February 2020 Date Account Name Post reference Debit Credit Thial Balance + Chart of accounts General Ledger General Journal ect destination and press ENTER or choose Paste Home Assessment Task Manual Recording - TEMPLATE-2 Insert Draw Page Layout Formulas Data Review View Tell me Callbl Body 11 ' ' P 13 Wrap 3 T General $% 9 W28 oxfo o il GENERAL LEDGER ACCOUNTS GENERAL LEDGER ACCOUNTS GENERALOGER ACCOUNTS De Der 1001 Date Demon D Det De Dertion 2010 DAN Date De ROHO Date Debi 1010 1 CH Ce Balance 100 Date O C De De C Chat of acco General Ledger Triane + MacBook Air