Importing a financial statement workbook

Financial statement workbooks that other employees create automatically appear in your Financial Statement Design window.

You need to import a workbook only when another person (such as your consultant) creates the workbook in a different database and then exports it for your use.

Note:
  • If the imported design contains a custom date property, only the property label imports; none of the other property options are included. You must re-create the custom date property.

Example

A custom date property contains the description January 2011 and the dates January 1, 2011, and January 29, 2011. The imported design displays [January2011] in the worksheet, but no financial information appears for that property because no other property options were included. You must re-create the custom date property using January 2011 as the description and January 1, 2011, and January 29, 2011, as the dates.

  • If the imported design contains a company logo, the logo is embedded into the design; it is not an active link to the Ajera database. You may need to delete and add the logo property back into the design to ensure that the company logo you want appears.

To import a financial statement workbook:

  1. Save the workbook you want to import to a location accessible to you.
  2. From the > Reports menu, click Manage Financial Statements > Designs. A blank worksheet appears.
  3. On the Design tab, click the Import button.
  4. Browse to the location where the workbook is stored. An exported workbook has a file extension of .fsd to indicate that it is an Ajera Financial Statement Designer spreadsheet document.
  5. Select the workbook and click Open. The workbook appears in the Financial Statement Designer.
Note: If the workbook you want to import is from an earlier version of the Financial Statement Designer, a window appears asking if you want to update the design. Click Yes. Review the workbook properties as some options may have changed.
  1. Click Save or Save As to save the workbook. The workbook appears in the Financial Statement Design window for anyone with access to that window.