Report Designer: Aligning decimals in a report or financial statement

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

You can use the following steps to correct align amount decimals in columns after editing the report in the Report Designer grid. This typically occurs when formatting at the cell level is inconsistent.

To open a report or financial statement layout for editing, choose File > Report Designer. In the Reports list frame, click the plus (+) sign next to the document type folder to expand the list, and then double-click a report or financial statement layout to open it in the design grid.

Prior to making changes to a report (including letters and financial statements) in the Report Designer, we recommend that you choose File > Save As to save the report with a different name. To restore a predefined report in which changes have been made, you can choose File > Restore Default.

Example of misaligned decimals in an Income Statement

In this example, mixed negative amount formats produces a misalignment of amount decimals in the Total column.

example misalignment of amounts

Follow these steps to correct the misalignment of decimals in amounts within a report.

  1. In the design grid, select the cell(s) in a column that contain misaligned amounts.
  2. Choose Format > Cells to and click the Format tab.
  3. Verify that the format is different than the other cells in the column.
  4. Select Amount in the Category list, and then select the Negative amounts to match the other cells in the amount column.
  5. Choose File > Save As to save the report changes, and preview or print the report to verify that the amounts line up in the report as expected.

See also: Reporting and Report Designer: Procedures

Share This