Simplify your global spending by automatically converting all totals to your home currency.
Managing orders from international sellers in various currencies can fragment your budget view. The CNFANS Spreadsheet's Multi-Currency Integration
The Core Challenge & Our Solution
Without integration, a budget might list USD for items from the US, EUR for EU purchases, and CNY for Chinese platforms. CNFANS automates the conversion, turning a multi-currency log into a unified financial report in your native currency.
How to Set Up Automatic Currency Conversion
-
Define Your Home Currency
In your spreadsheet settings, select your Primary (Home) Currency
-
Input Orders in Original Currency
Add each order normally. In the "Currency" column, select the transaction's original currency (JPY, AUD, CNY, etc.), and enter the cost in that currency.
-
Enable Live Exchange Rate Fetching
Activate the "Auto-Convert"
-
View Unified Totals
Watch as the "Total in Home Currency" column automatically populates. Your dashboard summary will now display aggregate spending in your chosen currency.
Key Benefits for Budget Control
- Instant Financial Clarity:true total expenditure
- Accurate Budget Tracking:
- Informed Decision-Making:
- Time-Saving Automation:
- Accurate Budget Tracking:
Pro Tips for Advanced Users
- Set a custom update frequency for exchange rates depending on your needs.
- Use the integrated historical rate snapshot
- Define fixed rates for specific, one-off transactions if needed.