Spielberg Company's general ledger shows a checking account balance of $22,830 on July 31, 2021. The July cash receipts of $1.745. 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 $41. 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,320. The bank statement shows a balance of $22,364 on July 31. Required: 1. Prepare a bank reconciliation to calculate the correct ending balance of cash on July 31, 2021. (Amounts to be deducted should be indicated with a minus sign.) SPIELBERG COMPANY Bank Reconciliation July 31, 2021 Bank's Cash Balance Company's Cash Balance Per Bank Statement $ 22,364 Per General Ledger 22,830 Deposits Outstanding 1,745 Service Fees (41) Checks Outstanding (1,320) $ Bank Balance per Reconciliation 5 22.780 Company Balance per Reconciliation $ 22,789 2. Record the necessary entrydes) 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 lit View journal entry worksheet Date July 31, 2021 No Joumal Entry Required No General Journal Debit Credit T.L. Jones Trucking Services establishes a petty cash fund on April 3 for $450. By the end of April, the fund has a cash balance of $371. The company has also issued a credit card and authorized its office manager to make purchases. Expenditures for the month include the following items: Utilities (credit card) Entertainment (petty cash) Stamps (petty cash) Plumbing repair services (credit card) $123 32 47 218 Required: 1. Record the establishment of the petty cash fund on April 3. 2. Record credit card expenditures during the month. The credit card balance is paid in full on April 30. 3. Record petty cash expenditures during the month. (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 2 3 1 Record the establishment of the petty cash fund on April 3. Note: Enter debits before credits General Journal Date April 03 Debit Credit Record entry Clear entry View general journal T. L. Jones Trucking Services establishes a petty cash fund on April 3 for $450. By the end of April, the fund has a cash balance of $371. The company has also issued a credit card and authorized its office manager to make purchases. Expenditures for the month include the following items: Utilities (credit card) Entertainment (petty cash) Stamps (petty cash) Plumbing repair services (credit card) $123 32 47 218 Required: 1. Record the establishment of the petty cash fund on April 3. 2. Record credit card expenditures during the month. The credit card balance is paid in full on April 30. 3. Record petty cash expenditures during the month. (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 3 > Record credit card expenditures during the month. The credit card balance is paid in full on April 30. Note: Enter debits before credits General Journal Date April 30 Debit Credit Record entry Clear entry View general Journal B T. L. Jones Trucking Services establishes a petty cash fund on April 3 for $450. By the end of April, the fund has a cash balance of $371. The company has also issued a credit card and authorized its office manager to make purchases. Expenditures for the month include the following items: Utilities (credit card) Entertainment (petty cash) Stamps (petty cash) Plumbing repair services (credit card) $123 32 47 218 bok int Required: 1. Record the establishment of the petty cash fund on April 3. 2. Record credit card expenditures during the month. The credit card balance is paid in full on April 30. 3. Record petty cash expenditures during the month. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) int ences View transaction list Journal entry worksheet