please write a bank reconciliation

yes

12345 7/1/2016 7/31/2016 1 of 1 P.O. Box 5555 Pasadena, CA 91106 Tel: (888) 555-5555 5000 Group Consulting Inc. 2000 Forever St. Pasadena, CA 91106 Business Checking Beginning Balance Deposit / Credits Withdraws/Debits $0.00 IS 47,115.00 $ 19,259.00 Trans. Date 1-Jul Cash deposit at the branch 5-Jul Ch#001 5-Jul Deposit by check 6-Jul Ch # 002 6-Jul Deposit by check 10-Jul Ch #003 12-Jul Ch # 004 16-Jul Ch # 005 17-Jul Cash deposit at the branch 18-Jul Debit card transaction 24-Jul Cash deposit at the branch 26-Jul Deposit by check 28-Jul Ch # 006 30-Jul Cash deposit at the branch 31-Jul Deposit Interest rate 0.100% 31-Jul Branch service fee 31-Jul Withdraw Debit Card, Intuit QuickBooks 800-466-8848 Ending Balance YTD interest $ 27,856.00 $ 15.00 Deposit Withdraw Balance 13500 13500 8500 5500 14000 4500/ 9500 15300 24800 400 24400 5200 19200 1750 17450 450 17900 600 17300 200 17500 12000 29500 1750 27750 27900 27915 27905 49 27856 150 10 Cleared check salem cu Amount Cleared checks (amounts already deducted in above section): Check # Date Ch #001 5-Jul 5000 Ch # 002 6-Jul 4500 Ch #005 16-Jul Ch # 003 10-Jul 400 Ch #006 28-Jul Checa 12-Jul Amount 5200 1750 1750 5200 12000 H 450 C D E F 22 17 From a cash clients, you received cash after providing some consultation 23 18 You paid by your business debit card to purchase some supplies 24 20 Sent invoice #006 to a customer for the service provided during last few days 25 24 From a cash clients, you received cash after providing some consultation 26 26 Received cash from clients on account 27 27 Paid your receptionist for two weeks' salary 28 29 Received and paid telephone bill for July (Ch#007) 29 31 Received and paid electricity bill for July (Ch#008) 30 31 From a cash clients, you received cash after providing some consultation 31 31 Sent invoice #007 to a customer for the service provided during last few days 32 31 Declared and paid dividends (Ch#009) 600 6600 200 12000 1750 300 600 150 3000 1500 1 Instructions: Record the transactions & Post to the General Ledger accounts. 2 Prepare Bank Reconciliation and post the necessery General Journal Entries. 3 Prepare a worksheet with unadjusted trial balances in it. At the end of July analyze and use these data to complete month-end adjustments. Supply on hand.............. Record adjustments to Insurance, Rent and Equipment Depreciation Accrual receptionist salary on July 31st for one day. Unearned fees as of July 31 ....... 4 Journalize and post adjusting entries after completing the worksheet 5 Prepare an Income Statement, a Retained Earnings Statement, and a Balance Sheet 6 Prepare, record, and post closing entries. 175 2750 44 H 13500 20800 3200 7500 G Your new firm entered into the following transactions starting July 1st, 2016 -Jul Following assets were received from you in exchange for 1000 shares of common stock: Cash A/R Supplies Use straight line of Depreciation Office Equipment Office Equipment useful life: Years Residual Value: 320.00 1 The firm paid 2 months' rent for a office space lease contract. 2 Paid one year insurance policy premium in advance 4 Received advance cash from a new clients for future services 5 Purchased additional office equipment on account from Office Depot 6 Received cash from clients on account 10 Paid cash for a local newspaper advertisement 12 Paid Office Depot for part of equipment purchased on account 12 Sent invoice #005 to a customer for 90 hrs consultation provided recently 14 Paid your receptionist for two weeks' salary 17 From a cash clients, you received cash after providing some consultation 18 You paid by your business debit card to purchase some supplies 20 Sent invoice #006 to a customer for the service provided during last few days 24 From a cash clients, you received cash after providing some consultation 26 Received cash from clients on account 27 Paid your receptionist for two weeks' salary 5000 4500 5500 6500 20800 400 5200 13500 1750 450 600 6600 200 12000 1750 Date: 07/12/2016 Invoice # 005 Consue TO Best Customer Ever Consultation Inc. 2000 Forever Street Pasadena, CA 91106 Tel: 999-999-9999 Fax 900-900-0000 Consultinfo.com 100 New Ave New Hall, CA 99000 Tel: 299.500-5000 Customer ID ABC12345 SALESPERSON PAYMENT TERMS DUE DATE JOB Bookkeeping Consultation Due on receipt QTY DESCRIPTION UNIT PRICE LINE TOTAL 90 hours Bookkeeping and Business Consultation $150 $13500 $13,500 SUBTOTAL SALES TAX TOTAL $13,500 INVUICE Date: 07/20/2016 L CHIU Best Customer Ever Consultation Inc. 2000 Forever Street Pasadena, CA 90000 Tel: 999.999.9999 Fax 900.900.000 Consultinfo.com 100 New Ave New Hall, CA 99000 Tel: 299.500.5000 Customer ID ABC12345] PAYMENT TERMS DUE DATE Due on receipt Bookkeeping Consultation OTY DESCRIPTION UNIT PRICE LINE TOTAL 0 hours Bookkeeping and Business Consultation $150 SUBTOTAL $6,600 $6,600 TUU New Ave Pasadena, CA YUUUU Tel: 999-999-9999 Fax 900-900-0000 Consult@info.com New Hall, CA 99000 Tel: 299-500-5000 Customer ID (ABC12345] SALESPERSON JOB PAYMENT TERMS DUE DATE Bookkeeping Consultation Due on receipt QTY DESCRIPTION UNIT PRICE LINE TOTAL 20 hours Bookkeeping and Business Consultation $150 $3000 $3,000 SUBTOTAL SALES TAX TOTAL $3,000 12345 7/1/2016 7/31/2016 1 of 1 P.O. Box 5555 Pasadena, CA 91106 Tel: (888) 555-5555 5000 Group Consulting Inc. 2000 Forever St. Pasadena, CA 91106 Business Checking Beginning Balance Deposit / Credits Withdraws/Debits $0.00 IS 47,115.00 $ 19,259.00 Trans. Date 1-Jul Cash deposit at the branch 5-Jul Ch#001 5-Jul Deposit by check 6-Jul Ch # 002 6-Jul Deposit by check 10-Jul Ch #003 12-Jul Ch # 004 16-Jul Ch # 005 17-Jul Cash deposit at the branch 18-Jul Debit card transaction 24-Jul Cash deposit at the branch 26-Jul Deposit by check 28-Jul Ch # 006 30-Jul Cash deposit at the branch 31-Jul Deposit Interest rate 0.100% 31-Jul Branch service fee 31-Jul Withdraw Debit Card, Intuit QuickBooks 800-466-8848 Ending Balance YTD interest $ 27,856.00 $ 15.00 Deposit Withdraw Balance 13500 13500 8500 5500 14000 4500/ 9500 15300 24800 400 24400 5200 19200 1750 17450 450 17900 600 17300 200 17500 12000 29500 1750 27750 27900 27915 27905 49 27856 150 10 Cleared check salem cu Amount Cleared checks (amounts already deducted in above section): Check # Date Ch #001 5-Jul 5000 Ch # 002 6-Jul 4500 Ch #005 16-Jul Ch # 003 10-Jul 400 Ch #006 28-Jul Checa 12-Jul Amount 5200 1750 1750 5200 12000 H 450 C D E F 22 17 From a cash clients, you received cash after providing some consultation 23 18 You paid by your business debit card to purchase some supplies 24 20 Sent invoice #006 to a customer for the service provided during last few days 25 24 From a cash clients, you received cash after providing some consultation 26 26 Received cash from clients on account 27 27 Paid your receptionist for two weeks' salary 28 29 Received and paid telephone bill for July (Ch#007) 29 31 Received and paid electricity bill for July (Ch#008) 30 31 From a cash clients, you received cash after providing some consultation 31 31 Sent invoice #007 to a customer for the service provided during last few days 32 31 Declared and paid dividends (Ch#009) 600 6600 200 12000 1750 300 600 150 3000 1500 1 Instructions: Record the transactions & Post to the General Ledger accounts. 2 Prepare Bank Reconciliation and post the necessery General Journal Entries. 3 Prepare a worksheet with unadjusted trial balances in it. At the end of July analyze and use these data to complete month-end adjustments. Supply on hand.............. Record adjustments to Insurance, Rent and Equipment Depreciation Accrual receptionist salary on July 31st for one day. Unearned fees as of July 31 ....... 4 Journalize and post adjusting entries after completing the worksheet 5 Prepare an Income Statement, a Retained Earnings Statement, and a Balance Sheet 6 Prepare, record, and post closing entries. 175 2750 44 H 13500 20800 3200 7500 G Your new firm entered into the following transactions starting July 1st, 2016 -Jul Following assets were received from you in exchange for 1000 shares of common stock: Cash A/R Supplies Use straight line of Depreciation Office Equipment Office Equipment useful life: Years Residual Value: 320.00 1 The firm paid 2 months' rent for a office space lease contract. 2 Paid one year insurance policy premium in advance 4 Received advance cash from a new clients for future services 5 Purchased additional office equipment on account from Office Depot 6 Received cash from clients on account 10 Paid cash for a local newspaper advertisement 12 Paid Office Depot for part of equipment purchased on account 12 Sent invoice #005 to a customer for 90 hrs consultation provided recently 14 Paid your receptionist for two weeks' salary 17 From a cash clients, you received cash after providing some consultation 18 You paid by your business debit card to purchase some supplies 20 Sent invoice #006 to a customer for the service provided during last few days 24 From a cash clients, you received cash after providing some consultation 26 Received cash from clients on account 27 Paid your receptionist for two weeks' salary 5000 4500 5500 6500 20800 400 5200 13500 1750 450 600 6600 200 12000 1750 Date: 07/12/2016 Invoice # 005 Consue TO Best Customer Ever Consultation Inc. 2000 Forever Street Pasadena, CA 91106 Tel: 999-999-9999 Fax 900-900-0000 Consultinfo.com 100 New Ave New Hall, CA 99000 Tel: 299.500-5000 Customer ID ABC12345 SALESPERSON PAYMENT TERMS DUE DATE JOB Bookkeeping Consultation Due on receipt QTY DESCRIPTION UNIT PRICE LINE TOTAL 90 hours Bookkeeping and Business Consultation $150 $13500 $13,500 SUBTOTAL SALES TAX TOTAL $13,500 INVUICE Date: 07/20/2016 L CHIU Best Customer Ever Consultation Inc. 2000 Forever Street Pasadena, CA 90000 Tel: 999.999.9999 Fax 900.900.000 Consultinfo.com 100 New Ave New Hall, CA 99000 Tel: 299.500.5000 Customer ID ABC12345] PAYMENT TERMS DUE DATE Due on receipt Bookkeeping Consultation OTY DESCRIPTION UNIT PRICE LINE TOTAL 0 hours Bookkeeping and Business Consultation $150 SUBTOTAL $6,600 $6,600 TUU New Ave Pasadena, CA YUUUU Tel: 999-999-9999 Fax 900-900-0000 Consult@info.com New Hall, CA 99000 Tel: 299-500-5000 Customer ID (ABC12345] SALESPERSON JOB PAYMENT TERMS DUE DATE Bookkeeping Consultation Due on receipt QTY DESCRIPTION UNIT PRICE LINE TOTAL 20 hours Bookkeeping and Business Consultation $150 $3000 $3,000 SUBTOTAL SALES TAX TOTAL $3,000