Prepapre a Bank & Book reconcilation please!

Please follow the provided format

Davis Consulting performs systems consulting and has begun selling software. The company uses the perpetual inventory system to account for software inventory. During January 20X2, Davis Consulting completed the following transactions: Jan. 2 2 5 7 18 19 20 21 22 24 26 28 28 Completed a consulting engagement and received cash of $7,800. Prepaid five months office rent, $2,375, check #206. Purchased office supplies on account, $300. Purchased 80 units software inventory on account, $1,680, plus freight-in, $80. Sold 40 software units on account, $2,000. Consulted with a client for a fee of $1,000 on account. Paid employee salaries, $2,100 (includes accrued salaries) check #207. Purchased 240 units software inventory on account, $6,240. Paid on account, $1,760, check #208. Paid utilities, $200, check #209. Paid $3,900 on account, check #210. Sold 120 units software for cash, $6,000. Collected $1,500 on account. At December 31, 20x1, the business gathers the following information for the adjusting entries: a) Accrued salaries expense, $678.72. b) Office supplies on hand, $150. c) Depreciation on computer, $45; Depreciation on furniture, $65. d) Expiration of prepaid rent, $475. e) Physical count of software inventory, 145 units. 17,800 8,222 Bank Statement for January 31, 20X2 Beginning Balance, December 31,20X1 Deposits and other Credits: Jan. 2 7,800 Jan. 20 (EFT Hip Hop Hats-a customer) 400 Jan. 28 (Interest credit) 22 Checks and other Debits: Jan. 2 (EFT to Paper Products) 9 Jan. 18 (ck#207) 2,100 Jan. 19 (ck#209) 200 Jan. 28 (EFT to The Cable Co.) 85 Jan. 28 (ck#208) 1,760 Bank Service Charge 15 Ending Balance, January 31, 20X2 4.169 21,853 1 DAVIS CONSULTING Bank Reconciliation 1/31/20X2 3 BANK 21,853.00 BOOK Balance, January 31, 20X2 ADD: 22,765.00 0.00 21,853.00 0.00 22.765.00 LESS: 6 Balance, January 31, 20X2 7 ADD: 8 9 10 11 12 LESS 13 14 15 Adjusted bank balance, 16 January 31, 20X2 17 0.00 0.00 Adjusted book balanco, January 31, 20X2 $ 21,853,00 $ 22,765.00