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
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% |