Hi EMB,

When exporting a financial statement to Excel, the sheet names in the created Excel workbook come from a combination of the respective sheet name in the Adagio financial statement and the department number selected for the report. The name of the Excel file is the same as the statement group. The individual financial statement file name is not used.

There is a maximum number of characters for the sheet names in Excel. The results you are getting mostly having to do with the fact that the Consolidated Departments text is taking up most of them, and to keep sheet names unique, they are getting suffixed with 1, 2, 3, etc. And the first part having Sheet likely has to do with your financial statement sheet name being Sheet 1 rather than something such as Income Stmt or Bal Sheet.

The first tip would be to change the text for a consolidated department selection to something shorter, which can be done from View / Customize. This would decrease the amount of characters used on the tab name for this, allowing more room for other info. Note that this text may print at the top of statements, so whatever you change this to should also be meaningful.

Secondly, you should rename tabs in your financial statements from Sheet X to something short but also descriptive and meaningful.

Note that if you rename a sheet in a financial statement, that will remove it's selection from statement group items, so you would have to go back and edit the statement group item to re-select the sheet. Not doing that causes that statement to be skipped when exporting, and for me actually crashed the Financial Reporter.