How do I convert amounts from IDR to USD in the rate sheet?

You can convert all IDR amounts to USD in Excel with a simple formula:

1. Know your exchange rate — for example, 1 USD = 16,000 IDR.
2. Use the formula USD = IDR ÷ 16,000 in a new column.
3. Drag the formula down for all rows.
4. If you want to overwrite the original IDR amounts with the USD values, replace the column and re-upload the sheet.

Related documentation

• Currencies, Exchange Rates and Tax Types