Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   A Little confused and stressed (https://www.askmehelpdesk.com/showthread.php?t=107623)

  • Jul 7, 2007, 10:36 AM
    Haley1976
    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!
  • Jul 7, 2007, 07:36 PM
    kd4mck
    Sales s/b a credit, cost of goods sold & sales discounts & returns s/b debits

    Switch those around & you s/b in balance.
  • Jul 8, 2007, 08:17 AM
    Haley1976
    Thank you a million! I have no idea why I got that mixed up...

  • All times are GMT -7. The time now is 01:38 PM.