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.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/Aa1x15j9McI

✨ 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 due flags
• Licenses & Insurance: policies, permits and certifications with expiry dates, Renew now reminders and yearly cost
• Expenses (600 rows) with a by-category summary; tag an event to include the cost in that event's profit
• Profit Report: revenue, gratuity, staff, event costs, overhead, maintenance and net profit by month, results by event type, package, lead source and dry hire vs full service, your 10 most profitable events and 2 charts
• Sample data from a busy mobile bar so you can see how it works; the blank copy keeps a starter bar price list and drink menu you can edit

★ PERFECT FOR ★
✓ Mobile bartenders and mobile bar trailer owners
✓ Bartending services for weddings and private events
✓ Dry hire bar rental businesses
✓ Anyone starting a mobile bar business

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download the files right after purchase.
2. On Setup, Packages and Drink Menu, add your settings, packages, prices and drinks.
3. Log inquiries, book events, schedule staff and record payments.
4. The calculator, dashboard and profit report update themselves.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• Liquor laws are different in every state, county, city and venue. This is a business planning tool, not legal, tax or financial advice.
• Alcohol amounts are estimates based on your own drinks-per-guest settings.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.