Use a Google Sheets template with columns for date, restaurant, payer, amount, and split type to track New Orleans restaurant bills with friends. This setup calculates per-person balances using formulas like SUMIF, adjusted for your sheet. It suits casual group dinners or outings, helping maintain simple records without apps.

Friends splitting bills after meals at places like Commander's Palace or Cafe du Monde can enter data on the spot via mobile, collaborate in real time, and settle owed amounts later. Editorial sources such as expensesorted.com outline similar columns and workflows for group expenses.

Recommended Columns for Restaurant Bill Tracking

Start with these evidence-based columns for a basic template, drawn from editorial guides on expense tracking.

  • Date: When the bill was paid (e.g., 2026-03-15).
  • Restaurant: Name and location (e.g., "Commander's Palace, Garden District").
  • Payer: Who covered the bill (e.g., "Alex").
  • Amount: Total bill before tip or tax (e.g., $120).
  • Split Type: Even split, reimbursement, or usage-based (dropdown: Even, Reimburse).
  • Notes: Details like "Alex paid cash, includes tip".
  • Receipt Link: Hyperlink to scanned receipt.

Add a summary sheet with totals per person. Freeze the first row for headers via View > Freeze > 1 row. Use data validation for dropdowns in Split Type and Restaurant columns to standardize entries, such as common New Orleans spots like "Cafe du Monde" or "Willie Mae's Scotch House".

This structure, adapted from sources like expensesorted.com and Johnny Africa, keeps tracking straightforward for small groups.

Setup Steps to Build and Share the Spreadsheet

  1. Go to sheets.google.com and create a new blank spreadsheet. Name it "New Orleans Group Dinners 2026".

  2. Enter headers in row 1: Date, Restaurant, Payer, Amount, Split Type, Notes, Receipt Link.

  3. Input a sample bill: Date "2026-03-15", Restaurant "Commander's Palace", Payer "Alex", Amount "$120", Split Type "Even".

  4. Format Amount as currency: Select column, Format > Number > Currency (USD).

  5. Freeze header: View > Freeze > 1 row.

  6. Share via the Share button (top right). Add friends' emails or generate a link. Set to "Editor" for group input or "Viewer" for records. For granular control, use Protected ranges later.

Link-sharing works without emails, ideal for ad-hoc groups. Access on desktop or mobile; changes sync across devices. Real-time collaboration shows live edits, with a built-in chat for questions like "Who paid at Antoine's?"

Balance Calculation Workflow with Formulas

Track balances with these editorial-sourced formulas, tested in your sheet as structures vary.

In a "Summary" sheet, list friends' names in column A (e.g., A2: "Alex"). In B2 for amount paid by Alex: =SUMIF(Expenses!D:D, A2, Expenses!C:C). This sums amounts where Payer matches the name (assumes Expenses sheet, Payer in D:D, Amount in C:C).

For even split owed: In C2, =B2 - (SUM(Expenses!C:C)/4) (adjust 4 for group size). Positive means they are owed money; negative means they owe.

For reimbursements, mark one payer at 100% in Split Type and adjust formulas accordingly. Test ranges first - mismatched columns cause errors, a common mistake per Johnny Africa.

Currency formatting applies automatically; for conversions if needed, try =GOOGLEFINANCE("CURRENCY:USDEUR") * [amount], but stick to USD for U.S. bills.

Update after each dinner: Enter bill, formulas recalculate instantly.

Handling Receipts and Recordkeeping

Receipts provide proof for disputes. Follow this workflow from Klippa:

  1. Scan physical receipt to image using phone camera or app.

  2. Upload to a shared Google Drive folder named "Dinner Receipts".

  3. In the Receipt Link column, insert hyperlink: Right-click cell > Insert link > paste Drive URL.

Reference links during settlements, e.g., "Check Alex's $120 receipt here". Sheets works offline - enter data at the restaurant, syncs later. Keep physical copies until settled.

For volume, sort by date or payer via Data > Create a filter.

Sharing Permissions and Common Mistakes

Set permissions carefully for group use, per guides like GeeksforGeeks.

  • Viewer: Read-only, no edits. Best for final records.
  • Commenter: Add notes, no changes.
  • Editor: Full access, for active tracking.

Use Protected ranges: Select formula cells (e.g., summary balances), Data > Protect sheets and ranges. Allow only you to edit.

Real-time edits show cursors and changes; use chat for coordination.

Common mistakes:

  • Wrong permissions: Editors overwrite formulas - start with Viewer, request edit access.
  • Unshared links: Copy link after setting "Anyone with link" to Editor.
  • Untested formulas: Mismatched ranges (e.g., D:D vs. D2:D100) break sums.
  • No frozen headers: Scrolling hides columns on mobile.
  • Forgetting mobile view: Test sharing on phones for restaurant entry.

This suffices for small groups with low-volume dinners (e.g., monthly outings). For frequent use or payments, consider split-bill apps qualitatively, but spreadsheets avoid fees and keep control.

FAQ

How do I share the sheet without giving everyone edit access?
Use the Share button, set to "Viewer" or generate "Anyone with the link" as Viewer. Viewers see data but can't change it.

What formula shows how much my friend owes after a $200 dinner split evenly?
=SUMIF(Expenses!D:D, "Friend Name", Expenses!C:C) - (SUM(Expenses!C:C)/group size). Test in your sheet; negative result means they owe.

Can I add New Orleans restaurant categories as dropdowns?
Yes, select Split Type or Restaurant column, Data > Data validation > List of items (e.g., "Commander's Palace, Cafe du Monde").

How do I protect balance formulas from accidental changes?
Data > Protect sheets and ranges > select formula cells > Set permissions to only you.

When should I switch from a spreadsheet to a split-bill app?
If payments automate or volume grows; spreadsheets work for simple tracking and records.

Does this work offline for entering bills at the restaurant?
Yes, enter data offline on mobile; syncs when online.

Next, create your sheet and test with a sample bill. Review balances monthly, settle via cash or apps, and archive settled rows.