preparing daily ash flow and bank report

Hi! I am looking for your help to design easiest automated report which includes daily retails and at end of month there is a consolidated report underneath. End of every month i want a report to trigger details by selecting catevory as in the colomn header and month wise also.

please note there are 2 sheets i want help with.. 1. P.T CASH (as in PETTY Cash)

2. bank 

thank you