Question

Requirements Prepare the bank reconciliation for Wilderness Associates at October 31, 2018. a. Format appropriate cells with
Internal Control and Cash Using Excel for a Bank Reconciliation Lorl Anders of Wilderness Associates is getting ready to prep
image.png
image.png
0 0
Add a comment Improve this question Transcribed image text
Answer #1
WILDERNESS ASSOCIATES
BANK RECONCILIATION STATEMENT
OCT 31,2018
BANK:
ENDING BALANCE $   2,445
ADD:  
UTILITIES $       250
SERVICE CHARGES $         12
DEPOSIT NOT RECEIVED IN BANK $   3,300
CHECK RETURN $         29
$   3,591
LESS:
NOTE RECEIVABLE $ (1,500)
INTEREST   $       (15)
CHECK NOT CLEARED $     (975)
$ (2,490)
BOOKS ENDING BALANCE $   3,546
BOOK:
ENDING BALANCE $   3,546
ADD:  
NOTE RECEIVABLE $   1,500
INTEREST   $         15
CHECK NOT CLEARED $       975
$   2,490
LESS:  
UTILITIES $     (250)
SERVICE CHARGES $       (12)
DEPOSIT NOT RECEIVED IN BANK $ (3,300)
CHECK RETURN $       (29)
$ (3,591)
BANK ENDING BALANCE $   2,445
DATE ACCOUNT EXPLANATION DEBIT CREDIT
31-10-18 BANK $     250
UTILITIES $     250
31-10-18 BANK $        12
SERVICE CHARGES $        12
31-10-18 BANK $ 3,300
DEPOSIT $ 3,300
31-10-18 BANK $        29
CHECK   $        29
31-10-18 NOTE RECEIVABLE $ 1,500
BANK $ 1,500
31-10-18 INTEREST $        15
BANK $        15
31-10-18 CHECK $     975
BANK $     975
Add a comment
Know the answer?
Add Answer to:
Requirements Prepare the bank reconciliation for Wilderness Associates at October 31, 2018. a. Format appropriate cells...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Mostly stuck around the first part Internal Control and Cash Using Excel for a Bank Reconciliation...

    Mostly stuck around the first part Internal Control and Cash Using Excel for a Bank Reconciliation Lori Anders of Wilderness Associates is getting ready to prepare the October bank reconciliation. The cash balance on the books of Wilderness 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 Wilderness Associates -- the principal was...

  • prepare a bank reconciliation as of October 31 from the above information Refer to the information...

    prepare a bank reconciliation as of October 31 from the above information Refer to the information given below a. The October 31 cash balance in the general ledger is $836. b. The October 31 balance shown on the bank statement is $335 c. Checks issued but not returned with the bank statement were No. 462 for $14 and No. 483 for $43 d. A deposit made late on October 31 for $472 is included in the general ledger balance but...

  • Prepare the bank reconciliation at October 31. (List items that increase balance as per bank &...

    Prepare the bank reconciliation at October 31. (List items that increase balance as per bank & books first.) LILJ ILUUIU TU e Tecndul. (Leur account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter o for the amounts.) Debit Credit Date Account Titles and Explanation Oct. 31 (To record EFT collections) (To record account receivable) (To adjust cheque #3421) (To record bank...

  • The October 31 bank statement of Wyndham Healthcare has just arrived from State Bank. To prepare...

    The October 31 bank statement of Wyndham Healthcare has just arrived from State Bank. To prepare the bank reconciliation, you gather the following data: (Click the icon to view the data.) Read the requirements Requirement 1. Prepare the bank reconciliation for Wyndham Healthcare at October 31, 2018 Wyndham Healthcare Bank Reconciliation October 31, 2018 Bank: ADD: Choose from any list or enter any number in the input fields and then click Check Answer i Data Table a. The October 31...

  • erform: Instructions Prepare the company's income statement for the year ended December 31, 2018, complete with...

    erform: Instructions Prepare the company's income statement for the year ended December 31, 2018, complete with an appropriate heading. a. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. b. Check your spelling carefully and do not abbreviate. (Always use cell references and formulas where appropriate to receive full credit If you copy/paste from the Instructions tab you will be marked wrong.) Total Points 1 The Financial Statements 2...

  • 1. Prepare an income statement for Del Campo for 2019 and 2018 under both the cash...

    1. Prepare an income statement for Del Campo for 2019 and 2018 under both the cash and the accrual basis of accounting. (Always use cell references and formulas, including $0 balances, where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Accrual Basis 2019 2018 Cash Basis 2019 2018 Operating expenses: Operating income 2. Compute operating cash flow for both years under cash and accrual bases. (Always use cell references and formulas...

  • erform: Instructions Prepare Jackson Corporation's balance sheet at December 31, 2018, complete with its proper heading....

    erform: Instructions Prepare Jackson Corporation's balance sheet at December 31, 2018, complete with its proper heading. a. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. b. Check your spelling carefully and do not abbreviate. c. Enter amounts in millions, as provided to you in the data. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be...

  • Exam - Chapters 45,6 Seved Help Save & EX On October 31, 2021, the bank statement...

    Exam - Chapters 45,6 Seved Help Save & EX On October 31, 2021, the bank statement for a company shows a balance of $12.895, while the company's records show a balance of $8.445. Information that might be useful in preparing a bank reconciliation follows: -- The company's cash receipts for the month total $74,640, of which $71,375 has been deposited in the bank. --The company has written checks for $72,515, of which $71,270 has been processed by the bank. --Bank...

  • Cynthia Company Bank Reconciliation December 31, 2018 Balance per bank 12/31 $ 18,375.91 a Deposits in...

    Cynthia Company Bank Reconciliation December 31, 2018 Balance per bank 12/31 $ 18,375.91 a Deposits in Transit 12/30 12/31 $1,471.10 b 2,840.69 b 4,311.79 Outstanding Checks 6/30 837 12/15 1941 12/20 1966 12/21 1984 12/23 1985 12/28 1985 12/30 1991 6,000.00 671.80 320.00 1,855.42 3,621.22c 2,576.89c 4,420.88 C (19,466.21) NSF check returned 12/29 December bank Charges Error in Check 1932, dated 11/20 Customer note collected by bank, 12/21 200.00 d 550.00 e 148.10 f (3,025.00) g Balance per book $...

  • On October 31, 2021, the bank statement for the checking account of Blockwood Video shows a...

    On October 31, 2021, the bank statement for the checking account of Blockwood Video shows a balance of $12.751, while the company's records show a balance of $12.381. Information that might be useful in preparing a bank reconciliation is as follows a. Outstanding checks are $1,280 b. The October 31 cash receipts of $835 are not deposited in the bank until November 2 c. One check written in payment of utilities for $147 is correctly recorded by the bank but...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT