Balance Sheet [Budget Analysis] report

Balance Sheet [Budget Analysis] October 2017
			Selected Period	Budgeted	$ Difference	% Difference
Assets
	Cash Accounts
		Checking 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%)
	Inventory
		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 Inventory		$78,529.62	$8,800.00	$69,729.62	792.4%
	Accounts Receivable		$37,264.78	$32,000.00	$5,264.78	16.5%
	Deposits Paid Vendors		$100.00	$100.00	$0.00	0.0%
Total Assets			$132,559.23	$75,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%
	Accounts Payable		$10,615.14	$21,000.00	($10,384.86)	(49.5%)
	Bank Indebtedness		$100,000.00	$100,000.00	$0.00	0.0%
	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			$130,606.89	$126,006.98	$8,663.17	6.8%

Equity
	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 Equity			$21,489.08	($12,343.07)	$33,832.15	(274.1%)

Total Liability & Equity			$156,659.23	$114,163.91	$42,495.32	37.2%

More help options