I Need help with worksheet trial balance. Paper due Tuesday morning 9/26. thanks in advNCE

MINI PRACTICE SET SOUSA REALTY Name: Section: Date: (1) SOUSA REALTY General Journal PAGE 1 Date Account Titles and Description 201X Sept 1 Cash James Sousa Capital Intail investment of cash by owner PR 111 311 Dr. 12 0 0 0 1 Office Equipment Cash Bought office Equipment 121 111 5 0 0 0 1 Prepaid Rent Cash Paid rent in advance for 5 months 114 111 1 0 0 0 1 Automobile Accounts Payable Purchased Automobile from hyunda North 123 211 19 0 0 0 4 Office Supplies 115 Cash 111 Purchased office supplies for cash from Paper Co. 6 0 0 5 Office supplies Accounts payable Purchased supplies on Account from Paper Co. 2 5 0 115 211 6 Cash 111 Commission Earned 411 Sold house to Brendan Hue and collected commission 8 Gas Expense Cash Paid gas bill to Haffner Gas Co. 513 111 11 0 0 0 4 5 Cr. 00 12 0 0 0 00 5 0 0 0 00 1 0 0 0 00 19 0 0 0 00 6 0 0 00 2 5 0 00 11 0 0 0 00 4 5 00 00 00 00 00 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 2 Date Account Titles and Description PR 201X Sept 15 Salary Expense 512 Cash 111 Paid salary to Rosie Petrillo Office Secretary (1st-15th) Dr. 3 0 0 17 Accounts Receiveable 112 Commission Earned 411 Sold building to Tropic Developers for Commission Will receive the payment on October 8th 201X 10 0 0 0 20 James Sousa Withdraw 312 Cash 311 Owner withdrew money to pay for personal expense 4 0 0 0 21 Cash 111 Commission Earned 411 Sold house to Suzanne Horngam collected commission 7 0 0 0 22 Gas Expense Cash Paid gas bill to Haffner Gas Co. 513 111 8 0 24 Repair fee Expense Cash Paid Hyundia North to fix Air conditioning 514 111 8 0 0 30 Salary Expense Cash Paid Salary to Rosie Petrillio office Secretary (16th-30th) 512 111 3 0 0 30 Telephone Expense Cash Paid comcast september phone bill 515 111 3 3 0 Cr. 00 3 0 0 00 10 0 0 0 00 4 0 0 0 00 7 0 0 0 00 8 0 00 8 0 0 00 3 0 0 00 3 3 0 00 00 00 00 00 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 3 Date Account Titles and Description PR 201X Sept 30 Advertising Expense 516 Accounts Payable 211 Received bill from Chicago Times for Sept. Due on October 2nd 201X Dr. 9 0 0 30 Rent Expenses Prepaid Rent One month rent has expired 2 0 0 30 Office Supplies Expenses Office Supplies (Office supplies used during the month) 1 0 0 30 Depreciation Expenses- Office equipment Accumulated Depreciation - Office equipment (Depreciation charged on equipment) 1 6 0 30 Depreciation Expenses- Automobile Accumulated Depreciation - Automobile (Depreciation charged on automobile) 2 1 0 Cr. 00 9 0 0 00 2 0 0 00 1 0 0 00 1 6 0 00 2 1 0 00 00 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 4 Date Account Titles and Description PR 201X Oct 1 Office Supplies 115 Cash 111 Bought office supplies with cash from Paper Co. Dr. 8 5 0 2 Accounts Payable 516 Cash 111 Paid Chicago times advertising bill from september 9 0 0 Cr. 00 00 6 Gas Expense Cash Paid gas bill to haffner Gas Co. 00 8 Commission Earned 411 Cash 111 Collected commission from Tropic Delvelopers from the sale that was made on September 17th 2 9 10 0 0 0 12 Miscellaneous Expense 524 Cash 111 Paid Long Realtors Assco. for workshop for employees 5 3 0 15 Salaries Expense 512 Cash 111 Paid salary Rosie Petrillo Office secretary (1st-15th) 3 0 0 17 Accounts Receivable 112 Commission Earned 411 Sold house to Gary Schneider for commissio but will Receive on Nov. 10th 2 9 0 0 00 9 0 0 00 7 3 0 0 00 2 9 00 10 0 0 0 00 5 3 0 00 3 0 0 00 2 9 0 0 00 00 3 Cash 111 7 3 0 0 Commision Earned 411 Sold house to Helen Baker and collected commission 513 111 8 5 0 00 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 5 Date Account Titles and Description PR Dr. 201X Oct 18 Accounts Receivable 411 4 5 0 0 Commision earned 111 Sold building to Gary Schneider to earn commission to be received on November 10th 201X 22 Miscellaneous Expense 524 Cash 111 donated money to Heritage Charities to help sponser loacl road race to aid the poor 6 5 Cr. 00 00 28 James Sousa Withdraw 312 2 2 0 0 Cash 311 Owner withdrew money to pay for personal expenses 00 30 Salaries Expense 512 3 0 0 Cash 111 Paid salary to Rosie Petrillo office secretary (16th-30th) 00 30 Telephone Expense Cash Paid comcast Phone bill 00 30 Advertising Expense 516 Accounts Payable 211 Received bill from chicago times for Oct. due on November 2nd 4 8 0 1 3 0 0 00 6 5 00 6 2 0 00 2 2 0 0 00 3 0 0 00 4 8 0 00 1 3 0 0 00 00 24 Repair fee expense 514 6 2 0 Cash 111 Paid hyundai North to fix automobile due to an accident 515 111 4 5 0 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SOUSA REALTY General Journal PAGE 6 Date Account Titles and Description Oct 30 Rent Expenses Prepaid Rent One month rent has expired PR 30 Office Supplies Expenses Office Supplies (Office supplies used during the month) Dr. 2 0 0 1 4 7 0 30 Depreciation Expenses- Office equipment Accumulated Depreciation - Office equipment (Depreciation charged on equipment) 1 6 0 30 Depreciation Expenses- Automobile Accumulated Depreciation - Automobile (Depreciation charged on automobile) 2 1 0 Cr. 00 2 0 0 00 1 4 7 0 00 1 6 0 00 2 1 0 00 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: CASH Date 201X Sept 1 1 1 4 6 8 15 20 21 22 24 30 30 OCT 1 2 3 6 8 12 15 22 24 28 30 30 Date Explanation James Sousa Capital Office Equipment Prepaid Rent Office Supplies Commission Earned Gas Expense Salary Expense James Sousa Withdraw Commission Earned Gas Expense Repair fee Expense Salary Expense Telephone Expense Office Supplies Accounts Payable Commision Earned Gas Expense Commission Earned Miscellaneous Expense Salaries Expense Miscellaneous Expense Repair fee expense James Sousa Withdraw Salaries Expense Telephone Expense Post Ref. GJ1 GJ1 GJ1 GJ1 GJ1 GJ1 GJ2 GJ2 GJ2 GJ2 GJ2 GJ2 GJ2 GJ4 GJ4 GJ4 GJ4 GJ4 GJ4 GJ4 GJ5 GJ5 GJ5 GJ5 GJ5 Debit GJ2 GJ4 GJ4 Credit 12 0 0 0 00 5 0 0 0 00 1 0 0 0 00 6 0 0 00 11 0 0 0 00 4 5 00 3 0 0 00 4 0 0 0 00 7 0 0 0 00 8 3 3 8 9 8 0 0 3 5 0 0 00 0 00 0 00 0 00 0 00 0 00 7 3 0 0 00 2 9 00 10 0 0 0 00 5 3 0 00 3 0 0 00 6 5 00 6 2 0 00 2 2 0 0 00 3 0 0 00 4 8 0 00 ACCOUNTS RECEIVABLE Post Explanation Debit Ref. 201X Sept 17 Commission Earned Oct 17 Commission Earned 18 Accounts Receivable ACCOUNT NO. 111 Balance Debit 10 0 0 0 00 2 9 0 0 00 4 5 0 0 00 Credit 12 7 6 5 16 16 16 12 19 18 18 17 17 16 15 23 23 33 32 32 32 31 29 29 28 0 0 0 4 4 3 0 0 0 9 1 8 5 6 7 0 0 0 5 2 1 5 3 0 5 0 0 0 0 0 5 5 5 5 7 7 7 4 9 9 9 6 6 3 3 7 5 5 5 7 0 0 0 0 0 5 5 5 5 5 5 5 5 5 5 5 6 6 6 6 1 1 1 1 1 ACCOUNT NO. 112 Balance Debit 10 0 0 0 12 9 0 0 17 4 0 0 ACCOUNT NO. 111 Balance Debit Credit 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ACCOUNT NO. 112 Balance Debit Credit 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: PREPAID RENT Post Explanation Ref. Date 201X Sept 1 Cash 30 Rent Expenses Oct 30 Rent Expenses OFFICE SUPPLIES Post Explanation Ref. Date 201X Sept 4 5 30 Oct 1 30 GJ1 GJ3 GJ6 Cash Accounts payable Office Supplies Expenses Cash Office Supplies Expenses Date 201X Sept 1 Cash GJ1 GJ1 GJ3 GJ4 GJ6 OFFICE EQUIPMENT Post Explanation Ref. GJ1 Debit Credit 1 0 0 0 00 2 0 0 00 2 0 0 00 Debit Credit 6 0 0 00 2 5 0 00 1 0 0 00 8 5 0 00 1 4 7 0 00 Debit 5 0 0 0 0.00 Credit ACCOUNT NO. 114 Balance Debit Credit 1 0 8 6 0 0 00 0 0 00 0 0 00 ACCOUNT NO. 115 Balance Debit Credit 6 8 7 1 6 1 0 5 5 0 3 0 0 0 0 0 00 00 00 00 00 ACCOUNT NO. 121 Balance Debit Credit 5 0 0 0 00 ACCUMULATED DEPRECIATION, OFFICE EQUIPMENT Post Date Explanation Debit Ref. 201X 30 Depreciation Expenses- Of GJ3 Oct 30 Depreciation Expenses- Of GJ6 Date AUTOMOBILE Post Explanation Ref. 201X Sept 1 Accounts Payable GJ1 Debit 19 0 0 0 00 Credit 1 6 0 00 1 6 0 00 Credit ACCOUNT NO. 122 Balance Debit Credit 1 6 0 00 3 2 0 00 ACCOUNT NO. 123 Balance Debit Credit 19 0 0 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: ACCUMULATED DEPRECIATION, AUTOMOBILE Post Date Explanation Debit Ref. Sep 30 Depreciation Expenses- Automobile GJ3 Oct 30 Depreciation Expenses- Automobile GJ6 ACCOUNTS PAYABLE Post Explanation Ref. Date 201X Sept 1 5 30 Oct 2 30 Automobile Office supplies Advertising Expense Cash Advertising Expense Date Date Sept 1 Cash GJ1 GJ1 GJ3 GJ4 GJ5 SALARIES PAYABLE Post Explanation Ref. JAMES SOUSA, CAPITAL Post Explanation Ref. GJ1 Debit Credit 2 1 0 00 2 1 0 00 Credit 19 0 0 0 00 2 5 0 00 9 0 0 00 9 0 0 00 1 3 0 0 00 Debit Debit Credit Credit 12 0 0 0 0.00 0 ACCOUNT NO. 124 Balance Debit Credit 2 1 0 00 4 2 0 00 ACCOUNT NO. 211 Balance Debit Credit 19 19 20 19 20 0 2 1 2 5 0 5 5 5 5 0 0 0 0 0 00 00 00 00 00 ACCOUNT NO. 212 Balance Debit Credit ACCOUNT NO. 311 Balance Debit Credit 12 0 0 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Date 201X Sep 20 Cash Oct 28 Cash Date JAMES SOUSA, WITHDRAWALS Post Explanation Ref. GJ2 GJ5 INCOME SUMMARY Post Explanation Ref. Debit Credit 4 0 0 0 00 2 2 0 0 00 Debit ACCOUNT NO. 312 Balance Debit Credit 4 0 6 2 Credit 0 0 00 0 0 00 ACCOUNT NO. 313 Balance Debit Credit Date 201X Sep. 1 17 21 Oct 3 8 17 18 COMMISSIONS EARNED Post Explanation Ref. Cash Accounts Receiveable Cash Cash Cash Accounts Receivable Accounts Receivable Debit Credit 11 10 7 7 10 2 4 GJ2 GJ2 GJ4 GJ4 GJ4 GJ5 0 0 0 3 0 9 5 0 0 0 0 0 0 0 RENT EXPENSE Date Explanation 201X Sep 30 Prepaid Rent Oct 30 Prepaid Rent Post Ref. GJ3 GJ6 Debit 2 0 0 00 2 0 0 00 ACCOUNT NO. 411 Balance Debit Credit Credit 0 00 0 00 0 00 0 00 0 00 0 00 0 00 11 21 28 7 17 20 24 0 0 0 3 3 2 7 0 0 0 0 0 0 0 ACCOUNT NO. 511 Balance Debit Credit 2 2 0 0 00 0 0 00 0 0 0 0 0 0 0 00 00 00 00 00 00 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: SALARIES EXPENSE Post Explanation Ref. Date 201X Sep 15 30 Oct 15 30 Cash Cash Cash Cash GJ2 GJ2 GJ4 GJ5 Debit 3 3 3 3 0 0 0 0 Credit 0 00 0 00 0 00 0 00 3 6 3 6 GAS EXPENSE Date 201X Sep 8 Cash 22 Cash Oct 6 Cash Date 201X Sep 24 Cash Oct 24 Cash Explanation Post Ref. GJ1 GJ2 REPAIRS EXPENSE Post Explanation Ref. GJ2 GJ5 Debit Credit 4 5 00 8 0 00 2 9 00 Debit 8 0 0 00 6 2 0 00 ACCOUNT NO. 512 Balance Debit Credit 0 0 0 0 0 0 0 0 00 00 00 00 ACCOUNT NO. 513 Balance Debit Credit 4 5 00 1 2 5 00 2 9 00 Credit ACCOUNT NO. 514 Balance Debit Credit 8 0 0 00 6 2 0 00 Date 201X Sep 30 Cash Oct 30 Cash TELEPHONE EXPENSE Post Explanation Ref. GJ2 GJ5 Debit 3 3 0 00 4 8 0 00 Credit ACCOUNT NO. 515 Balance Debit Credit 3 3 0 00 4 8 0 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: Date ADVERTISING EXPENSE Post Explanation Ref. 201X Sep 30 Accounts Payable Oct 30 Accounts Payable Date Debit GJ3 GJ6 DEPRECIATION EXPENSE, AUTOMOBILE Post Explanation Ref. 201X Sep 30 Accumulated Depreciation - Automobi GJ3 Oct 30 Accumulated Depreciation - Automobi GJ6 9 1 3 Credit 1 0 0 00 1 4 7 0 00 DEPRECIATION EXPENSE, OFFICE EQUIPMENT Post Explanation Debit Ref. 201X Sep 30 Accumulated Depreciation - Office e Oct 30 Accumulated Depreciation - Office e Date GJ3 GJ6 Credit 9 0 0 00 1 3 0 0 00 OFFICE SUPPLIES EXPENSE Post Explanation Ref. 201X Sep 30 Office Supplies Oct 30 Office Supplies Date GJ3 GJ5 Debit 2 1 0 00 2 1 0 00 0 0 00 0 0 00 ACCOUNT NO. 517 Balance Debit Credit 1 0 0 00 1 4 7 0 00 Credit 1 6 0 00 1 6 0 00 Debit ACCOUNT NO. 516 Balance Debit Credit ACCOUNT NO. 518 Balance Debit Credit 1 6 0 00 1 6 0 00 Credit ACCOUNT NO. 519 Balance Debit Credit 2 1 0 00 2 1 0 00 Date MISCELLANEOUS EXPENSE Post Explanation Ref. 201X OCT 12 Cash 22 Miscellaneous Expense GJ4 GJ5 Debit 5 3 0 00 6 5 00 Credit ACCOUNT NO. 524 Balance Debit Credit 5 3 0 00 5 9 5 00 MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (2) FOR MO Account Titles Trial Balance Dr. Adjustments Cr. Dr. SOUSA REALTY WORKSHEET FOR MONTH ENDED SEPTEMBER 30, 201X Adjustments Cr. Adjusted Trial Balance Dr. Cr. Income Statement Dr. Cr. tatement 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 SOUSA REALTY BALANCE SHEET PTEMBER 30, 201X 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. Cr. MINI PRACTICE SET (CONTINUED) SOUSA REALTY Name: Section: Date: (2) FOR M Account Titles Trial Balance Dr. Adjustments Cr. Dr. SOUSA REALTY WORKSHEET FOR MONTH ENDED OCTOBER 31, 201X Adjustments Cr. Adjusted Trial Balance Dr. Cr. Income Statement Dr. Cr. tatement 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 SOUSA REALTY BALANCE SHEET CTOBER 31, 201X 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. Cr