Hi I need an answer for the following exercise I had. Kindly provide the answer in excel sheet.

Thanks!

The trial balance columns of the worksheet for le Company at June 30, 2014, are shown below. LIM COMPANY Wnrksheet Fur the Mnth Ended June 3|], 2014 Cash Accounts Receivable Supplles Accounts Payable unearned Service Revenue Share CapltalOrdlhary Service Revenue Salanes and Wages Expense Miscellaneous apense Other data: HK$4,296 2,559 1,373 HK$1,035 357 4,550 3,527 554 177 messes; masses; 1. A physical count reveals HK$625 or suppllea on hand. 2. HK$107 of the unearned revenue is still unearned at monthrend. 3. Accrued salaries are HK$245. Enter the tnal balance on a worksheet and Complete the worksheet. Cash Accounts Recelvable Supplies Accounts Payable unearned Servlce Revenue Share CapitalDrdlnary Servlce Revenue Salaries and Wages Expense Mlscellaneous Expense Totals Supplies Expense Salaries and Wages Payable Totals Net Income Totals 2,599 1,373 1,035 367 4,350 3,527 854 177 9,339 9,339 LIM COMPANY Worksheet For HIE Holll Ended Jlllle 3|), 2014 (in lousands)