Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   Work Sheet Balance Error (https://www.askmehelpdesk.com/showthread.php?t=244841)

  • Aug 3, 2008, 12:25 PM
    queen3510
    Work Sheet Balance Error
    I'm working the 1st columns on my worksheet, pulling the data from the general ledger. My problem is on the Trial Balance, I am off by $54 dollars. My credits are higher than my debits by $54. I not sure how to backtrack and find my mistake. I've been looking at this off and on for days. Stepping away to clear my head and still cna't find it. I've divided the difference by 2, and then by 9 (not sure if that's the right way to look for the answer but I kind of remember something to that effect.

    Would appreciate any guidance that would head me in the right direction. Thanks!:confused: :confused:
  • Aug 3, 2008, 02:25 PM
    xHannahxLouisex
    I think you divide by 2 & then divide by 9 but in separate calculations. If the difference is 54 then I'm guessing the divide by 9 solution should work. Have you checked to see if the numbers are correct on both the general ledger & the trial balance? I always some how managed to get the digits mixed up.
  • Aug 3, 2008, 04:35 PM
    949
    Can't really find it cause you would have to show use your entries.
  • Aug 4, 2008, 04:51 PM
    queen3510
    Here are my entries into the trial balance.

    Account Title... Debit... Credit
    Cash... 29,639
    Accts recv... 4,200
    Prepaid Rent... 3,600
    Prepaid Insurance... 3,400
    Photographic Supplies... 1,064
    Office Supplies... 230
    Land... 7,500
    Photographic Equipment... 52,900
    Accum Depr - Photo Equip...
    Office Equipment... 20,000
    Accum Depr - Office Equip...
    Vehicle... 12,500
    Accum Depr - Vehicle...
    Accounts Payable... 8,280
    Note Payable... 20,000
    Salary Payable...
    Interest Payable...
    Unearned Photographic Service Revenue... 6,000
    Philip Browning, Capital... 108,487
    Philip Browning, Withdrawal... 1,000
    Income Summary...
    Photographic Service Revenue... 5.763
    Salary Expense... 3,500
    Rent Expense...
    Utilities Expense... 275
    Photographic Supplies Expense...
    Office Supplies expense...
    Insurance Expense...
    Deprec exp - Photo Equip...
    Deprec exp - Office Equip...
    Deprec exp - Vehicle...
    Gas and Oil Expense... 200
    Janitorial Expense... 100
    Advertising Expense... 350
    Interest Expense...
    Miscellaneous Expense... 18
    __________________________________________________ _______
    Total... 148,476... 148,530

    Please let me know if you need more information. Thanks for your help. I really appreciate you taking a look at this.
  • Aug 4, 2008, 06:51 PM
    949
    Sorry I was trying to say I need to see all your entries on the general ledger and your general journal.

    I would suspect its going to be kind of long. If you type it up ill take a look to see where the mistake is at.
  • Aug 6, 2008, 04:12 PM
    queen3510
    I hit the wrong button to post my journal and ledger. I actually created another question and it's entitled "copy of my entries". If you don't mind, please check there for my attachment. Thanks!
  • Aug 6, 2008, 05:42 PM
    949
    Hey do you have an email address? Pm me if you can here. Or just post it up.
  • Aug 7, 2008, 03:23 PM
    queen3510
    [email protected]

  • All times are GMT -7. The time now is 08:34 AM.