Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Transcribed image text : CONTINUING PROBLEM following is a list of transactions for the month of October. Petty Cash Account (1010) and Miscellaneous Expense Account
Transcribed image text: 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 dded 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. 2019 Oct 1 4 4 Click Total Trial Balance 566,999.82 4 00 Paid cleaning contract for October, November, and December, $900, cheque No. 252. Established a petty cash fund for $100, cheque No. 253. Collected $3,600 from a cash customer for building three systems. Invoiced (invoice No. 12684) and received $1.600 from Anthony Pitale. Purchased $25 worth of starps, using petty cash pet voucher No. 101. Withdrew $2,000 (cheque No. 254) for personal use. Purchased $22 worth of supplies, using petty cash put voucher No. 102 Paid the newspaper carrier $10, using petty cash voucher No. 103 Paid the amount due for October phone bill to West Bell Canada, $65, cheque No. 255. Paid the amount due for the October electric bill to City 0001 11 15 15 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 No. 104 28 Took $15 out of petty cash for lunch, voucher No. 105. 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 Trio Chapter 14 1 1 1 0 00 Pryor/Payee DEPOSITE Tomy Free th cum thc Cash customer Tilor Cachum Toa Parker Jones Summer Lipe Jeannine Sparks Mike Hammer 124 96 5 July Jwy 12 Jul 20 220 50 Amour Chapter Transaction Cheque No. 512 600 SET 2 201 300 203 1 205 306 207 2018 209 210 211 212 213 Payot/Puyee CHEQUES Malo Systems, Inc. Ollice Furniture, Inc. Capital Management Tony Freedman Insurance Protection, Inc. Office Depot Computer Edge Magazine City Electric Canada Past Capital Management West Bell Canada Computer Connection Multi Systems, loc 100 150 200 1400 15 50 1.200 155 200 XO July 3 July to July 15 July 1 BANK STATEMENT Royal Bank of Canada 322 Glow, Edmonton, AB TIP TY Pre Computer Centre Sd Duter Mary 21, 2019 Chiewer Pull Dupont and its Dule paid www.hr Amon! Dale red JUL 1,200.00 J. J. 202 600.000 1.10 23 foy 8.20 1.21 Talche paid for 52,200.00 Ending Balence on May 21-590.00 Received Statement May 28, 2019 Amon 4,500.00 210.00 200.00 1.200,00 $6.10.00 Total Deports BANK STATEMENT Rosa Beskonad 522 Glen Arme, Edmonton, ARTP2TY Price Computer Centre Statement Date: June 18, 2019 Che Pull Deposit and it Date pad Number Anna 6-2 204 100,00 201 IM 6-9 295 200.00 6-16 207 6-27 Tival chegar paid for $1.917.00 Date per Ano 500.00 X1.00 Total Deposits Beginning belowe on May 21-56950 Euldbine Peson Juw 14 ---2.90.00 Received Statement June 28, 2019, Swood BANK STATEMENT Chrysal Dal paid 72 209 Reconcile bank balance 51.625.00 Tral Balance 564,95982 Real Bank of Canada 322 Glat Are Ed AB TJP 2TY Pin Computer Centre Statement Date: July 29, 2019 Deposits and Cri Number Amo Date med A F0.00 7.8 21.00 210 1,200.00 7-10 211 220.00 11.00 850.00 Total cheques paid for $1.405.00 Total Deposit 51,399.00 Beginning balance on June 18 Ending baliace on July 23 S2911.00 $2,501.00 Rewed States 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started