Net Income Formula on Balance Sheet is Inaccurate/ Retained Earnings

(0) Share

Report

Posted on by Steve.Fitzgerald

Have a total income G/L row number 4999, variables costs at row 5998, and fixed costs at row 6999. On the balance sheet I'm trying to use a formula to create a net income value using the formula 4999-(5998+6999). The net income balance I'm getting on the balance sheet is different than what I'm getting on the income statement by a lot. Maybe $80,000. I'm not using any filters on either report so they should be the same. Any suggestions?

Also, how do I create a retained earnings row for the balance sheet?