Hello,

Background: set of statements within Financial Reporter (Balance Sheet, Income Statement).

The way the balance sheet is set up, it shows "opening fund balance" (this is a not for profit enterprise) and then shows the current period Net Income immediately below.

However, I am unaware as to how to have the net income figure automatically populated from the Income Statement into the Balance Sheet.

How does one go about inserting a reference to another sheet within the same file? I am familiar with Excel's comparable function, (=Sheet2!A1), but when attempting to utilize this formula in the Financial Reporter module, the following error is returned:



Any help would be greatly appreciated!

Thank you,
Ryan

Hi Ryan,

The Adagio Financial Reporter deals with referencing a cell differently than Excel. This is why you are getting an error when the formula is the way Excel works.

You need to use the QuerySheet function to do this:

=QuerySheet("Sheet name","Cell") or =QuerySheet("Sheet2","A1")

Note that the cell reference "A1" is in double-quotes, which is the exception to the rule of cells not being in quotes. Therefore, it would be better to 'Name' the cell rather than using the reference, in case you expand/collapse the Income Statement and the Net Income is in a different cell.

In your case, find the Net Income cell from the Income Statement, right-click on it and choose 'Create Named Range'. On the screen that appears, replace 'NewName' with 'NetIncome' (without a space in between the words), click Add to save this, and Done to save the change. Then your formula on the balance sheet can be:

=QuerySheet("Sheet2","NetIncome")

Hello Ryan,

There is a "better" way to accomplish what you need than referencing another sheet (for which you use the =QUERYSHEET() function in the financial reporter).

Just as the financial reporter to calculate the .BALance for the range of account numbers on the income statement. Say that all your P&L acccounts fall in the range of account number 4000 to 6999. You'd then use the formula:

to get the balance calculated over all the P&L accounts with the result returned in a single cell.

Make sense?