FX Revaluation Helper (Rates URL + Excel)

On the last day of each month, fetches exchange rates from a public rates URL you choose, revalues the open foreign-currency balances listed in your Excel workbook and emails accounting a draft revaluation journal as an Excel file. Nothing is posted; the accountant reviews and books it.

Steps in this flow

  1. Days 28-31 at 17:00
  2. Is today the last day?
  3. Last day of the month?
  4. Fetch exchange rates
  5. Excel: open foreign balances
  6. Revalue the balances
  7. Any balances revalued?
  8. Create the draft journal file
  9. Email accounting

All templates