This report displays the balance sheet for multiple periods in spreadsheet format.
More Details about the Balance Sheet (Spreadsheet) Report
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 |