Acc 150: Final Exam Version 3 1. Input Company Info Company Name: Your Name Accounting LLC Address: 75 Park Avenue, NY NY 10016 Industry: Accounting Form: Sule Proprietorship EIN 4 123-45-1112 Tel: 212-555-1212 2. Create Chart of Accounts (soc trial balance below) 3. Input Beginning Balances Cash Checking Accou Savings Account Petty Cash Accounts Receivable Fixed Asset Furniture Accumulated Depreciation Accounts Payable Your Name, Capital Revenue Bookkeeping Tax Services Consulting Fees Expenses Rent Bad Debts Expense General Liability Insurance Telephone Total 4. Set up Service Fees Bookkeeping Tax Services Consulting Fees 5. Supporting Details for A/R ABC ABC DEF DEF GHI GHI 6. Supporting Details for A/P Columbia Realty Sprint 6. Transactions for Jam 2021 Your Name Accounting LLC Trial Balance 12/31/20 DR 25,000 40,000 600 30,000 6,000 CR 0 6,000 95,600 101,600 101.600 Address 100 Park Ave NY NY 10016 Terms net 30 net 30 Invoice Date 59 109 34 Lexington Ave NY NY 10003. net 30 120 net 30 145 89 6th Ave NY NY 10001 net 30 net 30 160 165 5/5/19 Amoun Revenue 5,000 Bookkeeping 5.000 Tax Services 2,500 Consulting 7,500 Bookkeeping 6,000 Consulting 10/1/19 4/4/20 8:30-20 11/2/20 12/15/20 4,000 Tax Services Address Termis Invoice Date 900 Quums Blvd, Queens NY 19091 PO Box 33 Rochester NY 15674 due upon receipt met 15 45 12/1/20 800 12/14/20 2-Jan Pay Columbia Realty 4-Jan Collected 80% of Invoice #59 for ABC ABC; write off difference (deposit to checking) 6-Jan Received invoice from Office Depot for purchase of computer $1800. 8-Jan Prepaid 6 months of general liability insurance to AIG Insurance $600 10-Jan Send invoice to DEF DEF for Bookkeeping $2000 on account 12-Jan Paid Office Depot 15-Jan Void payment to Office Depot 18-Jan Send credit memo to GHI GHI for invoice # 160 for $500 (apply to invoice) 22-Jan Collected GHI GHI invoice a 160 (deposit to savings) 25-Jan Pay Sprint in full 28-Jan Transfer $5000 from Savings to Checking 31-Jan Record lan depo for Furniture; 5 year life Record Jan depn for Computer, 3 year life Record General Liability Insurance Expense for Jan 2021 7 Prepare Bank Reconciliation for Checking Account Bank Statement as of January 31 20121 Beginning Balance 4-Ja 8-Jan 11-Jan 28-Jan 31-Jan Payments Deposits Amount Account 4.000 Rent 2,000 Telephone Bank Balance Comments 25.000 4,000 29,000 ABC ABC deposit 25,000 Columbia Realty 4,000 600 5,000 25 & Submit Trial Balance Jan 31 2021; General Journal Jan 1-31 2021; and Bank Reconciliation Summary for Jan 31 2021; Balance Sheet as of Jan 31 2021 and Income Statement Jan 1-31 2021 24,400 Prepaid Insurance 29,400 Transfer 29.375 Bank Chanje