
Fechado
Publicado
Pago na entrega
We are looking to develop a custom financial dashboard / back-office ERP module for a precious metals business. The system must consolidate multi-currency and gold positions into USD, using transaction-weighted average calculations (not system FX rates). Core Requirements 1. Multi-Currency Cash & Bank Tracking Track balances per: Currency Bank Cash accounts Convert all values to USD using: Transaction-weighted average rate NOT real-time/system FX rates 2. Foreign Accounts & Counterparties Track balances with: Foreign accounts Gold buyers / partners Multi-currency support USD conversion using weighted average 3. Gold Inventory & Vault Tracking Track gold positions in: Vault KS / MH / MTMO (locations) Store: Quantity (kg) Average acquisition price Show USD valuation 4. Customer Gold Positions Per customer: Open gold positions Average price USD value Risk logic: Calculate stop level at 20% exposure Provide: Per-customer summary Consolidated exposure report 5. Calculation Logic (CRITICAL) Use: Transaction-weighted average price Must handle: Partial buys/sells Multiple currencies Historical transactions 6. Dashboard Clean UI dashboard showing: All values in USD Drill-down capability Auto-refresh every 2 hours Technical Expectations Ask candidates to specify: Tech stack (e.g., Python, Node.js, React, etc.) Experience with: Financial systems ERP development Commodity trading systems (preferred) Deliverables Fully working dashboard Backend calculation engine Database design Documentation VERY IMPORTANT: Add These Questions (to filter good freelancers) Ask every bidder: Have you built financial systems using weighted average calculations? Explain. Have you worked with commodity trading or gold/silver systems before? How would you design the weighted average calculation engine? Which tech stack would you use and why? Can you handle multi-currency + commodity (gold) accounting together? Can you provide similar past projects or demos?
ID do Projeto: 40322944
149 propostas
Projeto remoto
Ativo há 16 dias
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
149 freelancers estão ofertando em média $3.796 USD for esse trabalho

I understand the importance of developing a custom financial dashboard/back-office ERP module for your precious metals business. The system needs to effectively consolidate multi-currency and gold positions into USD using transaction-weighted average calculations, not relying on real-time/system FX rates. With my extensive experience in financial systems and ERP development, I have successfully built similar solutions for various industries, including fintech and commodity trading. My expertise in handling multi-currency accounting and commodity trading systems aligns perfectly with your project requirements. Using my knowledge of weighted average calculations, I will design a robust calculation engine that can handle partial buys/sells, multiple currencies, and historical transactions efficiently. I plan to utilize a tech stack that includes Python, Node.js, and React to ensure a seamless and reliable solution for your business. I am confident in my ability to deliver a fully working dashboard, backend calculation engine, database design, and comprehensive documentation within the specified budget and timeframe. Please feel free to reach out to discuss the project details further or to see demos of my past projects.
$6.400 USD em 60 dias
7,5
7,5

Hello, I can develop your financial ERP module with the high precision required for precious metals. I understand the core is a Transaction-Weighted Average Price (WAC) engine to reflect actual acquisition costs in USD, ignoring system FX rates. Answers to your screening questions: Weighted Average Experience: Yes. I recalculate the cost basis upon every inflow by adding the new acquisition cost to the current total stock value and dividing by the new total quantity. This ensures USD valuation reflects actual spend. Commodity Systems: I am familiar with tracking physical assets across vaults (KS/MH/MTMO) and handling Kg/Oz conversions vs. USD parity. Calculation Engine: I will use a Double-Entry Ledger architecture. Every transaction is an atomic record; valuations are calculated aggregates to ensure 100% auditability and zero rounding errors. Tech Stack: Node.js/TypeScript with PostgreSQL. I choose Postgres for its ACID compliance and Decimal types, essential for financial accuracy. React for the dashboard. Multi-currency + Gold: Yes. Gold is treated as a "base currency" in the DB, allowing for partial liquidations while maintaining historical cost integrity. Demos: Available via screen-share. I am ready to implement the 20% exposure risk logic and the 2-hour auto-refresh dashboard. Best regards, Anthony Muñoz
$6.000 USD em 45 dias
6,9
6,9

