
Closed
Posted
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.
Project ID: 40510688
25 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
25 freelancers are bidding on average $14 USD/hour for this job

With my extensive experience in accounting and a proven mastery of Excel, I possess the skills necessary to excel on your Google Sheets project. I've been managing financial accounts for several years, and that experience has given me a deep understanding of the nuances of financial models, treasury work, and accounting spreadsheets. This project aligns perfectly with my existing skill set, as many of the functionalities - such as tracking weighted average cost - are already commodities within my daily work routine. One aspect that sets me apart is my ability to understand existing logic and improve upon it. This means I will not only recreate your current Excel functions in Google Sheets, but I'll also optimize them for better efficiency. Also, I place great emphasis on data validation, dropdown functionality, and overall spreadsheet design - all elements critical to ensuring ease of use and future expansion/flexibility. At the end of it all, my goal is to provide you with a fully functional system that meets your unique needs. All my work is characterized by a sense of thoroughness and attention to detail - traits that have routinely generated satisfied clients. I'm confident I can deliver
$15 USD in 40 days
9.0
9.0

Hey! I specialize in Google Sheets automation and financial modeling with 9+ years building treasury, FX, accounting, and reserve management systems. Here's how I can help: - Rebuild your Excel model into scalable Google Sheets architecture - Automate reserve balances and weighted average rate calculations - Create FX deal tracking with profit and settlement reporting - Build dashboards, validations, and easy-to-maintain workflows Could you clarify approximately how many countries, currencies, and funding partners the workbook needs to support from day one?
$12 USD in 40 days
7.3
7.3

Hi there, I’ve carefully reviewed your project and understand you need your existing Excel-based forex and remittance reserve tracking workbook redesigned in Google Sheets, with support for pre-funded reserve management, FX deal tracking, weighted average reserve rate calculations, partner-level reporting, and management dashboards. My approach is to first analyze your current workbook and map the reserve and FX workflows into a well-organized Google Sheets structure. I will create dedicated tabs for reserve management, FX deal recording, country/currency tracking, partner/provider balances, and executive reporting. The reserve module will automatically calculate blended reserve costs and weighted average rates as new funding is added, while maintaining a complete funding history. The FX module will capture deal details, settlement status, rates, counterparties, and profit/spread calculations, with all balances updating dynamically across the workbook. The reporting layer will provide running balances by currency, current weighted average reserve rates, daily and monthly summaries, and a dashboard showing key metrics across countries, currencies, and partners. I’ll also implement data validation, dropdowns, optimized formulas, and a clean layout to ensure accuracy and ease of use. Do you want the dashboard to focus primarily on reserve positions, profitability, or both? I’m ready to start immediately. Warm Regards, Aneesa.
$8 USD in 40 days
7.0
7.0

Hello, I am a Google Sheets expert who will rebuild your forex and reserve tracker with automatic weighted average calculations, FX deal logging, running balances, and a dashboard. Please share your current Excel file. Regards, Zafar
$8 USD in 40 days
6.2
6.2

Hi there, We can help recreate and improve your FX reserve workbook in Google Sheets with a clear structure for pre-funding, deal tracking, partner sheets, and a summary dashboard. We will map the existing Excel logic, then build formulas for weighted average reserve rates, running balances, and settlement/spread reporting in a clean, maintainable format. We also pay attention to spreadsheet design, validation dropdowns, and formula efficiency so the model is easier to expand across currencies and countries. Once we review the current workbook, we can align the layout to your operating process and keep the sheet practical for day-to-day use. Best Regards, 8veer
$15 USD in 10 days
5.7
5.7

Hi, With seven years of experience in financial modeling and spreadsheet optimization, I am confident in my ability to redesign your Excel workbook into a comprehensive Google Sheets solution. My approach will ensure that all the key functionalities you require, including pre-funding management, FX deal tracking, and detailed reporting, are captured with precision. I prioritize accuracy and strong attention to detail, allowing me to bring deep insights into your business logic, ensuring seamless calculations and effective data management that aligns with your operational needs. I will maintain clear communication throughout the project, ensuring that I fully understand your requirements while keeping you updated on the progress. By meticulously following proper processes, I will deliver the redesigned workbook on time, equipped with user-friendly features like data validation and formula optimization. I’m excited to collaborate with you and am open to future improvements to further support your forex and remittance business needs.
$12 USD in 7 days
5.3
5.3

