We are seeking an Excel solution that reconciles client balances using transactional data from our finance platforms.
The reconciliation must integrate data from three platforms—a payment gateway, a payouts platform, and an exchange platform—which together manage around 14 different assets. The final output should include the balance in USD for each period as well as the individual balances for each underlying asset.
Our data set comprises approximately 300,000 lines for about 150 different clients. Additionally, we can provide a source of truth from each platform per client to verify the balances.
We welcome introductory calls to discuss any necessary details. Please note that an NDA must be signed before sharing the reports, but we are happy to move forward once that is in place.
