Can you tell me where I going wrong on the worksheet tab and guide me on how to fill out the Income statement and balance sheet?

Excel Jeon, Gordon > Documents U4A6 - Gordon - Saved File Home Insert Formulas Data Review View Jeon, Gordon Help Tell me what you want to do Open in Desktop App Default Share Headings Comments Keep Exit New Options Editing Reading New Freeze View View Window Panes ~ Gridlines Sheet View Document Views Window Show J45 E G H K 1 M N D. Virk, Chartered Accountants P Q ISTUVWXYZAA AB AC AD AE AF AG AH Al AJ AK AL AM AN AO AP AQ Worksheet December 31, 2015 Accounts No . Trial Balance Adjustments DR CR Income Statemen Balance Sheet DR CR OR CR OR CF 9 Bank 100 26,865.00 5 10 Accounts Receivable 516.00 105 26,349.00 9,650.00 26,349.0 244.00 11 9,406.00 Allowance for Doubtful Accounts 110 9,406.00 12 510.00 8 115 244.001 Supplies 66.00 7,000.00 13 6 1,000.00 366.00 |Prepaid Insurance 12,900.00 6,000.00 14 120 6,000.00 4) Building 125 322.50 12,577.50 147,100.00 12,577.50 15 Accumulated Amortization - Building 147,100.00 130 147,100.00 16 8,650.66 3 2.768.99 Office Equipment 135 11,419.65 30,100.00 11,419.65 17 140 30,100.00 cumulated Amortization - Equipment 30,100.0 15,000.00 18 145 1 5,000.00 Automobile 20,000.00 14,200.00 20,000.00 19 150 14,200.00 Accumulated Amortization - Automobile 2 930.61 14,200.00 20 9,546.94 Accounts Payable 200 3,275.00 10,477.55 10,477.55 21 Salaries Payable 3.275.00 205/ 3,275.00 22 HST Payable 1 2,975.00 2,975.00 2,975.00 23 210 11,650.00 HST Recoverable 24 215 11,650.00 150.00 11,650.00 oan Payable 225 150.00 150.00 25 17,500.00 Mortgage Payable 230 17,500.00 17,500.00 26 D. Virk, Capital 47,000.00 47,000.00 27 |300 47,000.00 94,132.40 |D. Virk, Drawings 305 94,132.40 13.200.00 94,132.40 28 Fees Revenue 13,200.00 29 400 13,200.00 77,500.00 Automobile Expense 600 2,400.00 77,500.00 77,500.00 30 31 Loss on Disposal of Fixed Asset 625 2,400.00 2,400.0 1,250.00 Salaries Expense 630 1,250.00 32 17,900.00 Utilities Expense 635 2,975.00 7 1,250.00 2,150.00 20,875.00 20,875.00 33 2,150.00 284,865.00 284,865.00 2,150.00 34 Amortization Expense - Automobile 610 285,757.50 35 Amortization Expense - Building 611 930.61 2 930.61 930.6 36 37 612 2,768.99 3 1,768.90 Amortization Expense - Equipment Insurance Expense 630 5,000.00 1 2,768.99 322.50 4) 1,000.00 5,000.00 38 Interest Expense 640 322.50 39 652 516.00 5 322.50 516.00 Supplies Expense 516.00 40 1,000.00 6 1,000.00 1,000.00 41 13,757.10 13.757.10 Net Income 296,295.60 296,295.60 296,295.60 296,295.60 42 43 Instructions Journal - Adjusting Entries Worksheet Income Stmt Balance Sheet Journal-Closing Entries Calculation Mode: Auton Workbook StatisticsExcel Jeon, Gordon > Documents U4A6 - Gordon - Saved Jeon, Gordon File Home Insert Formulas Data Review View Help Tell me what you want to do Open in Desktop App Share Comments Default Headings Keep Exit New Options Editing Reading New Freeze View View Window Panes ~ Gridlines Sheet View Document Views Window Show M14 IA B C D E G H K L M N 0 P Q R S T U V W X Y Z AA AB AC D. Virk, Chartered Accountants Income Statement ...For the Year Ending December 31 201? Revenue 10 Operating Expenses 12 Automobile PapenE.. 13 Amortization Expense - Automobile 14 :Amortization Expense - Building -...-..... 15 Amortization Expense - Equipment 16 Insurance Expense 17 Salaries Expense 18 Supplies Expense..... 19 Utilities Expense... 20 Total Operating Expenses 21 Operating Income (Net Income Before Interest, Taxes and 22 23 Extraordinary Items).... 24 25 Loss on Disposal of Fixed Asset 26 Total of Extraordinary Items 27 28 29 Net Income Hint: Net Income should be the same as on the worksheet. 42 Instructions Journal - Adjusting Entries Worksheet Income Stmt Balance Sheet Journal-Closing Entries + Calculation Mode: Automatic Workbook StatisticsExcel Jeon, Gordon > Documents U4A6 - Gordon - Saved Jeon, Gordon File Home Insert Formulas Data Review View Help Tell me what you want to do Open in Desktop App Share Comments Default Headings Keep Exit New Options Editing Reading New Freeze View View Window Panes ~ Gridlines Sheet View Document Views Window Show K35 B D E F H K L M N P Q R S T U V W X Y Z AA AB AC AD AE Balance Sheet December 31, 2015 Assets Current Assets Bank Accounts Pang""..... Accounts Receivable 10 : Allowance f ce for Doubt ul Accounts 11 12 Prepaid Insurance 13 14 15 Fixed Assets 16 17 Building 18 Accumulated Amortization - Building 19 : Accumulated Amortization - Equipment... : Automobile Accumulated Amortization - Automobile 23 -....me.DR............ 24 25 TOTAL ASSETS 26 27 Liabilities and Owner's Equity 28 29 Current Liabilities..... : Accounts Payable 30 -........... 31 alaries Payable :HST Payable " 32 33 BEST. Recoveracts............... 34 Total Current Liabumet. Long Term Liabilities 35 Loan Payable 36 Mortgage Payable 37 38 :.... Total.Long Term Liabilities.... 39 TOTAL LIABILITIES 40 J. Boulton, Capital 41 Equity at the Beginning of the Period Add: Net income.............. 43 Less: Drawing!........................" 44 Change in Equity for the Period ..Equity at the End of the Period 45 46 47 TOTAL LIABILITIES AND OWNER'S EQUITY 48 49 Hint: You should balance out at $203,469.30 Instructions Journal - Adjusting Entries Worksheet Income Stmt Balance Sheet Journal-Closing Entries Calculation Mode: Automatic Workbook StatisticsExcel Jeon, Gordon > Documents U4A6 - Gordon - Saved Jeon, Gordon File Home Insert Formulas Data Review View Help Tell me what you want to do Open in Desktop App Share Comments Default Headings Keep Exit New Options Editing Reading New Freeze View View Window Panes ~ Gridlines Sheet View Document Views Window Show E1 f& D. Virk, Chartered Accountants C D F ( H M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH Al D. Virk, Chartered Accountants W N General Journal Date P.R Debit December Particulars Credit Closing Entries 10 31 Fees Revenue 12 Income Summary 13 14 15 31 Income Summary Automobile Expense 16 Amortization Expense - Automobile Amortization Expense - Building 18 Amortization Expense - Equipment Insurance Expense Interest Expense Loss on Disposal of Fixed Asset Salaries Expense Supplies Expense Utilities Expense 25 26 31 Income Summary D. Virk, Capital 31 D. Virk, Capital D. Virk, Drawings 168,200.00 168,200.00 Instructions Journal - Adjusting Entries Worksheet Income Stemt Balance Sheet Journal-Closing Entries + Calculation Mode: Automatic Workbook Statistics