Sage 100

FRX - I have never been a whiz. Have a client with an Income Statement that is run for a date range. Now he wants a Balance Sheet. Everything was working well (in the date range I just put 1/1/1900 as the Start Date) EXCEPT for Retained Earnings. I am at a loss. If I use the same date range, I get a whacko number (am assuming because there is no actual Detail line for RE transfers, but they did have some manual postings). Can I add a line on the BS report that calls the value of a line on another report?

You want the balance of RE at 1/1/1900 then you want the sum of all of the income and expense accounts for the range 1/1/1900 to the ending date. For testing, I would separate the balance of RE at 1/1/1900 and the RE activity from 1/1/1900 (sum of all income and expense accounts during the date range). By separating the two values you can see if one of the values is incorrect.

Isn't the balance sheet value for the retained earnings the net of the income and expense accounts for the current year? This is always a calculated value in Sage.

@alanniergarth If you are talking one year and not a range of years or periods then retained earnings is: Ending balance of RE of the previous year plus the current year income. Sage tracks current year income separate and displays the prior year ending balance of RE and the current year income on the standard financial statements.

Thanks everyone - I did something and now it's working. I'll try to figure out later what I did!!!!!!!