Have you ever fronted $300 for a group gift and spent weeks tracking down who actually paid?

It happens constantly with wedding presents, baby showers, and office farewells. Someone buys the gift on their credit card. Everyone else promises to send money, and half of them forget by Tuesday.

You can fix this with a clean Notion setup. Two connected databases handle everything: one records each gift, and the other logs individual contributors.

When Notion Beats a Basic Spreadsheet

Spreadsheets work fine for a single gift shared between three roommates. You open Google Sheets, write names in column A, write dollar amounts in column B, and sum the bottom. Done in two minutes.

Thing is, spreadsheets get clumsy when you coordinate gifts throughout the year. Think of a family handling birthdays every month, or a workplace committee pooling cash for quarterly departures. In a flat sheet, you retype names, copy formulas, and lose track of who settled up across events.

Notion connects those records. A single contributor entry links across several gift pages. You see who owes money right now without opening five different tabs.

You will not bump into Notion database caps for this. Databases support up to 500 properties, according to the Notion Help Center on database properties. A reliable tracker needs only seven or eight.

Database Architecture: Two Tables, Zero Clutter

Do not stuff every contributor and purchase detail into a single table. That creates duplicate rows and breaks your totals. Instead, create two separate databases on the same page.

Database Property Property Type Purpose
Gifts Gift Name Title Identifies the event or recipient
Gifts Target Date Date Deadline for buying or collecting
Gifts Total Cost Number (Currency) Full price paid by the organizer
Gifts Status Select Planning, Purchased, or Settled
Gifts Ledger Relation Links to the Contributor Ledger
Gifts Total Collected Rollup Sums all received payments
Gifts Balance Due Formula Calculates money still owed
Contributor Ledger Contributor Name Title or Person Identifies who is chipping in
Contributor Ledger Gift Link Relation Two-way link back to Gifts
Contributor Ledger Amount Owed Number (Currency) Assigned share for this gift
Contributor Ledger Amount Paid Number (Currency) Actual money received
Contributor Ledger Payment Method Select Venmo, Zelle, Cash, or PayPal

This two-table structure keeps historical records tidy. When you finish a gift collection, you mark it Settled without losing the log of who paid what.

Formulas and Rollups That Run the Math

Once both tables exist, create a two-way relation between them, following the model in Notion VIP's guide to relations and rollups.

In the Gifts table, set up a Rollup named Total Collected. Configure it to look at the Contributor Ledger relation, pull the Amount Paid property, and calculate the Sum.

Next, write the formula for the remaining balance. Create a Formula property in the Gifts table named Balance Due and enter this expression:

prop("Total Cost") - prop("Total Collected")

When the balance hits zero, the gift is fully reimbursed.

For an equal split, you can calculate each person's suggested share automatically. Add a Formula property named Per-Person Target:

prop("Total Cost") / length(prop("Ledger"))

Turns out, equal splits do not work for every situation. Sometimes two people want to cover half the cost while three others chip in $20 each. Keep the Amount Owed field in the Contributor Ledger as a standard Number property instead of a locked formula. That lets you assign custom amounts whenever a split is uneven.

In the Contributor Ledger, calculate each person's remaining debt with another formula property named Unpaid:

prop("Amount Owed") - prop("Amount Paid")

If this number is zero, that person is clear.

Step-by-Step Setup in Your Workspace

  1. Create a blank page in Notion and name it "Group Gift Hub".
  2. Type /table and choose "Table view - New database". Name it "Gifts".
  3. Add the properties from the architecture table: Total Cost, Target Date, and Status.
  4. Below the Gifts table, type /table again to create the second database named "Contributor Ledger".
  5. In the Gifts table, add a new property, select "Relation", and choose "Contributor Ledger". Turn on the toggle for "Show on Contributor Ledger" to create a two-way link.
  6. In Gifts, add your Rollup property for Total Collected pointing to Amount Paid.
  7. Add the Balance Due formula property.
  8. Switch to the Contributor Ledger and add columns for Amount Owed, Amount Paid, and Payment Method.
  9. Create a Board view on the Contributor Ledger. Group the board by Payment Method or by formula output, using techniques from Thomas Frank on grouping database views by formulas.
  10. Add a filter to your board view where Unpaid is greater than 0 so you only see active balances.

Sharing Access Without Breaking Your Formulas

Sharing a financial tracker with casual friends can get messy fast.

If you invite friends as workspace members, you create two headaches. First, you run into workspace caps. A free Notion workspace hits a 1,000-block workspace ceiling the moment you add a second member. Second, casual members might click a column header and delete your formulas by accident.

Keep the workspace single-member. Share the specific tracker page by clicking the Share button in the top-right corner and inviting people as guests via email. Free Notion plans allow up to 10 guests per workspace without triggering the collaborative block cap.

Give those guests "Can edit content" permissions instead of full "Can edit" access, as detailed in Thomas Frank's guide to Notion sharing permissions. "Can edit content" lets people update their paid amounts, change a select menu, or attach a screenshot, but it stops them from renaming properties or wiping out your math.

To be honest, I once gave five family members full edit permissions on an anniversary gift tracker, and within two days my calculation formulas were replaced with plain text notes and a recipe link, which meant I had to rebuild the entire database from scratch on my phone.

Watch out for receipt file sizes as well. The free plan limits individual file uploads to 5 MB, based on the Notion Help Center on importing data. If someone uploads a massive phone photo of a paper receipt, it may fail. Tell contributors to compress the photo first or paste a shared Google Photos link into a URL property.

Four Traps to Avoid

  • Confusing formulas with automated reminders. A red formula label that reads "Unpaid" helps you spot debt, but it will not text your coworker. You still need to copy the balance and send a payment request.
  • Inviting contributors as members instead of guests. Workspace members trigger the 1,000-block ceiling. Page guests do not.
  • Forgetting to attach the original receipt. Always upload the invoice or paste an order link in the gift row. It eliminates quiet doubts about sales tax or shipping charges.
  • Leaving database views unlocked. After your layout is complete, open the database view menu and turn on "Lock database". It prevents accidental column drags on mobile screens.

Frequently Asked Questions

What should I do if someone pays in cash?

Enter the cash amount directly into the Amount Paid column in the Contributor Ledger and set the Payment Method tag to "Cash". The Rollup in the Gifts table will count it toward the total collected immediately.

Can I track one person's balance across three different gifts?

Yes. Open the Contributor Ledger, group the view by the contributor's name, and turn on the column calculation at the bottom of the Unpaid column set to "Sum". Notion will display that individual's combined outstanding balance across all linked gifts.

How do I handle someone who drops out after the purchase?

Do not delete their row. Set their Amount Owed to 0 and add a note explaining that they opted out. If the remaining group members absorb the difference, update the Amount Owed numbers for everyone else so the collective pool still covers the total cost.

Create a dummy gift record with two sample contributors right now. Send yourself a guest share link in a private browser window to confirm the permissions work, and you will be ready for the next group event.