People remember the ticket and forget the rest of the trip. A train or flight payment is only the start. A hotel, a cab, a toll, and meals away from home follow it. Each SMS is real and none of them is the whole cost. Without a shared note, you cannot say what the weekend cost. Those alerts can sit in your Google Sheet. Kharch Log files them without a bank login. Put one trip name on every related row, then sum that name. That total is the trip.
Keep every SMS, glue them with one name
Do not collapse the trip into one giant row. Keep each SMS as its own row and add the same trip name and dates in the note. A filter on that name is the sum. Separate rows show whether the stay or the cabs blew the plan. Write the sum in the header when you are back. Meals can stay in food if the trip name is on them too. Leave them out of the filter and the trip looks cheap while the food month looks worse.
If a friend paid the hotel and you UPI your share, that UPI is travel, not a vague friend transfer. Put the trip name on it. If you paid for everyone, log the full SMS as travel. Their repayments are transfers matched to the trip, not income. Your cost is the net. A repayment labelled income makes the trip feel cheaper than it was. Say in the note whether you paid the group or only your share.
- One trip name on ticket, stay, cabs, tolls, and meals
- Do not merge those SMS into a single blob
- Your share sent to a friend is travel, not a generic transfer
- Group repayments are transfers, and your cost is the net
The ticket price is the part you brag about
Add station food, cab, and extra fees to the trip even when each looks small. They are why the ticket price you quote is incomplete. A leisure toll is travel, not your office commute. Change the category or the commute month absorbs the holiday. Do not invent discounts that never hit the bank as negative spend. A cash auto you type by hand still belongs on the trip name. That is often the cost people drop first.
On a cancellation, the fee you did not get back is the travel cost. Match the refunded fare so it is not also a loss. A rebooked ticket is a new row with the same trip name. Do not overwrite the old price. You want the charge to stay visible. A separate insurance debit can carry the trip name and still be insurance. One trip may use several categories. The shared name is what lets you sum them.
Mark rows in the evening, not at the airport home
Each evening, add the trip name to that day's rows. Waiting until you are home means the small rows get misfiled. A hotel payee is often a person, and it will look like a friend transfer without a note. Food can keep both the food category and the trip name. A meal at home the night before is not the trip. Four words in the note are the whole method. The SMS is already captured.
You can log trip cash as one bundle if you will not note every snack. Say so in the note, and do not also itemise those snacks. If you withdraw again, add a new bundle row rather than editing the first. Leftover notes deposited back are not income. If the withdrawal was already a transfer to cash, unspent notes are simply spends you do not type. If you counted the withdrawal as the spend, the deposit reduces the trip. Know which cash method you are using before you leave.
- Add the trip name the same evening
- Hotel QR names need that note or they look like friend transfers
- Home meals before departure stay off the trip
- Trip cash is either itemised or one bundle, not both
Write the all-in number when you return
When you return, filter the trip name and split the sum into ticket, stay, local travel, food, and other. Write that sum in the header. Compare it with what you expected. Do not delete meals to force the old expectation. Next time, plan from this sum, not from the ticket screenshot. Use the net after friend repayments. If someone still owes you, say outstanding in the header and update the net when they pay.
Keep the rows in the main Sheet. A second file will miss later SMS. The trip name is enough to reopen the weekend. If the trip crosses two months, filter the name across dates instead of forcing one month. The monthly view can mention that a travel chunk was this trip. The SMS date may be the booking day, not the day you travelled. Put both dates in the note when they differ. A September booking for an October trip moves the cost unless the note says so.
Questions people actually ask
Do trip meals also use my normal food cap? Put trip meals in the trip sum first. Say whether they also use the monthly food cap. Many people keep them out of the weekly food cap so home habits are judged fairly. Write that choice before you leave. Do not decide afterward just to make the food month look calm. The rows stay. Only the cap rule changes.
I paid partly with reward points. What number do I keep? The cost is the SMS amount that left your account. If points lowered the debit, the lower figure is already the truth. Do not add the price from before the points. A fee you paid to buy points is its own row if there was an SMS. A trip that looks small because of points is showing real cash. That smaller number is what you gave up.
Work will repay part of the train fare. When do I log it? Log the full ticket when you pay, and mark the part you expect back. When the credit arrives, match it and clear only that part. Your cost is the remainder plus anything the office will not pay. Do not leave the ticket unlabelled while you wait. A pending claim is not the same as zero cost.
Give every ticket, hotel, cab, and meal the same trip name, then sum that filter when you are back. Weekly reviews still matter for the rest of the month, as in a twenty minute weekly review. The Kharch Log features page covers how the underlying SMS reaches your Sheet. Keep the all-in total, not the ticket screenshot.