Log in

View Full Version : Work Sheet Balance Error


queen3510
Aug 3, 2008, 12:25 PM
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
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
Aug 3, 2008, 04:35 PM
Can't really find it cause you would have to show use your entries.

queen3510
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
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
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
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
Aug 7, 2008, 03:23 PM
[email protected]