Hi, I have attached a project I need help with.

The document has the financial transactions and they need to be put into trial balances, statements, and such.

The Excel file has the template and spaces to organize the data for each of the steps. Thanks!

On December 1, 2014, Jane Smith set up a new Human Resources Consulting Company, Good Staff Inc. The following transactions occurred during the company's first month, December 131, 2014. Decembe r 1 Jane invested $20,000 cash and computer equipment worth $30,000 in the company in exchange for common stock. 2 The company rented the office space by paying $1,750 cash for the first month's (December) rent. 3 The company purchased $2,000 of office supplies for cash. 10 The company paid $3,600 cash for the premium on a 12-month insurance policy. Coverage begins on December 1, 2014. 14 The company paid $1,500 cash for two weeks' salaries earned by employees. 24 The company collected $9,000 cash on Consulting Fees from the customers. 28 The company paid $1,500 cash for two weeks' salaries earned by employees. 29 The company paid $500 cash for minor repairs to the company's computer. 30 The company paid $800 cash for this month's telephone bill. 31 The Company paid $150 for Utilities of December 2014 by cash 31 The company paid $2,000 cash for dividends. The company's chart of accounts follows: Cash Account Receivable Accrued Revenues Consulting Fees Earned Depreciation Expenses - Computer Office Supplies Prepaid Insurance Computer Equipment Accumulated Depreciation- Computer Salaries Expenses Insurance Expenses Rent Expenses Office Supplies Expenses Repairs Expenses Telephone Expenses Utilities Expenses Common Stock Retained Earnings Dividends Page 1 of 2 Required: 1. Prepare journal entries to record the transactions for December (Steps 1 & 2) 2. Post the Journal Entries to the ledger accounts (Step 3). 3. Prepare an unadjusted trial balance as of December 31 (Step 4) 4. Use the following information to journalize and post adjusting entries for the month of December: (Step 5) 1. One month's insurance coverage ($300) has expired. As of December 31, 2014, the insurance coverage of $3,300 has not unexpired 2. At the end of the month, $1,200 of office supplies are still available. 3. This month's depreciation on the computer equipment is $1,000. 4. The company earned $2,500 of Consulting Services that are not yet billed at month-end. 5. Prepare the adjusted trial balance as of December 30 (Step 6) 6. Prepare the income statement and the statement of retained earnings for the month of December and the balance sheet at December 31, 2014. (Step 7) Page 2 of 2 GOOD STAFF INC. DECEMBER 31, 2014 Step 5 Adjustments Step 4 Unadjusted Trial Balance Debits Credits Debits Step 6 Adjusted Trial Balance Credits Debit Credits Cash Account Receivables Accrued Revenues Office Supplies Prepaid Insurance Computer Equipment Accumulatd Depreciation Common Stock Retain Earnings Dividends Commisions Earned Depreciation Expenses Salaries Expenses Insurance Expenses Rent Expense Office SuppliesExpenses Repaired Expenses Telephone expenses Utility Expenses Total - - ## - - ### GOOD STAFF INC. Steps 1 & 2: Journalize / Prepare Journal Entries Date Date Accounts Debit Credit Step 5: Prepare Adjusting Journal Entries Accounts Debit Credit GOOD STAFF INC. Posting to General Ledger (Steps 3 & for Step 5 also) Cash Common Stock Consulting Fees Earned Retained Earnings Depreciation Expenses Salaries Expenses Dividends Insurance Expenses Account Receivable Office Supplies Expenses Office Supplies Repairs Expenses Prepaid Insurance Telephone Expenses Utilities Expenses Computer Equipment Accumulated Depreciation Accrued Salary Rent Expenses GOOD STAFF INC Income Statements GOOD STAFF INC. Statements of Retained Earnings Revenues Expenses Retained Earnings, December 31, 2014 GOOD STAFF INC. Balance Sheet As of December 31, 2014 Total Expenses Assets Net Income Total Assets Total Liabitity & Equity