Start a review and follow the costs back to Bookings or Expenses.
Suggested for your taskConnected records for everyday life
Travel Workbook
One trip. Costs, people and plans together.
Keep booking commitments, real payments and refunds separate. Divide a meal or booking among its actual participants, record a retained cancellation deposit and review what each person paid.
- Format
- Excel · .xlsx
- Inside
- 13 worksheets
- Included
- Clean file + example + guide
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
What is committed, still due and shared between us?
One person books the stay, another pays for dinner, and the packing list sits elsewhere. A trip total does not tell you what is still due or who should settle with whom. Keep bookings, other costs, people, local times and packing in distinct records with a shared review date.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Set up the trip before adding costs.
Suggested for your taskEnter the full booking once. Add every separate payment or refund in Payments.
Suggested for your taskKeep deposit, final balance and refunds attributable to their actual person and date.
Suggested for your taskRecord meals, entry fees or other costs outside Bookings.
Suggested for your taskReview each person's balance; positive means receive back.
Suggested for your taskSplit a cost among its actual participants; a blank Group ID means everyone.
Suggested for your taskFind conflicting plans. Split overnight activities at midnight.
Suggested for your taskKeep the essential items visible until packed.
Suggested for your taskUnderstand the separation of bookings and other expenses first.
Suggested for your taskRecord actual money transferred between people separately from shared trip expenses.
Suggested for your taskReview each person’s share and recorded settlements before agreeing what remains.
Suggested for your taskReview settlement links and warnings before relying on the close-out.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 13 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 13 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Follow one booking from deposit to group settlement.. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Start a review and follow the costs back to Bookings or Expenses.
- Settings: Set up the trip before adding costs.
- Bookings: Enter the full booking once. Add every separate payment or refund in Payments.
- Payments: Keep deposit, final balance and refunds attributable to their actual person and date.
- Expenses: Record meals, entry fees or other costs outside Bookings.
- People: Review each person's balance; positive means receive back.
- Groups: Split a cost among its actual participants; a blank Group ID means everyone.
- Itinerary: Find conflicting plans. Split overnight activities at midnight.
- Packing: Keep the essential items visible until packed.
- Start: Understand the separation of bookings and other expenses first.
- Settlements: Record actual money transferred between people separately from shared trip expenses.
- Trip Close-out: Review each person’s share and recorded settlements before agreeing what remains.
- Studio 5 Review: Review settlement links and warnings before relying on the close-out.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. travel-workbook-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. travel-workbook-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Follow one booking from deposit to group settlement.
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Open the booking
Find HOTEL in Bookings. The full cost is a commitment; its deposit belongs in Payments.
Read what is unpaid
Compare booking cost and actual payments at the review date. Keep separate non-booking expenses in Expenses.
Settle actual shared cash
Open People. Review only shared amounts actually paid and the selected group; agree rounding before settling outside the workbook.
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 13 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Dashboard
Start a review and follow the costs back to Bookings or Expenses.
- You enter
- Review date, trip settings and records in other sheets
- Calculated or supplied reference
- Commitments, outstanding booking balances, non-booking costs, budget remaining, shared paid cash and warnings
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Settings
Set up the trip before adding costs.
- You enter
- Trip name, base currency, dates, review date and budget
- Calculated or supplied reference
- Date/budget checks and the period used by records
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Bookings
Enter the full booking once. Add every separate payment or refund in Payments.
- You enter
- 50 shared bookings: full original cost, manual rate, notes, balance due and status; optional Group ID
- Calculated or supplied reference
- Commitment, net paid, payment-entry count, outstanding balance, planned net and input checks; cancelled bookings retain only actual net payments
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Payments
Keep deposit, final balance and refunds attributable to their actual person and date.
- You enter
- 200 entries: ID, date, Booking ID, Person ID, Payment/Refund, positive base-currency amount and note
- Calculated or supplied reference
- Signed actual and planned amounts, booking/payer checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Expenses
Record meals, entry fees or other costs outside Bookings.
- You enter
- 300 non-booking costs: date, original currency/amount, rate, payer and Shared Yes/No; optional Group ID for shared costs
- Calculated or supplied reference
- Converted actual amount, shared amount and future/input checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
People
Read the allocated share across selected groups after correcting warnings.
- You enter
- 12 unique person IDs and names
- Calculated or supplied reference
- Cash actually paid, allocated share across groups and receive/pay balance
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Groups
Split a cost among its actual participants; a blank Group ID means everyone.
- You enter
- 20 groups with up to 12 unique participant IDs each
- Calculated or supplied reference
- Members, shared cash and each participant's allocated share
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Itinerary
Find conflicting plans. Split overnight activities at midnight.
- You enter
- 60 items: date, local start/end time, place, zone label, plan and status
- Calculated or supplied reference
- Same-day/same-zone overlap counts and date/time checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Packing
Keep the essential items visible until packed.
- You enter
- 120 items: person, bag, required, packed and whole quantity
- Calculated or supplied reference
- Identifier, person, status and quantity checks; dashboard required-not-packed count
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Start
Understand the separation of bookings and other expenses first.
- You enter
- No routine input
- Calculated or supplied reference
- Six-step setup, review and settlement guide
Actual example worksheet · Preview range A1:G14. Image only; entries are made in your downloaded workbook.
Settlements
Record actual money transferred between people separately from shared trip expenses.
- You enter
- 200 records in blue cells
- Calculated or supplied reference
- Linked input checks and explicitly labelled review values
Actual example worksheet · Preview range A1:F19. Image only; entries are made in your downloaded workbook.
Trip Close-out
Review each person’s share and recorded settlements before agreeing what remains.
- You enter
- Review only
- Calculated or supplied reference
- Linked input checks and explicitly labelled review values
Actual example worksheet · Preview range A1:E31. Image only; entries are made in your downloaded workbook.
Studio 5 Review
Review settlement links and warnings before relying on the close-out.
- You enter
- Review only
- Calculated or supplied reference
- Linked input checks and explicitly labelled review values
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
Fictional example from the included workbook
The hotel commitment of 600 plus non-booking expenses of 92 and 208 totals 900 against a 1,200 budget, leaving 300. The deposit plus other costs actually paid totals 450: 150 each for three people. Jo has paid 150, Sam 92 and Lee 208, so Sam pays in 58 and Lee receives 58. The hotel still has 450 outstanding. The rate is a fictional manual input, not a current exchange rate. Settlement concerns paid shared cash; it does not split unpaid future commitments.
- Trip budget
- EUR 1,200
- Hotel full cost / deposit
- EUR 600 / 150
- USD expense × entered rate
- 100 × 0.92 = EUR 92
- Other EUR expense
- EUR 208
- People
- Jo, Sam and Lee
- Committed plus expenses
- EUR 900
- Budget remaining
- EUR 300
- Shared cash paid / equal share
- EUR 450 / 150 each
- Jo / Sam / Lee settlement
- EUR 0 / −58 / +58
Try the calculation
Convert a cost, then split it equally.
Change the fictional inputs below and compare the result. Nothing is submitted or saved.
Choose Calculate example to see the result.
A small browser demonstration of selected calculation rules. It does not open or edit the downloadable workbook. The kit contains the full records and planning views.
From setup to a regular review
How you use it.
Open the 5-step setup and review routineInputs, calculations and the decision each step supports
- 01
Set the trip and the people
You enterEnter dates, budget, currency and review date; add each person with a unique ID.
CalculatedThe workbook validates settings and person IDs; blank Group ID costs use everyone.
Your next stepKeep identifiers consistent across costs and packing.
- 02
Record commitments and payments once
You enterBookings holds the full cost and rate. Payments holds each payment or refund with its own payer/date. Expenses holds costs outside bookings.
CalculatedBooking totals join the ledger by exact ID. Future ledger entries stay planned. Net paid and outstanding balances remain distinct from full commitments.
Your next stepPay a deposit now and a balance later, with different people, without overwriting earlier payments.
- 03
Read the shared-cost balance
You enterMark each non-booking expense Shared Yes or No. Add a Group ID for its participants; blank means everyone.
CalculatedShared paid cash is split equally; paid amount minus equal share gives each balance.
Your next stepPositive means receive back; negative means pay in. Agree settlement outside the file.
- 04
Check times and what to take
You enterEnter each item’s local date, start/end times and zone label in Itinerary. Split overnight items at midnight; each row covers one day. Add packing items, person IDs and bag notes in Packing.
CalculatedItinerary flags overlapping activities and invalid times; Packing counts the items still to pack for each person. Times are not converted between zones.
Your next stepChange a conflicting plan or pack the missing item before the trip.
- 05
Close the trip without counting a transfer twice.
You enterRecord actual transfers between travellers and see each balance after settlement. Transfers do not change the expense ledger, booking payments or trip cost.
CalculatedNew views include inherited and new input warnings before showing dependent totals.
Your next stepKeep planned choices separate from actual records.
13 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
DashboardOpen sheet details
Editable inputs
- Review date, trip settings and records in other sheets
Calculated or reference
- Commitments, outstanding booking balances, non-booking costs, budget remaining, shared paid cash and warnings
Start a review and follow the costs back to Bookings or Expenses.
Inspect the actual Dashboard sheetSettingsOpen sheet details
Editable inputs
- Trip name, base currency, dates, review date and budget
Calculated or reference
- Date/budget checks and the period used by records
Set up the trip before adding costs.
Inspect the actual Settings sheetBookingsOpen sheet details
Editable inputs
- 50 shared bookings: full original cost, manual rate, notes, balance due and status; optional Group ID
Calculated or reference
- Commitment, net paid, payment-entry count, outstanding balance, planned net and input checks; cancelled bookings retain only actual net payments
Enter the full booking once. Add every separate payment or refund in Payments.
Inspect the actual Bookings sheetPaymentsOpen sheet details
Editable inputs
- 200 entries: ID, date, Booking ID, Person ID, Payment/Refund, positive base-currency amount and note
Calculated or reference
- Signed actual and planned amounts, booking/payer checks
Keep deposit, final balance and refunds attributable to their actual person and date.
Inspect the actual Payments sheetExpensesOpen sheet details
Editable inputs
- 300 non-booking costs: date, original currency/amount, rate, payer and Shared Yes/No; optional Group ID for shared costs
Calculated or reference
- Converted actual amount, shared amount and future/input checks
Record meals, entry fees or other costs outside Bookings.
Inspect the actual Expenses sheetPeopleOpen sheet details
Editable inputs
- 12 unique person IDs and names
Calculated or reference
- Cash actually paid, allocated share across groups and receive/pay balance
Review each person's balance; positive means receive back.
Inspect the actual People sheetGroupsOpen sheet details
Editable inputs
- 20 groups with up to 12 unique participant IDs each
Calculated or reference
- Members, shared cash and each participant's allocated share
Split a cost among its actual participants; a blank Group ID means everyone.
Inspect the actual Groups sheetItineraryOpen sheet details
Editable inputs
- 60 items: date, local start/end time, place, zone label, plan and status
Calculated or reference
- Same-day/same-zone overlap counts and date/time checks
Find conflicting plans. Split overnight activities at midnight.
Inspect the actual Itinerary sheetPackingOpen sheet details
Editable inputs
- 120 items: person, bag, required, packed and whole quantity
Calculated or reference
- Identifier, person, status and quantity checks; dashboard required-not-packed count
Keep the essential items visible until packed.
Inspect the actual Packing sheetStartOpen sheet details
Editable inputs
- No routine input
Calculated or reference
- Six-step setup, review and settlement guide
Understand the separation of bookings and other expenses first.
Inspect the actual Start sheetSettlementsOpen sheet details
Editable inputs
- 200 records in blue cells
Calculated or reference
- Linked input checks and explicitly labelled review values
Record actual money transferred between people separately from shared trip expenses.
Inspect the actual Settlements sheetTrip Close-outOpen sheet details
Editable inputs
- Review only
Calculated or reference
- Linked input checks and explicitly labelled review values
Review each person’s share and recorded settlements before agreeing what remains.
Inspect the actual Trip Close-out sheetStudio 5 ReviewOpen sheet details
Editable inputs
- Review only
Calculated or reference
- Linked input checks and explicitly labelled review values
Review settlement links and warnings before relying on the close-out.
Inspect the actual Studio 5 Review sheetCompare with a manual starting pointWhat the connected workbook adds
| What is included | Free browser tools | Travel Workbook 2.3 |
|---|---|---|
| Records | Small manual planning sheets in this browser | 13 connected XLSX sheets, fixed capacities stated above |
| Calculations | A small separate calculator where stated | Linked records, review-date totals, input checks and chart |
| Storage | Local browser draft and JSON backup | Your own clean workbook and separate worked example |
| Included files | No paid workbook | Two XLSX files and one START_HERE.pdf guide with practical limits and license |
Files, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
travel-workbook-clean.xlsx
13 connected sheets; blank records for your own use.
travel-workbook-example.xlsx
The same workbook with the fictional records and expected results shown above.
START_HERE.pdf
Your single guide to setup, the first useful task, file recovery, practical limits and license.
English labels and guides. Dates show month names. Keep a copy and backups.
Before you choose
Fit and practical limits.
- Friends organising a shared weekend away.
- A household keeping bookings, meals, activities and packing together.
Understand the boundaries.
- No bookings, live exchange rates, bank connection, payments, maps, reminders or calendar sync.
- All booking records are shared. Non-booking costs can be marked personal and excluded from settlement.
- Times are local with a zone label; no time-zone conversion. Split overnight activities at midnight.
- Fixed capacities. Resolve warnings before reading totals; rounding at settlement can require an agreed adjustment.
- Equal split within each selected group; no weighted shares or automatic bank settlement.
- Cancelled bookings retain actual net payments. Record only actual refunds; resolve future-dated cancellation entries before relying on totals.
Desktop spreadsheet software is required and not included. Native Excel, Google Sheets and Numbers compatibility remains unverified in this private preview.
Travel Workbook / Version 2.3
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$4.90USD · One-time purchaseTaxes included where applicable.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Digital download. Review availability and the final total in your cart.
Questions about this workbook
The details that affect your choice.
Are currency rates live?
No. Enter base-currency-per-original-unit rates yourself. A cost of 100 at a rate of 0.92 becomes 92 in base currency.
Can a booking be personal?
Bookings are shared in this version. Expenses has a Shared choice for personal non-booking costs. Use separate trip copies if that model does not fit.
Does everyone split every cost equally?
Choose a Group ID for a booking or shared expense. It splits equally between that group's members; blank means everyone. Up to 20 groups, each containing up to 12 unique person IDs. Weighted shares are not supplied.
How do I record a deposit, balance and refund?
Add separate Payments rows with the same Booking ID, their own date, Person ID and positive amount. Choose Payment or Refund. The booking shows the net paid and outstanding balance. Never duplicate the full booking or enter its payment again in Expenses.
Does the itinerary convert time zones?
No. It detects overlap only between records with the same date and zone label. Enter local start/end times and split overnight activities at midnight.