Automation of marketplace Revenue Reporting

Hi, We are B2C Company working with lot of market place like Amazon or Flipkart.. Our products are being sold via these platforms and than periodically we got sales reports in various format which contains sales, commission , logistics fees etc.. We need to clean up the heavy excel files so that we can derived the accounting entries and closed our books. Similarly we got settlement reports from these platform which we need to reconcile from our bank reports. All these takes lot of time