Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please please help Loni Anders of Wilderness Associates is getting ready to prepare the October bank reconciliation. The cach balance on the books of Widerness

Please please help image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Loni Anders of Wilderness Associates is getting ready to prepare the October bank reconciliation. The cach balance on the books of Widerness Associates on October 31 is $3,546. Lori reviews the bank statement, and notes the cash balance at October 31 of $2,445. The bank statement also reveals that the bank collected a note receivable on behalf of Widerness Associates - the principal was $1,500 and the interest was $15. One customer's check for $29 was returned by the bank for insutficient funds. Two additional items on the bank statement were the monthly EFT for the utilities, 5250 , and the bank service fee of $12. Lori notes that the cash deposit made on October 31 of $3,300 does not appear on the statement, and that three checks totaling $975 had not deated the bank account when the bankstatement was prepared. Use the blue shoded arear an the ENTERANSWERS tob for inputs. Aways use cell references and formulas where approptiate to recelve full credit. If you copy/paste from the instructions tab you will be marked wrong. Hequirements 1 Prepare the bank reconcliation for Widerness Assoclates at October 31, 2018. a. Format appropriate cells with dollar sitns, underlines, and double undertines. b. Use Excel formulas to calculate subtotals and totals. 6. Enter all amounts as positive values. Do not use a minus sign of parentheses for any values to be subtracted

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Cost Accounting

Authors: Don R. Hansen, Maryanne Mowen, Liming Guan, Mowen/Hansen

1st International Edition

0538749636, 978-0538749633

More Books

Students also viewed these Accounting questions

Question

What are the three types of authority noted by Max Weber?

Answered: 1 week ago