Balance Sheet [Budget Spreadsheet]

Index to Reports window > Accounts > Balance Sheet

This report displays the monthly budgeted amounts for the balance sheet accounts in spreadsheet format.

More Details about the Balance Sheet (Budget Spreadsheet) Report

Balance Sheet [Budget Spreadsheet]
October 2002 through December 2002

      October November December

___________________________________________________________________________

Assets      
  Cash Accounts      
    Bank Account £13,719.83 £13,719.83 £13,719.83
    Petty Cash £100.00 £100.00 £100.00
  Total Cash Accounts £13,819.83 £13,819.83 £13,819.83
  Stock      
    Raw Materials £3,400.00 £3,400.00 £3,400.00
    Finished Goods £75,141.50 £75,141.50 £75,141.50
  Total Stock £78,541.50 £78,541.50 £78,541.50
  Trade Debtors £37,264.78 £37,264.78 £37,264.78
  Deposits Paid Suppliers £100.00 £100.00 £100.00
  Office Equipment      
    Office Equip., Original Cost £12,000.00 £12,000.00 £12,000.00
    Office Equip., Amortisation (£4,125.00) (£4,125.00) (£4,125.00)
  Total Office Equipment £7,875.00 £7,875.00 £7,875.00
  Vehicles      
    Vehicles, Original Cost £32,000.00 £32,000.00 £32,000.00
    Vehicles, Amortisation £(17,000.00) £(17,000.00) £(17,000.00)
  Total Vehicles £15,000.00 £15,000.00 £15,000.00
  Other Assets £500.00 £500.00 £500.00
Total Assets £153,101.11 £153,101.11 £153,101.11
           
Liabilities      
  Credit Cards      
    American Express £3,200.00 £3,200.00 £3,200.00
    Visa £1,000.00 £1,000.00 £1,000.00
  Total Credit Cards £4,200.00 £4,200.00 £4,200.00
  Trade Creditors £10,627.02 £10,627.02 £10,627.02
  Bank Indebtedness £100,000.00 £100,000.00 £100,000.00
  VAT Liabilities      
    VAT 1 Collected £2,414.58 £2,414.58 £2,414.58
    VAT 2 Collected £2,348.68 £2,348.68 £2,348.68
  Total VAT Liabilities £4,763.26 £4,763.26 £4,763.26
  Payroll Liabilities      
    Payroll Liabilities £13,919.25 £13,919.25 £13,919.25
    Payroll Tax Payable £105.00 £105.00 £105.00
    Vacation Payable £1,267.50 £1,267.50 £1,267.50
  Total Payroll Liabilities £15,291.75 £15,291.75 £15,291.75
  Deposits from Customers £500.00 £500.00 £500.00
Total Liabilities £135,382.03 £135,382.03 £135,382.03
           
Capital      
  Paid in Capital £110,000.00 £110,000.00 £110,000.00
  Retained Earnings (£88,510.92) (£88,510.92) (£88,510.92)
  Current Year Earnings £(3,770.00) (£3,770.00) (£3,770.00)
Total Capital £17,719.08 £17,719.08 £17,719.08
      ____________ ____________ ____________
Total Liability & Capital £153,101.11 153,101.11 £153,101.11