November 26, 2013 at 12:27 pm
I have created a cube for Financial reporting using the AdventureWorks 2008R2 DW as a guide. I've defined my GL accounts and created the account hierarchy and everything is rolling up the way I expect with the exception of Net Income. It calculated correctly but the Balance sheet is not at zero but shows an amount equal to income. My question is should Income roll up under the Owner's Equity through the dimension or is there a way in SSAS to populated Retained Earnings?
In the MS example, Income does not roll up anywhere but is at the same level as the Balance Sheet. I am completely confused on a best practice for handling this.
November 27, 2013 at 5:26 pm
You typically do not show Net Income on a Balance Sheet. This rolls up on a P&L or Income Statement. I'm not an accountant, just a humble dba w/ acctg background, but a discussion w/ a higher up in your Accounting dept may help. Otherwise hard to tell what AS is doing w/out more info.
Regards,
ChrisB
sqldatabasesolutions.com
Chris Becker bcsdata.net
December 2, 2013 at 8:11 am
According to the accountants, the net income for a period would appear on a balance sheet under Owner's Equity, with an Account such as "Current Period Net Income/Loss". If I don't include it, the Balance Sheet is off the amount that appears on the Income Statement. Does that make sense?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply