Accounting Amazon settlement report

Amazon settlement report list the $ about orders and platform fees.

I want to sync from Amazon settlement report to ERPNext for the company financial report.

My first idea is group by date and type and creates Journal Entry.

But if I want to drill down to check the order sales, the average cost per order… etc
How should I do?

Currently, my idea:

  1. Create new fields on Journal Entry to define it is an order and record Amazon order id.
    Create chart with filter custom fields.
  2. Create sale orders with the information, but I don’t create Payment and Deliver Note, the orders will be overdue eventually.

Thanks for any suggestions.