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 Chuck 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 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. 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.ty 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) 15 Precision Computer Centre Summary of Deposits and Cheques NA Transaction Chapter 1 1 1 1 2 3 3 eses Payor/Payee DEPOSITS Tony Freda Cash customer Cash customer Taylor Golf CHI HTC Tony Parker Jones Sammer Lipe Jeannine Sparks Mike Hammer 54.30 20 20 1.0 wo 115 July 3 July July 12 1:00 3 Am Chapter Transaction $1.29 C () (m) (n Cheque No. Puyor/Payee CHEQUES 201 Mule Systems, Inc. 202 Office Furniture, Inc. 200 Capital Management 204 Tony Freedman 205 Insurance Protection, Inc. 206 Office Depot 2017 Computer Edge Magazine 208 City Electric 209 Canada Post 210 Capital Management 211 West Bell Canada 212 Computer Connection 213 Multi Systems, Inc. 600 400 100 150 200 1.400 55 50 1,200 155 200 1,200 (1) July 3 July 10 July 15 July 17 3 BANK STATEMENT Royal Bank of Canada 322 Glen Anwar, Edmonton, AB TJP2T9 Precision Computer Centre Sd Duter Mary 21, 2019 Chegwe Paid Deports and Credits Date paid Nwww.br Ant Date med JS 201 1.200.000 J. 1.7 202 61.00 1.10 5-14 2005 400.00 1.20 Amor 4.00.00 210.00 200.00 1,200.00 56,150.00 Total Deposit Tovalces paid for $2,200.00 Ending Balamorow May 21-53,950.00 Received Statement May 28, 2019. BANK STATEMENT Royal Bank of Code 122 Glen Armar, Edmonton, AB TJP2TY Precision Computer Center Statement Date: June 18, 2019 Chegwer uit Deposits and Credits Date paid Nanter Date med 204 10.00 6-7 203 150.00 2014 200.00 207 Anom 900.00 Thtal cheques paid for $1,995.00 $900.00 Beginning balance on May 21-51,9706 Endring balance on June 18 ---$2,90.00 Received Statement Jane 28, 2019, Total Deports Royal Bank of Canada 322 Glen Ave, Edmonton, AB TUP ZTY BANK STATEMENT Precision Computer Centre Chus Paid Date paid Nuwber Statement Dates July 23, 2019 Deposits and Credits Date cined FO.00 1.200.00 7.10 135.00 7.13 Check Figure Reconcile bank balance 51,625.00 Trial Balance 566.999.82 209 Total Deposits 210 325.00 211 220.00 850.00 Total 3 ceywes paid for $1,405.00 $1,398.00 Beginning balance on June 18 Ending balance on July 28 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.
