Google Sheets FX Management System
Budget: $8 – $15 USD
Project Description
I run a forex/remittance business and currently use an Excel workbook to track pre-funding reserves, FX deals, and weighted average exchange rates across multiple countries and payment partners.
I am looking for a Google Sheets expert to help me build or redesign this workbook in Google Sheets. This is a one-time project.
Business Logic
We maintain reserves (pre-funded balances) in multiple currencies and countries.
Example:
Existing Reserve = Amount A at Rate X
New Funding = Amount B at Rate Y
Total Cost = (A × X) + (B × Y)
Total Balance = A + B
Weighted Average Reserve Rate = Total Cost / Total Balance
This blended reserve rate is then used when offering exchange rates to customers and for future FX transactions.
Requirements
Build Google Sheets with multiple tabs for:
Pre-funding / Reserve management
FX deal recording
Country/currency specific reserve sheets
Partner/provider sheets
Summary dashboard
Reserve Management Features
Record existing reserve amount and average rate
Add new funding amount and funding rate
Automatically calculate:
Total reserve balance
Total cost
Weighted average reserve rate
Maintain historical funding records
FX Deal Recording
Trade Date
Value Date
Buy Currency
Sell Currency
Buy Amount
Sell Amount
Exchange Rate
Client / Counterparty
Deal Type (Spot / Forward / etc.)
Profit / Spread calculation
Settlement Status
Reporting
Running balances by currency
Current weighted average reserve rates
Daily/monthly summaries
Dashboard with key metrics
Other Requirements
Good spreadsheet design and formatting
Data validation and dropdowns
Formula optimization
Easy to maintain and expand
Files
I will provide my current Excel workbook as a reference. The freelancer should understand the existing logic and recreate/improve it in Google Sheets.
Ideal Freelancer
Strong Google Sheets expertise
Experience with financial models, treasury, forex, or accounting spreadsheets
Comfortable working with weighted average cost/reserve calculations
Able to understand existing Excel logic and improve it
This is a one-time project, but I may have additional small improvements in the future.
I run a forex/remittance business and currently use an Excel workbook to track pre-funding reserves, FX deals, and weighted average exchange rates across multiple countries and payment partners.
I am looking for a Google Sheets expert to help me build or redesign this workbook in Google Sheets. This is a one-time project.
Business Logic
We maintain reserves (pre-funded balances) in multiple currencies and countries.
Example:
Existing Reserve = Amount A at Rate X
New Funding = Amount B at Rate Y
Total Cost = (A × X) + (B × Y)
Total Balance = A + B
Weighted Average Reserve Rate = Total Cost / Total Balance
This blended reserve rate is then used when offering exchange rates to customers and for future FX transactions.
Requirements
Build Google Sheets with multiple tabs for:
Pre-funding / Reserve management
FX deal recording
Country/currency specific reserve sheets
Partner/provider sheets
Summary dashboard
Reserve Management Features
Record existing reserve amount and average rate
Add new funding amount and funding rate
Automatically calculate:
Total reserve balance
Total cost
Weighted average reserve rate
Maintain historical funding records
FX Deal Recording
Trade Date
Value Date
Buy Currency
Sell Currency
Buy Amount
Sell Amount
Exchange Rate
Client / Counterparty
Deal Type (Spot / Forward / etc.)
Profit / Spread calculation
Settlement Status
Reporting
Running balances by currency
Current weighted average reserve rates
Daily/monthly summaries
Dashboard with key metrics
Other Requirements
Good spreadsheet design and formatting
Data validation and dropdowns
Formula optimization
Easy to maintain and expand
Files
I will provide my current Excel workbook as a reference. The freelancer should understand the existing logic and recreate/improve it in Google Sheets.
Ideal Freelancer
Strong Google Sheets expertise
Experience with financial models, treasury, forex, or accounting spreadsheets
Comfortable working with weighted average cost/reserve calculations
Able to understand existing Excel logic and improve it
This is a one-time project, but I may have additional small improvements in the future.