We helped many agencies to automate reporting the way you described: https://www.narrative.bi/solutions/agencies