Solution for COntinuing Problem.
Following is a list of transactions for the month of October. Petty Cash account (1010) and Miscellaneous expense account (5100) have been added to the chart of accounts
CONTINUING PROBLEM following is a list of transactions for the month of October. Petty Cash Account (1010) and Miscellaneous Expense Account (5100) have been added to the chart of accounts. Assignment Recording and posting transactions: preparing a trial balance; and preparing a bank reconciliation 60 min) Excel templates for this Continuing Problem are available in MyAccountingLab.) 1. Record the transactions in appropriate journals or petty cash format 2. Post the transactions to the general ledger accounts. 3. Prepare a trial balance. 1 2019 Oct. Paid cleaning contract for October, November, and December, $900, cheque No. 252. 4 Established a petty cash fund for $100, cheque No. 253. 4 Collected $3,600 from a cash customer for building three systems Cock Figure 4 Invoiced (invoice No. 12684) and received $1,600 from Total Trial Balance 566,999.82 Anthony Pitale. 8 Purchased $25 worth of stamps, using petty cash pet voucher No. 101. 8 Withdrew $2,000 (cheque No. 254) for personal use. 9 Purchased $22 worth of supplies, using petty cash voucher No. 102 putty 11 Paid the newspaper carrier $10, using petty cash voucher No. 103. 15 Paid the amount due for October phone bill to West Bell Canada, $65, cheque No. 255. 15 Paid the amount due for the October electric bill to City Electric, $95, cheque No. 256. 22 Performed computer services for Taylor Golf; billed the client $4,200, invoice No. 12685. 25 Paid $20 for computer paper, using petty cash voucher ty No. 104 28 Took $15 out of petty cash for lunch, voucher No. 105. thy 29 Replenished the petty cash, cheque No. 257. Coin and currency in drawer $8. Since Tony was so busy trying to close his books, he forgot to recon- cile the May, June, and July bank statements. What follows on pages 388 and 389 is a list of all deposits and cheques written for these three months (each entry is identified by chapter, transaction date, or transaction letter) and bank statements for May through July Reconciliations for August and September are not part of this problem (Continued) Precision Computer Centre Summary of Deposits and Cheques M Transaction Chapter 54.30 1 00 0 Payor/Payee DEPOSITS Tomy Freedman Cash customer Cash customer Taylor Golf thCH HTC Tonga Parker Jones Summer Lipe Jeannine Sparks Mike Hammer 20 1.0 wo 1 1 2 3 15 230 July 3 July July 12 10 Am Chapter Transaction Cheque No. $1.20 (b) C (e) 201 202 200 2014 205 206 2017 208 209 (m) (n Puyor/Payee CHEQUES Mule Systems, Inc. Office Furniture, Inc. Capital Management Tony Freedman Insurance Protection, Inc. Office Depot Computer Edge Magazine City Electric Canada Post Capital Management West Bell Canada Computer Connection Multi Systems, Inc. 600 400 100 150 200 1.400 55 50 1,200 155 200 1,200 210 (1) July 3 July 10 July 13 July 17 211 212 213 3 BANK STATEMENT Royal Bank of Canada 322 Glee Aww, Edmonton, AB TIP 2T9 Precision Computer Centre Sd Date: May 21, 2019 Cheguer Paid: Deports and Credit Date piel Nur Amount Date received JF 201 1,200.00 5.7 202 6.00 J.10 205 400.00 1.20 Amor 4.400.00 270.00 200.00 1,200.00 56.10.00 Total Deposits Total chewes paid for $2,200.00 Ending Balance on May 21-53,950.00 Received Statement May 28, 2019 BANK STATEMENT Royal Bank of Code 522 Gles Arena, Edmonton, AB TJP2T9 Precision Computer Center Statement Date: June 18, 2019 Chegwer uit Deposits and Credits Date paid Number Date ori 10.00 Anot 201 900.00 10.00 2016 200.00 6-16 207 203 Thtal cheques paid for 51,995.00 Beginning balance on May 21-51970. Ending balance on Juwe 18 -52,915.00 $900.00 Received Statement June 28, 2019, Total Deposits Raul Burn of Canada 322 Glen Art, Edmotor AB TP ZTY BANK STATEMENT Precision Computer Centre Chus Puid Date paid 209 Reconcile bank balance 51,625.00 Trial Balance 566,999.82 7.13 Statement Dates July 23, 2019 Deposits and Credits Number Amon Date and Aurout FO.00 7-8 321.00 210 1.200.00 7.10 220.00 211 15.00 7.13 850.00 Total 3 cheques paid for $1,405.00 Total Deposits $1,398.00 Beginning balance on June 18 Ending balance on July 21 52.915.00 $2,90.00 Ried Statement July 28, 2019. Assignment Compare Precision Computer Centre's deposits and cheques with the bank statements and complete a bank reconciliation as of July 31. CONTINUING PROBLEM following is a list of transactions for the month of October. Petty Cash Account (1010) and Miscellaneous Expense Account (5100) have been added to the chart of accounts. Assignment Recording and posting transactions: preparing a trial balance; and preparing a bank reconciliation 60 min) Excel templates for this Continuing Problem are available in MyAccountingLab.) 1. Record the transactions in appropriate journals or petty cash format 2. Post the transactions to the general ledger accounts. 3. Prepare a trial balance. 1 2019 Oct. Paid cleaning contract for October, November, and December, $900, cheque No. 252. 4 Established a petty cash fund for $100, cheque No. 253. 4 Collected $3,600 from a cash customer for building three systems Cock Figure 4 Invoiced (invoice No. 12684) and received $1,600 from Total Trial Balance 566,999.82 Anthony Pitale. 8 Purchased $25 worth of stamps, using petty cash pet voucher No. 101. 8 Withdrew $2,000 (cheque No. 254) for personal use. 9 Purchased $22 worth of supplies, using petty cash voucher No. 102 putty 11 Paid the newspaper carrier $10, using petty cash voucher No. 103. 15 Paid the amount due for October phone bill to West Bell Canada, $65, cheque No. 255. 15 Paid the amount due for the October electric bill to City Electric, $95, cheque No. 256. 22 Performed computer services for Taylor Golf; billed the client $4,200, invoice No. 12685. 25 Paid $20 for computer paper, using petty cash voucher ty No. 104 28 Took $15 out of petty cash for lunch, voucher No. 105. thy 29 Replenished the petty cash, cheque No. 257. Coin and currency in drawer $8. Since Tony was so busy trying to close his books, he forgot to recon- cile the May, June, and July bank statements. What follows on pages 388 and 389 is a list of all deposits and cheques written for these three months (each entry is identified by chapter, transaction date, or transaction letter) and bank statements for May through July Reconciliations for August and September are not part of this problem (Continued) Precision Computer Centre Summary of Deposits and Cheques M Transaction Chapter 54.30 1 00 0 Payor/Payee DEPOSITS Tomy Freedman Cash customer Cash customer Taylor Golf thCH HTC Tonga Parker Jones Summer Lipe Jeannine Sparks Mike Hammer 20 1.0 wo 1 1 2 3 15 230 July 3 July July 12 10 Am Chapter Transaction Cheque No. $1.20 (b) C (e) 201 202 200 2014 205 206 2017 208 209 (m) (n Puyor/Payee CHEQUES Mule Systems, Inc. Office Furniture, Inc. Capital Management Tony Freedman Insurance Protection, Inc. Office Depot Computer Edge Magazine City Electric Canada Post Capital Management West Bell Canada Computer Connection Multi Systems, Inc. 600 400 100 150 200 1.400 55 50 1,200 155 200 1,200 210 (1) July 3 July 10 July 13 July 17 211 212 213 3 BANK STATEMENT Royal Bank of Canada 322 Glee Aww, Edmonton, AB TIP 2T9 Precision Computer Centre Sd Date: May 21, 2019 Cheguer Paid: Deports and Credit Date piel Nur Amount Date received JF 201 1,200.00 5.7 202 6.00 J.10 205 400.00 1.20 Amor 4.400.00 270.00 200.00 1,200.00 56.10.00 Total Deposits Total chewes paid for $2,200.00 Ending Balance on May 21-53,950.00 Received Statement May 28, 2019 BANK STATEMENT Royal Bank of Code 522 Gles Arena, Edmonton, AB TJP2T9 Precision Computer Center Statement Date: June 18, 2019 Chegwer uit Deposits and Credits Date paid Number Date ori 10.00 Anot 201 900.00 10.00 2016 200.00 6-16 207 203 Thtal cheques paid for 51,995.00 Beginning balance on May 21-51970. Ending balance on Juwe 18 -52,915.00 $900.00 Received Statement June 28, 2019, Total Deposits Raul Burn of Canada 322 Glen Art, Edmotor AB TP ZTY BANK STATEMENT Precision Computer Centre Chus Puid Date paid 209 Reconcile bank balance 51,625.00 Trial Balance 566,999.82 7.13 Statement Dates July 23, 2019 Deposits and Credits Number Amon Date and Aurout FO.00 7-8 321.00 210 1.200.00 7.10 220.00 211 15.00 7.13 850.00 Total 3 cheques paid for $1,405.00 Total Deposits $1,398.00 Beginning balance on June 18 Ending balance on July 21 52.915.00 $2,90.00 Ried Statement July 28, 2019. Assignment Compare Precision Computer Centre's deposits and cheques with the bank statements and complete a bank reconciliation as of July 31
