I need the solutions to this problem.

1 Spielberg Company's general ledger shows a checking account balance of $22.970 on July 31, 2021. The July cash receipts of $1885. included in the general ledger balance, are placed in the night depository at the bank on July 31 and processed by the bank on August 1. The bank statement dated July 31 shows bank service fees of $55. The bank processes all checks written by the company by July 31 and lists them on the bank statement, except for one check totaling $1.460. The bank statement shows a balance of $22.490 on July 31 10 points Required: 1. Prepare a bank reconciliation to calculate the correct ending balancelor cash on July 31, 2021. (Amounts to be deducted should be Indicated with a minus sign.) BOOK SPIELBERG COMPANY Bank Reconciliation July 31, 2021 Company's Cash Balance Per General Ledger Bank's Cash Balance Per Bank Statement Part References Sark Salance per Reconciliation Company Balance per Reconciliation 2. Record the necessary entry(es) to adjust the balance for cash. (If no entry is required for a transaction/event, select "No Journal Entry Required in the first account feld.) View traction list Journal entry worksheet 1 2 Record the amounts that increase cash. Date General Journal Debit Credit July 31, 2021 2 Record the necessary entry(ies) to adjust the balance for cash. (If no entry is required for a transaction/event, select "No Journal Entry Required" In the first account field.) View transaction list Journal entry worksheet 1 2 Record the amounts that decrease cash. Note Edebits before credits Date General Journal Debit Credit July 31.2021 Record entry Clear entry View general journal