 |
|
|
 |
New Member
|
|
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:
|
|
 |
New Member
|
|
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.
|
|
 |
Junior Member
|
|
Aug 3, 2008, 04:35 PM
|
|
Can't really find it cause you would have to show use your entries.
|
|
 |
New Member
|
|
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.
|
|
 |
Junior Member
|
|
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.
|
|
 |
New Member
|
|
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!
|
|
 |
Junior Member
|
|
Aug 6, 2008, 05:42 PM
|
|
Hey do you have an email address? Pm me if you can here. Or just post it up.
|
|
 |
New Member
|
|
Aug 7, 2008, 03:23 PM
|
|
|
|
Question Tools |
Search this Question |
|
|
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
|