Balance Sheet [Spreadsheet] report
Overview | ìDetailsî on page 37 | Notips | ìSampleî on page 36
This report displays the balance sheet for multiple periods in spreadsheet format.
This report can be displayed using the cash basis and accrual basis accounting methods. Click the Customize button in the Index to Reports window to display the Report Customization window. In the Report Basis field, select Accrual or Cash, then click Display to display your report.
Cash basis reports are differentiated
from
accrual basis reports by the word [Cash] listed after the report name.
Overview of Balance Sheet [Spreadsheet} report
To find the Balance Sheet [Spreadsheet] report
ìOverviewî on page 36 | ìDetailsî on page 37 | Notips | ìSampleî
on page 36
Reports menu > Index to Reports window >
Accounts tab > Balance Sheet header
|
Balance Sheet
[Spreadsheet] |
|||||||
|
|
|
|
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 |
|||
|
|
Deposits Paid Vendors |
$100.00 |
$100.00 |
$100.00 |
|||
|
|
Office Equipment |
|
|
|
|||
|
|
|
Office Equip., Original Cost |
$12,000.00 |
$12,000.00 |
$12,000.00 |
||
|
|
|
Office Equip., Amortization |
($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, Amortization |
($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 |
|||
|
|
Accounts Payable |
$10,627.02 |
$10,627.02 |
$10,627.02 |
|||
|
|
Bank Indebtedness |
$100,000.00 |
$100,000.00 |
$100,000.00 |
|||
|
|
Tax Liabilities |
|
|
|
|||
|
|
|
Tax 1 Collected |
$2,414.58 |
$2,414.58 |
$2,414.58 |
||
|
|
|
Tax 2 Collected |
$2,348.68 |
$2,348.68 |
$2,348.68 |
||
|
|
Total Tax 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 |
||||
|
|
|
|
|
|
|
||
|
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 |
||||
0 Comments