I saw that there is an option called CSV export. But that would give me just the master data and reports in excel files. But I also need the transaction data too

SuiteAnalytics is probably your best option