Manny - I saw this post and having free time I tried to see if the 1st question could be done.

I have a GL Detail Transaction report that at run time you enter a Start & End date.

So for example you run it for 2020 5/1/20 to 5/31/20.

The original ending balances are as of 5/31/20.

I created a Excel Data Expression that looks at the Posting Date and if it is equal to the End Date entered at run time it will show zero. Not equal will show the vales.

Here is an account from ABC Demo Co.

Col M is the regular balance & Col N is the Balance as of the day before the End Date.

Is this what you were looking for?

Thank you for responding and I apologize for not replying sooner. Well, Let me explain it a little further. The purpose is to calculate the monthly average balance for the GL accounts. If I know the ending balance for each day than i can add the amounts and divide it by the number of days in the month. That was the purpose of creating this report. In your experience have you or anyone created such a report?

Thank you for responding and I apologize for not replying sooner. Well, Let me explain it a little further. The purpose is to calculate the monthly average balance for the GL accounts. If I know the ending balance for each day than i can add the amounts and divide it by the number of days in the month. That was the purpose of creating this report. In your experience have you or anyone created such a report?

I would use the general ledger detail report as a base as it already calculates the running balance for you.  Then you would have to add some grouping breaks by the day and a few formulas to accumulate the balances at the end of each day.  

Potential problem however might be if there are no transactions for a given day, you wouldn't get a break for that day.  Probably not insurmountable but it does complicate it a bit.