PDA

View Full Version : Cant get trial balance to balance


pennytrot
Jun 7, 2012, 02:51 PM
I have done a trial balance using figures put together on an excel spreadsheet. I have the previous years trial balance and it balances. But I can not get mine to balance. I have slight changes this year with a loan introduced and then paid out as part of salaries. Can someone explain what I am doing wrong.

2010/2011 2009/2010
debit credit debit credit
Sales 20,538.00 24,405.00
Loan 4,000.00
Profits b/f
Purchases 8,279.41 13,135.00
Plant hire 935.45 594.00
Salaries 7,045.64 5,600.00
Drawings 7,045.64
Use of residence 834.00 416.00
Motor 2,042.32 778.00
Accountancy fees 450.00 550.00
Insurance 448.94 282.00
Advertising 735.44 701.00
Telephone 285.27 873.00
Bank charges 155.25
Misc 143.89
Deprecation 207.25 146.00
Corporation tax - 1,281.00
Depreceation 207.25 146.00
Corporation tax 1,183.00
Profit / loss -7,863.24 49.00
Plant additions 829.00 975.00
Asset depreciation
Trade debtors 570.00 710.00
Uk coporation tax -
Directors current account 500.00 1,330.00
Creditors - 1,840.00
Bank account 4.94 755.00
Accruals 450.00 550.00
Called up share 2.00 2.00
Profit/loss -7,863.24 49.00

22,649.19 17,334.01 28,175.00 28,175.00
Difference 5,315.18 ?

AtlantaTaxExpert
Jun 8, 2012, 07:19 AM
If this is a HOMEWORK question, this forum's guidelines forbids me from answering the question for you.

If it is a true business and you are having problems preparing the balance statement, then you are in over your head and need to get PROFESSIONAL accounting help.