Excel WorkBook for Assignment 1

Excel WorkBook for Assignment 1 - Morrissette...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Morrissette Pharmaceuticals, Inc. Year-End Worksheet 12/31/xx General Ledger Spreadsheet Exercise TB: Page 1 ACCT ACCOUNT NO TITLE 1100 Cash 1200 Accounts receivable 1300 Allowance for bad debts 1400 Inventory 1500 Prepaid expenses 1700 Marketable securities 2000 2200 Accumulated depreciation 3100 Accounts payable 3200 Payroll taxes payable 3300 Federal incomes taxes payable 3350 Interest payable 3500 Notes payable 4100 Common stock 4200 Dividends 4300 Retained earnings 5100 Sales 5200 Sales returns and allowances 5300 Sales discounts taken 6100 Inventory Adjustment to COGS 6200 Purchases 6300 Purchases returns and allowances 6400 Purchases discounts taken 6500 Freight-in 7100 Rent expense 7200 Advertising expense 7300 Office supplies expense 7400 Depreciation expense 7500 Wages expense 7600 Payroll tax expense 7700 Federal income tax expense 7800 Interest expense 7900 Bad debt expense 8100 Other operating expense TOTALS 12/31/prior year 12/31/xx POST CLOSING UNADJUSTED ADJUSTED INCOME BALANCE TRIAL BALANCE TRIAL BALANCE ADJUSTMENTS TRIAL BALANCE STATEMENT SHEET Dr Cr Dr Cr Ref Dr Ref Cr Dr Cr Dr Cr Dr Cr 22,565.00 25,600.00 25,600.00 25,600.00 17,550.00 16,400.00 16,400.00 16,400.00 500.00 600.00 600.00 600.00 48,500.00 52,000.00 52,000.00 52,000.00 500.00 500.00 500.00
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Excel WorkBook for Assignment 1 - Morrissette...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online