Run your mobile bartending business from one spreadsheet
The Pourcrest Mobile Bartending Business Kit is an Excel and Google Sheets workbook plus a printable PDF kit for mobile bar owners. It prices every event, estimates how much to buy, shows your profit before you send the quote, prints a polished client quote, and tracks every booking from first inquiry to final payment.
Everything is connected: the guest count in a quote flows into the drink estimate, the drink estimate flows into your costs, and your bookings flow into a live dashboard.
Who it is for
- Mobile bar and bartending service owners, dry hire or full service
- Bartenders starting a side business who want to price events with confidence
- Beverage caterers, cocktail trailers and event planners who run bars for weddings and parties
What’s included
- Pourcrest-Mobile-Bartending-Business-Kit.xlsx: the 11-tab workbook, ready for your business
- Example Filled-In workbook: the same file with a sample bar business so you can see every feature working
- Mobile Bar Printables PDF in US Letter and A4: 9 fillable pages
- User Guide (Word): setup, every tab explained, tips, troubleshooting and FAQ
Mobile bartending business spreadsheet features
Quote calculator with a profit check
- Choose a package and type guests and service hours. Base price, per-guest charge, package minimum, extra hours, additional bartender hours, travel past your free radius and up to 8 add-ons are calculated for you.
- Suggested bartenders from your own guests-per-bartender ratios for full bars and beer and wine bars.
- Three alcohol options: client supplies (dry hire), included in your package, or billed at cost plus your markup.
- Discount, service charge or gratuity, sales tax, total, deposit to book, balance due date and all-in price per guest.
- Profit check: bartender wages including setup and teardown, alcohol, bar supplies, add-on costs, vehicle cost, overhead and other costs. See your margin, whether you hit your target, and how much to raise the price if you do not.
Drink estimator and shopping list
- Total drinks from guests, hours, the share of guests who drink and drinks per hour (all editable).
- Preset mixes for a full bar, a beer and wine bar or an NA bar, or type your own mix.
- Beer by can and case, red, white and sparkling wine by bottle and case, spirits by bottle, with costs.
- Mixers, limes and lemons, garnish, syrups, non-alcoholic drinks, ice, cups, napkins and straws with pack sizes and costs.
Print-ready client quote
A one-page quote with your business name and contact details, the client, the event, service details, only the line items that apply, totals, deposit, balance due date, what’s included, your note and your terms with a signature line. Save it as a PDF and email it.
Bookings and deposit tracker
- 200 bookings with status (inquiry, quoted, booked, completed, lost, cancelled), package, guests and venue.
- Deposit required, deposit paid, later payments, balance and balance due date are calculated.
- Automatic payment status: deposit due, deposit paid, balance due soon, overdue or paid in full.
- Event costs, profit and margin for every event, plus lead source and staff assigned.
Event details and one-page event sheet
Record on-site contacts, arrival and closing times, bar location, power, what the venue provides, who supplies alcohol, the drink menu, NA requests, load-in and venue rules. Pick any booking to print an event-day sheet with a timeline, quick drink and ice estimates, the balance to collect and a 16-item checklist.
Bar inventory
Track bottles, mixers, garnish, disposables, bar tools and equipment with par levels. Items below par show how many to reorder and what it will cost. A starter list of common items is included.
Dashboard
Booked events, revenue, profit and margin, average event price, deposits received, balances to collect, events in the next 30 days and lead conversion. Plus upcoming events, payments to chase, a month-by-month table and chart, revenue by event type and leads by source.
9-page printable kit
Event-day pack list (50+ items), event-day timeline and service checklist, fillable client quote, client event details form, drink calculator and shopping list, bar inventory count sheet, responsible service and incident log, and a post-event recap and settlement page.
How it works
- Enter your business details, currency, deposit %, travel fee, staff pay, staffing ratios and target margin on Settings.
- Replace the starter packages and add-ons with your own prices and costs.
- Price each inquiry in the Quote Calculator, check the margin, then print the Client Quote.
- When the client books, add a row in Bookings and record the deposit. The dashboard updates by itself.
- Before the event, fill in Event Details, print the Event Sheet and the pack list, and shop from the Drink Estimator.
File formats and software
- .xlsx workbook for Microsoft Excel 2016 or newer (Windows and Mac), Microsoft 365, Excel for the web and Google Sheets (free Google account). Apple Numbers is not supported.
- No macros, scripts or add-ons. Formula cells are locked without a password so they are hard to break by accident.
- PDF printables in US Letter and A4, fillable in Adobe Acrobat Reader (free) or printed and filled by hand.
- User guide in Word (.docx).
Customize it
Use any currency symbol. Edit packages, add-ons, lists, terms, drink rules and prices.
Digital download
This is a digital product. No physical item ships. Download the files right after purchase from your order confirmation and your account. Personal use only, or use within your own business; please do not resell or share the files.
Use cases
- Quote a 140-guest wedding with a champagne toast in minutes and know your margin before you hit send.
- Switch a corporate party to beer and wine and watch staffing and the shopping list update.
- See which balances are due before a busy weekend, and which lead sources actually book.
Important: alcohol laws
This kit is a business planning tool, not legal advice. Alcohol rules differ by state, county, city and venue. Check your local liquor licensing (including whether you may buy, sell or supply alcohol or must work dry hire), permits, age-verification and responsible-service training rules, and carry liquor liability insurance. Drink quantities are planning estimates.
FAQ
How do I price a mobile bartending event?
Most mobile bars charge a package base price, a per-guest price, extra hours and add-ons, then a deposit to book. The Quote Calculator builds that for you and checks your costs and margin.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. Formulas, dropdowns, colors and charts carry over.
How much alcohol do I need per guest?
A common planning rule is about 2 drinks per drinking guest in the first hour and 1 per hour after that. The Drink Estimator uses your own numbers and turns them into bottles, cases and costs.
Can I use it for dry hire?
Yes. Choose “Client supplies (dry hire)” and alcohol is left out of your price and costs, while mixers, ice and supplies can still be counted.
Is there a subscription?
No. It is a one-time purchase and the files are yours to reuse every year.
Is this legal advice?
No. Check local licensing, permits and service rules before every event.
Pourcrest Mobile Bartending Business Kit by Taskdale.












Reviews
There are no reviews yet.