yeah I'm not an accountant either

I am an accountant....I've built these...you cant do it dynamically but you can add AMOUNT columns that reference a specific period...so you end up with some hard coded periods and a report that usually is named for the periods covered.