Hello I am having 10+ years experience in Microsoft Technologies like VB, VBA programming etc and Google Sheet Apps. I can help you to do this task very quickly. I can do it for fixed price also. Thanks Venkateswaran
$12 USD in 40 days
5.1
5.1

Built for your forex/remittance reserve workflow in Google Sheets. I’ll recreate your Excel logic into a clean, multi-tab model: Reserve Management (existing reserve, new funding, total balance, total cost, weighted average reserve rate), FX Deal Recording (trade/value dates, buy/sell currencies and amounts, exchange rate, profit/spread, deal type, settlement status), and per-country/currency and per-partner/provider sheets. A Summary Dashboard will consolidate running balances, current weighted averages, and daily/monthly reporting for easy decision-making and client-rate setting. The sheet will be designed for maintainability: strong data validation and dropdowns for currencies/partners/deal types/statuses, consistent table structures, optimized formulas for volume, and historical funding/deal tracking to keep blended reserve rates accurate over time. Formatting will prioritize clarity so you can audit transactions and expand the model later without breaking formulas.
$20 USD in 48 days
2.0
2.0

Dear Project Owner, I can redesign and build your FX / remittance management system in Google Sheets with a clean, scalable structure that accurately handles reserves, weighted average FX rates, and deal tracking across multiple currencies and partners. I understand the core logic of your system, especially the blended reserve calculation: (A × X + B × Y) / (A + B), and I will ensure it is implemented accurately, dynamically, and audit-ready across all sheets. Approach: • Rebuild structured sheets for reserves, FX deals, partners, and currency/country-specific tracking • Automate weighted average reserve rate calculations with real-time updates • Create FX deal logs with full breakdown (trade type, rates, settlement status, P/L or spread) • Build a clean dashboard with key metrics: exposure, balances, averages, and daily/monthly summaries • Use data validation, dropdowns, and protected formula ranges for accuracy and ease of use • Optimize formulas for performance and long-term scalability • Improve existing Excel logic and translate it cleanly into Google Sheets I have experience building financial models, trading journals, and FX tracking systems, and I can ensure your workbook becomes both accurate and easy to maintain. I can start immediately once you share the existing file. Regards, FX Coders
$12 USD in 40 days
1.9
1.9

Dear Client, Good morning . How are you? I hope this proposal finds you well. I'M A CERTIFIED & EXPERIENCED EXPERT, WELL VERSED WITH THE REQUIREMENTS FOR YOUR PROJECT "Google Sheets FX Management System." This is to inform you that I have KEENLY gone through your project description, CLEARLY understood all the project requirements as instructed in your project proposal and this is to let you know that I will perfectly deliver as desired. Being in possession of all stated required skills, (Data Analysis, Accounting, Excel, Google Sheets and Financial Modeling), as this is my field of professional specialization having completed all certifications and developed adequate experience in the respective field, I hereby humbly request you to consider my bid for professional, quality and affordable services that meet all your requirements. I always guarantee timely delivery and unlimited revisions where necessary hence you are assured of utmost satisfaction when working with me. Please send me a message so that we can discuss more and seal the project. WELCOME.
$50 USD in 40 days
0.0
0.0

All 999 LLM routing attempts exhausted. Last error: Provider unavailable, no API key, or premium not allowed
$15 USD in 7 days
0.0
0.0

Hello,I am a professional data entry specialist, virtual assistant, and data automation expert ready to deliver flawless results. My core expertise focuses on fast and highly accurate manual data entry, alongside comprehensive virtual assistant support like managing emails, schedules, and administrative tasks. Additionally, I build advanced Excel and Google Sheets models using complex formulas and custom VBA macros to completely automate repetitive workflows. I also develop web scraping tools for clean datasets, create interactive Power BI dashboards, convert messy PDFs or images into native Word and PowerPoint layouts with zero errors, and deliver well-researched content writing and high-converting copywriting. I ensure clear communication and fast delivery. Let's connect in the chat to get started right away
$10 USD in 40 days
0.0
0.0

Seoul, Korea, Republic of
Member since Jun 13, 2026
₹1500-12500 INR
₹750-1250 INR / hour
₹12500-37500 INR
$15-25 USD / hour
$10-30 USD
$30-250 USD
$500-1000 USD
£250-750 GBP
$250-750 USD
₹600-1500 INR
$30-250 USD
$25-50 USD / hour
₹1000000-3000000 INR
₹750-1250 INR / hour
₹600-1500 INR
₹20000-50000 INR
₹1500-12500 INR
€8-30 EUR
₹12500-37500 INR
$250-750 USD