Hello, I understand you need a financial dashboard and back-office ERP module for your precious metals business. The system will track multi-currency cash, foreign accounts, gold inventory, and customer gold positions, all converted to USD using transaction-weighted averages rather than real-time rates. I'll ensure the backend accurately handles partial transactions, multiple currencies, and historical data, with a clean dashboard that updates regularly. My approach includes designing a robust database, precise weighted average calculations, and an intuitive UI for easy drill-downs. I'll use a tech stack best suited for financial and ERP systems to deliver a reliable, maintainable product. Can you share more about your current data sources and any existing systems that need integration? What are your preferred technologies or constraints for the backend and frontend? How many users or scale do you expect for real-time dashboard use? Are there specific security or compliance standards your system must meet? Do you require reporting/export features beyond the dashboard analytics? Thanks,
$8.000 USD em 12 dias
6,6
6,6

I HAVE READ YOUR REQUIREMENTS CAREFULLY AND UNDERSTOOD WELL THE PROJECT SCOPE AND START WORKING ACCORDINGLY IN STAGES. With over 10+ years of experience in programming and architecting high-stakes financial ERPs, I am perfectly equipped to build your Precious Metals Financial Dashboard. I specialize in developing commodity-driven accounting engines where traditional real-time FX rates are insufficient. My background in Node.js, React, and PostgreSQL ensures a robust, transaction-weighted system that precisely tracks gold positions and multi-currency exposure with the 20% risk-stop logic you require. Answers to Your Required Filtering Questions: Weighted Average Systems: Commodity/Gold Experience: Calculation Engine Design Multi-Currency + Gold Accounting I WILL PROVIDE 2 YEAR FREE ONGOING SUPPORT AND COMPLETE SOURCE CODE, WE WILL WORK WITH AGILE METHODOLOGY AND WILL GIVE YOU ASSISTANCE FROM ZERO TO PUBLISHING ON STORES. I am available on desk as per your convenient time zone and am ready to begin the database design for your gold inventory and vault tracking immediately. I eagerly await your positive response. Thanks.
$500 USD em 7 dias
6,7
6,7

Hi I have strong experience building financial back-office systems with custom valuation engines, multi-currency ledger logic, and dashboard/reporting workflows for operational finance. The main technical challenge here is designing a calculation engine that handles transaction-weighted average valuations correctly across currencies, partial buys/sells, and gold position movements without relying on simplistic FX snapshots. I can build a custom backend that tracks cash, banks, foreign counterparties, vault gold, and customer gold exposure, then consolidates everything into USD using weighted-average logic driven by transaction history. My recommended approach would be a React frontend with a Python or Node.js backend and PostgreSQL, because this gives strong support for financial calculations, auditability, and drill-down reporting. I can also implement the risk layer for customer stop-level exposure, consolidated reporting, and auto-refresh dashboards with clear USD views and traceable source transactions. My focus is on calculation accuracy, data integrity, and a clean ERP-style UI that is practical for daily operations rather than just visually attractive. I have worked on structured finance and inventory-style systems where weighted costing, historical transactions, and reporting consistency were critical to trust in the platform. Thanks, Hercules
$6.000 USD em 25 dias
6,7
6,7

I am a seasoned software developer with expertise in building financial systems and ERP modules. My experience includes the development of multi-currency financial dashboards and back-office solutions for the commodity trading industry. I possess strong skills in Python, React, and Node.js, which allows me to deliver robust solutions tailored to complex requirements such as those in the precious metals business. Previously, I have designed weighted average calculation engines handling multi-currency transactions, and have worked on projects involving gold and silver trading systems. My approach ensures accurate transaction-weighted average calculations across multiple currencies and gold inventories. I have developed clean UI dashboards with drill-down capabilities and auto-refresh features that align with your needs. I am interested in discussing how I can contribute to your financial dashboard project. Could you share more about your current system architecture and specific technical expectations? I am prepared to provide demos of past work to demonstrate my capability. Best regards.
$7.500 USD em 45 dias
6,9
6,9

Hello, My name is Yasir and I lead a talented team at Our Software in Pakistan. Our company is renowned for providing exceptional web development services, including creating information-rich sites, e-commerce solutions, and designing effective Content Management Systems. These technical skills translate seamlessly to engaging with complex financial systems like the one you're seeking. Through our expertise in C# Programming and Microsoft SQL Server, we can create a user-friendly UI dashboard that incorporates all your requirements while offering a clean look that's easy to navigate. Given the gravity of accuracy in your business, ensuring precise currency conversions relying on transaction-weighted average calculations is of paramount importance. I'm pleased to inform you that we've successfully built similar systems - relying on this same calculation logic - in the past. This includes developing commodity trading systems which have distinct parallels with your precious metal business. We understand and appreciate that no two businesses are identical; thus, our approach towards each project reflects that. We will not simply recreate a tool for you but carefully design it around your specific needs, leveraging the choicest of modern technologies like Node.js or Python where needed, ensuring perfect compatibility and security throughout. Superior customer support and client satisfaction are also at the core of what we offer, so we g Thanks!
$4.445 USD em 1 dia
6,0
6,0

I went through your requirements, I will build your precious metals dashboard with a backend calculation engine for transaction-weighted average pricing across multi-currency cash, bank, and gold positions, all consolidated into USD. The system will include per-customer gold exposure tracking with 20% stop-level alerts and a drill-down dashboard with auto-refresh. For the weighted average engine, I will process each buy/sell chronologically and recalculate the running average on every partial fill, so mixed-currency and split-lot transactions stay accurate without relying on snapshot FX rates. Questions: 1) How are transactions currently recorded — spreadsheets, an existing system, or manual entry the new system should handle? 2) Should the 20% stop-level trigger email or SMS alerts, or just flag visually on the dashboard? 3) Do you need role-based access so traders and management see different views? Drop me a message and I will walk you through my approach. Kamran
$3.000 USD em 20 dias
6,5
6,5

Hello, I am an expert with 15+ years of experience in the technical world, delivering simple to complex websites, e-commerce platforms, membership systems, and custom portals. I always provide clear communication, continued support after delivery, and 100% client satisfaction. I specialize in Node.js development, creating secure, scalable, and high-performance backend systems with RESTful APIs, real-time applications, and database integration (MySQL, MongoDB, etc.). My focus is on building future-ready applications with clean and optimized code. If you are looking for a dedicated Node.js expert who delivers quality, innovation, and timely results, I’d be glad to work on your project.
$400 USD em 7 dias
5,9
5,9

As an accomplished full-stack developer with a focus on backend development and mastery in C# and Node.js programming, I am well-equipped to tackle the complex task of creating your financial dashboard. My experience includes building platforms that involve multilayered financial analysis as well as dealing with calculations based on transaction-weighted average pricing - a crucial aspect of your project. I’ve used this calculation methodology in my previous projects, including cryptocurrency trading apps and marketplace solutions. Moreover, I have successfully created data management systems for businesses dealing with valuable commodities like cryptocurrencies, which involved handling multi-currency accounting, which makes me adept at addressing the multi-currency + commodity aspects of your project. My approach towards designing the calculation engine would involve not just understanding each mathematical detail but also aligning it perfectly with your company's workflow ensuring seamless operations.
$15.000 USD em 90 dias
5,5
5,5

Hello, we once had a hard bug where using spot FX broke profit and inventory math and we fixed it by building a transaction-weighted average FX engine that handled partial fills. I will build a back-office dashboard that tracks multi-currency cash, banks, foreign counterparties, and gold inventory and converts everything to USD using transaction-weighted averages. The system will track gold by vault and location, record quantity and average acquisition price, show USD valuation, and give per-customer positions with a 20% stop exposure report. I will deliver a backend calculation engine, database design, documentation, and a React dashboard with drill-downs and auto-refresh every two hours. Please answer these questions: have you built weighted average calculations; have you worked in commodity or gold systems; how would you design the weighted average engine; which tech stack would you use and why; can you handle multi-currency plus gold accounting; can you show similar past projects or demos?
$4.005 USD em 7 dias
5,0
5,0

✅ Hi, Client! I am a Senior Web Developer ✅ I am interested in your project I have rich experiences with website development using HTML, Angular, TypeScript/JavaScript, PHP, CodeIgniter, Node, Next/React, Laravel, VueJS, Shopify, Python, C#, Webflow, MySQL. I am ready to start immediately and commit to working full-time (40 hours a week), depending on your time zone. Feel free to reach out at any time to explore how we can work together seamlessly. Let's discuss your project in detail and collaborate to create something truly magical. Looking forward to the opportunity! Best Regards! From Hien ...
$5.000 USD em 25 dias
5,2
5,2

Hi It C., Just last week I completed a similar task successfully, so I can get started on this without any ramp-up time. - For USD conversion, will each transaction include its own FX rate (deal/settlement rate)? If not, what authoritative source and effective date hierarchy should we use? - How exactly is the 20% stop exposure defined (net open USD value vs funded collateral/margin), and should triggers create alerts only or auto-close/hedge positions? - Implement an immutable double-entry ledger (dimensions: currency, counterparty, bank/cash, customer, vault/location KS/MH/MTMO). Compute transaction-weighted averages via incremental cost-basis snapshots to handle partial fills, multi-currency, and historical backfills at scale. - Stack: Python/FastAPI + PostgreSQL (partitioned journals, materialized USD views) + Redis/Celery for delta recomputes; React/TypeScript UI reading pre-aggregates for fast drilldowns; 2-hour refresh via scheduler; strict idempotent imports and reconciliation reports. Action Plan: - Phase 1: Requirements finalization, data mapping, exposure/stop rules, UX wireframes. - Phase 2: Schema + ledger engine POC; WA algorithms with unit tests; snapshot strategy. - Phase 3: ETL for banks, vaults, customers (CSV/API); backfill and reconcile to opening balances. - Phase 4: Valuation services (USD), risk/exposure module, alerting. - Phase 5: React dashboard with drill-downs, role-based access, auto-refresh jobs Best Regards, Sid
$8.000 USD em 11 dias
5,2
5,2

Hello, I am really excited about the opportunity to collaborate with you on this project! It aligns perfectly with my skill set and experience, and I’m confident I can contribute meaningfully to your vision. I genuinely enjoy working on projects like this, and I believe we can create something both functional and visually engaging. Please feel free to check out my profile to learn more about my past work and client feedback. I’d love to connect and discuss the project details further your goals, expectations, and any specific features or ideas you have in mind. The more I understand your vision, the better I can bring it to life. I am ready to get started right away and will put my full energy and focus into delivering quality results on time. My goal is not just to complete the project, but to exceed your expectations and build a long-term working relationship. Looking forward to hearing from you soon! With Regards! Nikhil
$5.500 USD em 45 dias
5,0
5,0

Hello , I just saw your project regarding Precious Metals Business Financial Dashboard Development. I've been building scalable web apps and custom integrations for a while, and this fits right into my wheelhouse. I'm a full-stack developer with hands-on experience in AI (custom LLMs, RAG, workflow automation), SaaS architectures (React, Node.js), and Web3 integrations. Instead of just delivering basic scripts, I focus on building secure, production-ready solutions that actually scale. I've launched multiple real-world products and know how to avoid the common technical pitfalls in these areas. Let's connect so we can go over your exact needs. I can share some of my recent work so you can see the code quality firsthand. Best, Emre
$10 USD em 57 dias
4,6
4,6

hi! i have reviewed the details of your project and i can do this!!. we have handled similar projects successfully, and I am confident we can deliver high quality results for you. we prefer clear communication and regular updates so that the project progresses smoothly and meets your expectations. let's have a detailed discussion, as it will help me give you a complete plan, including a timeline and estimated budget. I will share my portfolio in the chat to show relevant examples of our past work. looking forward to your response. mughiraa
$4.005 USD em 7 dias
4,5
4,5

✔️ Hello, I’m Taiwo, a UK-based Senior Software Developer with a Master's in Cybersecurity and 7 years of experience. I'm very interested in your precious metals business financial dashboard project. My experience in building backend financial services applications makes me a strong fit. I have previously built backend systems for financial services and have experience with fintech startups. ➕ I propose a Python/Django backend with a React frontend for a robust and scalable solution. I will implement transaction-weighted average calculations and handle multi-currency and gold positions. The dashboard will provide a clean UI with drill-down capabilities and auto-refresh. Security will be a priority, ensuring data integrity and compliance. Have you built financial systems using weighted average calculations? Explain: Yes, using Python and SQL Alchemy. Have you worked with commodity trading or gold/silver systems before? No, but the principles remain the same. How would you design the weighted average calculation engine? I will use SQL Alchemy for efficient and accurate calculations. Which tech stack would you use and why? Python/Django and React. Python is great for backend calculations and database handling while React is good for UI Can you handle multi-currency + commodity (gold) accounting together? Yes Can you provide similar past projects or demos? See below Relevant Projects ⏺ Global Loan Agency Services Ltd - Backend services for financial services, including third-party integrations and CI/CD pipelines. ⏺ IBM (https://
$6.400 USD em 7 dias
4,6
4,6

Hi, I can assist you in creating a custom financial dashboard and ERP module for your precious metals business. I understand you need accurate multi-currency tracking and gold position management with transaction-weighted average calculations, not system FX rates. I have experience working on financial systems and can build a clean dashboard with strong backend logic to handle partial trades, historical data, and USD consolidation. I will design a scalable database, reliable calculation engine, and an easy-to-use interface with drill-down features and auto-refresh. I focus on accuracy, performance, and clear reporting so you can track exposure and risk بسهولة. I’d love to understand your workflow better and deliver a solution that fits your business perfectly. How are your transactions currently stored or managed (Excel, software, etc.)? Do you need integration with any existing system or API? Thanks
$4.005 USD em 7 dias
5,4
5,4

Hello, I am Vishal Maharaj, a C# Programming and Backend Development expert with 20 years of experience in Node.js and Microsoft SQL Server. I have carefully reviewed the requirements for the custom financial dashboard/back-office ERP module for a precious metals business. To meet the project needs, I propose to use my expertise in C# Programming to develop a robust backend calculation engine that accurately consolidates multi-currency and gold positions into USD using transaction-weighted average calculations. I will ensure seamless integration of the core requirements, including multi-currency cash tracking, foreign accounts management, gold inventory tracking, customer gold positions, calculation logic, and a user-friendly dashboard with drill-down capability. Please initiate a chat to discuss further details. Cheers, Vishal Maharaj
$8.000 USD em 40 dias
5,3
5,3

I’ve analyzed your requirements for the Precious Metals ERP. Most freelancers will try to use live FX APIs, but I understand your core need: Transaction-Weighted Average Costing for true P&L, especially when handling physical gold (Vault/KS/MH) and multi-currency counterparty balances. Why I am the right choice: While others are still planning, I have already built the middleware foundation that handles the heavy lifting for systems like this. My existing stack (Node.js/TypeScript/PostgreSQL) is designed for high-integrity financial auditing.
$2.200 USD em 14 dias
4,4
4,4

Para, Suriname
Método de pagamento verificado
Membro desde jul. 16, 2014
$30-250 USD
$10-50 USD
$30-250 USD
$10-250 USD
$30-250 USD
€8-30 EUR
£20-250 GBP
₹100-400 INR / hora
$250-750 USD
₹12500-37500 INR
$250-750 USD
₹12500-37500 INR
$1500-3000 USD
£250-750 GBP
₹12500-37500 INR
₹1500-12500 INR
$10-50 USD
₹12500-37500 INR
$250-750 CAD
₹37500-75000 INR
₹100-400 INR / hora
₹100-400 INR / hora
$25-50 USD / hora
$250-750 CAD
$15-25 USD / hora