Mobile Bartending Business Spreadsheet, Excel and Google Sheets, Bar Business Tracker, Alcohol Calculator, Pour Cost, Event Bookings

Mobile Bartending Business Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Run your mobile bartending business from one file: inquiries, bookings priced from your packages, dry hire or full service, drink menu pour costing, an alcohol quantity calculator, staff pay, deposits, equipment upkeep, license renewals and profit per event. Perfect for mobile bartenders and mobile bar trailer owners. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers). ★ WHAT'S INCLUDED ★ • 15 tabs with a clickable Start Here page • Dashboard: 16 KPI tiles (revenue, net profit, events, average event, guests served, client balances, upcoming events, full service share, inquiries, close rate, follow-ups due, payments due soon, staff to pay, average pour cost, equipment service due and renewals), a month by month table, your next events, client payments due, license renewals, equipment service and 5 charts • Setup: your service model (client supplies the alcohol = dry hire, or you supply it), alcohol markup, deposit %, final payment timing, guests per bartender, travel fee, gratuity %, drinks per guest per hour, plus bar types with their beer / wine / cocktail / non-alc mix • Inquiries (300 rows): event date, guests, hours, package interest, lead source, stage, follow-up and quote, with a date check, a ballpark price, lead source close rates, why leads are lost and a chart • Events (200 rows): pick the package, bar type, add-ons and who supplies the alcohol; the package price, extra bartenders, travel fee, alcohol charge with your markup, gratuity, deposit, final payment, past due, bartenders needed, estimated drinks, staff cost, profit, margin and profit per guest fill in • Packages & Pricing: up to 12 packages (setup fee, per guest, hours, extra hour rate, bartenders included) with supplies and alcohol cost per guest, 15 add-ons and a Quick Quote with deposit, final due date and a date check • Drink Menu (60 drinks): each recipe in ounces with alcohol cost, mixers and supplies, cost per drink, pour cost %, profit per drink, a suggested price and a price check • Bar Price List (150 products): bottles, cans, kegs, mixers and garnish with cost per ounce, cost per pour and pours per pack • Alcohol Calculator: pick an event or type guests and hours to get the drinks, cans, bottles and cases of beer, wine and spirits, plus ice, cups, napkins, fruit and mixers, the estimated cost, bartenders needed and the staff booked for that event • Staff & Pay (600 shifts): hours from start and end times, pay at each person's rate, tips or gratuity share and paid / to pay status, plus a staff directory with alcohol certification expiry flags • Payments (500 rows): deposits and final payments with Paid / Overdue / Due soon status and days late • Equipment: your bar gear and trailer with a maintenance log, upkeep this year and next service du