Acc Solution - Transaction Analysis (Spreadsheet Method)...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: Transaction Analysis (Spreadsheet Method) YOUR NAME: Transacton Analysis of Har is Company ASSETS LIABILITIES OWNERS' EQUITY Cash Inventory Equipment Rev/Exp/Div Beginning Balances as of 1 Jan 2009 60.00 67.00 60.00 323.00 (80.00) 60.00 12.00 10.00 9.00 120.00 102.00 117.00 Transaction Number/Let er 1 a 400.00 400.00 2 b 1,000.00 1,000 Revenue 3 c (400.00) (400) Expense 4 d (300.00) (300.00) 5 e (200.00) (12.00) (188) Expense 6 f (60.00) (10.00) (50) Expense 7 g (18.00) (9.00) (9) Expense 8 h (130.00) 130.00 9 i (80.00) (80) Dividend 10 j (120.00) (120) Expense 11 k 3.00 (3) Expense 12 l (40.00) (40.00) Expense 13 m 46.00 (46.00) Expense Ending Balances as of 31 Dec 2009 272.00 67.00 10.00 60.00 323.00 (120.00) 0.00 0.00 0.00 160.00 0.00 46.00 3.00 120.00 0.00 0.00 0.00 102.00 181.00 Notes: 1 Each transaction is identified with its transaction let er. Do NOT write transaction description. 2 Under retained earnings, identify revenue, expense, and dividends declared accounts. Describe these accounts in the column named Rev/Exp/Div. 3 Row 23 displays calculated cel s that sum up each column. Do NOT alter the numbers as they wil change accordingly. Particulars Debit Credit a Inventory 400 Accounts Payable 400 b Cash 1000 Sales Revenue(Retained Earnings) 1000 c Cost of Goods Sold 400 Inventory 400 d Acconts Payable 300 Cash 300 e Accrued Wages Payable 12 Wages Expense(Retained Earnings) 188 Cash 200 f Accrued Income Tax Payable 10 Income Tax Expense(Retained Earnings) 50 Cash 60 g Accrued Interest Payable 9 Interest Expense(Retained Earnings) 9 Cash 18 h Prepaid Rent 130 Cash 130 i Dividend Expense(Retained Earnings)...
View Full Document

Page1 / 7

Acc Solution - Transaction Analysis (Spreadsheet Method)...

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