please solve every step every table

i have in excel how can i share that

as i uploading pictures of that

The pivotal role of accountants today is to undertake much accounting work using computers (small accounting software or ERP system). This practice question in Part A using Excel will enable you to Business Accounting students to understand the various steps in the accounting cycle and provide general understanding of the flow of business transactions through a simple set of accounting records. The assumptions considered include the business is a sole proprietorship, e.g., Syd Mel Ltd and using periodic inventory system of physical count at the end of each month. As well, all cash receipts are banked daily, and all cash payments are made by cheques. The following tables are provided for the month of June 2021 to complete the required questions detailed below: (1) Opening Trial Balance (existing chart of accounts), (2) Bank Statement, (3) Transactions during the month of June 2021, and (4) physical inventory records. TABLE 1: Syd Mel Ltd Opening Trial Balance 1 June 2021 Credit $ $ $ $ Debit 8.940 46,500 2.500 40,000 $ $ 25,000 61,620 30.000 $ 5.000 Account Cash at bank Accounts Receivable Prepaid rent Equipment (paid cash on 1 April 2014) Accounts Payable Bank loan Capital Drawings Sales Purchases Electricity Equipment Maintenance Costs Insurance - Equipment Interest Office Supplies Rent Telephone Wages $ 73,000 s $ $ $ un 72,000 1.970 1.40 300 1,000 320 5,500 680 3,500 $ s 5 $ 189,620 189,670 The following tables are provided for the month of June 2021 to complete the required questions detailed below: (1) Opening Trial Balance (existing chart of accounts), (2) Bank Statement, (3) Transactions during the month of June 2021, and (4) physical inventory records. TABLE 1: Syd Mel Ltd Opening Trial Balance 1 June 2021 Credit $ $ $ s Debit 8.9.00 46.500 2.500 40.000 25,000 61.670 30.000 5 5 5.000 Account Cash at bank Accounts Receivable Prepaid rent Equipment (paid cash on 1 April 2014) Accounts Payable Bank loan Capital Drawings Sales Purchases Electricity Equipment Maintenance Costs Insurance Equipment interest Office Supplies Rent Telephone Wages $ 73.000 $ $ $ S $ 5 5 5 $ 72.000 1.970 1.400 00 1.000 320 5.500 650 3.500 $ 10,670 S 189.670 TABLE 2: DATE June A Bhu 1 1 6 12 16 17 18 20 26 28 29 30 BANK STATEMENT As at 30 June 2021 PARTICULARS DEBIT CREDIT BALANCE $ 8,940 cheque no.119 $ 200 $ 8,740 cheque no.120 $ 350 $ 8,390 Orange Ltd $ 30,000 $ 38,390 cheque no.122 $ 1,000 $ 37,390 Cheery Ltd $ 4,200 $ 41,590 cheque no.121 $ 25,000 $ 16,590 cheque no.124 $ 1,000 $ 15,590 cheque no.126 $ 150 $ 15,440 cheque no.123 $ 320 $ 15,120 cheque no.128 $ 1,000 $ 14,120 bank service fees $ 25 $ 14,095 TRANSACTIONS FOR THE PERIOD MONTH DATE PARTICULARS June 1 Drew cheque 119 to establish Petty Cash Advance 1. Pald Insurance on equipment by cheque no. 120 2 Purchased 120 of Conventional at $280 each from Air King, Inice no. 60110 5 Heceived payment from customer, Orange for $30000. Receipt No. 602 8 Sold 80 Conventional $450 each to Berry Ltd on credit 9 Paid for cardboard boxes from petty cash. Voucher Ne 2 10 Sold 6 Refrigerator at $700 each to Cherry tal forces Receipt No. 603 11 Pald the outstanding debut in fall to Ar King Cheque No 121 13 Pald S8s for advertising brochures from petty cash. Voucher No 3 15 Pald wages expense. Chegue No. 122 18 Paid electricity expense. Cheque No. 123 20 Drawing by owner of $1000. Cheque No. 124 21 Retured S defective Refrigerators purchased on 2 June 2014 to Air King 23 Pald 585 for air conditioning gas. Cheque No. 125 26 Reimbursed petty cash. Cheque No. 126 27 Pald telephone expense. Cheque No. 127 28 Pald wages expense. Cheque No. 128 29 Received full payment from customer, Apple Ltd. 2% discount for early payment oplied Recent No. 604 29 Paid rent in advance for July 2021. Chequr No. 129 AMOUNT $ 200 5 350 $ 33.600 5 30.000 5 36.000 $ 65 $ 4.200 $ 25,000 $ 5 1.000 5 3.00 $ 1.000 5 1.400 $ 85 5 150 5 255 5 1.000 $ 16.500 $ 2.500 Table 4: Descriptio purchases WREFI 280 $ 81,600 REF 48 $ 24,000 15 105.000 sales 114 551 300 31 $21.700 1573 000 opening closing Inventory inventory 50 $ 15.000 10 $ 5.000 $20.000 Total Periodic Inventory System specific ider Piro Required: Complete the folowing accounting cycle using the Excel template provided on Moodle: General journal Cash receipt (special) Journal Cash paymants (special) Journal. Sales and purchase (special) journals Account receivable subsidiary ledgers and schedule (extract) Accounts payble subsidiary ledgers and schedule (extract) General Ledger Petty Cash Bank reconciliation Trial Balances (unadjusted, adjusted and post-closing) Income Statement (Statement of Profit or Loss) Balance Sheet (Statement of Financial Position) (Note: Student must complete these requirements using the provided Excel template on Moodle) Table 4: closing inventory $ Descriptio purchases $ WREF: 280 $ 81,600 WREFI 48 $ 24.000 Total $ 105.600 sales 114 $ 51,300 31 $21.700 $ 73.000 opening inventory 50 $ 15.000 10 $ 5.000 $ 20.000 Periodic Inventory System specific ider Fifo MO $ $ Required: Complete the folowing accounting cycle using the Excel template provided on Moodle: General journal Cash receipt (special) Journal Cash paymants (special) Journal. Sales and purchase (special) journals Account receivable subsidiary ledgers and schedule (extract) Accounts payble subsidiary ledgers and schedule (extract) General Ledger Petty Cash Bank reconciliation Trial Balances (unadjusted, adjusted and post-closing) Income Statement (Statement of Profit or Loss) Balance Sheet (Statement of Financial Position) (Note: Student must complete these requirements using the provided Excel template on Moodle) 3:00 . Done BACT105 T3 21 Assessment 3_Part A... Cover PTO ABNK STAT TRANSACTIONS LISTING INVENTORY 1. Ce 2.0 Do G iii 3:00 Done BACT105 T3 21 Assessment 3_Part A... Cover Page TB & BIKSTA TRANSACTIONS LISTING INVENTORY 1. 20 Do G iii Cover Page TO & BNK STAT TRANSACTIONS LISTING INVENTORY 1. General Journals 2.6 III Cover Page TB & BNK STAT INVENTORY 1. General Journals 2.0 TRANSACTIONS LISTING Syd Mel Lid 1 GENERAL JOURNALS POLAR DATE Cover Page TO & ONK STAT TRANSACTIONS LISTING INVENTORY 1. General Journals 2.C SELN CASH RECEIPTS JOURNALS = Syd Lid CASH PAYMENT JOURNALS III Cover Page TB & BNK STAT TRANSACTIONS LISTINO INVENTORY LG Journals 2 Sydal 2 SALES JOURNALS 2 Sydel La PURCHASES JOURNALS 2 By Mall PURCHASES RETURNS & ALLOWANCES JOURNALS 1 : Cover TAK STAY TRANSACTIONS LISTING INVENTORY Gemeente 3 GERAL LEGGE . 10 : Cover Page TH A DNK STAT TRANSACTIONS LISTING INVENTORY 1. General Journals 3 Sydol Ld ACCOUNTS RECEIVABLE SUGIARTLEGER A Cover Page TB & DRK STAT TRANSACTIONS USTING INVENTORY 3 Syd ACCOUNTS PAYABLE DIARY LEDGER 3 Cover Page TO & INK STAT TRANSACTIONS LISTING INVENTORY 1. Guma Cover Page TB & INK STAT TRANSACTIONS LISTING WENTORY Generals Cover Page TB & BNK STAT TRANSACTIONS LISTING INVENTORY LGA 20 OD 9 URDUSTRIAL BALANCE AR TE 6 ADJUSTED NA BALANCE 21 9 FOOTGOLING TIL BALANCE ASMA Cover Page TB & BNK STAT TRANSACTIONS LISTING INVENTORY LG 20 By COME STATEMENT For the period ended 30 June 2011 Cover Page TB & BNK STAT TRANSACTIONS LISTING INVENTORY LGA 20 7 BM ALTANCERET As June TESC TES AT Cover Page TB & BNK STAT TRANSACTIONS LISTING INVENTORY LG 20 By COME STATEMENT For the period ended 30 June 2011 The pivotal role of accountants today is to undertake much accounting work using computers (small accounting software or ERP system). This practice question in Part A using Excel will enable you to Business Accounting students to understand the various steps in the accounting cycle and provide general understanding of the flow of business transactions through a simple set of accounting records. The assumptions considered include the business is a sole proprietorship, e.g., Syd Mel Ltd and using periodic inventory system of physical count at the end of each month. As well, all cash receipts are banked daily, and all cash payments are made by cheques. The following tables are provided for the month of June 2021 to complete the required questions detailed below: (1) Opening Trial Balance (existing chart of accounts), (2) Bank Statement, (3) Transactions during the month of June 2021, and (4) physical inventory records. TABLE 1: Syd Mel Ltd Opening Trial Balance 1 June 2021 Credit $ $ $ $ Debit 8.940 46,500 2.500 40,000 $ $ 25,000 61,620 30.000 $ 5.000 Account Cash at bank Accounts Receivable Prepaid rent Equipment (paid cash on 1 April 2014) Accounts Payable Bank loan Capital Drawings Sales Purchases Electricity Equipment Maintenance Costs Insurance - Equipment Interest Office Supplies Rent Telephone Wages $ 73,000 s $ $ $ un 72,000 1.970 1.40 300 1,000 320 5,500 680 3,500 $ s 5 $ 189,620 189,670 The following tables are provided for the month of June 2021 to complete the required questions detailed below: (1) Opening Trial Balance (existing chart of accounts), (2) Bank Statement, (3) Transactions during the month of June 2021, and (4) physical inventory records. TABLE 1: Syd Mel Ltd Opening Trial Balance 1 June 2021 Credit $ $ $ s Debit 8.9.00 46.500 2.500 40.000 25,000 61.670 30.000 5 5 5.000 Account Cash at bank Accounts Receivable Prepaid rent Equipment (paid cash on 1 April 2014) Accounts Payable Bank loan Capital Drawings Sales Purchases Electricity Equipment Maintenance Costs Insurance Equipment interest Office Supplies Rent Telephone Wages $ 73.000 $ $ $ S $ 5 5 5 $ 72.000 1.970 1.400 00 1.000 320 5.500 650 3.500 $ 10,670 S 189.670 TABLE 2: DATE June A Bhu 1 1 6 12 16 17 18 20 26 28 29 30 BANK STATEMENT As at 30 June 2021 PARTICULARS DEBIT CREDIT BALANCE $ 8,940 cheque no.119 $ 200 $ 8,740 cheque no.120 $ 350 $ 8,390 Orange Ltd $ 30,000 $ 38,390 cheque no.122 $ 1,000 $ 37,390 Cheery Ltd $ 4,200 $ 41,590 cheque no.121 $ 25,000 $ 16,590 cheque no.124 $ 1,000 $ 15,590 cheque no.126 $ 150 $ 15,440 cheque no.123 $ 320 $ 15,120 cheque no.128 $ 1,000 $ 14,120 bank service fees $ 25 $ 14,095 TRANSACTIONS FOR THE PERIOD MONTH DATE PARTICULARS June 1 Drew cheque 119 to establish Petty Cash Advance 1. Pald Insurance on equipment by cheque no. 120 2 Purchased 120 of Conventional at $280 each from Air King, Inice no. 60110 5 Heceived payment from customer, Orange for $30000. Receipt No. 602 8 Sold 80 Conventional $450 each to Berry Ltd on credit 9 Paid for cardboard boxes from petty cash. Voucher Ne 2 10 Sold 6 Refrigerator at $700 each to Cherry tal forces Receipt No. 603 11 Pald the outstanding debut in fall to Ar King Cheque No 121 13 Pald S8s for advertising brochures from petty cash. Voucher No 3 15 Pald wages expense. Chegue No. 122 18 Paid electricity expense. Cheque No. 123 20 Drawing by owner of $1000. Cheque No. 124 21 Retured S defective Refrigerators purchased on 2 June 2014 to Air King 23 Pald 585 for air conditioning gas. Cheque No. 125 26 Reimbursed petty cash. Cheque No. 126 27 Pald telephone expense. Cheque No. 127 28 Pald wages expense. Cheque No. 128 29 Received full payment from customer, Apple Ltd. 2% discount for early payment oplied Recent No. 604 29 Paid rent in advance for July 2021. Chequr No. 129 AMOUNT $ 200 5 350 $ 33.600 5 30.000 5 36.000 $ 65 $ 4.200 $ 25,000 $ 5 1.000 5 3.00 $ 1.000 5 1.400 $ 85 5 150 5 255 5 1.000 $ 16.500 $ 2.500 Table 4: Descriptio purchases WREFI 280 $ 81,600 REF 48 $ 24,000 15 105.000 sales 114 551 300 31 $21.700 1573 000 opening closing Inventory inventory 50 $ 15.000 10 $ 5.000 $20.000 Total Periodic Inventory System specific ider Piro Required: Complete the folowing accounting cycle using the Excel template provided on Moodle: General journal Cash receipt (special) Journal Cash paymants (special) Journal. Sales and purchase (special) journals Account receivable subsidiary ledgers and schedule (extract) Accounts payble subsidiary ledgers and schedule (extract) General Ledger Petty Cash Bank reconciliation Trial Balances (unadjusted, adjusted and post-closing) Income Statement (Statement of Profit or Loss) Balance Sheet (Statement of Financial Position) (Note: Student must complete these requirements using the provided Excel template on Moodle) Table 4: closing inventory $ Descriptio purchases $ WREF: 280 $ 81,600 WREFI 48 $ 24.000 Total $ 105.600 sales 114 $ 51,300 31 $21.700 $ 73.000 opening inventory 50 $ 15.000 10 $ 5.000 $ 20.000 Periodic Inventory System specific ider Fifo MO $ $ Required: Complete the folowing accounting cycle using the Excel template provided on Moodle: General journal Cash receipt (special) Journal Cash paymants (special) Journal. Sales and purchase (special) journals Account receivable subsidiary ledgers and schedule (extract) Accounts payble subsidiary ledgers and schedule (extract) General Ledger Petty Cash Bank reconciliation Trial Balances (unadjusted, adjusted and post-closing) Income Statement (Statement of Profit or Loss) Balance Sheet (Statement of Financial Position) (Note: Student must complete these requirements using the provided Excel template on Moodle) 3:00 . Done BACT105 T3 21 Assessment 3_Part A... Cover PTO ABNK STAT TRANSACTIONS LISTING INVENTORY 1. Ce 2.0 Do G iii 3:00 Done BACT105 T3 21 Assessment 3_Part A... Cover Page TB & BIKSTA TRANSACTIONS LISTING INVENTORY 1. 20 Do G iii Cover Page TO & BNK STAT TRANSACTIONS LISTING INVENTORY 1. General Journals 2.6 III Cover Page TB & BNK STAT INVENTORY 1. General Journals 2.0 TRANSACTIONS LISTING Syd Mel Lid 1 GENERAL JOURNALS POLAR DATE Cover Page TO & ONK STAT TRANSACTIONS LISTING INVENTORY 1. General Journals 2.C SELN CASH RECEIPTS JOURNALS = Syd Lid CASH PAYMENT JOURNALS III Cover Page TB & BNK STAT TRANSACTIONS LISTINO INVENTORY LG Journals 2 Sydal 2 SALES JOURNALS 2 Sydel La PURCHASES JOURNALS 2 By Mall PURCHASES RETURNS & ALLOWANCES JOURNALS 1 : Cover TAK STAY TRANSACTIONS LISTING INVENTORY Gemeente 3 GERAL LEGGE . 10 : Cover Page TH A DNK STAT TRANSACTIONS LISTING INVENTORY 1. General Journals 3 Sydol Ld ACCOUNTS RECEIVABLE SUGIARTLEGER A Cover Page TB & DRK STAT TRANSACTIONS USTING INVENTORY 3 Syd ACCOUNTS PAYABLE DIARY LEDGER 3 Cover Page TO & INK STAT TRANSACTIONS LISTING INVENTORY 1. Guma Cover Page TB & INK STAT TRANSACTIONS LISTING WENTORY Generals Cover Page TB & BNK STAT TRANSACTIONS LISTING INVENTORY LGA 20 OD 9 URDUSTRIAL BALANCE AR TE 6 ADJUSTED NA BALANCE 21 9 FOOTGOLING TIL BALANCE ASMA Cover Page TB & BNK STAT TRANSACTIONS LISTING INVENTORY LG 20 By COME STATEMENT For the period ended 30 June 2011 Cover Page TB & BNK STAT TRANSACTIONS LISTING INVENTORY LGA 20 7 BM ALTANCERET As June TESC TES AT Cover Page TB & BNK STAT TRANSACTIONS LISTING INVENTORY LG 20 By COME STATEMENT For the period ended 30 June 2011