Index to Reports: General Ledger Tab
Compares your balance sheet as of the end of the selected month with your budgeted balance sheet for that month.
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 |
||||||
MasterCard |
$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 |
||||||
Default 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% | ||