Party Equipment Rental Profit Tracker

The Party Equipment Rental Profit Tracker tracks Offerings and Rates - customer / event, rental package, booking value, rental days, rate per rental day, extras revenue, total revenue, and direct cost for every booking. Change a price and the rate and totals update.; Bookings Log - date, customer / event, booking, rental days, rate, amount, and whether it was billable for every booking. Main-booking rates are pulled from sheet 1 by formula; extras are priced per booking.; Expenses - labor, delivery & fuel, maintenance, insurance, marketing, utilities and other overhead, with a monthly cost for each.; Monthly P and L - revenue, direct cost, labor, delivery & fuel, maintenance, insurance, marketing, utilities and other expenses by month, Jan-Dec, with net profit and margin. Revenue is a formula from the Bookings Log; direct cost is a formula from sheet 1.; Dashboard - total revenue, bookings, rental days, billable vs non-billable rental days, capacity used, average rate, direct cost, expenses, net profit and margin, best and weakest bookings, revenue by booking, costs by category, and rental days by booking..

The included example shows: 12 offerings; booking values 23,800; extras revenue 3,250; total revenue 27,050; direct cost 5,410.

Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.