The following information is available for Airborne, Inc. as of February $28,2023$:

a$.$ Cash on the books as of February $28$ amounted to $$22,754\mathrm{.}16.$ Cash on the bank statement for the same date was $$32,351\mathrm{.}46.$

b$.$ A deposit of $$3,344\mathrm{.}50,$ representing cash receipts of February $28,$ did not appear on the bank statement.

c$.$ Outstanding checks totaled $$3,936\mathrm{.}80.$

d$.$ A check for $$1,920\mathrm{.}00$ returned with the statement was recorded incorrectly in the check register as $$1,380\mathrm{.}00.$ The check was for a cash purchase of merchandise.

e$.$ The bank collected $$10,300\mathrm{.}00$ for Airborne, on a note. The face value of the note was $$10,000\mathrm{.}00.$

f$.$ The bank mistakenly charged to the company account a check for $$755\mathrm{.}00$ drawn by another company.

REQUIRED:

a$.$ Prepare in proper format the Bank Reconciliation for Airborne, Inc. as of February $28,2023.$

b$.$ Prepare in proper format the Journal Entries necessary to adjust the accounts as of February $28,2023.$

Instructions $($CEs$)$:

FORMAT: Must submit using an Excel worksheet. Dollar signs, commas, single lines, and double lines must be used when required.