copy_of_module_01_template.xlsx

Journal

Journal
Date Account Post Ref Debit Credit

T-Accounts

Cash #100 Accounts Receivable #110 Merchandise Inventory, Parts #120 Merchandise Inventory, Motorcycles #125 Office Supplies #130 Prepaid Insurance #140
Bal.. 150,000 Bal. 135,000 Bal. 90,000 Bal. 100,000 Bal. 6000 Bal. 3480
Office Equipment #150 Accumulated Depreciation, Office Equipment #155 Store Equipment #160 Accumulated Depreciation, Store Equipment #165 Shop Equipment #170 Accumulated Depreciation, Shop Equipment #175
Bal. 50,000 Bal. 7500 Bal. 52,000 Bal. 7860 Bal. 183,600 Bal. 41,040
Accounts Payable #200 Salaries Payable #210 Interest Payable #220 Note Payable #230 Ed Silver, Capital #300 Ed Silver, Drawing #310
Bal. 64,000 Bal. 0 Bal. 0 Bal. 67,200 Bal. 966355 Bal. 5000
Sales #400 Cost of Merchandise Sold #500 Sales Salaries Expense #505 Service Salaries Expense #510 Office Salaries Expense #515
Bal. 57,000 Bal. 350,000 Bal. 50,000 Bal. 27,000 Bal. 0
Advertising Expense #520 Depreciation Expense, Office Equipment #525 Depreciation Expense, Store Equipment #530 Depreciation Expense. Shop Equipment #535 Miscellaneous Selling Expenses #540
Bal. 7500 Bal. 0 Bal. 0 Bal. 0 Bal. 130
Rent Expense #545 Insurance Expense #550 Interest Expense #555 Office Supplies Expense #560 Miscellaneous Administrative Expense #565
Bal. 1000 Bal. 0 Bal. 0 Bal. 205 Bal. 40

Unadjusted Trial Balance

Big Ed's Motorcycle Shop
Unadjusted Trial Balance
January 31, 2014