70.2K

Verified Solution

Link Copied!

Melissa Jackson, bookkeeper for Kinko Company, cannot prepare a bank reconciliation. The bank statement

showed a $$2,955\mathrm{.}82$ balance. Melissa's checkbook showed a $$3,301\mathrm{.}82$ balance. Melissa placed a $$510\mathrm{.}19$

deposit in the bank's night depository on June $30.$ The deposit did not appear on the bank statement. The bank

included two DMs and one CM with the returned checks: $$690\mathrm{.}65$ DM for NSF check, $$8\mathrm{.}50$ DM for service

charges, and $$400\mathrm{.}00CM($less $$10\mathrm{.}00$ collection fee$)$ for collecting a $$400\mathrm{.}00$ non$-$interest$-$bearing note. Check

number $811$ for $$110\mathrm{.}94$ and check number $912$ for $$82\mathrm{.}50,$ both written and recorded on June $28,$ were not with

the returned checks. The bookkeeper had correctly written check number $884,$$$1,000\mathrm{.}00,$ for a new cash

register, but she recorded the check as $$1,069\mathrm{.}00.$ The May bank reconciliation showed check number $748$ for

$$210\mathrm{.}90$ and check number $710$ for $$195\mathrm{.}80$ outstanding on May $31.$ The June bank statement included check

number $710$ but not check number $748.$

Use the information above to compute Kinko's reconciled balances as of June $30,2024.$

Note: Use cells A$4$ to B$17$ from the given information to complete this question.

What is Kinko Company's reconciled checkbook balance?

What is the reconciled bank balance?

Must use correct excel formula to determine anwer.

Answer & Explanation Solved by verified expert

See Answer