How do I do the balance sheet it keeps telling me im off
AutoSave OFF LP6572 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X LG Arial 10 v AA Wrap Text Accounting E. 2 Insert Delete Format Y v Paste B I = _ Merge & Center ICE Conditional Format Cell Formatting as Table Styles Sort Filter Find & Select Sensitivity J27 G H I J K L A B D E F 5 6 Account Unadjusted Trial Balance Adjusting Entries 7 Number Name Debit Credit Debit Credit 8 1110 Cash 64,835.78 9 1120 Accounts Receivable 1,270.00 8,750.00 10 1130 Prepaid Insurance 5,472.00 228.00 11 1140 Prepaid Rent 6,300.00 - 2,100.00 12 1150 Office Supplies 580.00 344.00 13 1211 Office Equip 1,869.00 14 1212 Accum. Depr.-Office Equip 16.89 15 1311 Computer Equip. 215,380.00 16 1312 Accum. Depr.-Computer Equip. 3,589.67 17 1411 Building Cost 110,000.00 18 1412 Accum. Depr.-Building 289.68 19 1510 Land 21,000.00 20 2101 Accounts Payable 1,520.00 21 2102 Advanced Payments 24,500.00 22 2103 Interest Payable 1,031.33 23 2105 Salaries Payable 606.00 24 2106 Income Taxes Payable 3,015.01 25 2201 Mortgage Payable 117,900.00 454.41 26 2202 Notes Payable 128,000.00 27 3100 Capital Stock 193,154.00 28 3200 Retained Earnings 29 3300 Dividends 1,337.22 30 31 4100 Computer & Consulting Revenue 16.495.00 8,750.00 32 5010 Rent Expense 2,100.00 33 5020 Salary Expense 2,020.00 606.00 34 5030 Advertising Expense 425.00 35 5040 Repairs & Maint. Expense 1,140.00 General Journal Worksheet Income Statement A Changes in Retained Earnings A Balance Sheet Ready Page: 1 of 1 Adjusted Trial Balance Debit Credit 64,835.78 10,020.00 5,244.00 4,200.00 236.00 1,869.00 16.89 215,380.00 3,589.67 110,000.00 289.68 21,000.00 1,520.00 24,500.00 1,031.33 606.00 3,015.01 118,354.41 128,000.00 193,154.00 1,337.22 25,245.00 2,100.00 2,626.00 425.00 1,140.00 How to Create a Pivot Tabla Lodgor + Data for General Ledger EC W + 159% AutoSave OFF LP6572 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 X [G v AA et Wrap Text Accounting 2 Insert Delete Y v Paste I = B Merge & Center v ICE Conditional Format Cell Formatting es Table Styles Sort Filter Format v Find & Select Sensitivity J27 A B D E F G H I J K L - 425.00 1,140.00 940.00 - - - -- - - - 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Income Tax Expense 425.00 1,140.00 940.00 344.00 1.485.74 228.00 3,896.24 3,015.01 344.00 1.485.74 228.00 3,896.24 3,015.01 - - - - - TOTAL 457,069.00 457,069.00 20,424.99 20,424.99 474,821.99 474,821.99 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 Worksheet A Income Statement A Changes in Retained Eamings A Balance Sheet Lodger + General Journal Page: 1 of 1 How to Create a Pivot Table Data for General Ledger EC Ready W + 159% AutoSave OFF LP6572 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G Arial 10 Wrap Text Accounting 2 Insert Delete Y. v Paste . I = = = Merge & Center v ICE Conditional Format Cell Formatting as Table Styles Sort Filter Format v Find & Select Sensitivity D33 fix A B C D E F G H J L M N C Assets 6 7 8 9 10 11 12 13 14 15 16 17 18 Current Assets Cash Accounts Receivable Prepaid Insurance Prepaid Rent Office Supplies Total S 64,835.78 S 10,020.00 S 5,244.00 S 4,200.00 $ 236.00 S $ 84,535.78 Long-Term Assets Office Equip. Accum. Depr.-Office Equip. $ 1,869.00 16.89 $ 1,852.11 20 21 $ 215,380.00 3,589.67 $ 211,790.33 Computer Equip Accum. Depr.-Computer Equip. Building Cost Accum. Depr.-Building 23 24 $ 110,000.00 289.68 $ 109,710.32 323,352.76 Land Total Total Assets $ 21,000.00 S 344,352.76 Liabilities 26 27 28 29 30 31 32 33 34 35 36 37 $ $ 1,520.00 1.031.33 Current Llabilities Accounts Payable Advanced Payment Interest Payable Salaries Payable Income Taxes Payable Total $ $ 606.00 1,015.01 38 39 $ 4,172.34 A Worksheet A Income Statement A Changes in Retained Earnings Balance Sheet How to Create a Pivot Table Data for General Ledger Ledger + General Journal Page: 1 of 1 Ready W 142% AutoSave OFF LP6572 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G Arial 10 Wrap Text Accounting 2 Insert Delete Y. v Paste = I U Merge & Center v Conditional Format Cell Formatting as Table Styles Sort Filter Format Find & Select Sensitivity D33 fix B C D E G H L M N C 39 Total $ 4,172.34 40 41 42 43 Long-Term Liabilities Mortgage Payable Notes Payable Total Total Liabilities $ 118,354.41 128,000.00 246.354.41 44 45 $ 250,526.75 46 47 48 Stockholder's Equity 49 $ 193, 154.00 Capital Stock Retained Earnings Total Total Liabilities and Stockholder's Equity 193,154.00 $ 443,680.75 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 General Journal A Worksheet A Income Statement A Changes in Retained Earnings Balance Sheet How to Create a Pivot Table Data for General Ledger Ledger Ready Page: 1 of 1 W + 142% %
