Use this free Notion database template setup to track Airbnb bookings, split costs evenly or by usage, log reimbursements, and share read-only views with your group. Copy the property structure below and add basic sum/divide calculations in a Google Sheet export if needed.

This approach helps U.S. travel groups like friends, family, or clubs avoid reimbursement arguments by documenting total costs, guest counts, splits, and who owes what. Start with a single database for expenses, link to a people database for balances, and use multi-select properties for participants.

When to Use a Notion Template for Airbnb Cost Splits

Notion works well for Airbnb cost tracking when groups have multiple expenses like nightly rent, cleaning fees, service charges, groceries, or rental car costs. It shines for linked databases, such as connecting expenses to a list of participants to track individual balances.

Use Notion if your trip involves 3+ people, recurring updates during a multi-week stay, or extras like uneven stays (some nights with 4 guests, others with 2). The Relation property links expenses to people, making it easy to roll up totals per person.

For simpler cases, a spreadsheet is enough. Decision tree: One-off trip under 10 expenses? Use Google Sheets for quick sums. Multiple databases needed for people, expenses, and reimbursements? Switch to Notion. Groups with chores or rules tied to money also benefit from Notion's pages for household agreements.

Core Database Properties for Your Airbnb Split Calculator

Build your template with these Notion database properties, drawn from the Notion Help Center on database properties.

Create two linked databases: "Expenses" and "People."

Expenses Database Properties:

  • Name (title): Expense title, e.g., "Airbnb nightly rent - Night 1."
  • Number: Total Cost (enter amounts like 450.00).
  • Select: Category (options: Rent, Cleaning Fee, Service Fee, Groceries, Rental Car, Other).
  • Multi-select: Participants (tag multiple people, e.g., Alice, Bob, Charlie).
  • Number: # Guests (count for that expense, e.g., 4).
  • Select: Paid By (one person who covered it upfront, e.g., Alice).
  • Relation: Link to People database (pulls in participant details).
  • Created time: Auto-tracks entry date.
  • Last edited time: Shows updates.

People Database Properties:

  • Name: Person's name.
  • Number: Total Owed (placeholder for sums).
  • Number: Paid (track reimbursements).
  • Formula: Balance (placeholder like Owed minus Paid).
  • Relation: Link back to Expenses.

Example columns in a grouped view: Expense | Total Cost | # Guests | Equal Split | Paid By | Balance. Limit to under 500 properties total per database.

Step-by-Step Setup for the Notion Template

  1. In Notion, create a new page called "Airbnb Cost Split Calculator." Type /database and select "Table - Full page" for Expenses.

  2. Add properties as listed above. For People database, type /database on the same page and link via Relation.

  3. Enter sample data:

    • Row 1: "Airbnb Subtotal," $1200, Category: Rent, Participants: Alice/Bob/Charlie/Dave, # Guests: 4, Paid By: Alice.
    • Row 2: "Cleaning Fee," $150, Participants: All, # Guests: 4, Paid By: Bob.
    • Row 3: "Groceries Night 1," $80, Participants: Alice/Bob, # Guests: 2, Paid By: Charlie.

  4. For calculations, Notion Formulas offer placeholders. View totals with board grouping by Paid By or sum views (database sums are manual; export to Sheets for auto-sums). Test: Group by Category, check if rent + fees total $1350.

  5. Duplicate the page as a template: Click the ••• menu, select "Duplicate," then share the duplicate.

Checklist:

  • Test sums with 4-person trip sample (total ~$1430).
  • Add sample reimbursement row: "Alice reimbursed by Bob," $300.
  • Verify Relation links update both databases.
  • Set view filters: Show only unpaid balances.

Sharing and Permissions for Group Access

Follow Notion's sharing and permissions guide for secure group access.

Share public views as read-only: Guests viewing a public database view cannot make changes that reflect back to the main database - no two-way sync. Ideal for reimbursements; everyone sees balances without edit risks.

For edits, use page-level access: Grant specific users view/edit on individual database pages without full database access. The rule creator needs Full Access; assigned users get notifications, and avatars show real-time collaboration.

Owner keeps Full Access. For granular control like task assignments (e.g., "Bob tracks groceries"), page-level rules work well, as noted in Thomas Frank's guide on Notion granular permissions.

Common setup: Owner edits master; group views public link. Notify via @mentions or page comments for updates.

Splitting Workflows: Equal, Per-Person, and Usage-Based

Equal Split: Divide total by fixed group size. Example: $1200 rent / 4 people = $300 each. Use # Guests property; manually note per row or export to Sheets.

Per-Person Split: Same as equal for full-trip attendees. Track in People database: Sum linked expenses divided by participants.

Usage-Based Split: For extras, use Multi-select for actual users. Example: Groceries $80 for 2 people = $40 each. Count multi-select tags manually or filter views by participant.

Tradeoffs: Equal is simplest for rent; usage fairer for meals (e.g., vegetarian skips group dinner). Income-based: Add Number property "Share %" (e.g., 30/30/20/20). Room-size: Note "Nights Stayed" in People database.

Review weekly during trips: Group call to confirm entries, note paid dates. Export CSV to Google Sheets for running totals - adapt simple divide formulas there if needed.

Common Mistakes and Recordkeeping Basics

Avoid over-relying on public views: Edits there do not save to the main database. Always test permissions first.

Other pitfalls: Too many properties (cap at 500); skipping Last edited time (misses who/when changes happened); no backup (duplicate page before sharing).

For records, screenshot receipts and attach to expense rows. Export CSV monthly for reimbursements - notes paid dates and amounts. Keep for disputes as needed.

Spreadsheet enough when under 10 expenses or no linked people tracking. Notion overkill for one dinner; use it for full trips with databases.

Group Review Cadence Checklist:

  • Daily: Log new expenses.
  • Weekly: Review balances, confirm payments.
  • End of trip: Export final CSV, note all cleared.

FAQ

How do I calculate equal splits in Notion without formulas?
Use database sum views grouped by category, then divide manually or export to Sheets for auto-divide.

Can guests edit the main database?
No, public views are read-only with no changes syncing back. Use page-level access for controlled edits.

What's the difference between Select and Multi-select for participants?
Select for single choices like Paid By; Multi-select for tagging multiple people on one expense.

How often should our group review the tracker?
Daily for new spends, weekly for balances during trips, final review at end.

Is this template good for non-Airbnb trips?
Yes, works for hotels, vacation rentals, or group events - swap categories as needed.

When should I switch to a spreadsheet?
For under 10 expenses, one-off trips, or quick math without linked people tracking.

Next, duplicate your Notion page, test with real data, and share the public view link in your group chat.