Money Converter for Sheets

This tool enables currency conversion inside Google Sheets by standardizing inputs, sources, and outputs for multi‑currency workstreams. Target users include financial analysts, budgeting teams, treasury staff, and international sales operations who maintain invoices, forecasts, or pricing in several currencies. It provides a reproducible, auditable conversion workflow for current and historical data, minimizing manual rate lookups and errors.
The conceptual workflow: a conversion is computed as amount multiplied by a rate. The system fetches the rate from a selected source (GOOGLE_FINANCE via Sheets, ECB, or a user-supplied rate table). If a direct currency pair rate exists, it is used; otherwise a cross-rate is constructed through a base currency (commonly USD). Historical conversions can use a date parameter to retrieve the rate for that day.
Core value and features: required inputs include amount, from_currency, to_currency, and rate_source; optional date for history. Outputs include converted_amount, rate_used, and last_updated. Advanced options include batch conversions, rounding, and custom rate tables. Typical use cases include batch FX for price lists, monthly budgeting, and reconciliations. Assumptions: data relies on external rate sources and does not guarantee real‑time data; users should validate rates before critical financial decisions.