This report provides the monthly budgeted amounts for profit and loss accounts in spreadsheet format.
More Details about the Profit & Loss (Budget Spreadsheet) Report
Profit & Loss [Budget]
November 2001 through December 2001
November |
December |
Total | |||
______________________________________________________________________ | |||||
Income |
|||||
Sales |
|||||
Retail Sales |
$500.00 |
$5,000.00 |
$5,500.00 | ||
Wholesale Sales |
$100.00 |
$1,500.00 |
$1,600.00 | ||
Consignment Sales |
$11,000.00 |
$2,500.00 |
$13,500.00 | ||
Total Income |
$11,600.00 |
$9,000.00 |
$20,600.00 | ||
Cost of Sales |
|||||
Retail Cost of Sales |
$450.00 |
$3,000.00 |
$3,450.00 | ||
Wholesale Cost of Sales |
$100.00 |
$1,000.00 |
$1,100.00 | ||
Consignment Cost of Sales |
$550.00 |
$4,000.00 |
$4,550.00 | ||
Total Cost of Sales |
$11,050.00 |
$5,000.00 |
$16,050.00 | ||
Gross Profit |
$550.00 |
$4,000.00 |
$4,550.00 | ||
Expenses |
|||||
Car & Truck Expenses |
$0.00 |
$125.00 |
$125.00 | ||
Freight Paid |
$0.00 |
$75.00 |
$75.00 | ||
Insurance (other than health) Interest |
$0.00 |
$50.00 |
$50.00 | ||
Other Interest |
$0.00 |
$750.00 |
$750.00 | ||
Legal & Professional Services |
$0.00 |
$250.00 |
$250.00 | ||
Lease Expenses |
|||||
Machinery & Equipment |
$0.00 |
$120.00 |
$120.00 | ||
Other Business Property |
$0.00 |
$20.00 |
$20.00 | ||
Supplies |
$0.00 |
$150.00 |
$150.00 | ||
Taxes |
$0.00 |
$75.00 |
$75.00 | ||
Travel, Meals & Entertainment |
|||||
Meals & Entertainment |
$0.00 |
$1,500.00 |
$1,500.00 | ||
Utilities |
$0.00 |
$400.00 |
$400.00 | ||
Wages Paid |
$0.00 |
$700.00 |
$700.00 | ||
Total Expenses |
$0.00 |
$4,215.00 |
$4,215.00 | ||
Operating Profit |
$11,050.00 |
$785.00 |
$11,835.00 | ||
Other Income |
|||||
Other Expenses |
|||||
Net Profit/(Loss) |
$11,050.00 |
$785.00 |
$11,835.00 | ||
Profit & Loss (Budget Spreadsheet) Report - Sample Report