The bank portion of the bank reconciliation of Sandhill Ltd. at September 30, 2023 was as...

     

   

Transcribed Image Text:

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 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 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 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. 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 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, 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 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 (To correct for deposit of October 12) (To record bank service charges) (To record NSF cheque) (To correct error on cheque 279) I

Answer rating: 100% (QA)

October three Debit coins 1081 credit score accounts Re... View the full answer