We are seeking an experienced Excel specialist to develop a robust reconciliation solution that consolidates and verifies client balances across three financial platforms:
- A payment gateway - A payouts platform - A cryptocurrency exchange
Together, these platforms handle around 14 different assets, and our dataset is across 6 transactional reports.
Project Requirements: - Consolidated USD balances per client, per month - Breakdown of balances by individual asset - Integration of data from all three platforms - A summary sheet showing: - Opening balance - Movements (deposits/withdrawals) - Closing balance - Ability to trace summary numbers back to source sheets (linked cells preferred) - Reconciliation must allow comparison with source-of-truth data from each platform
Additional Details: - We will share a reconciliation sheet with a client (attached: “New Age Reconciliation”) - The client’s attempt to cross-check this data (attached: “Clients Own Reconciliation”) surfaced discrepancies (see “Balance Confirmation” tab) - We want to resolve this issue now and implement a more reliable reconciliation process moving forward - future work available.
Deliverables Due By: Monday/Tuesday (project is time-sensitive)
An NDA must be signed before any sensitive data is shared.
Add Service Pages & Boost SEO Category: Content Development, Content Writing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Web Development, Web Design, Website Optimization Budget: £250 - £750 GBP
Site e Redes para Consultório Category: Article Writing, Content Creation, HTML, Link Building, SEO, Social Media Management, Web Design, WordPress Budget: $250 - $750 USD
SEO-Optimized Blog Post Series Category: Article Rewriting, Article Writing, Blog, Blog Writing, Content Writing, Keyword Research, SEO, SEO Writing Budget: £250 - £750 GBP
Animated Background Replication Category: Adobe Premiere Pro, After Effects, Animation, Graphic Design, Motion Graphics, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: £10 - £50 GBP
