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
- Days 28-31 at 17:00
- Is today the last day?
- Last day of the month?
- Fetch exchange rates
- Excel: open foreign balances
- Revalue the balances
- Any balances revalued?
- Create the draft journal file
- Email accounting