Field descriptions: Financial Report Writer Format tab

Negative numbers

Determines how negative numbers appear (for example, showing a leading dash (-) sign). This applies to all output formats, and ensures that the numbers align correctly in the report. No other formatting, such as font and font size, is allowed.

Rounding

Rounds numbers to the nearest 1, thousand, or million.

Align currency symbol

Specifies whether to place currency symbols to the left of the column or just to the left of the number.

Show exchange rates

Applies to Global Consolidation companies, for reports that show consolidation data for a single month for 1 or more entities.

In this case, Show exchange rates enables you to optionally include exchange rates at the top of each entity column. You can display the ending spot rate, weighted average rate, or both.

Display zero balance with activity

Shows detail rows that have zero balances, as long as there were transactions posted during the reporting period.

Display zero for future periods

Shows zero amounts for any column where the reporting period is in the future.

This feature is useful if your report is set up for 12 months, but you only want to see actual amounts for the past and current periods, even if there are future transactions. If, for example, you have a report set up with columns for every month of the year, and you run the report as of June 30, then even though your columns contain actual amounts, you can see numbers for future dates, such as for the Month Ended July. However, you can select this checkbox to zero all the future numbers and clean up your report.

Display zero balance columns

Deselecting this option automatically hides any columns that have only zero amounts. This can be particularly useful if you sometimes compare report data by time period or dimension (such as department or project) and you want to automatically hide any columns that do not have data.

Show departments

Choose whether to display departments by name only, by ID only, or by name and ID.

Show locations

Choose whether to display locations by name only, by ID only, or by name and ID.

Show other

Choose whether to display other dimensions by name only, by ID only, or by name and ID.

Sorting (alphabetically sort Department or Location Group)

If you filter the report by a department or location group, the report automatically displays departments and locations in the order in which they are defined in the group. Select this option if you prefer to sort departments and locations alphabetically.

Logo options

PDF

If you uploaded a logo to the Company Information page, you can include your logo at the top of the report, aligned to the left, top, or center.

If you have not uploaded your logo, you can do so by going to Company > Company Info> General information tab > [Edit], then scroll to Printed logos and text.

Report title

PDF
HTML
Excel

Enter the title you want to display on the report. By default, the report uses the report name that you entered in the Report Info tab as the title

Subtitle 1 and Subtitle 2

PDF
Excel

For all new reports, Subtitle 1 displays as:

As of [As_of_Date_in_Word]

This displays the words "As of" followed by the date spelled out in words (as in "March 31, 2012").

You can enter your own text in either Subtitle 1 or Subtitle 2, and have the option to use the following variables to dynamically include the date either spelled out in words or numerically.

• [As_of_Date_in_Word]
• [As_of_Date]

Title comment

PDF
HTML
Excel

Enter an optional comment that will display aligned left just above the report body.

Company title -- Display locations as company title on individual reports

PDF

By default, your company name (as entered in the Company information page) is displayed at the top of the page header of printed reports and reports exported to Excel. However, suppose that you're splitting a report that compares data by location into multiple individual reports. In this case, you can choose to display the location name in the report title, instead of the company name.

This option applies only if you generated individual reports by location.

Align location title

PDF

When you split a report that compares data by location into multiple individual reports, you can specify an extended title that describes each location, which is then added to the top of each individual report. This option determines whether the titles should be aligned left, middle, or right.

This option applies only if you:

• Added titles for your departments or locations
• Generated individual reports by department or location

The footer information that you select appears in both PDF and Excel output. In Excel output, the footer is always left-aligned.

By default, the items you selected for the footer (page number, date, and time) and entered in the footer text field appear on all pages of the report. Deselect this checkbox if you want these items to appear only on the first page.

Default page settings

This is the default setting. Column size and breaks are determined automatically, but you can change the report orientation from Portrait to Landscape to fit more columns on the page.

Fit to x pages wide

This setting lets you specify the report width in pages (for example, fitting it to 1 page wide), but column widths are still set automatically.

Page orientation

By default, pages are set to Portrait. Select Landscape to change the orientation of the report pages.

Measurement

If you select Custom page size, column widths, and column breaks you can choose to measure margins and column widths in points or inches.

Custom page size, column widths, and column breaks

This setting lets you choose a different page size, set column widths, and set page margins.

Width
(PDF only)

Width of the column on printed (PDF) reports. Not available if you chose Default page settings.

Break
(PDF only)

Places a page break after the selected column, on printed (PDF) reports.

Available only if you chose Custom page size, column widths, and column breaks.

Font

Size

Bold
Italic

Hide heading

Omits the section heading.

Center heading (print only)

Centers the section heading across the report.

Blank lines above (print only)

Inserts empty rows before the section heading.

Page break after (print only)

Inserts a page break after the total for the section.

Hide totals

Hides the total title and amount line. To suppress the totals for all lines, select All at the top of the column.

Blank space above

Lets you insert up to nine blank lines before the line that contains the total.

Hide separator above totals

Hides the separator that appears above the line that contains the total.

Underline totals

Controls whether the total is underlined, and how many underlines are displayed.

By default, account groups are underlined as follows:

• Top-level account groups: Double underline
• One level down: Single underline
• Other levels: No underline

Show on details

Show on totals