Excel Project post-closing trial balance worksheet.xlsx -...

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

MSU Candy Company, Work Sheet for the Year Ended 1 Accounts 2011 PC Trial Balance Debit Credit Cash 10,000 a2, a3,e,hh Accts/Rec 28,000 a1 Allow. for D. Accts. 2,000 a4 Notes Rec. 6,000 Merch Inv. 60,000 bb Prep. Insurance 500 c Supplies 8,000 d Land 40,000 Building 200,000 AccumDepr-Bldg 16,000 Equipment 80,000 f AccumDepr-Equip 28,800 f Accts/Pay 13,000 b2,b3 Salaries Pay 5,000 g Payroll Taxes Pay 2,000 g Unearned Revenue 3,000 h Dividends Pay 4,000 i Com Stk-$10 Par 200,000 APIC-C/S 20,000 Retained Earnings 138,700 Totals 432,500 432,500 Journal Entries A1. Accounts Receivable 680,378 Sales Revenue 680,378 A2. Cash 612,340 Accounts Receivable 612,340 A3. Cash 26,600 Accounts Receivable 26,600 A4. Allowance for doubtful Acc 1,400 Acc. Rec. 1,400 B1. Purchases 376,970 Acc. Pay 376,970 B2. Acc. Pay 320,425 Cash 320,425 B3. Acc. Pay 13,000 Cash 13,000
C. Prepaid insurance 2,800 Cash 2,800 D. Supplies 27,697 Cash 27,697 E. Cash 3,000 Cash Interest 264 Notes Rec. 3,000 Interest Revenue 264 F. Equipment 7,378 Accum. Dep. Equip 3,600 Equipment 10,000 Gain on Disposal of Equip. 978 G. Salaries Exp. 63,780 Cash 63,780 Salaries Pay. 5,000 Cash 5,000 Payroll Tax Exp. 10,800 Cash 10,800 Payroll Tax Pay. 2,000 Cash 2,000 H. Unearned Revenue 2,340 Revenue 2,340 I. Dividends 6,378 Dividends Pay. 6,378 Dividends Pay. 4,000 Cash 4,000
y, Inc.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture