A free Google Sheet can keep a Nashville dinner group aligned, but only if the layout separates the bill from each person's share. Use one row for the restaurant charge, one row for every participant's share, and one row for every later repayment. Keep repayments separate.

This setup fits Pancake Pantry brunches, hot chicken runs, and ordinary weeknight dinners. The layout below is a build-your-own template you can adjust as your friend group changes.

Use four simple tabs

Turns out, a separate tab for each job makes the math easier to check. Names and dollar amounts belong in rows, not in one crowded Notes cell.

Tab What goes there Important columns
Bills One restaurant charge Bill ID, date, restaurant, payer, total bill
Shares One person's portion of one bill Bill ID, person, amount owed
Settlements One repayment between friends Date, sender, recipient, amount
Summary One balance line per person Paid, owed, sent, received, current net

A bill can appear once in Bills and several times in Shares. That is the key design choice.

Build the Google Sheet

  1. Open a blank Google Sheets file and rename the first tab Bills. Add tabs named Shares, Settlements, and Summary.
  2. In row 1 of Bills, add Bill ID, Date, Restaurant, Payer, Total bill, Split type, Receipt link, Notes, and Check.
  3. In row 1 of Shares, add Bill ID, Person, Equal share, Uneven amount, Amount owed, and Note.
  4. In row 1 of Settlements, add Date, Sender, Recipient, Amount, and Bill ID or note.
  5. In row 1 of Summary, add Person, Paid, Owed, Net before settlement, Sent, Received, and Current net.
  6. Give every bill a unique ID, such as NASH-001 or NASH-002. Use the same ID on every matching row in Shares.

Use Equal or Uneven in the Split type column. Add a dropdown if you want to prevent spelling differences.

Enter the amount your group actually agreed to divide. Include tax and tip if the group is sharing them. If some receipt items are personal, enter the shared amount and explain the adjustment in Notes.

Format the money columns as USD with Format > Number > Currency. Format dates consistently, then freeze row 1 so the headers stay visible while you add meals.

Add the formulas

These formulas assume the tab names and columns above are unchanged. Paste each formula into row 2, then copy it down.

Cell Formula Purpose
Shares!C2 =IF(A2="","",IFERROR(INDEX(Bills!$E:$E,MATCH(A2,Bills!$A:$A,0))/COUNTIF($A$2:$A,A2),"")) Calculates an equal share based on the number of matching participant rows
Shares!E2 =IF(A2="","",IFERROR(IF(INDEX(Bills!$F:$F,MATCH(A2,Bills!$A:$A,0))="Uneven",D2,C2),"")) Uses the manual uneven amount or the calculated equal share
Bills!I2 =IF(A2="","",IF(ROUND(SUMIF(Shares!$A:$A,A2,Shares!$E:$E)-E2,2)=0,"OK","Check")) Confirms that shares add up to the bill
Summary!B2 =SUMIF(Bills!$D:$D,A2,Bills!$E:$E) Adds bills paid by the person
Summary!C2 =SUMIF(Shares!$B:$B,A2,Shares!$E:$E) Adds that person's shares
Summary!D2 =B2-C2 Shows the balance before repayments
Summary!E2 =SUMIF(Settlements!$B:$B,A2,Settlements!$D:$D) Adds money sent to friends
Summary!F2 =SUMIF(Settlements!$C:$C,A2,Settlements!$D:$D) Adds money received from friends
Summary!G2 =D2+E2-F2 Shows the current balance after repayments

Copy the formulas down far enough for your group. Keep the person names consistent across all tabs.

A positive Current net means the group still owes that person. A negative value means that person still owes money. Zero means the recorded bills and repayments are even.

Test it with a Nashville bill

Suppose Alex pays a $120 Pancake Pantry bill for four diners on 2026-03-15. Add one Bills row with NASH-001, the date, restaurant, Alex as payer, $120.00, and Equal as the split type.

Then add four Shares rows with NASH-001, one for each diner. The equal-share formula returns $30 for each row. The Check cell should say OK.

Only add people who shared that particular bill. If three friends attended and one did not, create three share rows. The formula counts those rows, not the entire group list.

Handle uneven orders and repayments correctly

Thing is, the person who paid is not always the person who ultimately owes the money. The Payer column records who put the full charge on a card or paid the receipt. The Shares tab records who should bear the cost.

For an equal bill, leave Uneven amount blank. For an uneven bill, choose Uneven and enter the agreed amount for each person in column D. The Check cell gives you a quick test before anyone sends money.

If Alex paid the full bill but everyone shares the cost, do not mark Alex as owing 100 percent and everyone else as owing zero. Enter each person's actual share. A 100 percent and zero percent split is only correct when Alex is truly covering the whole expense.

Never create a second restaurant bill when someone pays a friend back. Add a row in Settlements instead. For example, if Jordan sends Alex $30, record Jordan as the sender, Alex as the recipient, the amount, and NASH-001 as the related bill. The original bill stays unchanged.

If an equal split creates a fraction of a cent, assign the leftover cent to one person in Uneven amount. Make the shares add exactly to the bill total.

Share the file without exposing it casually

Start with named access for a private friend group. Google Drive's sharing help covers access settings and permission choices.

Access choice Useful when Watch for
Restricted You know the group's email addresses Add new members when the group changes
Viewer People only need to check balances They cannot add bills
Commenter People need to flag a correction Comments do not update the ledger
Editor A person will enter bills or settlements Formula cells can be changed
Anyone with the link The information is not sensitive Anyone who gets the link may access the file

Anyone with the link is not private in the strict sense. Google indicates that link recipients may use the file without signing in, so Restricted access is the safer default for names and payment records.

Give editing access only to people who actually maintain the sheet. Keep formula columns protected or ask editors not to type over them.

Agree on the rules before dinner

A spreadsheet records the group's agreement. It cannot decide a disputed tip or missing receipt.

Decision Example rule to write in Summary
Who enters bills The person who paid adds the row
Entry timing Add the bill within an agreed window, such as 48 hours
Tip and tax Decide whether the group splits them equally or by each person's share
Personal items Remove them from the shared amount and explain the adjustment
Corrections Edit the original row and leave a note about the change
Settlements Record actual payments, not promises to pay later

Use the receipt link whenever possible. A photo or shared receipt location makes an unusual split easier to verify later.

Common mistakes to catch

Problem Fix
Several names appear in one cell Add one Shares row per person
A Bill ID is reused Give every restaurant charge a new ID
The same person appears twice for one bill Remove the duplicate before trusting equal-share formulas
Check says Check Compare the share rows with the total bill
A formula was replaced with a number Restore the formula and copy it down
Every share was rounded down Assign the leftover cent so the total matches

The Check column catches missing or excessive amounts. It will not catch a duplicate participant whose rows still add to the total, so scan the share names when a bill looks unusual.

When a split-bill app may fit better

A spreadsheet is usually enough when the group wants visible math, a simple history, and control over its own columns. It keeps tracking separate from paying.

Consider a split-bill app when the group needs repeated reminders, receipt scanning, payment requests, or a chat-first way to enter expenses. Check the tool's actual export and payment options before moving a group's records, since those features vary.

Enter one real bill today

Create the four tabs, enter your last Nashville restaurant bill, and add one Shares row for every diner. Wait for the Check cell to read OK, then share the file with Restricted access and record the first repayment in Settlements.