An NRI's month has two kinds of spikes that look alike in a total: weekend spending where you live, and festival money sent to family in India. Keep them apart by tagging every row as weekend or weekday by its date, and tagging remittances as their own category. Then compare spend per day, not the month total, and the real pattern appears.
Why do an NRI's weekend spikes hide so well?
Most NRIs earn in one currency on a fixed payday, pay rent early in the month, and then send money to India around the same time. By the 10th, the big lumps are already out. What is left looks like ordinary spending, so a Saturday dinner for six or a long-weekend trip blends into the groceries. The festival side is worse: a Raksha Bandhan gift, a Diwali top-up for your parents, or a Pongal shopping transfer lands in the same account as your own bills.
The fix is to ask two separate questions. First, how much do I spend on a weekend day compared with a weekday, in the currency I earn? Second, how much leaves for India in a festival month compared with a normal one?
How do you tag weekends and remittances?
- Put every transaction in one list with its date, its amount in the currency you spent in, and a category.
- Add a column called Day type. In Excel or Google Sheets, with the date in column A, use =IF(WEEKDAY(A2,2)>5,"Weekend","Weekday") and fill it down. WEEKDAY with 2 as the second argument numbers Monday as 1 and Sunday as 7, so 6 and 7 are Saturday and Sunday.
- Create a category called Family remittance and a second called Festival gifts. Keep both out of your own spending totals.
- Total each Day type with =SUMIFS($C$2:$C$500,$D$2:$D$500,"Weekend") and the same with "Weekday".
- Divide each total by the number of such days in that month.
If your weekend falls on different days because of shift work, change the test to match, for example WEEKDAY(A2,2)>4 for Friday to Sunday.
A worked example with made-up numbers
Say you live abroad and spend in dollars. In a 30-day month there are 8 weekend days and 22 weekdays. Your own spending, excluding rent and remittances, comes to $640 on weekend days and $660 on weekdays.
| Day type | Days | Total spent | Spend per day |
|---|---|---|---|
| Weekend | 8 | $640 | $80 |
| Weekday | 22 | $660 | $30 |
| Whole month | 30 | $1,300 | about $43 |
The month total of $1,300 says nothing unusual. The per-day column says a weekend day costs about 2.7 times a weekday ($80 divided by $30). Nearly half the spending, $640 out of $1,300, sits on just 8 days. That is the spike.
What about the festival months?
Take your remittance category and list it month by month. Say a normal month sends $250 home, and the month before Diwali sends $650, made of the usual $250 plus $400 of gifts and a family top-up. The extra $400 is not a leak. It is a planned cost that arrives yearly, so put it in a sinking fund: $400 divided by 12 months is about $33 set aside each month, or whatever your own figure works out to.
- Mark festival dates for your family in your calendar at the start of the year.
- Note the rate or amount actually received in rupees if your family cares about the rupee figure, since the rate changes between transfers.
- Keep the transfer receipt with the entry so you can answer a question later without searching chat history.
How do you read the result without guilt?
A weekend spike is not a failure. For many NRIs the weekend is the only time they eat out, meet friends or call home at a sensible hour. The point of the number is to choose it on purpose. If a weekend day costs $80 and you are happy with that, nothing needs fixing. If you set a goal, such as a larger remittance before the festival season, you can see how many weekend outings it would take to fund it.
When a sheet stops being enough
Tagging by hand works for a few months. It gets tiring when you hold accounts in two countries and add receipts, remittances and card spends together. SpendixAI lets you upload bank and card statements as PDF, CSV or Excel, review the rows before saving, and add cash spends by hand. Its insights highlight patterns across the period, and each expense can carry its own currency with totals in a base currency, which you choose before importing because it cannot be changed once transactions exist.
Your three-step check this month
- Tag every row as weekday or weekend and rank the Day type totals per day.
- Pull remittances into their own category and compare this month with the last three.
- Write down one number you will watch, for example the weekend per-day figure, and look at it again next month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


