A round-up saving works by rounding each spend up to the next ten rupees and treating the difference as spare change to set aside. In a sheet, =CEILING(D2,10)-D2 gives the round-up for one spend, and a SUM or SUMIFS adds the month. It works the same in Excel and Google Sheets.
What is the formula?
Say the spend amount is in D2. In E2 enter:
- =CEILING(D2,10)-D2
CEILING takes the number and the multiple you want to round up to. If D2 is ₹247.50, CEILING gives 250, and the round-up is ₹2.50. If D2 is ₹83, CEILING gives 90, and the round-up is ₹7. Change the 10 to 50 or 100 if you want bigger steps.
What about amounts that are already round?
CEILING leaves them alone, so ₹1,260 gives a round-up of 0. Some round-up apps always add up to the next step, charging 10 for a ₹250 spend. If you prefer that, use =FLOOR(D2,10)+10-D2 instead. For a spend of 250 it returns 10, and for 247.50 it returns 2.50, so the two formulas agree except on exact multiples. Choose one rule and keep it.
| Spend (₹) | Rounded up to (₹) | Round-up (₹) |
|---|---|---|
| 247.50 | 250 | 2.50 |
| 83 | 90 | 7 |
| 1,260 | 1,260 | 0 |
| 40 | 40 | 0 |
| 399 | 400 | 1 |
| Total | - | 10.50 |
The total checks out: 2.50 plus 7 plus 0 plus 0 plus 1 is 10.50.
How do I total the round-ups for a month?
If dates are in column A and round-ups in column E, use SUMIFS with month boundaries:
- =SUMIFS($E$2:$E$1000,$A$2:$A$1000,">="&H1,$A$2:$A$1000,"<"&EDATE(H1,1))
H1 holds the first of the month, such as 01-Nov-2026. Round the result to avoid floating-point oddities: wrap it in ROUND(...,2).
Which transactions should count?
- Only debits, meaning real spends. Refunds and incoming money give odd results, so leave them out with =IF(D2>0,CEILING(D2,10)-D2,0).
- Decide whether bill payments and rent count. A ₹18,000 rent payment is already round, but a ₹1,847 electricity bill gives ₹3, which is fine.
- If you include everything, the total grows with the number of payments rather than with the size of your spending.
How much could this add up to?
This is arithmetic, not a forecast. Say you make 60 spends a month and the round-ups average ₹4.50 each. That is 60 times 4.50, which is ₹270 a month, or ₹3,240 over twelve months. Your actual figure depends entirely on your spending pattern, and the point is the habit, not the sum.
UPI payments often carry paise, and the formula handles them: CEILING(83.47,10) is 90, so the round-up is 6.53. Wrap it as =ROUND(CEILING(D2,10)-D2,2) to keep clean two-decimal values. And if ten rupees feels coarse, try 5 or 1 as the second argument. A smaller step saves less per spend, but it adds up more evenly and suits small payments better.
Fuel stations and some card payments can show a pre-authorised amount first and a final amount later. Use the final figure from your statement, not the one from the first notification, or the round-up will be off. Where the money goes afterwards is your own decision; a separate savings account or a labelled pot keeps it from blending into spending money, and this article does not suggest any particular product.
Making it stick
- Set a reminder on the last day of the month.
- Keep a Moved column in the sheet and mark it done.
- Review the total once a quarter; stop if it is not working for you.
If you want the spends in this sheet to come from real statements, SpendixAI lets you download reports as CSV, and you can paste the amount column into the sheet and add the round-up formula beside it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

