Round-off is the small adjustment added to or taken off a bill so the total becomes a whole rupee. A bill that adds up to ₹1,234.60 is shown as ₹1,235, with a round-off of 40 paise. If you record it in its own head, your payment and the bank statement agree exactly, and the paisa differences stay out of your real expenses.
What does the example look like?
A shop bill adds up to ₹1,234.60 and is rounded to the nearest rupee. You pay ₹1,235.
| Line | Amount (₹) |
|---|---|
| Items and tax, as calculated | 1,234.60 |
| Round-off | 0.40 |
| Bill total, and amount paid | 1,235.00 |
Rounding can go the other way: a bill of ₹2,310.35 becomes ₹2,310, with a round-off of minus 0.35. Check: 2,310.35 minus 0.35 equals 2,310.
Where does the paisa difference go?
Into a dedicated Round-off account. It is a very small head, sometimes income and sometimes expense, depending on the direction. At the end of a month it holds just a few rupees. If you simply stuff the extra 40 paise into the expense, your expense is slightly overstated and the bill no longer matches the invoice figure line by line.
| Account | Debit (₹) | Credit (₹) |
|---|---|---|
| Expense (the item) | 1,234.60 | - |
| Round-off | 0.40 | - |
| Bank | - | 1,235.00 |
Debits 1,234.60 plus 0.40 equal 1,235.00, the same as the credit to the bank.
Why does it matter if it is only paise?
- Your bank shows ₹1,235 leaving the account; your books must say the same or the reconciliation fails by paise.
- Many small mismatches add up and hide larger genuine errors.
- Tick-offs against statements are faster when each amount matches exactly.
- Customers compare the printed total with the amount they paid.
How do I handle it in a sheet?
Keep the exact amount in one column and the payable amount in another. Compute the round-off with =ROUND(C2-B2,2), where B is the calculated total and C is the rounded total. Wrapping the result in ROUND(...,2) matters, because spreadsheets store decimals in binary and subtracting 1,234.60 from 1,235 can show a tiny trailing error rather than a clean 0.4. To round a total to the nearest rupee, use =ROUND(B2,0).
There is a practical reason to match the invoice. When you pay by UPI or transfer, you enter the rounded amount, so your statement shows ₹1,235 and not ₹1,234.60. Recording the same figure in your books means the line on the statement and the line in your records carry the same amount, and tick-off is instant. The odd paise belong to the Round-off head, not to the expense.
Do I always round to the nearest rupee?
It depends on how the invoice is drawn up. Some bills round to the nearest rupee, some show paise, and some round to ten paise. Follow whatever the invoice says, and record the difference between the calculated total and the invoice total as round-off. How rounding affects a tax invoice is a question for your CA; rules change, so confirm the current position with them or the official source.
What does a day of several rounded bills look like?
Round-offs go in both directions, and over time they tend to cancel. Say three bills in one day round by +0.40, -0.35 and +0.20.
| Bill | Round-off (₹) |
|---|---|
| Bill 1 | +0.40 |
| Bill 2 | -0.35 |
| Bill 3 | +0.20 |
| Net for the day | +0.25 |
The net is 0.40 minus 0.35 plus 0.20, which is 0.25. That is all the Round-off account holds for the day. Tiny numbers like this are a good sign: they show your payments match your bills to the paisa.
Monthly habit
Glance at the Round-off account when you close the month. It should be small. If it is not, open it and look at the lines, because the answer is usually a single wrong entry.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

