1. Record the transaction in appropriate journals or petty cash format.

2. Post the transactions to the general ledger accounts.

3. Prepare Trial Balance.

4. Prepare Bank Reconcillation

5. Auxilary Petty Cash Record

The trial balance should be &66,999.82

Reconcile Bank Balance $ 1,625.00

Continuing Problem wing of stone for the month of Octobet Potty C A01 Miscellaneo Eense Account 100 have My added to the chart of counts Assignment Excel templates for this continuing problem se available Accounting) 1. Record the transactions inappropriate journals or petty cash format 2. Mout the transactions to the general ledger accounts. 3. Prepare a trial balance 2022 Oct 1 December 5900, cheque No. 252 Paid cleaning contract for October November, and 4 Established a petty cash fund for $100, cheque No. 253 4 Collected $3,600 from a cash customer for building the 4 Invoiced (invoice No. 12684) and received $1,600 from systems Anthony Pitale 8 Purchased 525 worth of stamps, using petty cash voucher No. 101 8 Withdrew $2,000 (cheque No. 254) for personal use. No. 103 City 9 Purchased $22 worth of supplies, using petty cash voucher No. 102 11 Paid the newspaper carrier $10,9 petty cash voucher 15 Paid the amount due for Octobe phone bill to West Bell Canada, 565, cheque No. 255. 15 Paid the amount due for the Octoor electric bill to 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 reconcile the May, June, and July bank statements. What follows on pages 461 and 462 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. Precision Computer Centre Summary of Deposits and Cheques Chapter Transaction Amount 1 1 1 1 2 Payor/Payee DEPOSITS Tony Freedman Cash customer Cash customer Taylor Golf Cash customer Tonya Parker Jones Summer Lipe Jeannine Sparks Mike Hammer (p) July 5 July 8 July 12 July 26 $4,500 250 200 1,200 900 325 220 850 140 Chaps Transaction Amount (6) 1 $1,200 600 400 100 0 150 E 2 2 2 2 2 3 3 3 Cheque No. Payor/Payee CHEQUES 201 Multi Systems, Inc. 202 Office Furniture, Inc. 203 Capital Management 204 Tony Freedman 205 Insurance Protection, Inc. 206 Office Depot 207 Computer Edge Magazine 208 City Electric 209 Canada Post 210 Capital Management 211 West Bell Canada 212 Computer Connection 213 Multi Systems, Inc. 200 1,400 85 50 1,200 155 200 1,200 July 3 July 10 July 15 July 17 BANK STATEMENT Royal Bank of Canada 322 Glen Arenue, Edmonton, AB TIP 2T Precision Computer Centre Statement Date: May 21, 2022 Cheques Paid: Date paid S-S 5-7 Number 201 202 203 Amount 1,200.00 600.00 400.00 Deposits and Credits: Date receid 5-3 5-10 5-20 5-21 Total Deposits Amount 4,500.00 20.00 200.00 1,200.00 36,150.00 Total 3 cheques paid for $2,200.00 Ending Balance on May 21-33,950.00 Received Statement May 28, 2022. BANK STATEMENT Royal Bank of Canada 322 Glen Avenue, Edmonton, AB TIP 2T9 Precision Computer Centre Statement Date: June 18, 2022 Cheques Paid: Deposits and Credits: Date paid Number Amount Date received Amount 6-2 900.00 204 6-11 100.00 6-7 205 150.00 6.9 206 200.00 6-16 207 1,400.00 6-21 208 85.00 Total Deposits $900.00 Total cheques paid for $1,935.00 Beginning balance on May 21-$3,950.00 Ending balance on June 18 -32,915.00 Received Statement June 28, 2022. (Continued) VING PROCEDURES AND BANK STATEMENT Royal Bank of Canada 322 Glen Avenue, Edmonton, AB TSP 279 Precision Computer Centre Statement Date: July 23, 2022 Cheques Paid: Deposits and Credits: Date paid Number Amount Date received 7-2 209 50.00 7-8 7-6 1,200.00 7-10 7-13 211 155.00 7-13 Amount 325.00 220.00 850.00 210 Total Deposits $1,395.00 Total 3 cheques paid for $1,405.00 Ending balance on July 23 $2,905.00 Beginning balance on June 18 52,915.00 Received Statement July 28, 2022. Assignment Compare Precision Computer Centre's deposits and cheques with the bank statements and complete a bank reconciliation as of July 31