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

This preview shows page 1 - 3 out of 6 pages.

MSU Candy Company, Inc.Work Sheet for the Year Ended 12/31/12Accounts2011 PC Trial BalanceAdjustmentsDebitCreditDebitCreditCash10,000 A2558,384 B2316,676 A326,600 B313,000 E3,246 C2,200 HH1,427 D27,256 I4,000 G74,470 HH620Accts/Rec28,000 A1620,427 A2558,384 A326,600 A41,400 Allow. for D. Accts.2,000 A41,400 AA2502Notes Rec.6,000 E3,000 Merch Inv.60,000 BB54,270 BB60,000 Prep. Insurance500 C2,200 CC1,650 Supplies8,000 D27,256 DD29,829 Land40,000 Building200,000 AccumDepr-Bldg16,000 FF0Equipment80,000 F7,427 F10,000 AccumDepr-Equip28,800 F3,600 FF0Accts/Pay13,000 B2316,676 B1372,560 B313,000 Salaries Pay5,000 G5,000 GG17256Payroll Taxes Pay2,000 G2,000 GG3427Unearned Revenue3,000 H2,160 Dividends Pay4,000 I4,000 I6,427 Com Stk-$10 Par200,000 APIC-C/S20,000 Sales RevenueA1620,427 H2,160 Interest Revenue EE123 Gain on ExchangeF1,027 Interest Revenue E246 EE123 HH1,427 DividendsI6,427 Cost of Good SoldBB378,290 PurchasesB1372,560 BB372,560 Bad Debts ExpenseAA2502Insurance ExpenseCC1,650 Supplies ExpenseDD29,829 Salaries and Wages ExpenseG59,270 GG17256Payroll Taxes ExpenseG8,200
GG3427Office ExpenseHH620Depreciation Expense - BuildingFF4000Depreciation Expense - EquipmentFF0Retained Earnings138,700 Tax ExpenseII0Tax PayableII0Totals

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture