Wedding Welcome Bag & Favors Tracker

Making welcome bags for out-of-town wedding guests? Keep the room list, what goes in each bag, the shopping, the hotel drop-offs and your favors in one organized spreadsheet. WHAT YOU GET • Guest and room list for up to 200 rooms or households with hotel, booking name, check-in date, bag type, assembled and delivered • Up to three bag types (for example standard, family and wedding party), renamed to suit, with bags to make and cost per bag for each • Contents planner: how many of each item go in each bag type, the total needed, packs to buy after what you already have, cost each and what's bought • Hotels and drop-off schedule with dates, times, any front desk fee per bag, bags per hotel and a ready-to-send note for each hotel • Favors tracker for every reception guest: per guest for adults, kids or everyone, plus spares, packs to buy and packing progress • Checklist of 18 tasks with due dates counted back from the day the first guests arrive • Dashboard with days to go, bags assembled and delivered, average cost per bag, totals, a needs-attention list, the drop-off schedule and a shopping list HOW IT WORKS 1. Type both names, the wedding date, the first arrival date and your favor guest counts on Settings. 2. List your hotels, then add each room or household with its hotel and bag type. 3. Plan what goes in each bag type and each favor, then mark things bought, assembled and delivered. FEATURES • Total needed = each item per bag type times the bags of that type, plus spare bags • Packs to buy round up to whole packs after what you already have • Guests checking in before their hotel's drop-off date are flagged • Drop-off dates default to the day before the first guests arrive • Bags to assemble now, late drop-offs and overdue tasks are flagged • Prefilled starter items, categories and checklist to edit • Works in any currency, clean printable layout WORKS WITH • Microsoft Excel (desktop or Microsoft 365) • Google Sheets (free with a Google account) • Apple Numbers • LibreOffice Best on a computer or tablet. WHAT YOU RECEIVE • Wedding Welcome Bag & Favors Tracker - Blank.xlsx, ready for your welcome bags • Wedding Welcome Bag & Favors Tracker - Sample.xlsx, filled with example data so you can see how it works • A quick start guide (PDF) This is a digital download. Nothing is shipped, and the files are yours to keep. For personal use. QUESTIONS? Message us on Etsy. We're happy to help you get set up.