I need help filling out a bank reconciliation. I have added the bank statement for the month of Dec 2022. the list of items clearing with the bank statement. Cash recipts preslist. and the cash recipts and cash disbursements jorunal. if you need anytbing else let me know I wil give a thunbs up
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 Sala Color Date CHECK or ACH Inv Number Amount of volte C 589 100 40 10 52 53 000 110696 Dec Gates University 2 Dec. 8 Rosemont University a Dec, 12 Hancock College 4 Dec. 14 Clayborn University Dec. 14 Atwood Brothers Dec 16 Branch college DC19 First American 13/Dec. 27 Eastern wisconsin Uni. 1./Dec. 27 Hawkins College 14715 L-28 13507 727 28496 C-24 ACH 72.8 724 N/A LACH 730 MACH NA 1493266 129 4752 NA 5841100 401400 53 00 00 72.52.00 N/A NUSO 37.221 s555 - 82.500 1 2 2 54 9006 1 2 0 0 0 S53S- 10 11 12 3 10.30 07.3 500.00 41 13.00 2010 5.00 Document No. 2 nber 3120 22283 WAREN SPORTS SUPPLY LIST OF ITEMS CLEARING WITH BANK STATEMENT DECEMBER 2022 CHECKS/ACH PAYMENTS Date Check/ACH Number Date Written Cleared Payee Asount 1137 1138 1139 1140 E-53430 1143 11/30 11/30 11/30 12/7 12/12 12/13 12/13 12/13 12/14 12/14 12/14 12/14 12/15 12/15 12/15 12/5 12/4 12/4 12/12 12/15 12/15 12/15 12/19 12/20 12/20 12/21 12/21 12/22 12/21 12/21 Ray Kramer Jim Adams Nancy 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 1145 1147 1148 1149 1150 1151 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 BANK AND TRUST COMPANY First American Statement of Account Document No. 24 1 of 1 0003514 18 December 2022 FOR ABBASTANCE CALL 1-800-F AD-2004 1 TIE Waren Sports Supply 1978 Michigan Avenue Chicago, Illinois 60612 OR WRITE CUSTOMER SERVICE P.O. BOX 28914 CHICAGO, ILLINOIS 60610 EPOSIT BALANCE FORWARE 77.087.72 MINIMUIM BALANCE 50.262.94 ERDANG BALANCE 131.549.53 DEPOSITED ITES Date eposited TOTAL CHACHA TOTAL DEPOT AMOUNT HIV tin 6035505 116.842.36 25.50 AVERAGE BALANCE OF CECH AD OF DEPORTS 96.940.76 15 CHECKING ACCOUNT ENTRIES CHECKIVACHDESITS CHECKMAHDLITS DEPOSITSICREDITS November 30, 2022 Balance Forward 12/6 DATE BALANCE 77,087.72 '12 4 ded 786.70 2.765.38 1.797.23 4-Dec 5-Dec 8-Dec 12-Dec 15-Dec 74,503.79 71.738.41 77,629.41 81.144.93 har ACH 575.00 7,367.00 1.360.25 778.75 35,392.70 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 141,107.07 138,030,45 20-Dec 21-Dec 3,066,32 60.96 1,740.90 2,765.38 10.30 1297.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 OD - Overdrawn Balance ACH- Automatic Clearing House em ACH- FACH fee CD-CD Interest Deposit CM. Credit Memo PR Payroll Deposit RT - Returned Item SC-Service Charge ATM TRANSACTIONS BA Credit Card Advance RI - Instalment Loan Pmt AD Envelope Deposit RO-Other Payment RC Credit Card Payment RW - Cash Withdrawal RM. Mortonge Loan Pmt RS - Transfer to Savings RL-Money-Matic Loan RF - Transfer From Savings CASH RECEIPTS JOURNAL caun th GE 781 2222 411 w The Long Now Meclame Name Now Branch College WA00 1.00 NE HE 150 rait Solo AA M40 410 219.00 0.00 Monty Totals FG 101 115000 116.00 F 5OD 4400 ALLA 100 4095 53000 TI 500 5200D 50 401 200 OLETE 10.00 De Cotes niversity NE Dee Remover NE De Hancock College NE Dec 14 Cybern University NE De 14 Alwood Brothers NE Bracar INF Fest Arad NE 27 monti NE D 2.1 cm M Der 30 USE 30 cm wage NP De 2500 doce CA HE 170.09 XX Se INTE ht TYRE Coastaly NO WOO 50 ore Arlos ME so strategi M Del My St. BEDIE 10 56974 CASH DISBURSEMENTS JOURNAL November 5 E O GIL Cash G/L 10100 1555 26832.40 Purchas Account PayableGL 100 tu Discount Post OIL 30700 AN Amet Ral 259 185 BD 541 o 252 2138000 A Check! ACHING Description Nov. 124 Chicago Office Supply Now 11 112.5 Velocity Sporting Goods Nov. 1512- See Payroll Journal Nov. 151124 Internal Revenue Service G 10 D Am Po RA F endir 2.976 42 .. Nov. 15 IFO Nov 15 1131 Internal Revenue Service State of Illinois 10.00 CU882 Nov. 17 192 Worldwide Management Nov. 17 1135 Board of Water & Light Nov. 17 1134 Interstate Motor Freight Nov. 17 1135 University Athletic News Nov. 23 173 Chicago Office Supply Nov. 30 1137-4 See Payroll Journal 4800.00 170365 2.35694 3 250 00 1558 04 7.0300 14400 20700 143242 2010 1000 20400 15518 20500 5914 40100 A 80 000 41000 1165 2.35640 402.00 32-5000 253 55809 547 60 2.8.923 89 1331934 Monthly Totals FC M405267 RK 235699 V Cash Disbursements Journal continued on next page CASH DISBURSEMENTS JOURNAL December CREDIT DET Tree Subs Post Tram Cho Da ACHING Dec De 7 11:40 Flest Security Det 1141 Chicage Office Supple Dec 5541 Velocity Sporting Goods Dec 17 114 Worldwide Management Dec 1142 Board of Water Light Doc 1144 Interstate Moter Fright Dec 14 1145 Internal Reve Service 4000 1515.00 Purch Cash BIL 0100 GA 515.00 70700 2.5 3510 72210254 A 60.000 25 11515 Bolum 72 10 15.00 A010 A8000 1055 20900 1037001 20700 2014 20.00 20500 LO 20400 5109 10.10 1145 Dec 14 1146 Internal Revenue Service Dec 14 1050 1147 State of Illinois Colt Dec 14 State of Illinois 59000 Dec. 15 1149-51 5e Payroll Journal DO 20 HS 2 Frost Sect 1210 Dec 28 1155 VAIVASHY AWESEN IDR as 1153 Teterstate moer freight DR 28.35 velocely Sterka) goods are 500147 Set Boy 30 Past Main Boul SO First serunty Trewnal lashel- L- end How ZS WIP C2520 D 2160 16:50 marting to this FC HAV VES 200 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 Sala Color Date CHECK or ACH Inv Number Amount of volte C 589 100 40 10 52 53 000 110696 Dec Gates University 2 Dec. 8 Rosemont University a Dec, 12 Hancock College 4 Dec. 14 Clayborn University Dec. 14 Atwood Brothers Dec 16 Branch college DC19 First American 13/Dec. 27 Eastern wisconsin Uni. 1./Dec. 27 Hawkins College 14715 L-28 13507 727 28496 C-24 ACH 72.8 724 N/A LACH 730 MACH NA 1493266 129 4752 NA 5841100 401400 53 00 00 72.52.00 N/A NUSO 37.221 s555 - 82.500 1 2 2 54 9006 1 2 0 0 0 S53S- 10 11 12 3 10.30 07.3 500.00 41 13.00 2010 5.00 Document No. 2 nber 3120 22283 WAREN SPORTS SUPPLY LIST OF ITEMS CLEARING WITH BANK STATEMENT DECEMBER 2022 CHECKS/ACH PAYMENTS Date Check/ACH Number Date Written Cleared Payee Asount 1137 1138 1139 1140 E-53430 1143 11/30 11/30 11/30 12/7 12/12 12/13 12/13 12/13 12/14 12/14 12/14 12/14 12/15 12/15 12/15 12/5 12/4 12/4 12/12 12/15 12/15 12/15 12/19 12/20 12/20 12/21 12/21 12/22 12/21 12/21 Ray Kramer Jim Adams Nancy 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 1145 1147 1148 1149 1150 1151 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 BANK AND TRUST COMPANY First American Statement of Account Document No. 24 1 of 1 0003514 18 December 2022 FOR ABBASTANCE CALL 1-800-F AD-2004 1 TIE Waren Sports Supply 1978 Michigan Avenue Chicago, Illinois 60612 OR WRITE CUSTOMER SERVICE P.O. BOX 28914 CHICAGO, ILLINOIS 60610 EPOSIT BALANCE FORWARE 77.087.72 MINIMUIM BALANCE 50.262.94 ERDANG BALANCE 131.549.53 DEPOSITED ITES Date eposited TOTAL CHACHA TOTAL DEPOT AMOUNT HIV tin 6035505 116.842.36 25.50 AVERAGE BALANCE OF CECH AD OF DEPORTS 96.940.76 15 CHECKING ACCOUNT ENTRIES CHECKIVACHDESITS CHECKMAHDLITS DEPOSITSICREDITS November 30, 2022 Balance Forward 12/6 DATE BALANCE 77,087.72 '12 4 ded 786.70 2.765.38 1.797.23 4-Dec 5-Dec 8-Dec 12-Dec 15-Dec 74,503.79 71.738.41 77,629.41 81.144.93 har ACH 575.00 7,367.00 1.360.25 778.75 35,392.70 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 141,107.07 138,030,45 20-Dec 21-Dec 3,066,32 60.96 1,740.90 2,765.38 10.30 1297.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 OD - Overdrawn Balance ACH- Automatic Clearing House em ACH- FACH fee CD-CD Interest Deposit CM. Credit Memo PR Payroll Deposit RT - Returned Item SC-Service Charge ATM TRANSACTIONS BA Credit Card Advance RI - Instalment Loan Pmt AD Envelope Deposit RO-Other Payment RC Credit Card Payment RW - Cash Withdrawal RM. Mortonge Loan Pmt RS - Transfer to Savings RL-Money-Matic Loan RF - Transfer From Savings CASH RECEIPTS JOURNAL caun th GE 781 2222 411 w The Long Now Meclame Name Now Branch College WA00 1.00 NE HE 150 rait Solo AA M40 410 219.00 0.00 Monty Totals FG 101 115000 116.00 F 5OD 4400 ALLA 100 4095 53000 TI 500 5200D 50 401 200 OLETE 10.00 De Cotes niversity NE Dee Remover NE De Hancock College NE Dec 14 Cybern University NE De 14 Alwood Brothers NE Bracar INF Fest Arad NE 27 monti NE D 2.1 cm M Der 30 USE 30 cm wage NP De 2500 doce CA HE 170.09 XX Se INTE ht TYRE Coastaly NO WOO 50 ore Arlos ME so strategi M Del My St. BEDIE 10 56974 CASH DISBURSEMENTS JOURNAL November 5 E O GIL Cash G/L 10100 1555 26832.40 Purchas Account PayableGL 100 tu Discount Post OIL 30700 AN Amet Ral 259 185 BD 541 o 252 2138000 A Check! ACHING Description Nov. 124 Chicago Office Supply Now 11 112.5 Velocity Sporting Goods Nov. 1512- See Payroll Journal Nov. 151124 Internal Revenue Service G 10 D Am Po RA F endir 2.976 42 .. Nov. 15 IFO Nov 15 1131 Internal Revenue Service State of Illinois 10.00 CU882 Nov. 17 192 Worldwide Management Nov. 17 1135 Board of Water & Light Nov. 17 1134 Interstate Motor Freight Nov. 17 1135 University Athletic News Nov. 23 173 Chicago Office Supply Nov. 30 1137-4 See Payroll Journal 4800.00 170365 2.35694 3 250 00 1558 04 7.0300 14400 20700 143242 2010 1000 20400 15518 20500 5914 40100 A 80 000 41000 1165 2.35640 402.00 32-5000 253 55809 547 60 2.8.923 89 1331934 Monthly Totals FC M405267 RK 235699 V Cash Disbursements Journal continued on next page CASH DISBURSEMENTS JOURNAL December CREDIT DET Tree Subs Post Tram Cho Da ACHING Dec De 7 11:40 Flest Security Det 1141 Chicage Office Supple Dec 5541 Velocity Sporting Goods Dec 17 114 Worldwide Management Dec 1142 Board of Water Light Doc 1144 Interstate Moter Fright Dec 14 1145 Internal Reve Service 4000 1515.00 Purch Cash BIL 0100 GA 515.00 70700 2.5 3510 72210254 A 60.000 25 11515 Bolum 72 10 15.00 A010 A8000 1055 20900 1037001 20700 2014 20.00 20500 LO 20400 5109 10.10 1145 Dec 14 1146 Internal Revenue Service Dec 14 1050 1147 State of Illinois Colt Dec 14 State of Illinois 59000 Dec. 15 1149-51 5e Payroll Journal DO 20 HS 2 Frost Sect 1210 Dec 28 1155 VAIVASHY AWESEN IDR as 1153 Teterstate moer freight DR 28.35 velocely Sterka) goods are 500147 Set Boy 30 Past Main Boul SO First serunty Trewnal lashel- L- end How ZS WIP C2520 D 2160 16:50 marting to this FC HAV VES 200 13
