Please see attchments.
Wilson Company 2007© BrainMass Inc. brainmass.com June 4, 2020, 1:24 am ad1c9bdddf
The solution is provided in Excel in a format that matches the templates given in the problem.
There are two tabs in Excel.
First tab: Wilson Company
Balance per Checkbook - December 31 2,041.85 Balance per bank - December 31 2,055.40
Unrecorded NSF check (81.00)
The bank reconcilation has been prepared in Excel together with the journal entries required to complete the monthly activity.