I need help completing this mini practice set. I understand some of it but it is a huge part of my grade so I wanted to make sure I do it all correctly. Someone please fill the worksheet out. I have attached the instructions in a word document and the blank excel worksheet for the answers to go in. Thanks so much in advance!

MINI PRACTICE SET SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 1 Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 2 Date 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 3 Date 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 4 Date 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 5 Date 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 6 Date 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 Account Titles and Description PR Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: CASH Date Explanation Post Ref. Debit Credit ACCOUNTS RECEIVABLE Date Explanation Post Ref. Debit Credit ACCOUNT NO. 111 Balance Debit Credit ACCOUNT NO. 112 Balance Debit Credit MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: PREPAID RENT Date Explanation Post Ref. Debit Credit OFFICE SUPPLIES Date Explanation Post Ref. Debit Credit OFFICE EQUIPMENT Date Date Explanation Post Ref. Debit ACCUMULATED DEPRECIATION, OFFICE EQUIPMENT Post Explanation Debit Ref. Credit Credit AUTOMOBILE Date Explanation Post Ref. Debit Credit ACCOUNT NO. 114 Balance Debit Credit ACCOUNT NO. 115 Balance Debit Credit ACCOUNT NO. 121 Balance Debit Credit ACCOUNT NO. 122 Balance Debit Credit ACCOUNT NO. 123 Balance Debit Credit MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: ACCUMULATED DEPRECIATION, AUTOMOBILE Date Explanation Post Ref. Debit Credit ACCOUNTS PAYABLE Date Explanation Post Ref. Debit Credit SALARIES PAYABLE Date Explanation Post Ref. Debit Credit JAMES SOUSA, CAPITAL Date Explanation Post Ref. Debit Credit ACCOUNT NO. 124 Balance Debit Credit ACCOUNT NO. 211 Balance Debit Credit ACCOUNT NO. 212 Balance Debit Credit ACCOUNT NO. 311 Balance Debit Credit MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: JAMES SOUSA, WITHDRAWALS Date Explanation Post Ref. Debit Credit INCOME SUMMARY Date Explanation Post Ref. Debit Credit COMMISSIONS EARNED Date Explanation Post Ref. Debit Credit RENT EXPENSE Date Explanation Post Ref. Debit Credit ACCOUNT NO. 312 Balance Debit Credit ACCOUNT NO. 313 Balance Debit Credit ACCOUNT NO. 411 Balance Debit Credit ACCOUNT NO. 511 Balance Debit Credit MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SALARIES EXPENSE Date Explanation Post Ref. Debit Credit GAS EXPENSE Date Explanation Post Ref. Debit Credit REPAIRS EXPENSE Date Explanation Post Ref. Debit Credit TELEPHONE EXPENSE Date Explanation Post Ref. Debit Credit ACCOUNT NO. 512 Balance Debit Credit ACCOUNT NO. 513 Balance Debit Credit ACCOUNT NO. 514 Balance Debit Credit ACCOUNT NO. 515 Balance Debit Credit MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: ADVERTISING EXPENSE Date Explanation Post Ref. Debit Credit OFFICE SUPPLIES EXPENSE Date Explanation Post Ref. Debit Credit DEPRECIATION EXPENSE, OFFICE EQUIPMENT Date Explanation Post Ref. Debit Credit DEPRECIATION EXPENSE, AUTOMOBILE Date Explanation Post Ref. Debit Credit MISCELLANEOUS EXPENSE Date Explanation Post Ref. Debit Credit ACCOUNT NO. 516 Balance Debit Credit 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) SOUSA REALTY WORKSHEET FOR MONTH ENDED SEPTEMBER 30, 201X Account Titles Trial Balance Dr. Adjustments Cr. Dr. Cr. Adjusted Trial Balance Dr. Cr. Income Statement Dr. Balance Sheet Cr. Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (3) SOUSA REALTY INCOME STATEMENT FOR MONTH ENDED SEPTEMBER 30, 201X MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY STATEMENT OF OWNER'S EQUITY FOR MONTH ENDED SEPTEMBER 30, 201X MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY BALANCE SHEET SEPTEMBER 30, 201X ASSETS LIABILITIES AND OWNER'S EQUITY MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (5) SOUSA REALTY POST-CLOSING TRIAL BALANCE SEPTEMBER 30, 201X Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (2) SOUSA REALTY WORKSHEET FOR MONTH ENDED OCTOBER 31, 201X Account Titles Trial Balance Dr. Adjustments Cr. Dr. Cr. Adjusted Trial Balance Dr. Cr. Income Statement Dr. Balance Sheet Cr. Dr. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (3) SOUSA REALTY INCOME STATEMENT FOR MONTH ENDED OCTOBER 31, 201X MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY STATEMENT OF OWNER'S EQUITY FOR MONTH ENDED OCTOBER 31, 201X MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY BALANCE SHEET OCTOBER 31, 201X ASSETS LIABILITIES AND OWNER'S EQUITY MINI PRACTICE SET (CONCLUDED) SOUSA REALTY Name: Section: Date: (5) SOUSA REALTY POST-CLOSING TRIAL BALANCE OCTOBER 31, 201X Dr. Cr. End of the Worksheets Mini Practice Set Sousa Realty On September 1, 201X, James Sousa opened a real estate office called Sousa Realty. The following transactions were completed for the month of September: September 1 - James Sousa invested $12,000 cash in the real estate agency along with $5,000 of office equipment. September 1 - Rented and paid 5 months' rent in advance to Murray Property Management, $1000. September 1 - Bought an automobile on account from Hyundai North, $19,000. September 4 - Purchased office supplies from Paper Company, for cash, $600. September 5 - Purchased additional office supplies from Paper Company, on account, $250. September 6 - Sold a house to Brenden Hue and collected a $11,000 commission. September 8 - Paid gas bill to Haffner Gas Co., $45. September 15 - Paid Rosie Petrillo, office secretary, $300. September 17 - Sold a building lot to Tropic Developers and earned a commission, $10,000; payment to be received on October 8. September 20 - James Sousa withdrew $4,000 from the business to pay personal expenses. September 21 - Sold a house to Suzanne Horngam and collected a $7,000 commission. September 22 - Paid gas bill, $80, to Haffner Gas Co. September 24 - Paid Hyundai North $800 to repair automobile. September 30 - Paid Rosie Petrillo, office secretary, $300. September 30 - Paid Comcast September telephone bill, $330. September 30 - Received advertising bill for September, $900, from Chicago Times. The bill is to be paid on October 2. Required Work for September 1. Journalize transactions and post to ledger accounts. 2. 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 has expired. b. An inventory shows $100 of office supplies remaining. c. Depreciation on office equipment, $160. d. Depreciation on automobile, $210. 3. Prepare a September income statement, statement of owner's equity, and balance sheet. 4. From the worksheet, journalize and post adjusting and closing entries (p. 3 of journal). 5. Prepare a post-closing trial balance. (Should be $57,445.) During October, Sousa Realty completed these transactions: October 1 - Purchased additional office supplies on account from Paper Co., $850. October 2 - Paid Chicago Times advertising bill for September, $900. October 3 - Sold a house to Helen Baker and collected a commission of $7,300. October 6 - Paid gas bill to Haffner Gas Co., $29. October 8 - Collected commission from Tropic Developers for sale of building lot on September 17, $10,000. October 12 - Paid $530 to Long Realtors Assoc. to send employees to realtors' workshop. October 15 - Paid Rosie Petrillo, office secretary, $300. October 17 - Sold a house to Gary Schneider and earned a commission of $2,900. Commission to be received on November 10. October 18 - Sold a building lot to Lombardi Builders and collected a commission of $4,500. October 22 - Sent a check to Heritage Charities for $65 to help sponsor a local road race to aid the poor. (This amount is to be considered an advertising expense; it is a business expense and is posted to Miscellaneous Expense.) October 24 - Paid Hyundai North $620 for repairs to automobile due to accident. October 28 - James Sousa withdrew $2,200 from the business to pay personal expenses. October 30 - Paid Rosie Petrillo, office secretary, $300. October 30 - Paid Comcast telephone bill, $480. October 30 - Advertising bill from Chicago Times for October, $1,300. The bill is to be paid on November 2. Required Work for October 1. Journalize transactions in a general journal (p. 4) and post to ledger accounts. 2. Prepare a trial balance in the first two columns of a blank, fold-out worksheet located at the end of your textbook and complete the worksheet using the following adjustment data: a. One month's rent had expired. Paid 5 months' rent in advance on September 1, $1,000. b. An inventory shows $130 of office supplies remaining. c. Depreciation on office equipment, $160. d. Depreciation on automobile, $210. 3. Prepare an October income statement, statement of owner's equity, and balance sheet. 4. From the worksheet, journalize and post adjusting and closing entries (p. 6 of journal). 5. Prepare a post-closing trial balance. (Should be $66,551)