About the Fiscal Designator

When you use the Statement Designer to edit a Microsoft Excel worksheet, an Add-Ins tab appears on the Excel ribbon. On this tab, the FR menu displays commands you can use to create and edit financial reports and specifications.

The FR Paste command appears on this menu. On the FR Paste Function screen, the Fiscal Designator is a drop-down list that appears for the FRAMT, FRAMTA, FRDEBIT, FRCREDIT, FRTRN, FRTRNA, FRTRNCR, and FRTRNDR functions. The list shows the fiscal set options you can select:

The FRTRN, FRTRNA, FRTRNCR, and FRTRNDR functions include only the following options:

  • A. Actual monetary figures
  • Q. Quantities (either actual or provisional)
  • QA. Actual quantities

Whether actual or provisional figures or quantities appear depends on the default you select on the Preview Financial Statements screen at the time you print a report.