You can build a reusable New Orleans dinner bill template in a blank Google Sheet. The cleanest setup separates what each person paid from what each person owes, then checks that the totals match.
Turns out, one row per check is not enough when two friends split a meal or share only one appetizer. Use four tabs - Expenses, Payments, Allocations, and Summary - so the record stays clear even when the split changes from dinner to dinner.
Choose the split rule before entering numbers
Agree on the rule while the receipt is still open. The sheet can record several methods, but it won't decide what feels fair for your group.
| Method | Works well when | Allocation entry |
|---|---|---|
| Even | Orders are similar or everyone agrees to equal shares | Use the same percentage for every diner |
| Proportional | Orders differ, and the group shares tax and tip based on food totals | Divide each person's assigned pre-tax subtotal by the group subtotal |
| Itemized | People want to cover their own items | Add each person's assigned items, then convert the result to a share |
| Hybrid | The table shared some dishes but not others | Include each person's agreed portion of shared items |
Tax and tip should follow the rule you choose. With a proportional split, a diner whose assigned pre-tax subtotal is 30% of the group subtotal receives 30% of the final check. If the group agrees on a different treatment, enter the agreed final allocation instead.
Equal splitting is quick. Itemizing takes more work.
Build the Expenses tab
The Expenses tab stores each restaurant check once. It does not need a payer column because the Payments tab handles who actually covered the charge.
| Column | Header | What to enter |
|---|---|---|
| A | Bill ID | A unique value such as BILL-001 |
| B | Date | The date the check was paid |
| C | Restaurant | Restaurant name and, if useful, neighborhood |
| D | Total | The full amount being split |
| E | Method | Even, Proportional, Itemized, or Hybrid |
| F | Receipt Link | A link to the stored receipt |
| G | Notes | Details about cash, shared dishes, or an exception |
| H | Paid | Formula total from Payments |
| I | Allocated | Formula total from Allocations |
| J | Payment Difference | Total minus amount paid |
| K | Allocation Difference | Total minus amount allocated |
Enter the amount in D as a number, then format the column as currency. Include tax and tip if the group is sharing them. Keep each Bill ID stable because the formulas use it to connect the tabs.
In H2, enter =ROUND(SUMIF(Payments!$A$2:$A$2000,$A2,Payments!$C$2:$C$2000),2). In I2, enter =ROUND(SUMIF(Allocations!$A$2:$A$2000,$A2,Allocations!$D$2:$D$2000),2).
In J2, enter =ROUND(D2-H2,2). In K2, enter =ROUND(D2-I2,2). Copy H2:K2 down the sheet.
Both difference columns should show 0.00 for a finished bill. A nonzero value usually points to a missing payment, a wrong Bill ID, or an allocation that does not cover the full check.
Add the Payments tab
Payments records who actually paid and how much. Each row represents one contribution toward a bill.
| Column | Header | What to enter |
|---|---|---|
| A | Bill ID | The matching ID from Expenses |
| B | Payer | The person's name |
| C | Amount Paid | The amount that person covered |
For a normal single-payer check, add one row with the full bill amount. If two people used separate cards or combined cash and card, add a row for each payer. Their amounts must add up to the Expenses total.
Use the same spelling everywhere. A dropdown helps prevent entries such as Alex, alex, and Alexander from becoming three different people in the Summary tab.
Add the Allocations tab
Allocations records what each person owes. Each bill gets one row per participant.
| Column | Header | What to enter |
|---|---|---|
| A | Bill ID | The matching ID from Expenses |
| B | Person | The diner responsible for the share |
| C | Share % | That person's percentage of the bill |
| D | Owed | Formula result in dollars |
| E | Note | Optional item or shared-dish explanation |
In D2, enter =IF(OR(A2="",B2="",C2=""),"",ROUND(VLOOKUP(A2,Expenses!$A$2:$D$1000,4,FALSE)*C2,2)). Copy it down as new allocation rows are added.
For four equal diners, enter 25% in each of four rows. For a proportional split, calculate each person's assigned pre-tax subtotal and divide it by the group subtotal. Include a person's portion of a shared appetizer before calculating that percentage.
Thing is, the Method label does not perform the calculation. It documents the agreement. The percentages and allocation rows still need to be entered correctly.
All C values for one Bill ID should total 100%. The K check on Expenses catches missing or extra shares. If rounding creates a one-cent remainder, replace the final D formula with the agreed cent adjustment and explain it in column E.
Build the Summary tab
List every participant in column A, starting at A2. Include people who paid but did not eat if you want the sheet to show that they should receive money.
In B2, enter =ROUND(SUMIF(Payments!$B$2:$B$2000,$A2,Payments!$C$2:$C$2000),2).
In C2, enter =ROUND(SUMIF(Allocations!$B$2:$B$2000,$A2,Allocations!$D$2:$D$2000),2).
In D2, enter =ROUND(B2-C2,2).
| Column | Meaning |
|---|---|
| A | Person's name |
| B | Total paid |
| C | Total owed |
| D | Net balance |
Copy the formulas down for every name. A positive balance means the person should receive money. A negative balance means the person owes money.
The Summary shows net positions, not exact payment pairings. If several people owe or are owed, the group still needs to agree who pays whom.
Finish the sheet before sharing it
-
Create a blank spreadsheet and rename the tabs exactly
Expenses,Payments,Allocations, andSummary. -
Add the headers from the tables above. Put the formulas in the first data row and copy them down far enough for your group.
-
Format Expenses D, Payments C, Allocations D, and Summary B:D as currency. Format Allocations C as a percentage. Format the date column consistently.
-
Use Data validation to create a Method dropdown with Even, Proportional, Itemized, and Hybrid. Create name dropdowns from the participant list in Summary A2:A20, extending the range if needed.
-
Freeze the first row on each tab. This makes the headers easier to follow on a phone.
-
Protect formula ranges through Data > Protect sheets and ranges. Protect Expenses H:K, Allocations D, and Summary B:D, while leaving input columns editable.
-
Add one test bill, one payment row, and one allocation row per diner. For a four-person even split, use 25% for each person and confirm that both difference columns show
0.00.
Give Editor access only to people who need to enter information. After the group finishes updating the file, Viewer access is usually enough for the record. Commenter access can work for someone who needs to flag an issue without changing amounts.
To be honest, permissions are where a good sheet gets messy. Someone needs to edit, another person needs to see a receipt, somebody changes a name, and then a protected range suddenly feels like a very good idea. Set access before the first dinner, not after a disagreement.
Link sharing may be limited by account or organization settings. A receipt link also does not give someone access to the receipt automatically, so check the Drive file permissions separately.
If you plan to enter the bill at the table, set up and test offline access before dinner. Otherwise, take a phone photo and enter the information once the group is back online.
Store receipts and record settlements
Create a Drive folder for receipt images. Name each file with its Bill ID, upload a clear photo, and paste the file link into Expenses F. Google's Drive Help center covers current file-sharing controls.
Check the link with the same account a friend will use. A private receipt link is not useful to a Viewer who cannot open it.
The sheet tracks the agreement; it does not send money. Add an optional Settlements tab to record payments made after the meal.
| Column | Header |
|---|---|
| A | Date |
| B | From |
| C | To |
| D | Amount |
| E | Method |
| F | Status |
| G | Note |
Record cash, a bank transfer, or a payment-app transfer there without adding it as another expense. Duplicating a reimbursement in Expenses would make the dinner total too high. Mark the settlement as pending or settled, and keep the original bill and receipt unchanged.
Check these common mistakes
| Mistake | Fix |
|---|---|
| The full check is entered twice in Payments | Enter each person's actual contribution; the rows must equal the bill total |
| A name is spelled differently across tabs | Use a name dropdown and keep the Summary list as the source |
| Allocation percentages do not total 100% | Check every row with the same Bill ID |
| A formula was replaced with a dollar amount | Restore the formula, or document any intentional rounding override |
| A receipt opens for the owner but not friends | Update the Drive file or folder permissions |
| The group outgrows the formula ranges | Extend the ranges beyond row 1000 or 2000 |
| A settled bill is deleted | Keep the original expense and mark the settlement separately |
Edge cases worth deciding early
Someone paid but did not eat. Keep that person in Payments, but leave them out of Allocations for that bill. The Summary will show the amount they should receive.
A shared dish does not divide neatly. Agree on each person's dollar portion, add that portion to their other assigned items, and use the resulting subtotal to calculate the share. For an exact final-dollar rule, enter the agreed amount in D and explain the change in E.
Several New Orleans dinners use the same workbook. Add one Expenses row per check and never reuse a Bill ID. Payments and Allocations can then carry the same ID for each separate meal.
Start with one test bill now: add the check, enter the people who paid, add one allocation row per diner, and confirm both difference columns show 0.00. After that works, duplicate the structure for the next dinner.