TL;DR: In TallyWay, open the group, open its export screen, choose Excel or PDF, and save or share the generated file. Excel preserves the ledger across multiple sheets; PDF creates a stable trip summary. Before sending either one, check payers, participant shares, currencies, repayments, and balances. Download TallyWay on the App Store to start a free ledger with no daily expense limit.
How to export in TallyWay in about 60 seconds
- Open the group whose expenses you want to export.
- Open the group's export screen.
- Choose Excel for a structured multi-sheet workbook or PDF for a stable trip summary.
- Save or share the generated file using the device flow.
- Open the file once before sending it and confirm the group, travelers, currencies, and balances are the ones you expected.
That is the quick task. The rest of this guide explains how to reconcile the ledger first so the export becomes a useful group record, reimbursement record, or expense report—not merely a file. If a recipient specifically requires CSV, confirm that before the trip; TallyWay's structured spreadsheet export is an Excel workbook.
An expense export is most useful when it answers the questions that appear at the end of a group trip: What did we spend? Who paid? Which travelers shared each cost? Which currency was used? What has already been repaid? And what still needs to happen?
The export button cannot fix a ledger that nobody reviewed. The reliable sequence is reconcile first, export second, settle last. That turns a collection of entries into a trip expense export the group can follow without asking the organizer to explain every row.
Closeout rule: preserve the source amount and currency, make every payer and participant visible, and confirm that recorded payments are separate from expenses before sharing a final file.
Getting the most from your trip expense export
| Stage | What the organizer checks | What the group receives |
|---|---|---|
| Reconcile | Receipts, dates, payers, participants, split rules, currencies, refunds | A ledger with explainable inputs |
| Export | File format, balances, payment history, settlement plan | An Excel workbook or PDF summary |
| Settle | Final transfers and recorded repayments | A closed record with no unexplained balance |
Do not collapse these stages. A polished PDF can still contain the wrong participants. A correct spreadsheet can still look unfinished if repayments were made but never recorded.
Step 1: Freeze new entries long enough to review
Pick a review point after the final shared purchase has been entered. Tell the group that you are preparing the closeout and ask everyone to submit missing expenses or corrections by a specific time.
This does not mean the ledger can never change again. It creates a stable version to inspect. If someone adds a forgotten train ticket while another person is checking balances, both people are reviewing different totals.
Start with four counts:
- the number of expenses;
- the number of recorded repayments;
- the number of travelers represented in the ledger;
- the currencies used.
Those counts make omissions easier to spot before you begin checking individual rows.
Step 2: Reconcile every expense to its source
Work through the ledger in date order and compare each material expense with its receipt, booking confirmation, or card record. The goal is not to create an accounting archive for every coffee. It is to make each shared charge traceable enough that another traveler can understand it.
For each expense, verify:
- a recognizable title and purchase date;
- the original amount and original currency;
- the person or people who paid;
- only the travelers who participated;
- the split method and resulting shares;
- any note needed to explain an exception;
- whether the row is an expense, refund, or repayment.
A vague row named “tickets” is hard to review. “Airport train to city — arrival day” gives the group a useful cue without exposing unnecessary personal information.
If the trip used more than one currency, do not replace every original amount with a home-currency total. Keep the source currency attached to each expense and use one stated home currency for summaries and balances. The multi-currency expense guide explains how to preserve the rate evidence behind those conversions.
Step 3: Check the math by role, not only by total
A ledger can add up overall while assigning the wrong share to one traveler. Review it from three perspectives:
| View | Question to answer | Common problem it reveals |
|---|---|---|
| Expense view | Does each row equal the amount paid? | Missing participant or rounding difference |
| Person view | Does each traveler's paid amount and share make sense? | Wrong payer or someone included after leaving |
| Group view | Do balances and proposed transfers reconcile? | Repayment entered as an expense or omitted payment |
Pay special attention to accommodation, rental cars, shared meals, and activities with different participation. Equal splitting is appropriate only when equal participation matches the group's agreement. For alternatives such as nights, exact amounts, shares, or itemized meals, use the fair group-trip splitting guide.
Illustrative check: imagine four travelers recorded costs in EUR, GBP, and JPY, but one traveler left before the final activity. The detailed expense sheet preserves each source currency and participant list. The per-person matrix then puts paid amounts and shares side by side, making it easier to notice if the early-departing traveler was accidentally included in that activity. This is a hypothetical review pattern, not customer data.
Step 4: Record repayments separately
A repayment does not reduce the cost of the trip. It changes who owes whom. Keep it separate from the expense that created the balance.
Suppose one traveler pays the full lodging bill and another later sends them money. The lodging remains a lodging expense. The transfer is a payment between members. If you replace the original expense amount with a smaller number, the category total, payer history, and remaining balances all become harder to explain.
Before exporting, compare recorded repayments with the payment confirmations available to the group. Mark only transfers that actually happened. A suggested settlement is a plan, not evidence of payment.