EXCEL TEMPLATES - Chapter 3

.xlsx

School

Northern Alberta Institute of Technology *

*We aren’t endorsed by this school

Course

ACCT1115

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

37

Uploaded by ProfessorFog9275

Report
DO IT! 3-3 Transaction Analysis # Description Accounts Impacted Type of Account Increase or Decrease Debit/Credit Amount 1 ' Jan 1 Green Robin issued 1,000 common shares in exchange for $5,000 cash. 2 ' Jan 1 3 ' Jan 1 4 ' Jan 15 Green Robin sold $1,000 of services on account. 5 ' Jan 31 6 ' Jan 31 The company paid $400 in wages to employees. (Needed for pivot table) The company rented a retail location, paying $3,000 in rent for January, February and March. The company took out a bank loan for $6,000 and purchased new equipment. The equipment will be depreciated at 2% per month. The company received $500 from its customers as payments on their accounts that originated January 15.
DO IT! 3-3 Date Account Titles Debit Credit Required 1. For transactions (1) to (6), record the journal entry 2. For transactions (1) to (6), post the transactions to the appropriate T-Accounts 3. Bonus- Could you sum the accounts using a pivot table instead of manually posting to T-Accounts?
Cash Accounts Receivable Prepaid Rent Equipment Bank Loan Wages Expense Service Revenue Common Shares
DO IT! 3-3 Transaction Analysis # Description Accounts Impacted Type of Account Increase or Decrease Debit/Credit Amount 1 ' Jan 1 Green Robin issued 1,000 common shares in exchange for $5,000 cash. Cash Asset Increase Debit 5,000 Common Shares Common Shares Increase Credit 5,000 2 ' Jan 1 Prepaid Rent Asset Increase Debit 3,000 Cash Asset Decrease Credit (3,000) 3 ' Jan 1 Equipment Asset Increase Debit 6,000 Bank Loan Liability Increase Credit 6,000 4 ' Jan 15 Green Robin sold $1,000 of services on account. Accounts Receivable Asset Increase Debit 1,000 Service Revenue Revenue Increase Credit 1,000 5 ' Jan 31 Cash Asset Increase Debit 500 Accounts Receivable Asset Decrease Credit (500) 6 ' Jan 31 The company paid $400 in wages to employees. Wages Expense Expense Increase Debit 400 Cash Asset Decrease Credit (400) (Needed for pivot table) The company rented a retail location, paying $3,000 in rent for January, February and March. The company took out a bank loan for $6,000 and purchased new equipment. The equipment will be depreciated at 2% per month. The company received $500 from its customers as payments on their accounts that originated January 15.
DO IT! 3-3 Date Account Titles Debit Credit Cash 5,000 Common Shares 5,000 Prepaid Rent 3,000 Cash 3,000 Equipment 6,000 Bank Loan 6,000 Accounts Receivable 1,000 Service Revenue 1,000 Cash 500 Accounts Receivable 500 Wages Expense 400 Cash 400 Required 1. For transactions (1) to (6), record the journal entry 2. For transactions (1) to (6), post the transactions to the appropriate T-Accounts 3. Bonus- Could you sum the accounts using a pivot table instead of manually posting to T-Accounts?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help