please prepare a Bank Reconciliation form

general journal

in excel format!!!

BANK RECONCILIATION PROBLEM You have just been hired by Peppers Technology Company (PTC). You are task with preparing a bank reconciliation for the month of July. Information: 1.) Cash balance per bank, July 31, $2,542.00 2.) Bank collected $600 note on PTC behalf, plus $36 for interest and a fee of $15 3.) The bank charges a monthly administrative fee of $10 4.) One outstanding check for $207 5.) Cash balance in the general ledger for July $2,549 6.) Deposits in transit for July $825 Instructions: a.) Prepare a bank reconciliation at July 31 b.) Journalize the adjusting entries as a result of the bank reconciliation PAYROLL FINAL PROBLEM 1.) Employee Name: Rollo Lawson Marital Status Single 3.) Employee Name: Jackie Brown Mental Sextos Married FIT: S150 FIT. $133 Annual Salary: $50,000 Aral Salary: $52,000 Payroll Schedule: Bi-Weekly Payroll Schedule: Bi-Weekly 2.) Employee Name: George Jefferson 4.) Employee Name. Thelma Evans Marital Status: Single Marital Status: Married FIT: $148 FIT. $257 Annual Salary: $65,000 Annual Salary $50,000 Payroll Schedule: Semi-Sonthly Payroll Schedule: Semi-Monthly Employee J. Lewis R Bell C. Duncan 2. Anderson Hours 45 42 40 48 Hourly Employees Hourly Rate Federal Income Tax $13.00 $30 15.00 35 18.00 38 15.00 Additional Data The state of Missouri has 6% tax rate. The city of St. Louis has a 19 tax rate. INSTRUCTIONS: for Salary employees 1.) Calculate Net Payexscal working papers-salay tab in green shore crois footing of amounts) Prepare jounal tries for salary only INSTRUCTIONS for Hourly emplovees: 1.) Calculate Diet Pay (excel working papers-Loule teb is yellow ikow cross foeting of mount) Additional leformation for hourk enployees ont Hourly employees are paid time and a half for our oktat supenes 40 hours