Apple Numbers can work well for a simple shared-expense log: record who paid, keep the file offline on your device, and share it through iCloud when you want others to view or edit it. For formula steps, use the standard table workflow described in Apple's Numbers guide.

This setup is best for roommates, travel groups, couples, or any small group that wants a clean record of shared spending and a basic way to calculate reimbursements at the end of a trip or month.

Setting Up the Main Expense Table

Start with one main table for every shared purchase. Keep the columns simple so the sheet stays easy to scan and update.

Date Description Paid By Amount Category Split Type
When the expense happened What the expense was for Who covered it Total cost Food, gas, lodging, supplies, etc. Equal, Percentage, Fixed

A few practical notes:

  • Date helps you sort expenses in order and spot missing entries.
  • Description should be short but specific enough to recognize the receipt later.
  • Paid By should use the same names every time so totals are easier to calculate.
  • Amount should hold the full expense amount, not each person's share.
  • Category makes it easier to review spending later by type.
  • Split Type tells you how the group wants to divide that line item.

If your group uses only one split rule, you can still keep the Split Type column. It makes the sheet easier to audit later if one charge is handled differently.

Calculating Totals per Person

To total spending for each person, use SUMIF in a summary area or a separate table.

Apple's Numbers guide explains the basic workflow for adding formulas in tables: select the cells or range you want, then use the formula tools in the toolbar and enter the formula. You can also drag to select a range across rows and columns when you are building totals.

A simple pattern looks like this:

  • Pick one cell for a person's total paid.
  • Use SUMIF to add only the rows where Paid By matches that person's name.
  • Use the Amount column as the sum range.

Example structure:

  • Criteria range: the Paid By column
  • Criteria: one person's name
  • Sum range: the Amount column

If you need to edit a formula, Apple notes that you can remove cell references in the Formula Editor by selecting them and pressing Delete.

You do not need complicated logic to make this useful. Even a basic person-by-person total helps the group see who covered more of the shared costs.

Building a Settlement Summary

Create a second table called Settlement Summary. This keeps the main log clean and puts the reimbursement math in one place.

A simple summary table can include:

  • Name
  • Total Paid
  • Total Owed
  • Net Balance

Use the names from your group in the first column.

For each person:

  • Total Paid = the amount they covered from the main expense table
  • Total Owed = that person's share of the shared expenses
  • Net Balance = Total Paid minus Total Owed

That last column is the key number. If the result is positive, the person paid more than their share. If it is negative, they owe the group. If it is zero, they are settled.

If your group uses different split types, keep the math simple and document your rule in the sheet notes or beside the table. The goal is not to make Numbers guess the split for you. The goal is to keep the record clear enough that the group can settle manually with confidence.

Sharing the Spreadsheet

If you want other people to update the sheet, use Numbers' Share feature with iCloud.

A practical workflow:

  1. Save the file in iCloud Drive.
  2. Click Share in Numbers.
  3. Invite the people who need access.
  4. Decide whether they can edit or only view.

Use sharing when multiple people are adding expenses during a trip or month. If only one person is updating the log, you can still keep the file private and send periodic copies instead.

This is a collaboration convenience, not a payment system. The spreadsheet records what happened; it does not move money for you.

Attaching Receipts

Receipts matter when you want the log to match the source documents. Two simple options are:

  • Link each receipt to the matching row in the table
  • Use the Insert from iPhone/iPad camera feature to capture a receipt image

If you store receipt images in a folder, keep the file names close to the row description so they are easy to find later. If you attach them directly, keep the attachment method consistent across the sheet so each line item is easy to verify.

A clean receipt habit saves time at settlement. When someone questions a charge, you can find the row and the receipt without rebuilding the history from memory.

Quick Setup Checklist

  • Create one main expense table with the six columns above.
  • Keep names and categories consistent.
  • Use SUMIF to total each person's paid amount.
  • Add a second Settlement Summary table for net balances.
  • Share the file through iCloud only if other people need to edit it.
  • Attach receipts or insert receipt photos so each row is easy to verify.

A simple way to keep the sheet tidy

  • Enter expenses as they happen instead of waiting until the end.
  • Use the same spelling for every person's name.
  • Keep one row per expense.
  • Review the settlement table before anyone sends reimbursement requests.
  • Export or copy the file after the trip or month so you have a record.

If you want the tracker to stay useful, keep it boring and consistent. A shared-expense sheet works best when everyone can understand it quickly and trust what each row means.