Create a bank reconciliation ASAP for December using the following information.

Here is November's bank reconciliation as an example of how to do December's

Statement of Account PAGE NO. 1 of 1 ACCOUNT NUMBER 000334 18 Waren Sports Supply 1978 Michigan Avenue Chicago, Illinois 60612 TOTAL CK/ACH AMT 60.355.05 AVERAGE BALANCE 96,940.76 CHECKS/ACH/DEBITS 786.70 2,765.38 575.00 7,367.00 1,360.25 778.75 3,066.32 60.96 1,740.90 2,765.38 TRANSACTION CODE LEGEND DD Direct Deposit DM-Debit Memo EFT-Electronic Funds Transfer NSF NSF Fees OD-Overdrawn Balance BALANCE FORWARD 77,087.72 MINIMUM BALANCE 50,262.94 DATE 4-Dec 5-Dec 8-Dec 12-Dec 15-Dec 19-Dec 20-Dec 21-Dec 22-Dec 30-Dec ACH-Automatic Clearing House Item ACH-F-ACH fee CD-CD Interest Deposit CM-Credit Memo First American BANK AND TRUST COMPANY Chicago, Illinois 60603 MONTH December 2022 ACH FEE/SERV CHO TOTAL DEPOSIT AMOUNT 114,842.36 25.50 OF CK/ACH NO. OF DEPOSITS 6 15 CHECKING ACCOUNT ENTRIES CHECKS/ACH/DEBITS DEPOSITS/CREDITS November 30, 2022 Balance Forward 1,797.23 5,891.00 4,090.52 ACH 35,392.70 5,306.00 7,931.96 ACH 1,622.88 EFT 90,000.00 10.30 1,297.32 590.86 20.50 5.00 December 31, 2022 Ending Balance RA-Credit Card Advance RD-Envelope Deposit RC-Credit Card Payment RM-Mortgage Loan Pmt RL-Money-Matic Loan ACH-F S/C PR-Payroll Deposit RT-Returned Item SC-Service Charge FOR ASSISTANCE: CALL 1-800-FAB-2864 OR WRITE: CUSTOMER SERVICE P.O. BOX 28914 CHICAGO, ILLINOIS 60610 ENDING BALANCE 131,549.53 DEPOSITED ITEMS 7 BALANCE 77,087.72 74,503.79 71,738.41 77,629.41 81,144.93 50,262.94 141,107.07 138,030.45 134,340.41 131,575.03 131,549.53 131,549.53 RI-Instaliment Loan Pret RO-Other Payment RW-Cash Withdrawal RS-Transfer to Savings RF-Transfer From Savings ATM TRANSACTIONS WAREN SPORTS SUPPLY LIST OF ITEMS CLEARING WITH BANK STATEMENT DECEMBER 2022 Payee 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 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 1144 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 DEPOSITS Date Date Recorded Deposited by Bank Amount 12/6 12/8 5,891.00 12/8 12/12 4,090.52 12/12 12/15 5.306.00 12/14 12/15 7,931.96 12/16 12/19 1,622.88 12/19 12/19 90,000.00 Amount 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 Waren Sports Supply Bank Reconciliation November 2022 Bank Statement S 77,087.72 0.00 (7,334.52) $ 69,753.20 Unadjusted balance, 11-30-22 Add: Deposits in transit Deduct: Outstanding checks # 1118 1,985.21 #1137 2,765.38 #1138 1,797.23 # 1139 786.70 Bank fees/service charges Adjustments: Adjusted balance, 11-30-22 Journal Entry, 11-30-22 Account No. 41000 Other operating expense Cash 10100 Debit $ 21.00 General Ledger $ 69,774.20 (21.00) $ 69,753.20 Credit $21.00 In Statement of Account PAGE NO. 1 of 1 ACCOUNT NUMBER 000334 18 Waren Sports Supply 1978 Michigan Avenue Chicago, Illinois 60612 TOTAL CK/ACH AMT 60.355.05 AVERAGE BALANCE 96,940.76 CHECKS/ACH/DEBITS 786.70 2,765.38 575.00 7,367.00 1,360.25 778.75 3,066.32 60.96 1,740.90 2,765.38 TRANSACTION CODE LEGEND DD Direct Deposit DM-Debit Memo EFT-Electronic Funds Transfer NSF NSF Fees OD-Overdrawn Balance BALANCE FORWARD 77,087.72 MINIMUM BALANCE 50,262.94 DATE 4-Dec 5-Dec 8-Dec 12-Dec 15-Dec 19-Dec 20-Dec 21-Dec 22-Dec 30-Dec ACH-Automatic Clearing House Item ACH-F-ACH fee CD-CD Interest Deposit CM-Credit Memo First American BANK AND TRUST COMPANY Chicago, Illinois 60603 MONTH December 2022 ACH FEE/SERV CHO TOTAL DEPOSIT AMOUNT 114,842.36 25.50 OF CK/ACH NO. OF DEPOSITS 6 15 CHECKING ACCOUNT ENTRIES CHECKS/ACH/DEBITS DEPOSITS/CREDITS November 30, 2022 Balance Forward 1,797.23 5,891.00 4,090.52 ACH 35,392.70 5,306.00 7,931.96 ACH 1,622.88 EFT 90,000.00 10.30 1,297.32 590.86 20.50 5.00 December 31, 2022 Ending Balance RA-Credit Card Advance RD-Envelope Deposit RC-Credit Card Payment RM-Mortgage Loan Pmt RL-Money-Matic Loan ACH-F S/C PR-Payroll Deposit RT-Returned Item SC-Service Charge FOR ASSISTANCE: CALL 1-800-FAB-2864 OR WRITE: CUSTOMER SERVICE P.O. BOX 28914 CHICAGO, ILLINOIS 60610 ENDING BALANCE 131,549.53 DEPOSITED ITEMS 7 BALANCE 77,087.72 74,503.79 71,738.41 77,629.41 81,144.93 50,262.94 141,107.07 138,030.45 134,340.41 131,575.03 131,549.53 131,549.53 RI-Instaliment Loan Pret RO-Other Payment RW-Cash Withdrawal RS-Transfer to Savings RF-Transfer From Savings ATM TRANSACTIONS WAREN SPORTS SUPPLY LIST OF ITEMS CLEARING WITH BANK STATEMENT DECEMBER 2022 Payee 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 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 1144 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 DEPOSITS Date Date Recorded Deposited by Bank Amount 12/6 12/8 5,891.00 12/8 12/12 4,090.52 12/12 12/15 5.306.00 12/14 12/15 7,931.96 12/16 12/19 1,622.88 12/19 12/19 90,000.00 Amount 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 Waren Sports Supply Bank Reconciliation November 2022 Bank Statement S 77,087.72 0.00 (7,334.52) $ 69,753.20 Unadjusted balance, 11-30-22 Add: Deposits in transit Deduct: Outstanding checks # 1118 1,985.21 #1137 2,765.38 #1138 1,797.23 # 1139 786.70 Bank fees/service charges Adjustments: Adjusted balance, 11-30-22 Journal Entry, 11-30-22 Account No. 41000 Other operating expense Cash 10100 Debit $ 21.00 General Ledger $ 69,774.20 (21.00) $ 69,753.20 Credit $21.00 In