please help filling out the highlighted areas

The Bead Company is a maker of fine beaded Necklaces and Bracelets. Please prepare, a Bank Reconciliation for The Bead Co. for the month ended November 30, 2016. The following information is available to reconcile the Bead Company's Book Balance of Cash with its Bank Statement balance as of November 30, 2016: #1. According to the November Bank Statement, the Balance on the Checking account on 11/30/16 is $140,326. #2. The Cash Account on the Company Books shows a Balance of $148,072. #3. The Bead Company made a Deposit of $25,326 on 11/30/16 which is not induded in the Bank Statement. #4. The Following checks were issued by the Bead Company during November but have not yet appeared on the Bank statement: Check #: 1147 1156 1270 Amount $7,350 $8,400 $1,526 #5. The Bank collected interest on Note Receivable on behalf of the Bead Company. The Bank Statement shows that $500 was collected during November. #5. The Bank Statement shows Two NSF Checks were returned with the May Statement These were from customers Smith and Jones for $242 and $162, respectively. #7. The Bank Statement shows Interest Earned on the Checking Account was $256. The Bank Statement also shows $48 of Bank Charges were charged to the account. #8. An Accountant in the A/P Department discovered that a check for $250 written to Jewelry Beads Supplies was erroneously recorded in the Glue & Adhesives Payable Account in the Ledger. Hints for Creating your Bank Reconciliation: (See Next Page) ** Follow the Example in your Chapter #8 PowerPoint Slides on Slides #24 to #30. A. Setup a Bank Reconciliation with a Bank Side and a Book Side. Leave room to both add and Deduct various items when necessary. Each Column should resultin a reconciled, equal balance. B. Examine each item #1 thru #8 to determine whether it affects the book balance OR the Bank balance and whether it should be added or deducted from the Bank or Book Cash balance. C. After all the items #1 thru #8 are analyzed, complete the Bank Reconciliation and arrive at a Reconciled Balance between the bank side and the book side. D. After the Bank Reconciliation is complete, for each reconciling item on the Book side, prepare an Adjusting Entry. Remember: Additions to the Book Side require an Adjusting entry that Debits Cash. Remember also that Deductions on the Book side require an adjusting entry that Credits Cash. (C (Continued) In Yellow Shaded Areas: Page #2 of 3. Please enter Amounts $$ ACC 111 The Bead Co. Bank Reconciliation Check # or Descriptions The Bead Company Bank Reconciliation Book Balance: November 30, 2016 Bank Satement Balance: Balance per the Bank Statement: $ Balance in the Cash Account: $ Add: Add: Deposit In Transit: + $ + $ $ $ Deduct: Checks In Transit: S Deduct: Check # $ Check # $ Check # $ $ $ $ Adjusted Bank Balance.... $ Adjusted Book Balance.... Continued) Mare Five (5) Required Adjusting Journal Entries (AJE's): Date: Enter your AJE Debit & Credit Entries and Description Below: #1. AJE Description: #2. AJE Description #3. AJE Description #4. AJE Description: 5 #5. AJE Description