Balance Sheet [Budget Analysis]

Index to Reports window > Accounts > Balance Sheet

This report compares your balance sheet as of the end of the selected month with your budgeted balance sheet for that month.

More Details about the Balance Sheet (Budget Analysis) Report

Balance Sheet [Budget Analysis]
October 2002

      Selected Period Budgeted £ Difference % Difference

____________________________________________________________________________________

Assets        
  Cash Accounts        
    Bank Account £16,664.83 £34,878.91 (£18,214.08) (52.2%)
    Petty Cash £100.00 £100.00 £0.00 0.0%
  Total Cash Accounts £16,764.83 £34,978.91 (£18,214.08) (52.1%)
  Stock        
    Raw Materials £3,400.00 £3,400.00 £0.00 0.0%
    Finished Goods £75,129.62 £5,400.00 £69,729.62 1,291.3%
  Total Stock £78,529.62 £8,800.00 £69,729.62 792.4%
  Trade Debtors £37,264.78 £32,000.00 £5,264.78 16.5%
  Deposits Paid Suppliers £100.00 £100.00 £0.00 0.0%
  Office Equipment        
    Office Equip., Original Cost £12,000.00 £12,000.00 £0.00 0.0%
    Office Equip., Amortisation (£4,000.00) (£4,000.00) £0.00 0.0%
  Total Office Equipment £8,000.00 £8,000.00 £0.00 0.0%
  Vehicles        
    Vehicles, Original Cost £32,000.00 £32,000.00 £0.00 0.0%
    Vehicles, Amortisation (£16,500.00) (£16,500.00) £0.00 0.0%
  Total Vehicles £15,500.00 £15,500.00 £0.00 0.0%
  Other Assets £500.00 £500.00 £0.00 0.0%
Total Assets 156,659.23 £99,878.91 £56,780.32 56.8%
             
Liabilities        
  Credit Cards        
    American Express £3,200.00 £3,200.00 £0.00 0.0%
    Visa £1,000.00 £1,000.00 £0.00 0.0%
  Total Credit Cards £4,200.00 £4,200.00 £0.00 0.0%
  Trade Creditors £10,615.14 £21,000.00 (£10,384.86) (49.5%)
  Bank Indebtedness £100,000.00 £100,000.00 £0.00 0.0%
  VAT Liabilities        
    VAT 1 Collected £2,214.58 £354.98 £1,859.60 523.9%
    VAT 2 Collected £2,348.68 £452.00 £1,896.68 419.6%
  Total VAT Liabilities £4,563.26 £806.98 £3,756.28 465.5%
  Payroll Liabilities        
    Payroll Liabilities £13,919.25 £0.00 £13,919.25 NA
    Payroll Tax Payable £105.00 £0.00 £105.00 NA
    Vacation Payable £1,267.50 £0.00 £1,267.50 NA
  Total Payroll Liabilities £15,291.75 £0.00 £15,291.75 NA
  Deposits from Customers £500.00 £500.00 £0.00 0.0%
Total Liabilities £135,170.15 £126,506.98 £8,663.17 6.8%
             
Capital        
  Paid in Capital £110,000.00 £110,000.00 £0.00 0.0%
  Retained Earnings (£58,078.07) (£136,628.07) £78,550.00 (57.5%)
  Current Year Earnings (£30,432.85) £14,285.00 (£44,717.85) (313.0%)
Total Capital £21,489.08 (£12,343.07) £33,832.15 (274.1%)
      ____________ ____________ ____________ __________
Total Liability & Capital £156,659.23 £114,163.91 £42,495.32 37.2%