Finance Question- matching sales value date with that of amount received date

Dear Sir/Madam,

Thanks for your prompt reply to my post.

Now for the case of Opening balance which I did not included earlier is due to not expecting that it would be solved,hence partial ledger was given excluding opening balance either debit or credit.Now as enclosed in attachment in a single workbook,I have stated 4 different cases of Debit Opening balance & 4 different cases of Credit Opening Balance.Now you are requested to take into account all those situations of all sheets.Also, this is a sample one whose range might differ in actual situation as stated here is from row 3 to row 15 so it can vary from it.

You are further requested to see my assumption sheet as enclosed in my dummy work book as you said.If you require further information then do let me know.The output in general is taken out from Tally Software which is well famous in India and exported ledger is being analysed by me for the above cases.

Hoping a positive response as usual.

With Best Rgds,
Suresh