I need help to filling out and do this Waren's month end procedure. SUA 10th edition.

MONTH-END PROCEDURES - After you have recorded all the transactions, go to page 12 of the Instructions and Flowcharts book and complete all the month-end procedures. An additional month-end requirement for this project is: Yes Monthly Statement- Prepare a monthly statement (Doc. No. 15) for Rosemont University. Document No. 15 Document No. 15 WAREN SPORTS SUPPLY PAGE PAGE EST 2002 1978 M2 STATEMENT REMITTANCE ADVICE DATE GUSTOMER NIMER DATE CUSTOMER NUBER PLEASE DETACH AND TURN THE STUD WITH YOUR REMITTANCE CUSTOMER NAME AND ADDRESS TERMS: 2/10, Net 30 AOLIN DAYS TO: WAREN SPORTS SUPPLY 1970 MICHIGAN AVENUE CHICAGO, IL 60612 WOICE NUMBER AMOUNT INVOICE NUMBER DATE AMOUNT DUE CURRENT 21.00 OVERS TOTAL DUE TOTAL CURRENT TOTAL 81-60 TOTAL 61.00 TOTAL OVER 50 TOTAL DUE REVIEWED BY WAREN'S MONTH-END PROCEDURES Following are the procedures performed at the end of each month by Waren's employees after all transactions are recorded in the journals and subsidiary ledgers. You are to assume the roles of Ray Kramer, Nancy Ford, and Jim Adams and perform each of these month- end procedures for December. The only materials needed are this list of seven month-end procedures, all journals and ledgers, and four items from the loose document set: blank monthly statement (Doc. No. 15), bank reconciliation for November (Doc. No. 23), December bank statement (Doc. No. 24), and the list of items clearing with the bank statement (Doc. No. 25). Set all other documents and records temporarily aside. 1. Jim Adams foots and crossfoots each of the five special journals (sales, cash receipts, purchases, cash disbursements, and payroll). He uses the following symbols in the special journals to indicate that his work has been performed: F for Footing and C for Cross-footing 2. Jim Adams posts the column totals and individual transactions in "Other" columns to the appropriate general ledger account and updates each general ledger account balance. He places a posting reference check mark | under each column total in the journals and by each of the individual transactions in the "Other" columns to show that the numbers have been posted. 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: a. Traces and agrees the monthly totals from the cash account columns of the cash receipts and cash disbursements journals and the net pay column of the payroll journal to the posting in the general ledger cash account. He initials the cash account (net pay) column totals in the journals, as well as the general ledger lines where the totals are posted. b. Compares each entry in the cash receipts prelist (Doc. No. 9) to the cash receipts journal for name, date, and amount, and puts a check mark [] by each entry in the prelist. 12 c. Prepares a bank reconciliation using the procedures outlined in the Systems Understanding Aid Reference book on pages 62 through 65. You can also use November's bank reconciliation (Doc. No. 23) as a model. Any deposits in transit and outstanding checks at November 30 are listed there. d. Adjusts the cash general ledger account using the general journal, regardless of materiality, for all reconciling items requiring an adjustment. e Attaches together and files the bank reconciliation, bank statement, list of items clearing with bank statement, and the cash receipts prelist in the file labeled "Shipping/Banking." 4. Jim Adams calculates and records the unemployment taxes paid by employers, and Waren's portion of the FICA payroll tax. These payroll taxes are calculated at the end of the month on gross payroll and recorded in the general journal. The taxes are paid the following month State and federal unemployment taxes are imposed on the first $7,000 of wages paid to covered employees in 2022. Thus, a review of the employee earnings subsidiary ledger on pages 19 through 21 of the Ledgers book indicates that only one of Waren's employees remains subject to this tax (ie, has not yet exceeded the wage base maximum). The same wage base maximum is used in the project for both state and federal unemployment taxes to simplify the calculations The state unemployment tax (SUTA) rate is 3.55%. Because employers are allowed credits against the federal unemployment tax (FUTA) rate for participation in state unemployment programs, the net FUTA rate is 6% 5. General Journal: Ray Kramer approves all monthly general journal entries and places his initials in the Approval column. Next, Jim Adams posts transactions from the general journal to the general ledger (and subsidiary if applicable), places a posting reference check mark in the general journal post reference column for each item posted, and updates each general ledger balance. 6. Nancy Ford foots the balances of each subsidiary for the accounts receivable accounts payable, employee earnings, and fixed assets subsidiaries and compares the total to the appropriate general ledger control account (G/L accounts 10200, 20100, 40500, 10800, and 10900, respectively). She initials each general ledger control account to indicate that she has made the comparison 7. Jim Adams prepares a monthly statement (Doc. No. 15) for each customer with a balance. He includes information about each unpaid invoice including its aging status. Aging totals and the total amount due are shown at the bottom. He completes the remittance advice (attached to the monthly statement in a similar fashion except that no aging is included. Ray Kramer reviews each statement and initials it before it is mailed to the customer. In this project, you are to prepare a December monthly statement for only one customer and file it in the "Mailed to Outsiders file tab. The name of the selected customer is stated in the transactions list (Doc. No. 1) provided with your loose document set in this package After completing all seven month-end procedures for December continue to the next section and perform Waren's year-end procedures 13 Document No. 25 WAREN SPORTS SUPPLY LIST OF ITEMS CLEARING WITH BANK STATEMENT DECEMBER 2022 CHECKS/ACH PAYMENTS Check/ACH Number Date Written Date Cleared Payee Amount 1137 1138 1139 1140 1141 E-33430 1143 1144 1145 1146 1147 1148 1149 1150 1151 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/5 12/4 12/4 12/12 12/15 12/13 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 $75.00 7.367.00 35.392.70 1,360.25 778.75 3,06632 10.30 60.96 590.86 2.765 35 1.740.90 1.297.32 12/15 12/15 12/15 DEPOSITS Date Deposited Amount 12/6 12/8 12/12 12/14 12/16 Date Recorded by Bank 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 12/19 Document No. 24 Statement of Account First American BANK AND TRUST COMPANY Chicago, Illino PAGE NO 1 of 1 ACCOUNT NUMBER 000334 18 MONTH December 2022 FOR ASSISTANCE CALL 1-800-FAB-2864 Waren Sports Supply 1978 Michigan Avenue Chicago, Illinois 60612 OR WRITE: CUSTOMER SERVICE P.O. BOX 28914 CHICAGO, ILLINOIS 60610 BALANCE FORWARD 77,087.72 MINIMUM BALANCE 50.262.94 ENCING BALANCE 131,549.53 DEPOSITED ITEMS TOTAL CIACH AUT TOTAL DEPOSIT AMOUNT ACTIC 60,355.05 114.842.36 25.50 AVERAGE BALANCE OF CKACH NO OF DEPOSITS 96.940.76 15 6 CHECKING ACCOUNT ENTRIES CHECKS/ACH DEBITS CHECKS/ACH DEBITS DEPOSITSCREDITS November 30, 2022 Balance Forward DATE BALANCE 77,087.72 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 575.00 7,367.00 1.360.25 778.75 ACH 35,392.70 5.891.00 4,090 52 5,306 00 7,931.96 ACH 1.62288 EFT 90,000.00 50.262.94 19-Dec 141,107.07 138,030.45 20-Dec 21-Dec 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 SIC 20.50 5.00 131,549 53 December 31, 2022 Ending Balance 131,549.53 TRANSACTION CODE LEGEND DO-Drect Deposit DM. Debit Memo EFT-Electronic Funds Tanger NSF - NSF Fees OD-Overdrawne ACH - Automatic Clearing Househem ACH- FACH 1 CD-CD interest Deposit CM-Credit Memo PA - Paprile RT-medlem SC-Service Charge ATM TRANSACTIONS RA-Dret Card Adam Rent Loan RD.Epe Depes RO-One Payment RC-Cars Part RwCash Wiedra RM. Mortgage len RS-Transfer Saving RL Money Loo RF Transfer from Swing ar Document No. 23 Waren Sports Supply Bank Reconciliation November 2022 Bank Statement General Ledger Unadjusted balance, 11-30-22 S 77,087.72 S 69.774.20 Add: Deposits in transit 0.00 Deduct: Outstanding checks #1118 1.985.21 #1137 2,765.38 #1138 1,797.23 #1139 786.70 (7.334.52) Adjustments: Bank fees/service charges (21.00) Adjusted balance, 11-30-22 $ 69.753.20 $ 69,753.20 Journal Entry, 11-30-22 Debit Credit Account No. S21.00 41000 10100 Other operating expense Cash S21.00 MONTH-END PROCEDURES - After you have recorded all the transactions, go to page 12 of the Instructions and Flowcharts book and complete all the month-end procedures. An additional month-end requirement for this project is: Yes Monthly Statement- Prepare a monthly statement (Doc. No. 15) for Rosemont University. Document No. 15 Document No. 15 WAREN SPORTS SUPPLY PAGE PAGE EST 2002 1978 M2 STATEMENT REMITTANCE ADVICE DATE GUSTOMER NIMER DATE CUSTOMER NUBER PLEASE DETACH AND TURN THE STUD WITH YOUR REMITTANCE CUSTOMER NAME AND ADDRESS TERMS: 2/10, Net 30 AOLIN DAYS TO: WAREN SPORTS SUPPLY 1970 MICHIGAN AVENUE CHICAGO, IL 60612 WOICE NUMBER AMOUNT INVOICE NUMBER DATE AMOUNT DUE CURRENT 21.00 OVERS TOTAL DUE TOTAL CURRENT TOTAL 81-60 TOTAL 61.00 TOTAL OVER 50 TOTAL DUE REVIEWED BY WAREN'S MONTH-END PROCEDURES Following are the procedures performed at the end of each month by Waren's employees after all transactions are recorded in the journals and subsidiary ledgers. You are to assume the roles of Ray Kramer, Nancy Ford, and Jim Adams and perform each of these month- end procedures for December. The only materials needed are this list of seven month-end procedures, all journals and ledgers, and four items from the loose document set: blank monthly statement (Doc. No. 15), bank reconciliation for November (Doc. No. 23), December bank statement (Doc. No. 24), and the list of items clearing with the bank statement (Doc. No. 25). Set all other documents and records temporarily aside. 1. Jim Adams foots and crossfoots each of the five special journals (sales, cash receipts, purchases, cash disbursements, and payroll). He uses the following symbols in the special journals to indicate that his work has been performed: F for Footing and C for Cross-footing 2. Jim Adams posts the column totals and individual transactions in "Other" columns to the appropriate general ledger account and updates each general ledger account balance. He places a posting reference check mark | under each column total in the journals and by each of the individual transactions in the "Other" columns to show that the numbers have been posted. 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: a. Traces and agrees the monthly totals from the cash account columns of the cash receipts and cash disbursements journals and the net pay column of the payroll journal to the posting in the general ledger cash account. He initials the cash account (net pay) column totals in the journals, as well as the general ledger lines where the totals are posted. b. Compares each entry in the cash receipts prelist (Doc. No. 9) to the cash receipts journal for name, date, and amount, and puts a check mark [] by each entry in the prelist. 12 c. Prepares a bank reconciliation using the procedures outlined in the Systems Understanding Aid Reference book on pages 62 through 65. You can also use November's bank reconciliation (Doc. No. 23) as a model. Any deposits in transit and outstanding checks at November 30 are listed there. d. Adjusts the cash general ledger account using the general journal, regardless of materiality, for all reconciling items requiring an adjustment. e Attaches together and files the bank reconciliation, bank statement, list of items clearing with bank statement, and the cash receipts prelist in the file labeled "Shipping/Banking." 4. Jim Adams calculates and records the unemployment taxes paid by employers, and Waren's portion of the FICA payroll tax. These payroll taxes are calculated at the end of the month on gross payroll and recorded in the general journal. The taxes are paid the following month State and federal unemployment taxes are imposed on the first $7,000 of wages paid to covered employees in 2022. Thus, a review of the employee earnings subsidiary ledger on pages 19 through 21 of the Ledgers book indicates that only one of Waren's employees remains subject to this tax (ie, has not yet exceeded the wage base maximum). The same wage base maximum is used in the project for both state and federal unemployment taxes to simplify the calculations The state unemployment tax (SUTA) rate is 3.55%. Because employers are allowed credits against the federal unemployment tax (FUTA) rate for participation in state unemployment programs, the net FUTA rate is 6% 5. General Journal: Ray Kramer approves all monthly general journal entries and places his initials in the Approval column. Next, Jim Adams posts transactions from the general journal to the general ledger (and subsidiary if applicable), places a posting reference check mark in the general journal post reference column for each item posted, and updates each general ledger balance. 6. Nancy Ford foots the balances of each subsidiary for the accounts receivable accounts payable, employee earnings, and fixed assets subsidiaries and compares the total to the appropriate general ledger control account (G/L accounts 10200, 20100, 40500, 10800, and 10900, respectively). She initials each general ledger control account to indicate that she has made the comparison 7. Jim Adams prepares a monthly statement (Doc. No. 15) for each customer with a balance. He includes information about each unpaid invoice including its aging status. Aging totals and the total amount due are shown at the bottom. He completes the remittance advice (attached to the monthly statement in a similar fashion except that no aging is included. Ray Kramer reviews each statement and initials it before it is mailed to the customer. In this project, you are to prepare a December monthly statement for only one customer and file it in the "Mailed to Outsiders file tab. The name of the selected customer is stated in the transactions list (Doc. No. 1) provided with your loose document set in this package After completing all seven month-end procedures for December continue to the next section and perform Waren's year-end procedures 13 Document No. 25 WAREN SPORTS SUPPLY LIST OF ITEMS CLEARING WITH BANK STATEMENT DECEMBER 2022 CHECKS/ACH PAYMENTS Check/ACH Number Date Written Date Cleared Payee Amount 1137 1138 1139 1140 1141 E-33430 1143 1144 1145 1146 1147 1148 1149 1150 1151 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/5 12/4 12/4 12/12 12/15 12/13 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 $75.00 7.367.00 35.392.70 1,360.25 778.75 3,06632 10.30 60.96 590.86 2.765 35 1.740.90 1.297.32 12/15 12/15 12/15 DEPOSITS Date Deposited Amount 12/6 12/8 12/12 12/14 12/16 Date Recorded by Bank 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 12/19 Document No. 24 Statement of Account First American BANK AND TRUST COMPANY Chicago, Illino PAGE NO 1 of 1 ACCOUNT NUMBER 000334 18 MONTH December 2022 FOR ASSISTANCE CALL 1-800-FAB-2864 Waren Sports Supply 1978 Michigan Avenue Chicago, Illinois 60612 OR WRITE: CUSTOMER SERVICE P.O. BOX 28914 CHICAGO, ILLINOIS 60610 BALANCE FORWARD 77,087.72 MINIMUM BALANCE 50.262.94 ENCING BALANCE 131,549.53 DEPOSITED ITEMS TOTAL CIACH AUT TOTAL DEPOSIT AMOUNT ACTIC 60,355.05 114.842.36 25.50 AVERAGE BALANCE OF CKACH NO OF DEPOSITS 96.940.76 15 6 CHECKING ACCOUNT ENTRIES CHECKS/ACH DEBITS CHECKS/ACH DEBITS DEPOSITSCREDITS November 30, 2022 Balance Forward DATE BALANCE 77,087.72 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 575.00 7,367.00 1.360.25 778.75 ACH 35,392.70 5.891.00 4,090 52 5,306 00 7,931.96 ACH 1.62288 EFT 90,000.00 50.262.94 19-Dec 141,107.07 138,030.45 20-Dec 21-Dec 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 SIC 20.50 5.00 131,549 53 December 31, 2022 Ending Balance 131,549.53 TRANSACTION CODE LEGEND DO-Drect Deposit DM. Debit Memo EFT-Electronic Funds Tanger NSF - NSF Fees OD-Overdrawne ACH - Automatic Clearing Househem ACH- FACH 1 CD-CD interest Deposit CM-Credit Memo PA - Paprile RT-medlem SC-Service Charge ATM TRANSACTIONS RA-Dret Card Adam Rent Loan RD.Epe Depes RO-One Payment RC-Cars Part RwCash Wiedra RM. Mortgage len RS-Transfer Saving RL Money Loo RF Transfer from Swing ar Document No. 23 Waren Sports Supply Bank Reconciliation November 2022 Bank Statement General Ledger Unadjusted balance, 11-30-22 S 77,087.72 S 69.774.20 Add: Deposits in transit 0.00 Deduct: Outstanding checks #1118 1.985.21 #1137 2,765.38 #1138 1,797.23 #1139 786.70 (7.334.52) Adjustments: Bank fees/service charges (21.00) Adjusted balance, 11-30-22 $ 69.753.20 $ 69,753.20 Journal Entry, 11-30-22 Debit Credit Account No. S21.00 41000 10100 Other operating expense Cash S21.00