After attending two webinars on Financial Reporter I finally am getting the reports to work close to what the bank wants from us, however how do I get the Earnings/Loss as calculated on the income statement to copy over the the balance sheet to show a balanced sheet? I am using a formula of total income less total expenses = net earnings/loss on the income statement. Also the heading "assets" at the top of the balance sheet stays on the top of all pages so it shows as a heading for liabilities. Any ideas where I've gone wrong?

Hi Sammy,

If I understand the question, you want the value from a cell on one sheet to appear on a different sheet within the same Financial Reporter workbook?

If so, then there is a formula to do this, and it's different than how you would do this in Excel.
=Querysheet("Sheet name","Cell") is the syntax.

eg =Querysheet("Income Statement","H123") would read the value from the cell H123 on the sheet named 'Income Statement'.

If the Income Statement sheet uses Expand/Collapse, then H123 may or may not contain the amount you need. So what you should do is create a 'named range' for the cell that contains the Earnings/Loss from the Income Statement. To do this, open your Income Statement and right-click on your Earnings/Loss cell. Choose 'Create named range' from the pop-up. Replace the text 'NewName' with something like 'Earnings', click the Add button to save, and then Done to close.

Then modify the formula above to reference the cell 'name' instead of the location:
=Querysheet("Income Statement","Earnings")

Note that you cannot do this for an entirely different workbook - it must be a different sheet in the same workbook. If your Income Statement and Balance Sheet are in separate files, you can import one of them into the other, using the File / Import Workbook function - with one statement open, import the other one.
--
As for your question regarding the 'Assets' header, the reason it is repeating with all the other title information is that it is within the set of 'header' rows that are Frozen and print at the top of each page. To adjust, you need to Unfreeze the rows (from Format / Rows / Unfreeze), re-adjust the rows to be in the order required - drag rows as necessary - and then re-select the first N rows that you want to repeat and Freeze (Format / Rows / Freeze).

Glad to hear the webinars are helping out!

hi sammy,

Another way of getting the "net profit (loss)" line on your balance sheet is to get the BAL value for all the Income accounts summed together. Say your P&L accounts lie between 4000 and 8999. Use "4000:8999" as the account range.

Andrew: Thanks that what I figured out. As to the header, I did not unfreeze and that was hanging me up. Thanks for all the help.