Copy of Excel Project post-closing trial balance worksheet (version 1) (version 1).xlsx

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

MSU Candy Company, Inc. Work Sheet for the Year Ended 12/31/17 Accounts2016 PC Trial Balance Adjustments Debit Credit #Debit #Cash10,000 a2586,480 b2a326,600 b3e3,255 chh993 dgiAccts/Rec28,000 a1651,644 a2a3a4Allow. for D. Accts.2,000 a41,400 aaNotes Rec.6,000 eInterest. Rec.ee127 Merch Inv.60,000 bbPrep. Insurance500 c2,510 ccSupplies8,000 d25,303 ddLand40,000 Building200,000 AccumDepr-Bldg16,000 fEquipment80,000 f7,644 fAccumDepr-Equip28,800 f3,600 fAccts/Pay13,000 b2300,076 b1b313,000 Salaries Pay5,000 g5,000 ggPayroll Taxes Pay2,000 g2,000 ggUnearned Service Revenue3,000 h2,253 Dividends Pay4,000 i4,000 iCom Stk-$10 Par200,000 APIC-C/S20,000 Retained Earnings138,700 i6,644 Totals432,500 432,500 Cost of Goods Soldbb356,590 Purchasesb1353,030 bbService RevenuehSales Revenuea1Interest RevenueehheeGain on DisposalfSalary Expg66,440 gg15,303 Payroll Tax Expg10,510 gg3,644 Insurance Expcc2,383
Bad Debt Expaa2,658 Supplies Expdd27,659 Depreciation Expf4,000 f3,488 Office Expensehh651 Totals 2,488,884 Journal Entriesref.AccountAccountDebit Credit a1Accts/Rec651,644 Sales Revenue651,644 a2Cash586,480 Accts/Rec586,480 a3Cash26,600 Accts/Rec26,600 a4Allow. for D. Accts.1,400 Accts/Rec

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture