Precious Metals Business Financial Dashboard Development

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? Show More