This report provides the monthly budgeted amounts for profit and loss accounts in spreadsheet format.
More Details about the Profit & Loss (Budget Spreadsheet) Report
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 | ||
Carriage 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 | ||
VAT | £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 |