TABLE TOOLS DESIGN LAYOUT 5 Homework 7 FA - Microsoft Word FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Cover Page P Hyperlink Blank Page Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Page Break Pictures Office Video Cross-reference Pages Tables Illustrations Apps Media Links ? 6 - 2x Sign in It Equation 2 Symbol A A A Text Quick WordArt Drop Box Parts Cap Text Signature Line Date & Time Object Comment Header Footer Page Number Comments Header & Footer Symbols Q3 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. #2472 $1,510 #2473 1,830 #2474 999 4,339 www.youtube.com. 21m Reconciled cash balance $23,809 | Recommended: 379) & all abog E ES - PAGE 5 OF 10 1002 WORDS + 100% TABLE TOOLS DESIGN LAYOUT 5 page1-23 - Microsoft Word FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Cover Page P Hyperlink Blank Page Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Page Break Pictures Office Video Cross-reference Pages Tables Illustrations Apps Media Links ? 6 - 2x Sign in TT Equation - 2 Symbol Signature Line - Date & Time Comment Header Footer Page - Number Comments Header & Footer A A A Text Quick WordArt Drop Box Parts - Cap- Text Object 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 Account (Debits) Amounts Added to Account (Credits) Date Description Balance Oct. 31 24,770 Nov. 1 Cheque. No. 2472 2472 1,510 1,510 23,260 23,260 PAGE 5 OF 10 1002 WORDS DE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation - 2 Symbol Cover Page Blank Page Page Break Pages Table Hyperlink Bookmark Cross-reference Links Signature Line - Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Pictures Office Video Illustrations Apps Media Nov. I Cheque. No. 2472 Comment Header Footer Page Number Comments A A A Text Quick WordArt Drop Box Parts - Cap- Text 25,260 Tables Symbols 1. Ioader & Footer 1 Deposit 3,378 26,638 2 Cheque. No. 2473 1,830 24,808 3 Deposit 2,239 27,047 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 3.300 20,091 15 EFT, salaries 6,000 14,091 20 Deposit 5,890 19,981 25 Returned chequsNSF. Giasson Developments PAGE 6 OF 10 1002 WORDS DE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in It Equation 2 Symbol Cover Page Blank Page Page Break Pages Table Signature Line Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office Video Apps Media Comment Header Footer Page Number Comments Header & Footer A A A Text Quick WordArt Drop Box Parts Cap- Text Tables Symbols 25 NSF fee 19,573 26 Cheque. No. 2479 1.470 18,103 27 Deposit 3,600 21,703 28 EFT, collection of note receivable and interest 4,564 26,267 30 Cheque. No. 2481 1,247 25,020 30 EFT, salaries 6,000 19,020 PAGE 6 OF 10 1002 WORDS DE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation - 2 Symbol 9 Cover Page Blank Page Page Break Pages Table Hyperlink Bookmark Cross-reference Links Signature Line - Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Pictures Office - Video Illustrations Apps Media 30 Bank service charges Comment Header Footer Page Number Comments Header & Footer A A A Text Quick WordArt Drop Box Parts Cap- Text 19,015 Tables Symbols The cash records per books for November showed the following: Cash Receipts Cash Payments Date Amount Date Number Amount Nov. 3 $2,239 Nov. 1 $ 3,286 1,970 2475 2476 2477 2478 5,000 1.200 4,660 2 5.908 3,300 3,600 2479 1.470 2,531 EFT. salaries 6,000 $20,908 18 2480 1,137 2024811,247 PAGE 7 OF 10 1002 WORDS DE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation - 2 Symbol Signature Line - Date & Time Cover Page Blank Page Page Break Pages Table Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office Video Apps Media bject Comment Header Footer Page - Number Comments Header & Footer A A A Text Quick WordArt Drop Box Parts Ca Text 1,200 Tables Symbols 4,660 2477 5,908 2478 3,300 3,600 2479 1.470 2,531 EFT salaries 6,000 $20,908 2480 1,137 2481 1,247 2482 1,640 EFT, salaries 6,000 $30,280 PAGE 7 OF 10 1002 WORDS LE B E ES -- + 100% TABLE TOOLS DESIGN LAYOUT 5 page1-23 - Microsoft Word FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Cover Page P Hyperlink Blank Page Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Page Break Pictures Office Video Cross-reference Pages Tables Illustrations Apps Media Links ? 6 - 2x Sign in It Equation 2 Symbol A A A Text Quick WordArt Drop Box Parts - Cap- Text Signature Line Date & Time Object Comment Header Footer Page Number Comments Header & Footer Symbols Additional information: 1. 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 accrued. 2. EFT payments are recorded when they occur. 3. 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 PAGE 8 OF 10 1002 WORDS LE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation- 2 Symbol Cover Page Blank Page Page Break Pages Table Signature Line - Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office Video Apps Media A A A Text Quick WordArt Drop Box Parts Cap- Text Comment Header Footer Page Number Comments Header & Footer Tables Symbols SHERIDAN LIMITED Bank Reconciliation November 30 PAGE 8 OF 10 1002 WORDS LE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation - 2 Symbol Cover Page Blank Page Page Break Pages Table Signature Line - Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office - Video Apps Media A A A Text Quick WordArt Drop Box Parts - Cap- Text Comment Header Footer Page Number Comments Header & Footer Tables Symbols PAGE 9 OF 10 1002 WORDS LE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in It Equation 2 Symbol Cover Page Blank Page Page Break Pages Table Signature Line Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office Video Apps Media A A A Text Quick WordArt Drop Box Parts - Cap- Text Comment Header Footer Page Number Comments Header & Footer Tables Symbols 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 PAGE 9 OF 10 1002 WORDS LE B E ES -- + 100% FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES Cover Page Blank Page Table Pictures Online Shapes SmartArt Chart Screenshot Page Break Pictures Pages Tables Illustrations page1-23 - Microsoft Word MAILINGS REVIEW VIEW P Hyperlink Bookmark Apps for Online Comment Header Footer Page Office - Video Cross-reference - Number Apps Media Links Comments Header & Footer ? 6 - 2x Sign in TT Equation - 2 Symbol A A A Text Quick WordArt Drop Box Parts - Cap Text Signature Line - Date & Time Object Symbols amounts.) Date Account Titles and Explanation Debit Credit Nov. 30 (To record EFT collections) 30 (To record bank charges) (To record NSF chegue and fee) 30 (To correct error in recording chegue No. 2476) 30 (To correct error in Nov. 20 deposit) PAGE 10 OF 10 1002 WORDS B E ES -- + 100% TABLE TOOLS DESIGN LAYOUT 5 Homework 7 FA - Microsoft Word FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Cover Page P Hyperlink Blank Page Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Page Break Pictures Office Video Cross-reference Pages Tables Illustrations Apps Media Links ? 6 - 2x Sign in It Equation 2 Symbol A A A Text Quick WordArt Drop Box Parts Cap Text Signature Line Date & Time Object Comment Header Footer Page Number Comments Header & Footer Symbols Q3 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. #2472 $1,510 #2473 1,830 #2474 999 4,339 www.youtube.com. 21m Reconciled cash balance $23,809 | Recommended: 379) & all abog E ES - PAGE 5 OF 10 1002 WORDS + 100% TABLE TOOLS DESIGN LAYOUT 5 page1-23 - Microsoft Word FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Cover Page P Hyperlink Blank Page Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Page Break Pictures Office Video Cross-reference Pages Tables Illustrations Apps Media Links ? 6 - 2x Sign in TT Equation - 2 Symbol Signature Line - Date & Time Comment Header Footer Page - Number Comments Header & Footer A A A Text Quick WordArt Drop Box Parts - Cap- Text Object 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 Account (Debits) Amounts Added to Account (Credits) Date Description Balance Oct. 31 24,770 Nov. 1 Cheque. No. 2472 2472 1,510 1,510 23,260 23,260 PAGE 5 OF 10 1002 WORDS DE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation - 2 Symbol Cover Page Blank Page Page Break Pages Table Hyperlink Bookmark Cross-reference Links Signature Line - Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Pictures Office Video Illustrations Apps Media Nov. I Cheque. No. 2472 Comment Header Footer Page Number Comments A A A Text Quick WordArt Drop Box Parts - Cap- Text 25,260 Tables Symbols 1. Ioader & Footer 1 Deposit 3,378 26,638 2 Cheque. No. 2473 1,830 24,808 3 Deposit 2,239 27,047 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 3.300 20,091 15 EFT, salaries 6,000 14,091 20 Deposit 5,890 19,981 25 Returned chequsNSF. Giasson Developments PAGE 6 OF 10 1002 WORDS DE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in It Equation 2 Symbol Cover Page Blank Page Page Break Pages Table Signature Line Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office Video Apps Media Comment Header Footer Page Number Comments Header & Footer A A A Text Quick WordArt Drop Box Parts Cap- Text Tables Symbols 25 NSF fee 19,573 26 Cheque. No. 2479 1.470 18,103 27 Deposit 3,600 21,703 28 EFT, collection of note receivable and interest 4,564 26,267 30 Cheque. No. 2481 1,247 25,020 30 EFT, salaries 6,000 19,020 PAGE 6 OF 10 1002 WORDS DE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation - 2 Symbol 9 Cover Page Blank Page Page Break Pages Table Hyperlink Bookmark Cross-reference Links Signature Line - Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Pictures Office - Video Illustrations Apps Media 30 Bank service charges Comment Header Footer Page Number Comments Header & Footer A A A Text Quick WordArt Drop Box Parts Cap- Text 19,015 Tables Symbols The cash records per books for November showed the following: Cash Receipts Cash Payments Date Amount Date Number Amount Nov. 3 $2,239 Nov. 1 $ 3,286 1,970 2475 2476 2477 2478 5,000 1.200 4,660 2 5.908 3,300 3,600 2479 1.470 2,531 EFT. salaries 6,000 $20,908 18 2480 1,137 2024811,247 PAGE 7 OF 10 1002 WORDS DE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation - 2 Symbol Signature Line - Date & Time Cover Page Blank Page Page Break Pages Table Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office Video Apps Media bject Comment Header Footer Page - Number Comments Header & Footer A A A Text Quick WordArt Drop Box Parts Ca Text 1,200 Tables Symbols 4,660 2477 5,908 2478 3,300 3,600 2479 1.470 2,531 EFT salaries 6,000 $20,908 2480 1,137 2481 1,247 2482 1,640 EFT, salaries 6,000 $30,280 PAGE 7 OF 10 1002 WORDS LE B E ES -- + 100% TABLE TOOLS DESIGN LAYOUT 5 page1-23 - Microsoft Word FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Cover Page P Hyperlink Blank Page Bookmark Table Pictures Online Shapes SmartArt Chart Screenshot Apps for Online Page Break Pictures Office Video Cross-reference Pages Tables Illustrations Apps Media Links ? 6 - 2x Sign in It Equation 2 Symbol A A A Text Quick WordArt Drop Box Parts - Cap- Text Signature Line Date & Time Object Comment Header Footer Page Number Comments Header & Footer Symbols Additional information: 1. 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 accrued. 2. EFT payments are recorded when they occur. 3. 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 PAGE 8 OF 10 1002 WORDS LE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation- 2 Symbol Cover Page Blank Page Page Break Pages Table Signature Line - Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office Video Apps Media A A A Text Quick WordArt Drop Box Parts Cap- Text Comment Header Footer Page Number Comments Header & Footer Tables Symbols SHERIDAN LIMITED Bank Reconciliation November 30 PAGE 8 OF 10 1002 WORDS LE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in TT Equation - 2 Symbol Cover Page Blank Page Page Break Pages Table Signature Line - Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office - Video Apps Media A A A Text Quick WordArt Drop Box Parts - Cap- Text Comment Header Footer Page Number Comments Header & Footer Tables Symbols PAGE 9 OF 10 1002 WORDS LE B E ES -- + 100% TABLE TOOLS 5 HOME page1-23 - Microsoft Word PAGE LAYOUT REFERENCES MAILINGS FILE INSERT DESIGN REVIEW VIEW DESIGN LAYOUT ? 6 - 2x Sign in It Equation 2 Symbol Cover Page Blank Page Page Break Pages Table Signature Line Date & Time Object Pictures Online Shapes SmartArt Chart Screenshot Pictures Illustrations Hyperlink Bookmark Cross-reference Links Apps for Online Office Video Apps Media A A A Text Quick WordArt Drop Box Parts - Cap- Text Comment Header Footer Page Number Comments Header & Footer Tables Symbols 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 PAGE 9 OF 10 1002 WORDS LE B E ES -- + 100% FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES Cover Page Blank Page Table Pictures Online Shapes SmartArt Chart Screenshot Page Break Pictures Pages Tables Illustrations page1-23 - Microsoft Word MAILINGS REVIEW VIEW P Hyperlink Bookmark Apps for Online Comment Header Footer Page Office - Video Cross-reference - Number Apps Media Links Comments Header & Footer ? 6 - 2x Sign in TT Equation - 2 Symbol A A A Text Quick WordArt Drop Box Parts - Cap Text Signature Line - Date & Time Object Symbols amounts.) Date Account Titles and Explanation Debit Credit Nov. 30 (To record EFT collections) 30 (To record bank charges) (To record NSF chegue and fee) 30 (To correct error in recording chegue No. 2476) 30 (To correct error in Nov. 20 deposit) PAGE 10 OF 10 1002 WORDS B E ES -- + 100%