Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Report Designer

Change the sign of account balances

You can change how numbers appear in your report. This can make your reports easier to read and understand, especially when dealing with expenses or losses.
Sometimes you might want to flip the sign of numbers in your report. For example, changing a negative to a positive, changing how a negative amount is presented, or choosing between numerals or ordinal words. Follow these steps to change the sign of account balances.
  1. Select
    File
    , then
    Report Designer
    .
  2. Select the
    +
     next to the document type folder.
  3. Double-click a report to open it.
  4. Save a backup (recommended):
    1. Select
      File
      , then
      Save As
      .
    2. Give your report a new name.
  5. Select the cell you want to change.
  6. Select
    Format
    ,
    Cells
    , then the
    Format
     tab.
    • Select
      Amount
       in the Category list, then mark the
      Multiply by -1
       checkbox. This changes a positive to a negative or a negative to a positive.
    • Select
      Amount
       in the Category list and choose whether numbers are represented using numerals or ordinal words (the difference between 99 and ninety-ninth).
    • Select
      Amount
       in the Category list and use the dropdown for
      Negative Amounts
       to change how negatives are displayed. You can choose between a minus sign, parenthesis, and red text.
  7. Select
    File
    , then
    Save As
     to save your changes.

This article applies to:

  • Product: Accounting CS, Workpapers CS
  • Subject: Reports