Based on the information for Mansouri Inc. below, $(1)$ prepare a bank reconciliation using Excel

and $(2)$ prepare the necessary adjusting journal entries in good form as of January $31,2024$:

a$.$ B$$lance per bank statement at January $31,2024-$ $$7,349\mathrm{.}46$

b$.$ Balance per books $-$$$5,432\mathrm{.}76$

c$.$ Outstanding check $-$$$2,131\mathrm{.}85$

d$.$ Deposit in transit not recorded by bank $-$ $$1,243\mathrm{.}15$

e$.$ Note collected by bank $-$ $$1,015$ including $$15$ in interest

f$.$ A check for $$46$ for supplies was erroneously entered as $$64$

g$.$ Bank service charges not entered $-$ $$5$

INSTRUCTIONS:

$-$This assignment MUST be completed using an Excel spreadsheet. Use of formulas is required

along with proper spelling and cell formatting. Save a copy to your computer or flash drive.

$-$Prepare this as though you were doing it for your job including a proper heading.

$-$If you have questions on format, refer to exhibits in your e$-$text.

$-$Upload your completed assignment to Blackboard. Do not email it to me$.$ Reminder, late work

will not be accepted.

$-$If I find you've used an online solution, you will receive a zero. This violates academic integrity

policies at NDSU.