A Little confused and stressed
I have the following worksheet that I have completed to how I understand the work - however my unadjusted trial balance and adjusted trial balance is off by the same amount. Please see worksheet:
Unadjusted
Trial Balance
Account Debit Credit
Cash... 135,911
Accounts receivable... 18,200
Merchandise inventory... 189,519
Office supplies... 793
Store supplies... 3,301
Prepaid insurance... 3,318
Office equipment... 25,690
Accum. Depr. office equip... 9,898
Store equipment... 38,920
Accum. Depr. store equip... 17,556
Accounts payable... 53,059
J. Colo, Capital... 308,085
J. Colo, Withdrawals... 7,000
Sales... 156,422
Sales discounts... 350
Sales returns and allowances... 175
Cost of goods sold... 99,910
Depr. Expense, office equip. 0
Depr. Expense, store equip. 0
Office salaries expense... 6,300
Sales salaries expense... 10,640
Insurance expense
Rent exp. office space... 742
Rent exp. selling space... 2,968
Office supplies expense
Store supplies expense
Utilities expense... 1,283
Totals 601,007... 645,455
Totals s/b 545,020 s/b 545,020
I think it has something to do with the following income statement but I am having difficulty changing (or knowing how to change or what to change) so that the numbers add correctly to $545,020):
Revenue:
Sales... 156,422
Less: Sales discounts... $350
Sales returns and allowances... 175... (525)
Net sales... $155,897
Less: Cost of goods sold... 99,910
Gross profit on sales... $55,987 <<I am off by this dr amt>>
Operating expenses:
Selling expenses:
Depreciation expense, store equipment... $567
Sales salaries expense... 10,640
Rent expense, selling space... 2,968
Store supplies expense... 669
Total selling expenses... $14,844
General and administrative expenses:
Depreciation expense, office equipment... $329
Office salaries expense... 6,300
Insurance expense... 553
Rent expense, office space... 742
Office supplies expense... 289
Utilities expense... 1,283
Total general and administrative expenses... 9,496
Total operating expenses... 24,340 <I'm off by this cr amt>
Net income... $31,647 (all of these numbers are correct)
Can you please look it over and let me know how my numbers on unadjusted are wrong?
Thank you!