I have a table with monthly trial balances for every month end dates and want to make derive monthly MIS. Financial year ends 31st March
TB table
Month end date, ledger, YTD amt
30-04-2016, sales, 300
30-04-2016, exps, -100
...
31-05-2016, sales, 450
31-05-2016, exps, -200
...
Mis report for...