Profit & Loss [Budget Spreadsheet]

Index to Reports: General Ledger Tab

Provides the monthly budgeted amounts for profit and loss accounts in spreadsheet format.

Profit & Loss [Budget]

November 2000 through December 2000

     

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