"Live" Profit and Loss Report?

Regarding “show detail such as each transaction and dates”, you could also check out https://community.tillerhq.com/t/p-l-analyzer-profit-and-loss-analyzer-solution-for-google-sheets which can automatically show detailed transactions when a category is selected (plus a link back to the transaction sheet if you desire, by inputting your Transactions sheet ID). I use it for small business reporting like you’re suggesting. I hope to share some tutorials in the future about how to extend it in other ways as discussed in that post.