Excel Project trial balance - ACC301.xlsx - Accounts Cash...

This preview shows page 1 - 4 out of 10 pages.

MSU Candy Company, Inc. Work Sheet for the Year Ended 12/31/17 Accounts 2016 PC Trial Balance Adjustments Debit Credit Debit Credit Cash 10,000 a2 591,917 b2 296,863 a3 26,600 b3 13,000 e 3,000 c 2,570 hh 1,029 d 24,925 g 77,430 i 4,000 Accts/Rec 28,000 a1 657,686 a2 591,917 a3 26,600 a4 1,400 Allow. for D. Accts. 2,000 aa 1,288 Notes Rec. 6,000 e 3,000 Interest Rec. ee 129 Merch Inv. 60,000 bb 3,140 Purchases b1 349,250 bb 349,250 Prep. Insurance 500 c 2,570 cc 2,428 Supplies 8,000 d 24,925 dd 27,239 Land 40,000 Building 200,000 AccumDepr-Bldg 16,000 ff 4,000 Equipment 80,000 f 7,686 f 10,000 AccumDepr-Equip 28,800 f 3,600 ff 10,240 Accts/Pay 13,000 b2 296,863 b1 349,250 b3 13,000 Salaries Pay 5,000 g 5,000 gg 14,925 Payroll Taxes Pay 2,000 g 2,000 gg 3,686 Unearned Revenue 3,000 h 2,271 Income Tax Payable ii 52,312 Dividends Pay 4,000 i 4,000 i 6,686 Com Stk-$10 Par 200,000 APIC-C/S 20,000 Retained Earnings 138,700 Dividends i 6,686 Sales Revenue a1 657,686 h 2,271 Interest Income e - ee 129 hh 1,686 Gain on Disposal of Equipment f 1,286 Cost of Goods Sold bb 352,390 Insurance Expense cc 2,428 Supplies Expense dd 27,239 Salaries Expense g 61,860 gg 14,925 Payroll Taxes Expense g 8,570
gg 3,686 Office Expense hh 657 Deprecation Expense ff 4,000 ff 10,240 Bad Debt Expense aa 1,288 a4 1,400 income tax expense ii 52,312 Totals 432,500 432,500 2,539,207 2,539,207
Adjusted Trial Bal.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture