Management reporter, calculate an average daily balance of a GL account?

(0) Share

Report

Posted on by Community Member

Is there a way in management reporter to determine the average daily balance of a GL account over a month or quarter? This is for our customer to determine the average daily balance of an escrow account and pay interest on it quarterly. If they can at least get the average they can calculate the interest percentage themselves

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

serbach 571 on at

Like (0)

Report

Frank,

This may be a sort of naïve solution...

I created a Column Definition that shows last month and this month (BASE-1 (Column B) and BASE (Column C)) and a CALC column with this Formula:

B+(C-B)/30

Because there's no function in MR (well, there are no functions at all) that returns the number of days in the month, you would have to adjust the formula for the actual number of days in the month you're analyzing every time you run the report.

Does this help?

Sincerely,

Steve Erbach
WOW Logistics Company
Appleton, WI

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

That looks like a great solution to me! We will test it out. Thanks for the formula, you are like the Aaron Rodgers of Management Reporter!

Was this reply helpful? Yes No
serbach 571 on at

Like (0)

Report

Frank,

Well, that formula doesn't rise to the level of an Aaron Rodgers Hail Mary, but I appreciate the Packers reference all the same!

Sincerely,

Steve Erbach

Was this reply helpful? Yes No
serbach 571 on at

Like (0)

Report

P.S., would you mark the formula response as the Answer? Thanks!

Steve Erbach

Was this reply helpful? Yes No
iruser2 2,048 on at

Like (0)

Report

Any smart ideas for how to make this same report calculate a daily average balance?

Column format you can use periodic and use from to 1 to 1 1 to 2 etc, you would need 31 columns, but then calculating the average you wind up with 31 more columns

that seems to be very large for something that could be easier, shorter, quicker.

any thoughts?

Was this reply helpful? Yes No
serbach 571 on at

Like (0)

Report

iruser2,

I'm a bit confused by "...for something that could be easier, shorter, quicker." If one used Excel to show daily averages for 31 days in a month, it allows you to stack formulae in successive rows; so you wouldn't have to have double the number of columns. Management Reporter isn't a spreadsheet, even though the developers have taken pains to make its Designer look like one.

Regards,

Steve Erbach

WOW Logistics Company

Appleton, WI

Was this reply helpful? Yes No