Ask Experts Questions for FREE Help !
Ask
    queen3510's Avatar
    queen3510 Posts: 5, Reputation: 1
    New Member
     
    #1

    Aug 3, 2008, 12:25 PM
    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:
    xHannahxLouisex's Avatar
    xHannahxLouisex Posts: 17, Reputation: 2
    New Member
     
    #2

    Aug 3, 2008, 02:25 PM
    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.
    949's Avatar
    949 Posts: 31, Reputation: 2
    Junior Member
     
    #3

    Aug 3, 2008, 04:35 PM
    Can't really find it cause you would have to show use your entries.
    queen3510's Avatar
    queen3510 Posts: 5, Reputation: 1
    New Member
     
    #4

    Aug 4, 2008, 04:51 PM
    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.
    949's Avatar
    949 Posts: 31, Reputation: 2
    Junior Member
     
    #5

    Aug 4, 2008, 06:51 PM
    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.
    queen3510's Avatar
    queen3510 Posts: 5, Reputation: 1
    New Member
     
    #6

    Aug 6, 2008, 04:12 PM
    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!
    949's Avatar
    949 Posts: 31, Reputation: 2
    Junior Member
     
    #7

    Aug 6, 2008, 05:42 PM
    Hey do you have an email address? Pm me if you can here. Or just post it up.
    queen3510's Avatar
    queen3510 Posts: 5, Reputation: 1
    New Member
     
    #8

    Aug 7, 2008, 03:23 PM
    [email protected]

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Balance sheet [ 10 Answers ]

Use the following adjusted trial balance of Webb Trucking Company to prepare a classified balance sheet as of December 31, 2005. Cash.. . $ 7,000 Accounts receivable.. . 16,500 Office supplies.. . 2,000 Trucks.. . 170,000 Accumulated depreciation—Trucks.. . $ 35,000 Land.. . 75,000...

Ledger, trial balance, balance sheet [ 5 Answers ]

hello, I have problem with my assignment. Can anyone help me with one question? I have to prepare journals, ledger, trial balance, profit and loss and balance sheet. Jan 6 Bought spare parts on credit 27000 cash sale 62500 Jan 7 charged Moji for repairs 5000 sold spare parts to Koba on...

Creating balance sheet from trial balance [ 10 Answers ]

I am having issues getting a balance sheet to come out right from the given data from a trial balance. Can anyone help me out with this? I have included a picture of what I am working on...

If T-Accounts Balance does this mean balance sheet & P&L work correctly? [ 1 Answers ]

Hi, Just wondering been having some problems with my Balance Sheet balancing, I was wondering if the Trial Balance balances, does that mean that the balance sheet will balance? (given that I do everything correctly? ) Also just a quick question while I'm asking, regarding depreciation in...


View more questions Search