Balance Sheet [Budget Spreadsheet] report

Balance Sheet [Budget Spreadsheet] October 2017 through December 2017
			October	November	December

Assets
	Cash Accounts
		Checking 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
	Inventory
		Raw Materials	$3,400.00	$3,400.00	$3,400.00
		Finished Goods	$75,141.50	$75,141.50	$75,141.50
	Total Inventory		$78,541.50	$78,541.50	$78,541.50
	Accounts Receivable		$37,264.78	$37,264.78	$37,264.78
Total Assets			$129,626.11	$129,626.11	$129,626.11

Liabilities
	Accounts Payable		$10,627.02	$10,627.02	$10,627.02
	Bank Indebtedness		$100,000.00	$100,000.00	$100,000.00
	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			$126,418.77	$126,418.77	$126,418.77

Equity
	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 Equity			$17,719.08	$17,719.08	$17,719.08

Total Liability & Equity			$153,101.11	153,101.11	$153,101.11

More help options