GL Report with Beginning balance, Period Activity (all transaction in selection duration), End Balan

Summary:

GL Report with Beginning balance, Period Activity (all transaction in selection duration), End Balance

Content (required):

Business wants simple GL Report with Beginning balance, Period Activity (all transaction for selection duration), End Balance by Natural Account.

User selects natural account and wants to see above balances based on Periods selected and data should display all accounts under that. This will be easy for reconcilaition. User might report for single period or multiple period.

Account analysis report shows each account string with above details. Its very difficult to summarise by natural account as each one show in seperate section. Pls suggest the best way to achieve my requirement.