How can I put this information in an excel sheet?

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

a.Cash on the books as of February 28 amounted to$22,754.16.Cash on the bank statement for the same date was$32,351.46.

b.A deposit of$3,344.50, representing cash receipts of February 28, did not appear on the bank statement.

c.Outstanding checks totaled$3,936.80.

d.A check for$1,920.00returned with the statement was recorded incorrectly in the check register as$1,380.00. The check was for a cash purchase of merchandise.

e.The bank collected$10,300.00for Airborne, on a note. The face value of the note was$10,000.00.

f.The bank mistakenly charged to the company account a check for$755.00drawn by another company.

REQUIRED:

1. Prepare in a proper format theBank Reconciliationfor Airborne, Inc. as of February 28, 2021.
2. Prepare in proper format theJournal Entriesnecessary to adjust the accounts as of February 28, 2021.

Airborne Inc

Bank Reconciliation

February 28, 2021

Bank :

Bank statement balance

$32,351.46

Add : Deposit in transit

$3,344.50

Less : Outstanding checks

$3,936.80

Add : Bank error

$755

Adjusted Bank balance

$32,514.16

Books :

Balance as per books

$22,754.16

Add : Note collection

$10,300

Less : Book error

$540

Adjusted Book balance

$32,514.16

Requirement 2

Date

Account Titles and explanations

Debit

Credit

February 28, 2021

Cash

$10,300

Notes receivable

$10,000

Interest income

$300

(To record note collected by bank)

February 28, 2021

Merchandise inventory

$540

Cash

$540

(To correct recording error)