50.1K

Verified Solution

Link Copied!

I Need help on the balance sheet and creating a general ledger

C L D E F G H J K L M N TA 1 Rocky Ram, Inc. 2 Worksheet 12/31/18 3 1 Balance Sheet Adjustments Dr. Ref Income Statement Dr. Cr. Ref Cr. Dr. Cr. 1 Adjusted Trial Balance Dr. Cr. 40,936 60,552 63,000 40,936 60,552 63,000 11,000 1,500 1,500 Unadjusted Trial Balance Dr. Cr. 40.900 60,552 74,000 1,500 201,000 2,000 16,000 130,000 47,000 380,000 180,000 11,500 52.000 1,100 500 199,900 1,500 17,100 130,000 199,900 1,500 17,100 130,000 1.100 1,000 48,000 48,000 380,000 180,000 380,000 180,000 500 12,000 52,000 30,000 30,000 12.000 52,000 30,000 3.000 3.000 3,000 94 4 8,200 8,200 8,200 Acc # Account Titles 1010 Cash 1020 Cash in Savings Account 1030 Accounts Receivable 1035 Allowance for Doubtful Accounts 1040 Merchandise Inventory 1050 Prepaid Insurance 1060 Supplies 1510 Office Equipment 1515 Accum. Depr.- Office Equip 1520 Land 1530 Building 1535 Accum. Depr.- Bldg. 2010 Accounts Payable 2020 Wages & Salaries Payable 2030 Unearned Rent Revenue 2040 Interest Payable 2050 Income Taxes Payable 2500 Dividends Payable 2700 Notes Payable 2800 Mortgage Notes Payable 3000 Common Stock 3800 Retained Earnings 3900 Dividends 4010 Sales Revenue 4100 Sales Returns and Allowances 4150 Sales Discounts 5010 Cost of Goods Sold 6000 Wage & Salary Expense 6010 Insurance Expense 6020 Utilities Expense 6030 Supplies Expense 6040 Depreciation Expense - Bldg. 6050 Depreciation Expense - Equip. 6060 Bad Debt Expense 7000 Interest Expense 7100 Interest Revenue 7150 Rent Revenue 9000 Income Tax Expense Totals Net Income Totals 200,000 190.000 470,000 200,000 190,000 470,000 200,000 190,000 470,000 14,200 6.000 8.200 14,200 2, 152,200 2,152,200 2,152,200 2,152 200 7,200 15,600 1,202,075 685,000 4,000 73.800 26,000 5,500 11.000 30,000 500 7,200 15,600 1,202,075 715,000 4500 73,800 26,000 6,000 12,000 11.000 4,219 1,202,075 715,000 5,000 73,800 26,000 6,000 12,000 11,000 4.219 7.200 15,600 1,202,075 715,000 5,000 73.800 26,000 6,000 12,000 11,000 4.219 500 1,000 11,000 4,125 36 588 3,000 588 3,000 588 3,000 3,000 3.124.752 $3.124.752 430 55,430 | 3,167,582 3,167,582 2,055,094 3,106,888 2,155,788 100,694 3,228,776 121,888 "Ref Explanations: 10 999

Answer & Explanation Solved by verified expert

See Answer