Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

question 3 : please answer question I posted all information as the teacher gave us X Homework 7 FA- Microsoft Word TABLE TOOLS Sign in

question 3 : please answer question I posted all information as the teacher gave us

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

X Homework 7 FA- Microsoft Word TABLE TOOLS Sign in E REFERENCES MAILINGS REVIEW VIEW FILE INSERT DESIGN PAGE LAYOUT DESIGN LAYOUT A Signature Line E Date & Time Hyperlink Cover Page Blank Page TT Equation 2 Symbol A # Bookmark Comment Header Footer Text Quick WordArt Drop Box Parts Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online OfficeVideo Page Number Object SCross-reference Page Break Pictures Cap Pages Tables Illustrations Apps Media Links Comments Header & Footer nt Symbols The bank portion of last month's bank reconciliation for Sheridan Limited at October 31 is shown here SHERIDAN LIMITED Bank Reconciliation October 31 Cash balance per bank $24,770 Add: Deposits in transit 3,378 28,148 Less: Outstanding cheques $1,510 #2472 # 2473 1,830 #2474 999 4,339 x www.youtube.com 21m $23,809 Reconciled cash balance - Recommended: 9Jg Ro lsig nog PAGE 5 OF 10 1002 WORDS +100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E PAGE LAYOUT MAILINGS REVIEW DESIGN FILE INSERT DESIGN REFERENCES VIEW LAYOUT Signature Line EN Date & Time Object Cover Page Blank Page erlink TT Equation 2 Symbol A- AA Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online OfficeVideo Comment Header Footer Page Number Text Quick WordArt Drop Box Parts Cross-reference Page Break Cap Pictures xt Pages Tables llustrations Apps Media Links Comments Header& Footer Symbols The reconciled cash balance per bank agreed with the reconciled cash balance per books after the bank reconciliation at October 31. The November bank statement showed the following SHERIDAN LIMITED Bank Statement November 30 Amounts Deducted from Amounts Added Account to Account (Credits) Date Description (Debits) Balance Oct. 31 24,770 Nov. 1 Cheque, No. 2472 1,510 23,260 + PAGE 5 OF 10 1002 WORDS 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E PAGE LAYOUT VIEW FILE INSERT DESIGN REFERENCES MAILINGS REVIEW DESIGN LAYOUT A Signature Line E Date & Time Cover Page Blank Page erlink TT Equation 2 Symbol A- # Bookmark Comment Header Footer Text Quick WordArt Drop Box Parts Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Office Video age Number Object Cross-reference Page Break Pictures ext Pages Tables llustrations Apps hcquc. No. 14/2 Media Links Comments Header & Footer Symbols Nov. 1310 25.260 1 Deposit 3,378 26,638 2 Cheque No. 2473 1,830 24,808 2,239 27,047 3 Deposit 4 Cheque. No. 2475 3,286 23,761 7 Deposit 1,970 25,731 8 Cheque. No. 2476 5,800 19,931 10 Cheque, No. 2477 1,200 18,731 14 Deposit 4,660 23.391 15 Cheque, No. 2478 20,091 3,300 14,09 15 EFT, salaries 6,000 20 Deposit 5,890 19,981 25 Returned cheque-NSF, Giasson Developments 1002 WORDS E + PAGE 6 OF 10 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E REFERENCES VIEW FILE INSERT DESIGN PAGE LAYOUT MAILINGS REVIEW DESIGN LAYOUT A Signature Line E Date & Time Cover Page Blank Page Hyperlink TT Equation 2 Symbol A # Bookmark Comment Header Footer Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Video age Number Text Quick WordArt Drop Box Parts Object Cross-reference Page Break Office Pictures Cap Text Pages Tables llustrations Apps Media Links Comments Header & Footer Symbols 25 NSF fee 8 19,573 26 Cheque. No. 2479 1,470 18,103 27 Deposit 3,600 21,703 28 EFT, collection of note receivable and interest 26,267 4,564 30 Cheque, No. 2481 1,247 25,020 30 EFT, salaries 6.000 19,020 1002 WORDS E + PAGE 6 OF 10 100% page1-q3- Microsoft Word X TABLE TOOLS Sign in E MAILINGS VIEW FILE INSERT DESIGN PAGE LAYOUT REFERENCES REVIEW DESIGN LAYOUT A Signature Line ENDate & Time Cover Page Blank Page erlink TT Equation 2 Symbol A A |# Comment Header Footer Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online OfficeVideo age Number Text Quick WordArt Drop Box Parts Object Cross-reference Page Break Pictures Text Pages Tables Apps Media Links Comments Header & Footer Symbols llustrations 30 Bank service charges 5 19,015 The cash records per books for November showed the following Cash Receipts Cash Payments Date Amount Date Number Amount 2475 Nov. 3 $2,239 Nov. 1 $3,286 1,970 2 2476 5,000 12 4,660 2 2477 1,200 3,300 5,908 20 8 2478 1,470 27 3,600 15 2479 EFT salaries 30 2,531 15 6,000 $20,908 18 2480 1,137 20 2481 1,247 D + PAGE 7 OF 10 1002 WORDS 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E VIEW DESIGN FILE INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW LAYOUT Hyperlink A Signature Line E Date & Time Cover Page Blank Page TT Equation 2 Symbol A # Bookmark Text Quick WordArt Drop Cap Text Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Office Video Comment Header Footer Page Number Object Cross-reference Page Break Box Parts Pictures Pages Tables llustrations Apps Media Links Comments Header & Footer Symbols 12 4,660 2477 1,200 20 5,908 8 2478 3,300 2479 1,470 27 3,600 15 EFT 30 2,531 15 6,000 salaries 2480 1,137 $20,908 18 20 2481 1,247 1,640 29 2482 EFT 30 6,000 salaries $30,280 D + PAGE 7 OF 10 1002 WORDS 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in REFERENCES E VIEW FILE INSERT DESIGN PAGE LAYOUT MAILINGS REVIEW DESIGN LAYOUT A Signature Line E Date & Time Cover Page Blank Page erlink TT Equation 2 Symbol A Bookmark Comment Header Footer Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online OfficeVideo Page Number Text Quick WordArt Drop Object Cross-reference Page Break Box Parts Pictures Pages Tables llustrations Apps Media Links Comments Header & Footer nt Symbols Additional information: The EFT collection was not previously recorded. The collection of the note on November 28 was for $4,400, plus $164 interest. Interest was not previously ccrued 2 EFT payments are recorded when they occur The bank did not make any errors. 4. Two errors were made by the company: one in recording a cheque and one in recording a cash receipt. The correction of any errors in the recording of cheques should be made to Accounts Payable. The correction of any errors in the recording of cash receipts should be made to Accounts Receivable, calculate the cash balance per books as at November 30, prior to reconciliation. Cash balance per books S Prepare the bank reconciliation at November 30. (List items that increase balance as per bank & books first) SHERIDAN LIMITED Bank Reconciliation November 30 1002 WORDS E + PAGE 8 OF 10 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E PAGE LAYOUT MAILINGS REVIEW DESIGN FILE INSERT DESIGN REFERENCES VIEW LAYOUT Signature Line E Date & Time Hyperlink Cover Page Blank Page TT Equation 2 Symbol A AA Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Video Comment Header Footer Page Number Text Quick WordArt Drop Page Break Cross-reference Cap-Object Office Box Parts Pictures Text Pages Tables llustrations Apps Media Links Comments Header & Footer Symbols SHERIDAN LIMITED Bank Reconciliation November 30 S PAGE 8 OF 101002 WORDS + 100% LLL 1 page1-q3- Microsoft Word X TABLE TOOLS Sign in E REFERENCES MAILINGS VIEW FILE INSERT DESIGN PAGE LAYOUT REVIEW DESIGN LAYOUT A 2Signature Line E Date & Time Cover Page Blank Page TT Equation 2 Symbol A erlink # Bookmark Comment Header Footer Text Quick WordArt Drop Cap Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Video Page Number Object 5Cross-reference Page Break Office Pictures BoxParts Pages Tables llustrations pps Media Links Comments Header & Footer nt Symbols 1002 WORDS E + 100 % PAGE 9 OF 10 LILIZLL page1-q3- Microsoft Word X TABLE TOOLS Sign in E MAILINGS VIEW FILE INSERT DESIGN PAGE LAYOUT REFERENCES REVIEW DESIGN LAYOUT A Signature Line E Date & Time Cover Page Blank Page erlink T Equation 2 Symbol A # Bookmark Comment Header Footer Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Page Number Text Quick WordArt Drop Box Parts Object 5Cross-reference Page Break Office Pictures Video Cap pps Pages Tables llustrations Media Links Comments Header & Footer nt Symbols S Prepare any journal entries required from the reconciliation. (Credit 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 0 for the 1002 WORDS E + PAGE 9 OF 10 100% D page1-q3- Microsoft Word Sign in E REFERENCES FILE INSERT DESIGN PAGE LAYOUT MAILINGS REVIEW VIEW A Signature Line Date & Time Cover Page Blank Page Hyperlink T Equation 2 Symbol AE # Bookmark Comment Header Footer Text Quick WordArt Drop a* Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Office Video age Number Cross-reference Page Break Cap- Object Pictures Box Parts Pages Tables llustrations Apps Media Links Comments Header & Footer nt Symbols ounts.) Date Account Titles and Explanation Credit Debit Nov. 30 (To record EFT collections) 30 (To record bank charges) 30 (To record NSF chcque and fee) 30 (To correct error in recording cheque No. 2476) 30 (To correct error in Nov. 20 deposit) E 1002 WORDS CE + PAGE 10 OF 10 100% X Homework 7 FA- Microsoft Word TABLE TOOLS Sign in E REFERENCES MAILINGS REVIEW VIEW FILE INSERT DESIGN PAGE LAYOUT DESIGN LAYOUT A Signature Line E Date & Time Hyperlink Cover Page Blank Page TT Equation 2 Symbol A # Bookmark Comment Header Footer Text Quick WordArt Drop Box Parts Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online OfficeVideo Page Number Object SCross-reference Page Break Pictures Cap Pages Tables Illustrations Apps Media Links Comments Header & Footer nt Symbols The bank portion of last month's bank reconciliation for Sheridan Limited at October 31 is shown here SHERIDAN LIMITED Bank Reconciliation October 31 Cash balance per bank $24,770 Add: Deposits in transit 3,378 28,148 Less: Outstanding cheques $1,510 #2472 # 2473 1,830 #2474 999 4,339 x www.youtube.com 21m $23,809 Reconciled cash balance - Recommended: 9Jg Ro lsig nog PAGE 5 OF 10 1002 WORDS +100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E PAGE LAYOUT MAILINGS REVIEW DESIGN FILE INSERT DESIGN REFERENCES VIEW LAYOUT Signature Line EN Date & Time Object Cover Page Blank Page erlink TT Equation 2 Symbol A- AA Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online OfficeVideo Comment Header Footer Page Number Text Quick WordArt Drop Box Parts Cross-reference Page Break Cap Pictures xt Pages Tables llustrations Apps Media Links Comments Header& Footer Symbols The reconciled cash balance per bank agreed with the reconciled cash balance per books after the bank reconciliation at October 31. The November bank statement showed the following SHERIDAN LIMITED Bank Statement November 30 Amounts Deducted from Amounts Added Account to Account (Credits) Date Description (Debits) Balance Oct. 31 24,770 Nov. 1 Cheque, No. 2472 1,510 23,260 + PAGE 5 OF 10 1002 WORDS 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E PAGE LAYOUT VIEW FILE INSERT DESIGN REFERENCES MAILINGS REVIEW DESIGN LAYOUT A Signature Line E Date & Time Cover Page Blank Page erlink TT Equation 2 Symbol A- # Bookmark Comment Header Footer Text Quick WordArt Drop Box Parts Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Office Video age Number Object Cross-reference Page Break Pictures ext Pages Tables llustrations Apps hcquc. No. 14/2 Media Links Comments Header & Footer Symbols Nov. 1310 25.260 1 Deposit 3,378 26,638 2 Cheque No. 2473 1,830 24,808 2,239 27,047 3 Deposit 4 Cheque. No. 2475 3,286 23,761 7 Deposit 1,970 25,731 8 Cheque. No. 2476 5,800 19,931 10 Cheque, No. 2477 1,200 18,731 14 Deposit 4,660 23.391 15 Cheque, No. 2478 20,091 3,300 14,09 15 EFT, salaries 6,000 20 Deposit 5,890 19,981 25 Returned cheque-NSF, Giasson Developments 1002 WORDS E + PAGE 6 OF 10 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E REFERENCES VIEW FILE INSERT DESIGN PAGE LAYOUT MAILINGS REVIEW DESIGN LAYOUT A Signature Line E Date & Time Cover Page Blank Page Hyperlink TT Equation 2 Symbol A # Bookmark Comment Header Footer Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Video age Number Text Quick WordArt Drop Box Parts Object Cross-reference Page Break Office Pictures Cap Text Pages Tables llustrations Apps Media Links Comments Header & Footer Symbols 25 NSF fee 8 19,573 26 Cheque. No. 2479 1,470 18,103 27 Deposit 3,600 21,703 28 EFT, collection of note receivable and interest 26,267 4,564 30 Cheque, No. 2481 1,247 25,020 30 EFT, salaries 6.000 19,020 1002 WORDS E + PAGE 6 OF 10 100% page1-q3- Microsoft Word X TABLE TOOLS Sign in E MAILINGS VIEW FILE INSERT DESIGN PAGE LAYOUT REFERENCES REVIEW DESIGN LAYOUT A Signature Line ENDate & Time Cover Page Blank Page erlink TT Equation 2 Symbol A A |# Comment Header Footer Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online OfficeVideo age Number Text Quick WordArt Drop Box Parts Object Cross-reference Page Break Pictures Text Pages Tables Apps Media Links Comments Header & Footer Symbols llustrations 30 Bank service charges 5 19,015 The cash records per books for November showed the following Cash Receipts Cash Payments Date Amount Date Number Amount 2475 Nov. 3 $2,239 Nov. 1 $3,286 1,970 2 2476 5,000 12 4,660 2 2477 1,200 3,300 5,908 20 8 2478 1,470 27 3,600 15 2479 EFT salaries 30 2,531 15 6,000 $20,908 18 2480 1,137 20 2481 1,247 D + PAGE 7 OF 10 1002 WORDS 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E VIEW DESIGN FILE INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW LAYOUT Hyperlink A Signature Line E Date & Time Cover Page Blank Page TT Equation 2 Symbol A # Bookmark Text Quick WordArt Drop Cap Text Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Office Video Comment Header Footer Page Number Object Cross-reference Page Break Box Parts Pictures Pages Tables llustrations Apps Media Links Comments Header & Footer Symbols 12 4,660 2477 1,200 20 5,908 8 2478 3,300 2479 1,470 27 3,600 15 EFT 30 2,531 15 6,000 salaries 2480 1,137 $20,908 18 20 2481 1,247 1,640 29 2482 EFT 30 6,000 salaries $30,280 D + PAGE 7 OF 10 1002 WORDS 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in REFERENCES E VIEW FILE INSERT DESIGN PAGE LAYOUT MAILINGS REVIEW DESIGN LAYOUT A Signature Line E Date & Time Cover Page Blank Page erlink TT Equation 2 Symbol A Bookmark Comment Header Footer Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online OfficeVideo Page Number Text Quick WordArt Drop Object Cross-reference Page Break Box Parts Pictures Pages Tables llustrations Apps Media Links Comments Header & Footer nt Symbols Additional information: The EFT collection was not previously recorded. The collection of the note on November 28 was for $4,400, plus $164 interest. Interest was not previously ccrued 2 EFT payments are recorded when they occur The bank did not make any errors. 4. Two errors were made by the company: one in recording a cheque and one in recording a cash receipt. The correction of any errors in the recording of cheques should be made to Accounts Payable. The correction of any errors in the recording of cash receipts should be made to Accounts Receivable, calculate the cash balance per books as at November 30, prior to reconciliation. Cash balance per books S Prepare the bank reconciliation at November 30. (List items that increase balance as per bank & books first) SHERIDAN LIMITED Bank Reconciliation November 30 1002 WORDS E + PAGE 8 OF 10 100% X page1-q3- Microsoft Word TABLE TOOLS Sign in E PAGE LAYOUT MAILINGS REVIEW DESIGN FILE INSERT DESIGN REFERENCES VIEW LAYOUT Signature Line E Date & Time Hyperlink Cover Page Blank Page TT Equation 2 Symbol A AA Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Video Comment Header Footer Page Number Text Quick WordArt Drop Page Break Cross-reference Cap-Object Office Box Parts Pictures Text Pages Tables llustrations Apps Media Links Comments Header & Footer Symbols SHERIDAN LIMITED Bank Reconciliation November 30 S PAGE 8 OF 101002 WORDS + 100% LLL 1 page1-q3- Microsoft Word X TABLE TOOLS Sign in E REFERENCES MAILINGS VIEW FILE INSERT DESIGN PAGE LAYOUT REVIEW DESIGN LAYOUT A 2Signature Line E Date & Time Cover Page Blank Page TT Equation 2 Symbol A erlink # Bookmark Comment Header Footer Text Quick WordArt Drop Cap Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Video Page Number Object 5Cross-reference Page Break Office Pictures BoxParts Pages Tables llustrations pps Media Links Comments Header & Footer nt Symbols 1002 WORDS E + 100 % PAGE 9 OF 10 LILIZLL page1-q3- Microsoft Word X TABLE TOOLS Sign in E MAILINGS VIEW FILE INSERT DESIGN PAGE LAYOUT REFERENCES REVIEW DESIGN LAYOUT A Signature Line E Date & Time Cover Page Blank Page erlink T Equation 2 Symbol A # Bookmark Comment Header Footer Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Page Number Text Quick WordArt Drop Box Parts Object 5Cross-reference Page Break Office Pictures Video Cap pps Pages Tables llustrations Media Links Comments Header & Footer nt Symbols S Prepare any journal entries required from the reconciliation. (Credit 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 0 for the 1002 WORDS E + PAGE 9 OF 10 100% D page1-q3- Microsoft Word Sign in E REFERENCES FILE INSERT DESIGN PAGE LAYOUT MAILINGS REVIEW VIEW A Signature Line Date & Time Cover Page Blank Page Hyperlink T Equation 2 Symbol AE # Bookmark Comment Header Footer Text Quick WordArt Drop a* Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Office Video age Number Cross-reference Page Break Cap- Object Pictures Box Parts Pages Tables llustrations Apps Media Links Comments Header & Footer nt Symbols ounts.) Date Account Titles and Explanation Credit Debit Nov. 30 (To record EFT collections) 30 (To record bank charges) 30 (To record NSF chcque and fee) 30 (To correct error in recording cheque No. 2476) 30 (To correct error in Nov. 20 deposit) E 1002 WORDS CE + PAGE 10 OF 10 100%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Financial And Managerial Accounting For MBAs

Authors: Peter D. Easton

6th Edition

9781618533593

Students also viewed these Finance questions