Loading fibnancial data

Hi I am trying to build a data model that will compare the Financial statements(BS,P&L) of public companies. Could you please suggest any best practice to do so. I tried unpivoting the traditional financial statement but writing ratio measures seemed not possible or clear. Thanks