Management Reporter Balance Sheet when Prior year is closed

(0) Share

Report

Posted on by Community Member

I created a column for prior year YTD and current year YTD and am adding them together. That works great for everything except Retained Earnings/Net Income. Is there anyway within either the row set or column set to take the prior year net income and add it to the retained earnings account and only include the current year net income in the net income account?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

sozluk 5 on at

Like (0)

Report

RE: Management Reporter Balance Sheet when Prior year is closed

Hi all,

At column definitions, I've created three columns; B, C, D. First column is standard one. Second column is for closing transactions. I used Attribute filter: Transaction Posting Type = [Close] Third column is the difference of first and second columns. (D=B-C)

Print Control is NP for B and C columns.

There is no closing transaction for 1st to 11th months. The closing transactions are at the last column and all those accounts' balances are zero.

If you generate the report for these months (1-11), all figures will be all zero at the C column. So the report will work properly

If you generate the report as 12th period, all figures will be all zero at the B column, but you will see the sign of account balance reversed. Our formula is: B-C => 0 - (-X) = X

I found a method in my own way.

If anyone have any other solution with standard functionalities of MR, I would ask him to share.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Management Reporter Balance Sheet when Prior year is closed

I am having the same issue. Has anyone come up with a solution?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Management Reporter Balance Sheet when Prior year is closed

Hi Katy,

I am having the same problem. Did you find a solution? Thank you in advance!

Was this reply helpful? Yes No