How can we run a deferred revenue report with showing the beginning and ending balance for each cale

Depends on how your structure the columns in your report, but you probably have “for the period” balances checked populating the column of the report. You could add a column to the right and then check through end of the of the period For the same account groups. And then same thing for beginning balance as a column on the left side of the report.