I need help making this bank reconcilation for the SUA 10th editon monthly end procedures.

3. Ray Kramer prepares a bank reconciliation on a separate working paper (not provided). After receiving the bank statement (Doc. No. 24) and list of items clearing with the bank statement (Doc. No. 25) from the bank, he performs the following procedures: Document No. 9 WAREN SPORTS SUPPLY CASH RECEIPTS PRELIST MONTH December Purpose Cash AR Sale Colomer CHECK or ACH Invoke Number Amount onvold Am Received C Date Description Dec 6 Gates University 2 Dec. 8 Rosemont University a Dec, 12 Hancock College 4 Dec. 14 Clayborn University Dec. 14 Atwood Brothers la da 16 Branch college DE 19 Fist American 13/Dec. 27 Easton wisconsin un. Dec. 27 Hawling college 589 100 40 1052 53 00 00 11096 14715 C-28 13507 727 28446 C-29 ACH 72.8 724 N/A LACH 730 PACH NA 149520729 4752 MA 5890.00 411400 53 000 12.52.00 N/A MUS NA 82.500 1 2 2 1 9006 12 000 SS- 37.221 S555- 10 12 3 45 10.30 107.33 41 11.00 20.50 5.00 Docum No.95 mbar 3120 TRA AD Inc WAREN SPORTS SUPPLY LIST OF ITEMS CLEARING WITH BANK STATEMENT DECEMBER 2022 ni Payee Amount . . CHECKS/ACH PAYMENTS Check/ACH Date Date Number Written Cleared 1137 11/30 12/5 1138 11/30 12/4 1139 11/30 12/4 1140 12/7 12/12 1141 12/12 12/15 E-53430 12/13 12/15 1143 12/13 12/15 12/13 12/19 1145 12/14 12/20 1146 12/14 12/20 1147 12/14 12/21 1148 12/14 12/21 1149 12/15 12/22 1150 12/15 12/21 1151 12/15 12/21 Ray Kramer Jim Adams Nar Ford First Security Insurance Chicago Office Supply Velocity Sporting Goods Board of Water and Light Interstate Motor Freight Internal Revenue Service Internal Revenue Service State of Illinois State of Illinois Ray Kramer Jim Adams Nancy Ford 2.765.38 1.797.23 786.70 575.00 7,367.00 35,392.70 1.360.25 778.75 3,066.32 10.30 60.96 590.86 2,765.38 1,740.90 1.297.32 DEPOSITS Date Deposited Date Recorded by Bank Amount 12/6 12/8 12/12 12/14 12/16 12/19 12/8 12/12 12/15 12/15 12/19 12/19 5,891.00 4,090.52 5,306,00 7,931.96 1,622.88 90,000.00 Vaud BANK AND TRUST COMPANY First American Statement of Account thi li tim vi vi Document No. 24 ST24 0003514 18 December 2022 1 Waren Sports Supply 1978 Michigan Avenue Chicago, Illinois 60612 FOR ABBASTANCE CALL 1-800-FAB-2064 OR WRITE CUSTOMER SERVICE PO BOX 28014 CHICAGO, ILLINOIS 60610 EPOSIT BALANCE FORWARE 77,087.72 MINIMUIMBALANCE 50.262.94 ENDING BALANCE 131.549.53 DEPOSTED ITEMS TOTAL.CACH AM TOTAL DE AMOUNT HTV Eig 60.355.05 114,842.36 25.50 AVERAGE BALANCE OF CECH NO OF DEPOSITS 96.940.76 15 CHECKING ACCOUNT ENTRIES CHECKSACHDEBITS CHECKLACHOCBITS DEPOSITSIGHEDITS November 30, 2022 Balance Forward Date eposited 126 DATE BALANCE 77,087.72 28 '12 4 1.797.23 786.70 2.765.38 4-Dec 5-Dec 8-Dec 12-Dec 15-Dec 74,503.79 71.738.41 77,629.41 81.144.93 ACH 35,392.70 575.00 7,367.00 1.360.25 778.75 5,891.00 4,090.52 5,306.00 7.931.96 1,622.88 90,000.00 50,262.94 19-Dec ACH EFT 20-Dec 21-Dec 141,107.07 138,030,45 A 3,066,32 60.96 1,740.90 2,765.38 10.30 1.297.32 590.86 134,340.41 131,575.03 22-Dec 30-Dec ACH-F S/C 20.50 5.00 131,549.53 December 31, 2022 Ending Balance 131,549.53 TRANSACTION CODE LEGEND DD - Direct Deposit DM-Debit Memo EFT - Electronic Funds Transfer NSF - NSF Fees 00 - Overdrawn Balance ACH. Automatic Clearing House Mom ACH-F - ACH lee CD-CD interest Deposit CM. Credit Memo PR - Payroll Deposit RT - Returned Item SC-Service Charge ATM TRANSACTIONS RA Credit Card Advance RI - Instalment Loan Pmt AD Envelope Deposit RO-Other Payment RC - Credit Card Payment RW - Cash Withdrawal RM. Mortgage Loan Pmt RS - Transfer to Savings RL - Money Matic Loan PF - Transfer From Savings CASH RECEIPTS JOURNAL can 411 WA The College Now Melam College Now Branch College Nawatan wan 11.00 NE NE NE 10 Soo 00 Al 40 410 AL 209.00 DO Mouth Total FC 101 115000 1161.00 5 4400 Auto 5200 1900 404 407 125200 ERIONICE DO 222222 doce Datenverty NE 100 Dee Resman University NE 4005 De Hancock College NE 53000 Dec 14 Cyborn University TOO De 14 Arwood Brothers 2900 braka 19 A NE 2 montin uw 2.1 cm 30 ways SV 30 cm Wanje NP 17- Seandaling Sorent As Solo MFHEN 30 Susan Callage M Del D HO 117009 15 SEE th SID D ON FE 569,740. CASH DISBURSEMENTS JOURNAL November CREDE Account Payable GIL 200 Purchase tuba Subs GL 10100 Trans Pos OIL 30700 AN Amount Rat 455 50 2.53 185.80 26832.40 5476 252 213000 O GIL R GALOG AR Check Date ACH No Description Nov. 124 Chicago Office Supply Nov I 1125 Velocily Sporting Goods Nov. 15 126-B Ser Payroll Journal Nov. 151124 Internal Revenue Service D R F 2.9742 Nov. 15 1190 Nov 15 1131 Internal Revenue Service State of Illinois 1000 C1982 Nov. 17 1192 Worldwide Management Nov. 17 1135 Board of Water & Light Nov. 17 1134 Interstate Motor Freight Nov. 17 1135 University Athletic News Nov. 23 113 Chicago Office Supply Nov. 301197-4 See Payroll Journal 480000 070365 2356 94 3 250 00 55804 7.0-300 14400 20100 14292 201400 1000 20400 551 20500 591 40100 A 80 000 41000 11635 235649 40200 3.2.5000 253 55804 5:47 00 2.8423.891 23569 1331439 Monthly Totals FC M405267 RK Cash Disbursements Journal continued on next page CASH DISBURSEMENTS JOURNAL December CREDIT DEM RPWL Subs Tran Post GAL os Tra 41000 ACHNO Dec 7 1140 First Security Det 1141 Chicago Office Supply Dec 13 54 Velocity Sporting Conds Dec 18 114 Worldwide Management Dec 12 114 Board of Wate Light Doc 1144 Interstate Moter Freight Dec 14 1145 Internal Revenue Service Cash BIL 100 1515.00 107.00 5210 A60.000 suola 1115 SUU 252 7210154 721001 15.00 A AS000 dag 10.15 209.00 1071,00 20100 2014 20600 10.10 20500 Lou 2.0400 540 1710 Dec 14 1146 Internal Revenue Service Dec 14 1030 State of Illinois Gol Dec 14 1145 State of Illinois 50 Dec 15 1149-51 5e Payroll Tournal IDE IS 2 Frost Security DEC 28 1155 VAIVASHY AWES NEW IDR as 1153 Tunterstate moer freight DR 28.319 Very Story good VC34 ty 3015657 See Bayi 30 Fest Man Bowl DOO SO For Styrelsel Zaxis es How NIA C209 2160 100 manting to this FC VES 70 V 13 3. Ray Kramer prepares a bank reconciliation on a separate working paper (not provided). After receiving the bank statement (Doc. No. 24) and list of items clearing with the bank statement (Doc. No. 25) from the bank, he performs the following procedures: Document No. 9 WAREN SPORTS SUPPLY CASH RECEIPTS PRELIST MONTH December Purpose Cash AR Sale Colomer CHECK or ACH Invoke Number Amount onvold Am Received C Date Description Dec 6 Gates University 2 Dec. 8 Rosemont University a Dec, 12 Hancock College 4 Dec. 14 Clayborn University Dec. 14 Atwood Brothers la da 16 Branch college DE 19 Fist American 13/Dec. 27 Easton wisconsin un. Dec. 27 Hawling college 589 100 40 1052 53 00 00 11096 14715 C-28 13507 727 28446 C-29 ACH 72.8 724 N/A LACH 730 PACH NA 149520729 4752 MA 5890.00 411400 53 000 12.52.00 N/A MUS NA 82.500 1 2 2 1 9006 12 000 SS- 37.221 S555- 10 12 3 45 10.30 107.33 41 11.00 20.50 5.00 Docum No.95 mbar 3120 TRA AD Inc WAREN SPORTS SUPPLY LIST OF ITEMS CLEARING WITH BANK STATEMENT DECEMBER 2022 ni Payee Amount . . CHECKS/ACH PAYMENTS Check/ACH Date Date Number Written Cleared 1137 11/30 12/5 1138 11/30 12/4 1139 11/30 12/4 1140 12/7 12/12 1141 12/12 12/15 E-53430 12/13 12/15 1143 12/13 12/15 12/13 12/19 1145 12/14 12/20 1146 12/14 12/20 1147 12/14 12/21 1148 12/14 12/21 1149 12/15 12/22 1150 12/15 12/21 1151 12/15 12/21 Ray Kramer Jim Adams Nar Ford First Security Insurance Chicago Office Supply Velocity Sporting Goods Board of Water and Light Interstate Motor Freight Internal Revenue Service Internal Revenue Service State of Illinois State of Illinois Ray Kramer Jim Adams Nancy Ford 2.765.38 1.797.23 786.70 575.00 7,367.00 35,392.70 1.360.25 778.75 3,066.32 10.30 60.96 590.86 2,765.38 1,740.90 1.297.32 DEPOSITS Date Deposited Date Recorded by Bank Amount 12/6 12/8 12/12 12/14 12/16 12/19 12/8 12/12 12/15 12/15 12/19 12/19 5,891.00 4,090.52 5,306,00 7,931.96 1,622.88 90,000.00 Vaud BANK AND TRUST COMPANY First American Statement of Account thi li tim vi vi Document No. 24 ST24 0003514 18 December 2022 1 Waren Sports Supply 1978 Michigan Avenue Chicago, Illinois 60612 FOR ABBASTANCE CALL 1-800-FAB-2064 OR WRITE CUSTOMER SERVICE PO BOX 28014 CHICAGO, ILLINOIS 60610 EPOSIT BALANCE FORWARE 77,087.72 MINIMUIMBALANCE 50.262.94 ENDING BALANCE 131.549.53 DEPOSTED ITEMS TOTAL.CACH AM TOTAL DE AMOUNT HTV Eig 60.355.05 114,842.36 25.50 AVERAGE BALANCE OF CECH NO OF DEPOSITS 96.940.76 15 CHECKING ACCOUNT ENTRIES CHECKSACHDEBITS CHECKLACHOCBITS DEPOSITSIGHEDITS November 30, 2022 Balance Forward Date eposited 126 DATE BALANCE 77,087.72 28 '12 4 1.797.23 786.70 2.765.38 4-Dec 5-Dec 8-Dec 12-Dec 15-Dec 74,503.79 71.738.41 77,629.41 81.144.93 ACH 35,392.70 575.00 7,367.00 1.360.25 778.75 5,891.00 4,090.52 5,306.00 7.931.96 1,622.88 90,000.00 50,262.94 19-Dec ACH EFT 20-Dec 21-Dec 141,107.07 138,030,45 A 3,066,32 60.96 1,740.90 2,765.38 10.30 1.297.32 590.86 134,340.41 131,575.03 22-Dec 30-Dec ACH-F S/C 20.50 5.00 131,549.53 December 31, 2022 Ending Balance 131,549.53 TRANSACTION CODE LEGEND DD - Direct Deposit DM-Debit Memo EFT - Electronic Funds Transfer NSF - NSF Fees 00 - Overdrawn Balance ACH. Automatic Clearing House Mom ACH-F - ACH lee CD-CD interest Deposit CM. Credit Memo PR - Payroll Deposit RT - Returned Item SC-Service Charge ATM TRANSACTIONS RA Credit Card Advance RI - Instalment Loan Pmt AD Envelope Deposit RO-Other Payment RC - Credit Card Payment RW - Cash Withdrawal RM. Mortgage Loan Pmt RS - Transfer to Savings RL - Money Matic Loan PF - Transfer From Savings CASH RECEIPTS JOURNAL can 411 WA The College Now Melam College Now Branch College Nawatan wan 11.00 NE NE NE 10 Soo 00 Al 40 410 AL 209.00 DO Mouth Total FC 101 115000 1161.00 5 4400 Auto 5200 1900 404 407 125200 ERIONICE DO 222222 doce Datenverty NE 100 Dee Resman University NE 4005 De Hancock College NE 53000 Dec 14 Cyborn University TOO De 14 Arwood Brothers 2900 braka 19 A NE 2 montin uw 2.1 cm 30 ways SV 30 cm Wanje NP 17- Seandaling Sorent As Solo MFHEN 30 Susan Callage M Del D HO 117009 15 SEE th SID D ON FE 569,740. CASH DISBURSEMENTS JOURNAL November CREDE Account Payable GIL 200 Purchase tuba Subs GL 10100 Trans Pos OIL 30700 AN Amount Rat 455 50 2.53 185.80 26832.40 5476 252 213000 O GIL R GALOG AR Check Date ACH No Description Nov. 124 Chicago Office Supply Nov I 1125 Velocily Sporting Goods Nov. 15 126-B Ser Payroll Journal Nov. 151124 Internal Revenue Service D R F 2.9742 Nov. 15 1190 Nov 15 1131 Internal Revenue Service State of Illinois 1000 C1982 Nov. 17 1192 Worldwide Management Nov. 17 1135 Board of Water & Light Nov. 17 1134 Interstate Motor Freight Nov. 17 1135 University Athletic News Nov. 23 113 Chicago Office Supply Nov. 301197-4 See Payroll Journal 480000 070365 2356 94 3 250 00 55804 7.0-300 14400 20100 14292 201400 1000 20400 551 20500 591 40100 A 80 000 41000 11635 235649 40200 3.2.5000 253 55804 5:47 00 2.8423.891 23569 1331439 Monthly Totals FC M405267 RK Cash Disbursements Journal continued on next page CASH DISBURSEMENTS JOURNAL December CREDIT DEM RPWL Subs Tran Post GAL os Tra 41000 ACHNO Dec 7 1140 First Security Det 1141 Chicago Office Supply Dec 13 54 Velocity Sporting Conds Dec 18 114 Worldwide Management Dec 12 114 Board of Wate Light Doc 1144 Interstate Moter Freight Dec 14 1145 Internal Revenue Service Cash BIL 100 1515.00 107.00 5210 A60.000 suola 1115 SUU 252 7210154 721001 15.00 A AS000 dag 10.15 209.00 1071,00 20100 2014 20600 10.10 20500 Lou 2.0400 540 1710 Dec 14 1146 Internal Revenue Service Dec 14 1030 State of Illinois Gol Dec 14 1145 State of Illinois 50 Dec 15 1149-51 5e Payroll Tournal IDE IS 2 Frost Security DEC 28 1155 VAIVASHY AWES NEW IDR as 1153 Tunterstate moer freight DR 28.319 Very Story good VC34 ty 3015657 See Bayi 30 Fest Man Bowl DOO SO For Styrelsel Zaxis es How NIA C209 2160 100 manting to this FC VES 70 V 13