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
Balance Sheet [Budget Analysis]
October 2001
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% | ||
Office Equipment |
||||||
Office Equip., Original Cost |
$12,000.00 |
$12,000.00 |
$0.00 |
0.0% | ||
Office Equip., Amortization |
($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, Amortization |
($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% | ||
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% | ||
Tax Liabilities |
||||||
Tax 1 Collected |
$2,214.58 |
$354.98 |
$1,859.60 |
523.9% | ||
Tax 2 Collected |
$2,348.68 |
$452.00 |
$1,896.68 |
419.6% | ||
Total Tax 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% | ||
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% | ||
Balance Sheet (Budget Analysis) Report - Sample Report