A couple of general questions re common Financial Rpeorts:
1. Balance sheet.
When including the line for current earnings (sum of all the Income Statement accounts),
- In the tree, should this range be set as type Income Statement and marked Revenue?
- When dragged into the spreadsheet, the same formulas are created as for the other balance sheet accounts (GLDATA.BAL for current year and GLDATA.BAL_PY for previous year, for example). Should these be changed to the Net Changes formulas (GLDATA.Y and GLDATA.YY in the above cases)? This seems to give the correct results.
2. Income Statement
Do you generally find it is better/easier to:
- Not include a total line for the income statement and make your own (simple) formulas, or
- Include the total line and allow the wrong formula to be created in the spreadsheet, then modify it?
Thanks in advance.