Festival spending in an Indian household rarely arrives as one neat payment. A sari, a train berth, a box of mithai, and a transfer to parents can hit four UPI apps between Friday night and Sunday afternoon. If you only open a bank app on the 30th, the salary is already spoken for and the only choice left is guilt. An Expense tracker that copies bank and UPI SMS into your own Google Sheet shows the spike while you can still skip the second outfit. Kharch Log does that on Android from the alerts the bank already sent your phone. You do not type a netbanking password. The rows stay in a Sheet you control.
Write three caps before the first gift UPI
Write a gift cap, a travel cap, and a food cap on the month tab before the first festival UPI goes out. The gift cap is one number for the whole family, including the cousin you remember on Sunday night, not a fresh limit every time someone calls. Travel includes the train or bus fare plus the auto from the station, because the ticket alone is how people fool themselves. Food includes mithai, the restaurant after the visit, and the late snack order that never feels like a meal. When a new SMS lands in the Sheet, compare the amount with the cap already written down.
Keep those caps in a cell above the transactions, or in the first row of a note column, so you are not hunting through chat messages. If gifts cross the cap by Wednesday, the next decision is a smaller sweet box, not another kurta. Clothes bought for yourself belong in a clothes line, not inside gifts, or you will not know which promise to shrink. Kharch Log can file the SMS with a category you correct once. After that, similar payee names are easier to spot in the same Sheet. Do this before Dussehra, Diwali, Eid, or Onam, whenever your own cluster of spends actually starts.
- One gift cap for the whole family, not a new cap per person you remember late
- Travel means ticket plus local auto, cab, and the snack on the platform
- Food means sweets and eating out, which hide if you only watch groceries
- Clothes you buy for yourself stay out of the gift line
What the bank SMS will show that week
Bank and UPI alerts usually catch IRCTC, Amazon, Meesho, a clothing store QR, and transfers that leave the account. They also catch Swiggy or a restaurant if you pay from the same phone. Read the payee text the bank actually sent, not the name you wish the shop had used. A truncated merchant string is still useful if you paste a plain note the same day: Diwali gift, silk, for Meera. Kharch Log keeps that SMS draft in your Google Sheet, so you are not exporting three app histories and hoping the dates line up.
Ignore the UPI app insight screen as your only record. PhonePe, Google Pay, and your bank app each show a slice, and a transfer to your own other account can look like spending in one of them. The Sheet should hold the debit once. If two SMS arrive for one payment, keep the bank debit and mark the duplicate so the total does not double. Lifetime unlock for Kharch Log is ₹149 once, paid by you, not a festival offer from a bank. Nothing here requires the bank to partner with the app. The SMS was already on your phone.
Cash, gold schemes, and rows the SMS will miss
Cash handed to a relative at the station never sends an SMS. A gold scheme paid in notes at the counter will not appear either. Those amounts still belong in the Expense tracker, or the festival will look cheaper than it was and you will repeat it. Add the row the same evening with the person or shop name you would recognise in January. Use the same categories as the UPI rows so the cap math still works. If you mix cash gifts into a vague misc line, the Saturday check becomes useless. A short note is enough. You do not need a photo of every bill.
If someone will repay you for a group train ticket, mark that row as repayable the day you book it. Leave it unmarked and the Sheet will tell you the festival cost more than your real share, and next year you will cut the wrong thing. When the repayment UPI arrives, link it in the note with the original date and amount. Do not treat that incoming credit as income you can spend on another outfit. Kharch Log is still only reading your SMS and the manual rows you add. Shared family cash is on you to type. That is normal, and it is still one ledger.
- Add station cash and counter payments the same evening
- Use a payee name you will understand next January
- Mark group bookings you expect to be repaid
- Do not spend an incoming repayment on a new gift
A ten minute Saturday pass
On Saturday, filter the Sheet to the festival dates only. Sort by amount descending and read the top eight rows out loud. If gifts already crossed the written cap, stop new clothing orders the same day, including the ones sitting in a cart. If travel is over, the remaining visits are bus or a shared cab, not another last-minute ticket. This pass works only if Friday cash was typed. A perfect category system with missing rows is a diary of the UPI half of your life. Ten minutes is the point. A long cleanup on the 30th will not bring the money back.
After the festival week, write the three actual totals next to the caps you set. That pair of numbers is what you open next year, not a camera roll of bills. If one category was wildly over, change next year's cap or change the plan, but do not average it away into a yearly mush. The Expense tracker is useful here because the rows are already dated in your Google Sheet. You can filter October without rebuilding a budget from screenshots. Kharch Log does not need a new Sheet for one week. A category and a note are enough to see the spike.
Questions people actually ask
Should money sent to parents during the festival count as a gift expense? Yes, if it left your account and is not coming back. Put it in a family category so it does not sit beside your own clothes and make the outfit budget look worse than it was. If the transfer was a group booking they will return, mark the row repayable the same day. A name in the note is enough to tell a gift from a loan.
Do I need a new Google Sheet just for the festival? No. A new Sheet splits the SMS feed and you stop trusting either tab. Stay in the month Sheet you already use, add a category or a short note, and filter those dates when you want the festival view. Caps can live in a cell at the top. Kharch Log keeps writing new bank SMS into that same Sheet, which is what makes the Saturday check fast.
What if I only notice the damage after Diwali week? Still record the real totals before you forget which payments were gifts. The money is gone, but the split between clothes, travel, food, and family is the input for the next festival. Sort the dates, fix duplicates, add cash you remember, and write the three numbers down. Next time, set the caps on the first day, not after the last UPI.
When the week ends, write the gift, travel, and food totals beside the caps on the month tab. That pair is the number to beat next year, not a feeling that you were careful. Small UPI rows are easy to skip when the big gifts dominate, which is why the small UPI payments guide is worth a pass. The Kharch Log features page shows how bank SMS lands in your own Sheet.