I have had a tutor help me with this accounting cycle problem, but its done differently than the way we learned it. This is from chapters 1-5 in College Accounting 13th edition. If I can have someone do it correctly so that I may learn from it. I have attached the excel that was done with a tutor and the directions on how its suppose to be done. I know its missing the a,b,c,d on the worksheet and also the adjusting and closing entries as well as some ledgers are not done. I need help with it ASAP for my study guide.

MINI PRACTICE SET SOUSA REALTY Name: Section: Date: (1) SOUSA REALTY General Journal PAGE 1 Amount($) Date 201x, June Account Titles and Description 1 Cash James Sousa, capital Initial investment of cash by owner PR Dr. 111 311 8 0 0 0 1 Office Equipment Cash Purchase office equipment 121 111 3 0 0 0 1 Prepaid Rent Cash Rent paid in advance (3 months) to Miller Property Management 114 111 2 1 0 0 1 Automobile Accounts payable Purchased automobile from Volvo West 123 211 15 0 0 0 4 Office Supplies Cash Purchased supplies for cash from Office Supply Direct 115 111 4 0 0 5 Office Supplies Accounts payable Purchased supplies on acct. from Office Supply Direct 115 211 2 5 0 6 Cash Commission Earned Sold home to Bill Barnes earned commission 111 411 6 0 0 0 8 Gas Expense Cash Paid gas bill to Petro Petroleum 513 111 2 2 Cr. 00 8 0 0 0 00 3 0 0 0 00 2 1 0 0 00 15 0 0 0 00 4 0 0 00 2 5 0 00 6 0 0 0 00 2 2 00 00 00 00 00 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 2 Amount($) Date Account Titles and Description 201x, June 15 Salary expense Cash Paid salary to Betty Long office secretary PR Dr. 512 111 5 5 0 17 Accounts Receivables Commission earned Sold building lot to West Land Developers and earned commission 112 411 6 5 0 0 20 James Sousa, withdrawal cash Owners withdrawal to pay personal expense 312 111 1 0 0 0 21 Cash Commissions Earned Sold home to Laura Harrison earned commission 111 411 4 5 0 0 22 Gas Expense Cash Paid gas bill to Petro Petroleum 513 111 4 5 24 Repairs Expense Cash Paid Volvo West for repairs 514 111 6 0 0 30 Salary expense Cash Paid salary to Betty Long office secretary 512 111 5 5 0 30 Telephone Expense Cash Paid telephone expense to Cell Service Inc. 515 111 5 1 0 Cr. 00 5 5 0 00 6 5 0 0 00 1 0 0 0 00 4 5 0 0 00 4 5 00 6 0 0 00 5 5 0 00 5 1 0 00 00 00 00 00 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 3 Amount($) Date Account Titles and Description 201x, June 30 Advertising Expense Accounts payable Bill received from Salem News but not paid PR 516 211 Dr. 1 2 0 0 Cr. 00 1 2 0 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 4 Date Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 5 Date Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 6 Date Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Amount($) CASH Date 201x, June Explanation 1 Initial investment of cash by owner 1 Purchase office equipment 1 Rent paid in advance (3 months) to Miller Property Management 4 Purchased supplies for cash from Office Supply Direct 6 Sold home to Bill Barnes earned commission 8 Paid gas bill to Petro Petroleum 15 Paid salary to Betty Long office secretary 20 Owners withdrawal to pay personal expense 21 Sold home to Laura Harrison earned commission 22 Paid gas bill to Petro Petroleum 24 Paid Volvo West for repairs 30 Paid salary to Betty Long office secretary 30 Paid telephone expense to Cell Service Inc. Post Ref. One One One One One One Two Two Two Two Two Two Two Debit 8 0 0 0 Credit 00 3 0 0 0 2 1 0 0 4 0 0 2 2 5 5 0 1 0 0 0 4 5 0 0 00 00 00 4 5 6 0 0 5 5 0 5 1 0 6 0 0 0 00 00 00 00 00 00 00 00 00 ACCOUNTS RECEIVABLE Date Explanation 201x, June 17 Sold building lot to West Land Developers and earned commission Post Ref. Two ACCOUNT NO. 111 Balance Debit Credit Debit 6 5 0 0 00 Credit 8 5 2 2 8 8 7 6 11 11 10 10 9 0 0 9 5 5 4 9 9 4 3 7 2 7 0 0 0 0 0 7 2 2 2 8 8 3 2 0 0 0 0 0 8 8 8 8 3 3 3 3 00 00 00 00 00 00 00 00 00 00 00 00 00 ACCOUNT NO. 112 Balance Debit Credit 6 5 0 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Amount($) PREPAID RENT Date 201x, June Date 201x, June Date 201x, June Date Explanation Post Ref. Rent paid in advance (3 months) to 1 Miller Property Management One OFFICE SUPPLIES Post Explanation Ref. Purchased supplies for cash from 4 Office Supply Direct Purchased supplies on acct. from 5 Office Supply Direct Credit 2 1 0 0 00 Debit 2 1 Credit 4 0 0 00 One 2 5 0 00 6 5 0 00 One Debit Credit 3 0 0 0 00 ACCUMULATED DEPRECIATION, OFFICE EQUIPMENT Post Explanation Debit Ref. 201x, June Explanation Purchased automobile from Volvo 1 West ACCOUNT NO. 115 Balance Debit Credit 4 0 0 00 Post Ref. One Debit 15 0 0 0 00 ACCOUNT NO. 121 Balance Debit Credit 3 0 0 0 00 Credit AUTOMOBILE Date 0 0 00 One OFFICE EQUIPMENT Post Explanation Ref. 1 Purchase office equipment Debit ACCOUNT NO. 114 Balance Debit Credit Credit ACCOUNT NO. 122 Balance Debit Credit ACCOUNT NO. 123 Balance Debit Credit 15 0 0 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Date Date 201x, June Date 201x, June ACCUMULATED DEPRECIATION, AUTOMOBILE Post Explanation Debit Ref. ACCOUNTS PAYABLE Post Explanation Ref. Purchased automobile from Volvo 1 West Purchased supplies on acct. from 5 Office Supply Direct Bill received from Salem News but 30 not paid Date Amount($) Credit ACCOUNT NO. 211 Balance Debit Credit One 15 0 0 0 00 15 0 0 0 00 One 2 5 0 00 15 2 5 0 00 1 2 0 0 00 16 4 5 0 00 Three SALARIES PAYABLE Post Explanation Ref. JAMES SOUSA, CAPITAL Post Explanation Ref. 1 Initial investment of cash by owner Debit Credit ACCOUNT NO. 124 Balance Debit Credit One Debit Debit Credit Credit 8 0 0 0 00 ACCOUNT NO. 212 Balance Debit Credit ACCOUNT NO. 311 Balance Debit Credit 8 0 0 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Date Amount($) JAMES SOUSA, WITHDRAWALS Post Explanation Ref. 201x, Owners withdrawal to pay personal June 20 expense Date Date Two INCOME SUMMARY Post Explanation Ref. COMMISSIONS EARNED Post Explanation Ref. 201x, Sold home to Bill Barnes earned June 6 commission Debit Credit 1 0 0 0 00 Debit Debit One 1 0 Credit Credit Explanation ACCOUNT NO. 313 Balance Debit Credit ACCOUNT NO. 411 Balance Debit Credit 6 0 0 0 00 6 5 0 0 00 12 5 0 0 00 4 5 0 0 00 17 0 0 0 00 RENT EXPENSE Date 0 0 00 6 0 0 0 00 Sold building lot to West Land 17 Developers and earned commission Two Sold home to Laura Harrison earned 21 commission Two Post Ref. ACCOUNT NO. 312 Balance Debit Credit Debit Credit ACCOUNT NO. 511 Balance Debit Credit MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Date Amount($) SALARIES EXPENSE Post Explanation Ref. 201x, Paid salary to Betty Long office June 15 secretary Paid salary to Betty Long office 30 secretary Debit Credit Two 5 5 0 00 5 5 0 00 Two 5 5 0 00 1 1 0 0 00 GAS EXPENSE Date Explanation 201x, June 8 Paid gas bill to Petro Petroleum 22 Paid gas bill to Petro Petroleum Date Date Post Ref. One Two REPAIRS EXPENSE Post Explanation Ref. 201x, June 24 Paid Volvo West for repairs Two TELEPHONE EXPENSE Post Explanation Ref. 201x, Paid telephone expense to Cell June 30 Service Inc. ACCOUNT NO. 512 Balance Debit Credit Two Debit Credit 2 2 00 4 5 00 Debit 2 2 00 6 7 00 Credit 6 0 0 00 Debit 5 1 0 00 ACCOUNT NO. 513 Balance Debit Credit ACCOUNT NO. 514 Balance Debit Credit 6 0 0 00 Credit ACCOUNT NO. 515 Balance Debit Credit 5 1 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Date ADVERTISING EXPENSE Post Explanation Ref. 201x, Bill received from Salem News but June 30 not paid Date Date Date Date Amount($) Three Debit 1 2 0 0 00 OFFICE SUPPLIES EXPENSE Post Explanation Ref. Debit DEPRECIATION EXPENSE, OFFICE EQUIPMENT Post Explanation Debit Ref. DEPRECIATION EXPENSE, AUTOMOBILE Post Explanation Ref. MISCELLANEOUS EXPENSE Post Explanation Ref. Credit Debit Debit ACCOUNT NO. 516 Balance Debit Credit 1 2 Credit Credit Credit Credit 0 0 00 ACCOUNT NO. 517 Balance Debit Credit ACCOUNT NO. 518 Balance Debit Credit ACCOUNT NO. 519 Balance Debit Credit ACCOUNT NO. 524 Balance Debit Credit MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (2) Amount($) SOUSA REALTY WORKSHEET FOR MONTH ENDED JUNE 30, 201X Trial Balance Account Titles CASH ACCOUNTS RECEIVABLE PREPAID RENT OFFICE SUPPLIES OFFICE EQUIPMENT AUTOMOBILE ACCOUNTS PAYABLE JAMES SOUSA, CAPITAL JAMES SOUSA, WITHDRAWALS COMMISSIONS EARNED SALARIES EXPENSE GAS EXPENSE REPAIRS EXPENSE TELEPHONE EXPENSE ADVERTISING EXPENSE RENT EXPENSES INVENTORY ACCUMULATED DEPRECIATION, AUTOMOBILE ACCUMULATED DEPRECIATION, OFFICE EQUIPMENT PROFIT FOR THE MONTH OF JUNE 201x CARRY FORWARD TOTAL 9 6 2 3 15 Dr. 7 2 5 0 1 0 6 5 0 0 0 0 Adjustments Cr. 3 0 0 0 0 0 Dr. 00 00 00 00 00 00 7 0 5 1 0 2 0 16 4 5 0 8 0 0 0 1 1 0 6 6 0 5 1 1 2 0 0 7 0 0 0 0 0 0 0 00 00 00 00 9 6 1 2 14 00 00 17 0 0 0 1 0 0 0 Cr. 00 00 1 00 00 00 00 00 1 1 7 0 5 2 0 1 0 0 0 0 0 00 00 00 00 Adjusted Trial Balance Dr. Cr. 7 2 3 00 5 0 0 00 4 0 0 00 6 0 0 00 9 0 0 00 8 0 0 00 16 4 5 0 8 0 0 0 0 0 0 00 17 0 0 0 1 0 0 00 6 7 00 6 0 0 00 5 1 0 00 2 0 0 00 7 0 0 00 5 0 00 2 0 0 00 1 0 0 00 Income Statement Dr. 9 6 1 2 14 4 5 0 00 41 4 5 0 1 0 5 0 00 1 0 5 0 00 41 4 5 0 00 41 4 5 0 Dr. 7 2 5 0 4 0 6 0 9 0 8 0 Cr. 3 0 0 0 0 0 00 00 00 00 00 00 00 00 16 4 5 0 8 0 0 0 1 0 0 0 00 17 0 0 0 1 1 0 7 0 0 0 0 0 6 0 1 0 0 2 0 0 1 0 0 5 2 3 00 00 00 00 00 5 0 00 00 00 00 00 00 00 00 00 6 5 1 2 7 12 41 Balance Sheet Cr. 00 12 5 2 3 36 9 7 3 00 00 36 9 7 3 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (3) Amount($) SOUSA REALTY INCOME STATEMENT FOR MONTH ENDED SEPTEMBER 30, 201X Account Titles and Description SUBTOTAL TOTAL COMMISSIONS EARNED 17 0 0 0 00 TOTAL INCOME 17 0 0 0 00 SALARIES EXPENSE GAS EXPENSE REPAIRS EXPENSE TELEPHONE EXPENSE ADVERTISING EXPENSE RENT EXPENSES ACCUMULATED DEPRECIATION, AUTOMOBILE ACCUMULATED DEPRECIATION, OFFICE EQUIPMENT TOTAL EXPENSES PROFIT FOR THE MONTH OF JUNE 201x CARRY FORWARD 1 1 6 5 1 2 7 2 1 0 6 0 1 0 0 0 0 0 7 0 0 0 0 0 0 00 00 00 00 00 00 00 00 4 4 7 7 00 12 5 2 3 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Amount($) SOUSA REALTY STATEMENT OF OWNER'S EQUITY FOR MONTH ENDED JUNE 30, 201X Account Titles and Description JAMES SOUSA, CAPITAL LESS:JAMES SOUSA, WITHDRAWALS ADD:PROFIT FOR THE MONTH OF JUNE 201x CARRY FORWARD OWNER'S EQUITY SUBTOTAL 1 0 0 0 12 5 2 3 TOTAL 8 0 0 0 00 00 19 5 2 3 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Amount($) SOUSA REALTY BALANCE SHEET JUNE 30, 201X ASSETS CASH ACCOUNTS RECEIVABLE PREPAID RENT OFFICE SUPPLIES OFFICE EQUIPMENT AUTOMOBILE INVENTORY TOTAL SUBTOTAL 9 7 2 3 6 5 0 0 1 4 0 0 6 0 0 2 9 0 0 14 8 0 0 5 0 TOTAL 00 00 00 00 00 00 00 35 9 7 3 00 LIABILITIES AND OWNER'S EQUITY SUBTOTAL OWNER'S EQUITY 19 5 2 3 00 ACCOUNTS PAYABLE 16 4 5 0 00 TOTAL 35 9 7 3 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (5) Amount($) SOUSA REALTY POST-CLOSING TRIAL BALANCE Account Titles and Description Dr. CASH ACCOUNTS RECEIVABLE PREPAID RENT OFFICE SUPPLIES OFFICE EQUIPMENT AUTOMOBILE INVENTORY OWNER'S EQUITY ACCOUNTS PAYABLE 9 7 2 3 6 5 0 0 1 4 0 0 6 0 0 2 9 0 0 14 8 0 0 5 0 TOTAL 35 9 7 3 00 Cr. 00 00 00 00 00 00 00 19 5 2 3 16 4 5 0 35 9 7 3 00 00 00 COMPLETE ACCOUNTING CYCLE PROBLEM June is due __________________ Accounting Cycle Journalize Business Transactions Post Worksheet Financial Statements Adjusting Entries Post Closing Entries Post Post Closing Trial Balance Required Work for June 1. 2. 3. 4. 5. Journalize transactions and post to ledger accounts. Prepare a trial balance in the first two columns of the worksheet and complete the worksheet using the following adjustment data: a. One month's rent had expired. b. An inventory shows $50 of office supplies remaining. c. Depreciation on office equipment, $100 d. Depreciation on automobile, $200. Prepare a June income statement, statement of owner's equity, and balance sheet. From the worksheet, journalize and post adjusting and closing entries. Prepare a post-closing trial balance. Chart of Accounts Assets Revenue 111 Cash 112 Accounts Receivable 114 Prepaid Rent 115 Office Supplies 121 Office Equipment 122 Accumulated Depreciation, Office Equipment 123 Automobile 124 Accumulated Depreciation, Automobile 411 Commissions Earned Expenses 511 Rent Expense 512 Salaries Expense 513 Gas Expense 514 Repairs Expense 515 Telephone Expense 516 Advertising Expense 517 Office Supplies Expense Liabilities 211 Accounts Payable 212 Salaries Payable 518 Depreciation Expense, Office Equipment 519 Depreciation Expense, Automobile 524 Miscellaneous Expense Owner's Equity 311 James Sousa, Capital 312 James Sousa, Withdrawals 313 Income Summary June Transactions: 1 James Sousa invested $8,000 cash in the real estate agency along with $3,000 of office equipment. 1 Rented and paid three months' rent in advance to Miller Property Management, $2,100. 1 Bought an automobile on account from Volvo West, $15,000. 4 Purchased office supplies from Office Supply Direct for cash, $400. 5 Purchased additional office supplies from Office Supply Direct on account, $250. 6 Sold a house to Bill Barnes and collected a $6,000 commission. 8 Paid gas bill to Petro Petroleum, $22. 15 Paid Betty Long, office secretary, $550. 17 Sold a building lot to West Land Developers and earned a commission, $6,500; payment to be received on July 8. 20 James Sousa withdrew $1,000 from the business to pay personal expenses. 21 Sold a house to Laura Harrison and collected a $4,500 commission. 22 Paid gas bill, $45 to Petro Petroleum 24 Paid Volvo West, $600 to repair automobile. 30 Paid Betty Long, office secretary $550. 30 Paid Cell Service Inc. June telephone bill, $510. 30 Received advertising bill for June, $1,200 from Salem News. The bill is to be paid on July 2. You will be allowed to ask two free questions about this problem. After that any question asked will incur five (5) points deducted from your final grade. I will not give you a direct answer to a question, but I will give you suggestions on how to find errors if your totals do not balance. Good Luck! PROBLEM 5A-2 Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 (1) PARKHOUSE'S CLEANING SERVICE GENERAL JOURNAL Page 2 Date Account Titles and Description Adjusting Entries Dec. 31 Insurance expense Prepaid Insurance PR Dr. 3 9 0 Cr. 00 3 9 0 3 9 0 3 6 0 0 5 0 0 0 0 0 00 00 00 00 00 00 00 3 6 0 5 31 Salarie expense Salary Payable 00 1 4 2 2 1 3 3 4 4 5 0 00 6 9 0 0 31 Depr. Expense, Auto Accum. Depr, Auto 00 3 6 0 3 9 0 00 4 5 0 31 Cleaning Supplies expense Cleaning supplies 00 00 1 1 5 0 00 00 00 00 Closing Entries 31 Fees Earned Income Summary 6 9 0 0 31 Income Summary Salarie Expense Telephone expense advertising expense Gas expense Insurance expense Cleaning Supplies Expense Depr. Expense, Auto 3 2 9 5 31 Income Summary B. Parkhouse, Capital 3 6 0 5 31 B. Parkhouse, Capital B.Parkhouse, Withdrawals 1 1 5 0 00 00 1 3 6 6 9 9 5 00 00 PROBLEM 5A-2 (CONTINUED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 CASH Date Explanation Dec 31 Balance Post Ref. Debit Credit PREPAID INSURANCE Date Explanation Dec 31 Balance 31 adjusting Post Ref. Debit Credit 3 9 0 0.00 CLEANING SUPPLIES Date Explanation Dec 31 Balance 31 Adjusting Post Ref. Debit Credit 3 9 0 0.00 AUTO Date Dec 31 Balance Date Dec 31 Balance 31 Adjusting Explanation Post Ref. Debit ACCUMULATED DEPRECIATION, AUTO Post Explanation Debit Ref. Credit Credit 4 5 0 0.00 ACCOUNT NO. 112 Balance Debit Credit 4 0 0 00 ACCOUNT NO. 114 Balance Debit Credit 1 4 5 0 00 1 0 6 0 00 ACCOUNT NO. 115 Balance Debit Credit 4 6 6 00 7 6 00 ACCOUNT NO. 121 Balance Debit Credit 3 0 4 0 00 ACCOUNT NO. 122 Balance Debit Credit 5 4 0 00 9 9 0 00 PROBLEM 5A-2 (CONTINUED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 ACCOUNTS PAYABLE Date Explanation Dec 31 Balance Post Ref. Debit Credit ACCOUNT NO. 212 Balance Debit Credit 5 9 0 00 Credit ACCOUNT NO. 213 Balance Debit Credit 3 6 0 00 SALARIES PAYABLE Date Explanation Post Ref. Debit Dec 31 Adjusting 3 6 0 0.00 B. PARKHOUSE, CAPITAL Date Explanation Dec 31 Balance 31 Closing Closing Post Ref. Debit Credit 3 6 0 5 0.00 1 1 5 0 0.00 B. PARKHOUSE, WITHDRAWALS Date Dec 31 Balance 31 closing Date Dec 31 Closing 31 Closing 31 Closing Explanation Post Ref. Debit Credit ACCOUNT NO. 312 Balance Debit Credit 1 8 1 00 3 7 8 6 00 2 6 3 6 00 ACCOUNT NO. 313 Balance Debit Credit 1 1 5 0 00 1 1 5 0 0.00 INCOME SUMMARY Post Explanation Ref. Debit Credit 6 9 0 0 0.00 3 2 9 5 0.00 3 6 0 5 0.00 ACCOUNT NO. 314 Balance Debit Credit 6 9 0 0 00 3 6 0 5 00 PROBLEM 5A-2 (CONTINUED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 CLEANING FEES Date Explanation Dec 31 Balance 31 Closing Post Ref. Debit Credit 6 9 0 0 0.00 SALARIES EXPENSE Date Explanation Dec 31 Balance 31 Adjusing 31 closing Post Ref. Debit Credit 3 6 0 0.00 ACCOUNT NO. 513 Balance Debit Credit 1 0 5 0 00 1 4 1 0 00 1 4 1 0 0.00 TELEPHONE EXPENSE Date ACCOUNT NO. 412 Balance Debit Credit 6 9 0 0 00 Explanation Dec 31 Balance 31 closing Post Ref. Debit Credit ACCOUNT NO. 514 Balance Debit Credit 2 3 5 00 2 3 5 0.00 ADVERTISING EXPENSE Date Explanation Dec 31 Balance 31 Closing Post Ref. Debit Credit 2 6 0 0.00 GAS EXPENSE Date Dec 31 Balance 31 Closing ACCOUNT NO. 515 Balance Debit Credit 2 6 0 00 Explanation Post Ref. Debit Credit 1 6 0 0.00 ACCOUNT NO. 516 Balance Debit Credit 1 6 0 00 PROBLEM 5A-2 (CONTINUED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 INSURANCE EXPENSE Date Dec Explanation Post Ref. 31 Adjusting Closing Debit Credit 3 9 0 0.00 3 9 0 0.00 CLEANING SUPPLIES EXPENSE Date Dec Explanation Post Ref. 31 Adjusting 31 Closing Debit Credit 3 9 0 0.00 Dec 31 Adjusting 31 Closing ACCOUNT NO. 518 Balance Debit Credit 3 9 0 0.00 3 9 0 0.00 DEPRECIATION EXPENSE, AUTO Date ACCOUNT NO. 517 Balance Debit Credit 3 9 0 0.00 Explanation Post Ref. Debit Credit 4 5 0 0.00 4 5 0 0.00 ACCOUNT NO. 519 Balance Debit Credit 4 5 0 0.00 Problem 5A-2 (CONCLUDED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 (2) PARKHOUSE'S CLEANING SERVICE POST-CLOSING TRIAL BALANCE DECEMBER 31, 201X Prepaid Insurance Cash Cleaning Supplies Auto Accumm. Depr. Auto Accounts Payable Salaries Payable B.Pennington, Capital Totals Dr. 1 0 6 4 0 7 30 4 Cr. 0 0 6 0 00 00 00 00 4 5 7 6 00 9 5 3 2 6 45 9 9 6 3 7 0 0 0 6 6 00 00 00 00 00 PROBLEM 4A-2 Name: Section: Date: LEMMINGS'S LANDSCAPING SERVICE WORKSHEET FOR MONTH ENDED AUGUST 31, 201X Account Titles Cash in Bank Accounts Receivable Prepaid Rent Landscaping Supplies Landscaping Equipment Accumulated Depreciation, Landscaping Equipment Accounts Payable A. Lemmings, Capital Landscaping Revenue Heat Expense Advertising Expense Wage Expense Rent Expense Landscaping Supplies Depreciation, Landscaping Equipment Accumulated Depreciation, Landscaping Equipment Salaries Payable Trial Balance Dr. 5 5 0 9 0 8 0 1 1 9 1 4 0 Adjustments Cr. 0 0 0 5 0 7 0 4 1 5 0 0 0 Cr. 00 00 00 00 00 (A) (B) 8 8 5 6 4 7 4 3 1 4 12 0 Dr. 00 00 00 00 6 3 1 0 0 6 4 0 1 0 0 8 7 0 00 00 00 00 00 00 (D) 2 5 0 00 (A) (B) ( C) 1 0 0 8 7 0 3 0 0 00 00 00 Adjusted Trial Balance Dr. Cr. 5 5 0 0 00 9 0 0 00 7 0 0 00 3 2 5 00 1 4 0 0 00 8 6 8 3 5 6 1 4 7 0 4 7 5 00 3 0 0 00 1 6 9 0 00 Income Statement Dr. 0 6 4 0 Balance Sheet Cr. 00 00 00 00 Dr. 5 5 0 9 0 1 0 3 2 1 4 0 Cr. 0 0 0 5 0 00 00 00 00 00 5 4 4 7 5 3 0 0 1 1 9 0 00 00 7 1 8 3 2 0 4 4 00 00 00 00 00 00 00 00 00 1 0 0 8 7 0 3 0 0 7 0 0 8 3 6 6 1 4 00 00 00 12 0 1 0 00 1 5 2 0 00 1 0 0 8 7 0 3 0 0 ( C) (D) 1 3 0 0 2 5 0 5 2 0 00 00 00 12 5 6 0 00 00 00 00 12 3 0 0 2 5 0 5 6 0 00 00 00 3 2 3 5 1 4 6 5 4 7 0 0 00 00 00 4 7 0 0 00 8 8 2 5 00 4 7 0 0 00 8 2 2 5 00 0 5 0 6 6 0 0 0 5 5 PROBLEM 4A-2 Name: Section: Date: LEMMINGS'S LANDSCAPING SERVICE WORKSHEET FOR MONTH ENDED AUGUST 31, 201X Account Titles Cash in Bank Accounts Receivable Prepaid Rent Landscaping Supplies Landscaping Equipment Accumulated Depreciation, Landscaping Equipment Accounts Payable A. Lemmings, Capital Landscaping Revenue Heat Expense Advertising Expense Wage Expense Rent Expense Landscaping Supplies Depreciation, Landscaping Equipment Accumulated Depreciation, Landscaping Equipment Salaries Payable Trial Balance Dr. 5 5 0 9 0 8 0 1 1 9 1 4 0 Adjustments Cr. 0 0 0 5 0 7 0 4 1 5 0 0 0 Cr. 00 00 00 00 00 (A) (B) 8 8 5 6 4 7 4 3 1 4 12 0 Dr. 00 00 00 00 6 3 1 0 0 6 4 0 1 0 0 8 7 0 00 00 00 00 00 00 (D) 2 5 0 00 (A) (B) ( C) 1 0 0 8 7 0 3 0 0 00 00 00 Adjusted Trial Balance Dr. Cr. 5 5 0 0 00 9 0 0 00 7 0 0 00 3 2 5 00 1 4 0 0 00 8 6 8 3 5 6 1 4 7 0 4 7 5 00 3 0 0 00 1 6 9 0 00 Income Statement Dr. 0 6 4 0 Balance Sheet Cr. 00 00 00 00 Dr. 5 5 0 9 0 1 0 3 2 1 4 0 Cr. 0 0 0 5 0 00 00 00 00 00 5 4 4 7 5 3 0 0 1 1 9 0 00 00 7 1 8 3 2 0 4 4 00 00 00 00 00 00 00 00 00 1 0 0 8 7 0 3 0 0 7 0 0 8 3 6 6 1 4 00 00 00 12 0 1 0 00 1 5 2 0 00 1 0 0 8 7 0 3 0 0 ( C) (D) 1 3 0 0 2 5 0 5 2 0 00 00 00 12 5 6 0 00 00 00 00 12 3 0 0 2 5 0 5 6 0 00 00 00 3 2 3 5 1 4 6 5 4 7 0 0 00 00 00 4 7 0 0 00 8 8 2 5 00 4 7 0 0 00 8 2 2 5 00 0 5 0 6 6 0 0 0 5 5 PROBLEM 5A-2 Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 (1) PARKHOUSE'S CLEANING SERVICE GENERAL JOURNAL Page 2 Date Account Titles and Description Adjusting Entries Dec. 31 Insurance expense Prepaid Insurance PR Dr. 3 9 0 Cr. 00 3 9 0 3 9 0 3 6 0 0 5 0 0 0 0 0 00 00 00 00 00 00 00 3 6 0 5 31 Salarie expense Salary Payable 00 1 4 2 2 1 3 3 4 4 5 0 00 6 9 0 0 31 Depr. Expense, Auto Accum. Depr, Auto 00 3 6 0 3 9 0 00 4 5 0 31 Cleaning Supplies expense Cleaning supplies 00 00 1 1 5 0 00 00 00 00 Closing Entries 31 Fees Earned Income Summary 6 9 0 0 31 Income Summary Salarie Expense Telephone expense advertising expense Gas expense Insurance expense Cleaning Supplies Expense Depr. Expense, Auto 3 2 9 5 31 Income Summary B. Parkhouse, Capital 3 6 0 5 31 B. Parkhouse, Capital B.Parkhouse, Withdrawals 1 1 5 0 00 00 1 3 6 6 9 9 5 00 00 PROBLEM 5A-2 (CONTINUED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 CASH Date Explanation Dec 31 Balance Post Ref. Debit Credit PREPAID INSURANCE Date Explanation Dec 31 Balance 31 adjusting Post Ref. Debit Credit 3 9 0 0.00 CLEANING SUPPLIES Date Explanation Dec 31 Balance 31 Adjusting Post Ref. Debit Credit 3 9 0 0.00 AUTO Date Dec 31 Balance Date Dec 31 Balance 31 Adjusting Explanation Post Ref. Debit ACCUMULATED DEPRECIATION, AUTO Post Explanation Debit Ref. Credit Credit 4 5 0 0.00 ACCOUNT NO. 112 Balance Debit Credit 4 0 0 00 ACCOUNT NO. 114 Balance Debit Credit 1 4 5 0 00 1 0 6 0 00 ACCOUNT NO. 115 Balance Debit Credit 4 6 6 00 7 6 00 ACCOUNT NO. 121 Balance Debit Credit 3 0 4 0 00 ACCOUNT NO. 122 Balance Debit Credit 5 4 0 00 9 9 0 00 PROBLEM 5A-2 (CONTINUED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 ACCOUNTS PAYABLE Date Explanation Dec 31 Balance Post Ref. Debit Credit ACCOUNT NO. 212 Balance Debit Credit 5 9 0 00 Credit ACCOUNT NO. 213 Balance Debit Credit 3 6 0 00 SALARIES PAYABLE Date Explanation Post Ref. Debit Dec 31 Adjusting 3 6 0 0.00 B. PARKHOUSE, CAPITAL Date Explanation Dec 31 Balance 31 Closing Closing Post Ref. Debit Credit 3 6 0 5 0.00 1 1 5 0 0.00 B. PARKHOUSE, WITHDRAWALS Date Dec 31 Balance 31 closing Date Dec 31 Closing 31 Closing 31 Closing Explanation Post Ref. Debit Credit ACCOUNT NO. 312 Balance Debit Credit 1 8 1 00 3 7 8 6 00 2 6 3 6 00 ACCOUNT NO. 313 Balance Debit Credit 1 1 5 0 00 1 1 5 0 0.00 INCOME SUMMARY Post Explanation Ref. Debit Credit 6 9 0 0 0.00 3 2 9 5 0.00 3 6 0 5 0.00 ACCOUNT NO. 314 Balance Debit Credit 6 9 0 0 00 3 6 0 5 00 PROBLEM 5A-2 (CONTINUED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 CLEANING FEES Date Explanation Dec 31 Balance 31 Closing Post Ref. Debit Credit 6 9 0 0 0.00 SALARIES EXPENSE Date Explanation Dec 31 Balance 31 Adjusing 31 closing Post Ref. Debit Credit 3 6 0 0.00 ACCOUNT NO. 513 Balance Debit Credit 1 0 5 0 00 1 4 1 0 00 1 4 1 0 0.00 TELEPHONE EXPENSE Date ACCOUNT NO. 412 Balance Debit Credit 6 9 0 0 00 Explanation Dec 31 Balance 31 closing Post Ref. Debit Credit ACCOUNT NO. 514 Balance Debit Credit 2 3 5 00 2 3 5 0.00 ADVERTISING EXPENSE Date Explanation Dec 31 Balance 31 Closing Post Ref. Debit Credit 2 6 0 0.00 GAS EXPENSE Date Dec 31 Balance 31 Closing ACCOUNT NO. 515 Balance Debit Credit 2 6 0 00 Explanation Post Ref. Debit Credit 1 6 0 0.00 ACCOUNT NO. 516 Balance Debit Credit 1 6 0 00 PROBLEM 5A-2 (CONTINUED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 INSURANCE EXPENSE Date Dec Explanation Post Ref. 31 Adjusting Closing Debit Credit 3 9 0 0.00 3 9 0 0.00 CLEANING SUPPLIES EXPENSE Date Dec Explanation Post Ref. 31 Adjusting 31 Closing Debit Credit 3 9 0 0.00 Dec 31 Adjusting 31 Closing ACCOUNT NO. 518 Balance Debit Credit 3 9 0 0.00 3 9 0 0.00 DEPRECIATION EXPENSE, AUTO Date ACCOUNT NO. 517 Balance Debit Credit 3 9 0 0.00 Explanation Post Ref. Debit Credit 4 5 0 0.00 4 5 0 0.00 ACCOUNT NO. 519 Balance Debit Credit 4 5 0 0.00 Problem 5A-2 (CONCLUDED) Name: Heevy Sindi Section: Office Accounting Date: 11/11/2015 (2) PARKHOUSE'S CLEANING SERVICE POST-CLOSING TRIAL BALANCE DECEMBER 31, 201X Prepaid Insurance Cash Cleaning Supplies Auto Accumm. Depr. Auto Accounts Payable Salaries Payable B.Pennington, Capital Totals Dr. 1 0 6 4 0 7 30 4 Cr. 0 0 6 0 00 00 00 00 4 5 7 6 00 9 5 3 2 6 45 9 9 6 3 7 0 0 0 6 6 00 00 00 00 00 PROBLEM 4A-2 Name: Section: Date: LEMMINGS'S LANDSCAPING SERVICE WORKSHEET FOR MONTH ENDED AUGUST 31, 201X Account Titles Cash in Bank Accounts Receivable Prepaid Rent Landscaping Supplies Landscaping Equipment Accumulated Depreciation, Landscaping Equipment Accounts Payable A. Lemmings, Capital Landscaping Revenue Heat Expense Advertising Expense Wage Expense Rent Expense Landscaping Supplies Depreciation, Landscaping Equipment Accumulated Depreciation, Landscaping Equipment Salaries Payable Trial Balance Dr. 5 5 0 9 0 8 0 1 1 9 1 4 0 Adjustments Cr. 0 0 0 5 0 7 0 4 1 5 0 0 0 Cr. 00 00 00 00 00 (A) (B) 8 8 5 6 4 7 4 3 1 4 12 0 Dr. 00 00 00 00 6 3 1 0 0 6 4 0 1 0 0 8 7 0 00 00 00 00 00 00 (D) 2 5 0 00 (A) (B) ( C) 1 0 0 8 7 0 3 0 0 00 00 00 Adjusted Trial Balance Dr. Cr. 5 5 0 0 00 9 0 0 00 7 0 0 00 3 2 5 00 1 4 0 0 00 8 6 8 3 5 6 1 4 7 0 4 7 5 00 3 0 0 00 1 6 9 0 00 Income Statement Dr. 0 6 4 0 Balance Sheet Cr. 00 00 00 00 Dr. 5 5 0 9 0 1 0 3 2 1 4 0 Cr. 0 0 0 5 0 00 00 00 00 00 5 4 4 7 5 3 0 0 1 1 9 0 00 00 7 1 8 3 2 0 4 4 00 00 00 00 00 00 00 00 00 1 0 0 8 7 0 3 0 0 7 0 0 8 3 6 6 1 4 00 00 00 12 0 1 0 00 1 5 2 0 00 1 0 0 8 7 0 3 0 0 ( C) (D) 1 3 0 0 2 5 0 5 2 0 00 00 00 12 5 6 0 00 00 00 00 12 3 0 0 2 5 0 5 6 0 00 00 00 3 2 3 5 1 4 6 5 4 7 0 0 00 00 00 4 7 0 0 00 8 8 2 5 00 4 7 0 0 00 8 2 2 5 00 0 5 0 6 6 0 0 0 5 5 PROBLEM 4A-2 Name: Section: Date: LEMMINGS'S LANDSCAPING SERVICE WORKSHEET FOR MONTH ENDED AUGUST 31, 201X Account Titles Cash in Bank Accounts Receivable Prepaid Rent Landscaping Supplies Landscaping Equipment Accumulated Depreciation, Landscaping Equipment Accounts Payable A. Lemmings, Capital Landscaping Revenue Heat Expense Advertising Expense Wage Expense Rent Expense Landscaping Supplies Depreciation, Landscaping Equipment Accumulated Depreciation, Landscaping Equipment Salaries Payable Trial Balance Dr. 5 5 0 9 0 8 0 1 1 9 1 4 0 Adjustments Cr. 0 0 0 5 0 7 0 4 1 5 0 0 0 Cr. 00 00 00 00 00 (A) (B) 8 8 5 6 4 7 4 3 1 4 12 0 Dr. 00 00 00 00 6 3 1 0 0 6 4 0 1 0 0 8 7 0 00 00 00 00 00 00 (D) 2 5 0 00 (A) (B) ( C) 1 0 0 8 7 0 3 0 0 00 00 00 Adjusted Trial Balance Dr. Cr. 5 5 0 0 00 9 0 0 00 7 0 0 00 3 2 5 00 1 4 0 0 00 8 6 8 3 5 6 1 4 7 0 4 7 5 00 3 0 0 00 1 6 9 0 00 Income Statement Dr. 0 6 4 0 Balance Sheet Cr. 00 00 00 00 Dr. 5 5 0 9 0 1 0 3 2 1 4 0 Cr. 0 0 0 5 0 00 00 00 00 00 5 4 4 7 5 3 0 0 1 1 9 0 00 00 7 1 8 3 2 0 4 4 00 00 00 00 00 00 00 00 00 1 0 0 8 7 0 3 0 0 7 0 0 8 3 6 6 1 4 00 00 00 12 0 1 0 00 1 5 2 0 00 1 0 0 8 7 0 3 0 0 ( C) (D) 1 3 0 0 2 5 0 5 2 0 00 00 00 12 5 6 0 00 00 00 00 12 3 0 0 2 5 0 5 6 0 00 00 00 3 2 3 5 1 4 6 5 4 7 0 0 00 00 00 4 7 0 0 00 8 8 2 5 00 4 7 0 0 00 8 2 2 5 00 0 5 0 6 6 0 0 0 5 5