Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The bank portion of the bank reconciliation of Sandhill Ltd. at September 30, 2023 was as follows: Cash Balance per Bank Add: Deposit in

image text in transcribed  image text in transcribed image text in transcribed image text in transcribed 
image text in transcribed  image text in transcribed image text in transcribed

The bank portion of the bank reconciliation of Sandhill Ltd. at September 30, 2023 was as follows: Cash Balance per Bank Add: Deposit in transit Less: Outstanding cheques: Ch. No. Date 261 Oct. 3 Oct. 7 270 Adjusted cash balance per bank 274 Deposit Amount $ 1,081 Amount 832 428 945 The adjusted cash balance per bank agreed with the cash balance per books at September 30, 2023 following the recording of any necessary adjustments to the books after reconciling the bank account. The accounting records for deposits and cheques for the month of October revealed the following details: 281 $5,416 1,192 No. 275 1,654 No. 276 $4,954 Cheque Number Cheque Amount $1,329 1,066 Oct. 12 Oct. 15 Oct. 19 Oct. 21 Oct. 23 Oct. 25 Oct. 30 Total 534 Reference 462 No. 270 230 954 175 1,070 722 $6,060 Cheques & other charges Amount No. 277 $945 No. 278 No. 279 No. 280 No. 281 No. 282 No. 283 No. 284 Total Deposits $ 1,192 1,081 The following is a replica of the bank statement for the month of October listing: cheques, deposits, debit and credit memos entered by the bank on its systems. Date Oct. 1 Oct. 3 Oct. 5 Balance $5,416 5,663 138 6,744 760 494 855 256 954 469 222 $6.543 No. 274 No. 276 No. 275 No. 277 No. 279 No. 281 No. 280 No. 283 Totals 281 1,066 1,329 NSF 182 S/C 56 832 138 718 256 855 469 EFT 414 $6,295 541 462 230 954 1,070 175 $6,951 Oct. 8 Oct. 13 Oct. 17 Oct. 20 Oct. 22 Oct. 24 Oct. 27 Oct. 29 Oct. 30 Oct. 31 7,295 6,770 5,903 5,995 6,231 7,045 6,365 6,310 6,128 6,072 The following footnote notations also appeared on the bank statement as explanations. NSF = Non-sufficient funds S/C=Monthly back service charges EFT(Electronic Funds Transfer) Represents collection of a note receivable which includes $44 of interest. The interest had not been previously accrued. Additional information: 1. 2. There are no bank errors. Any correction of errors (on book errors) relative to cheques written should be corrected to accounts payable. All deposits are the result of collections on accounts from customers. Calculate the unadjusted balance per books at October 31, 2023 based on the information provided. Balance per books at October 31, 2023 Prepare, the bank reconciliation of Sandhill for the month of October 2023. (List items that increase balance as per bank and books first.) M: SANDHILL Ltd. Bank Reconciliation $ 11 Prepare any necessary journal entries required after performing part b. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. List all debit entries before credit entries. If no entry is required, select "No Entry" for the account titles and enter O for the amounts.) Account Titles and Explanation (To record collection of note and interest) Debit Credit (To correct for deposit of October 12) (To record bank service charges) (To record NSF cheque) (To correct error on cheque 279) I

Step by Step Solution

There are 3 Steps involved in it

Step: 1

October three Debit coins 1081 credit score accounts Re... 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

Step: 3

blur-text-image

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

Calculus

Authors: Ron Larson, Bruce H. Edwards

10th Edition

1285057090, 978-1285057095

More Books

Students also viewed these Mathematics questions

Question

How does the direct method differ from the indirect method?

Answered: 1 week ago