Travel and vehicles

Expense apps that show amounts in lakhs and crores: a checklist

How to test whether an expense app shows 12,50,000 in Indian grouping, plus a buyer's checklist for INR-friendly apps and spreadsheets.

Editorial illustration for Expense apps that show amounts in lakhs and crores: a checklist

Showing amounts as 12,50,000 rather than 1,250,000 is what this thread wants from an expense app, so is there one that uses lakhs and crores? Some apps do and many do not. The quickest way to know is to enter a large test amount and look at how it displays, then check reports and exports too, since formatting can differ between screens.

Why does the grouping matter?

In Indian grouping the first comma comes after three digits from the right and the rest after every two. So 1250000 reads as 12,50,000, which is twelve lakh fifty thousand. In Western grouping it reads 1,250,000, which many readers have to pause over. For a down payment, a car loan or a yearly total, misreading by a factor of ten is easy at a glance.

How do you test an app in two minutes?

  1. Add an expense of 1250000, or a mock entry in a free plan.
  2. Look at the list view, the dashboard and any chart label. Note where the commas fall.
  3. Add 12000000. In Indian grouping this is 1,20,00,000, one crore twenty lakh.
  4. Open a report and a CSV download. Check whether the figure in the file is plain digits, which is best for spreadsheets, or formatted text, which can break formulas.
  5. Check the currency symbol and the placement of the minus sign for refunds.

What does the correct grouping look like?

Plain numberIndian groupingIn words
125000012,50,000Twelve lakh fifty thousand
120000001,20,00,000One crore twenty lakh
85008,500Eight thousand five hundred
1000001,00,000One lakh

A handy check: one crore is 100 lakh, and 100 lakh is 10,000,000. So 1,20,00,000 should equal 120 lakh.

What else belongs on the buyer's checklist?

  • INR as a real currency, with the rupee symbol and not a dollar sign.
  • Statement import for the formats Indian banks give you: PDF, CSV or Excel.
  • Account types you actually have: bank, card, wallet.
  • Cash entry, since many Indian expenses never touch a statement.
  • A financial year view if you need April to March.
  • GST fields on categories if you run a small business.

What if the app does not support lakh grouping?

It is a cosmetic issue, not a data issue, as long as the stored numbers are right. Read totals carefully, or export to a spreadsheet and apply Indian-style number formatting there. If a custom format is needed in Excel, search for the Indian number format option in your regional settings rather than guessing a format code.

Does the same issue appear in a spreadsheet?

Yes. Excel and Google Sheets follow your regional settings, so a sheet set to a Western locale will show 1,250,000 even when you are thinking in lakhs. Changing the locale or applying an Indian number format fixes the display, and the stored value stays the same. Spreadsheets also show a negative number for a refund differently from a statement, so test that too. When you import statement data into a sheet, make sure amounts arrive as numbers and not as text with commas, or sums will return zero.

Also check how the app handles very small amounts, such as 45.50, and negative numbers. A good test set is five entries: a tiny one, a round thousand, a lakh, a crore and a refund. If all five read cleanly on the list and in a downloaded file, the formatting is reliable enough for daily use.

Before you commit

  • Enter 1250000 and 12000000.
  • Check the list, dashboard, report and export.
  • Confirm the export holds raw numbers.
  • Run one real statement through.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports