formulas

Formulas

Article Content: This Is A Step By Step Guide On How To create, edit, and apply custom formulas to perform automated calculations in financial statements.

Formulas allow you to perform custom calculations within financial statements by combining rows, values, or other formula elements. They help automate totals, variances, ratios, and other computed fields for more detailed and dynamic reporting.

Step-By-Step

Step 1: Navigate to System Setup → Report Setup → Formulas.

This screen displays all existing formula definitions that can be used across financial reports.


Step 2: To create a new formula, select New.
You can now:
  • Enter a Formula ID and Description
  • Build the calculation by adding formula components
  • Use operations such as:
    • Addition
    • Subtraction
    • Multiplication
    • Division
  • Reference existing row IDs, account totals, or previously created formulas
Once complete, click Save & Close.
Step 3: To edit an existing formula, select the formula from the list.
You may:
  • Modify calculation logic
  • Add or remove formula lines
  • Update descriptions or referenced rows
  • Adjust display settings
After updating, select Save & Close.

Step 4: Formula definitions are maintained on a single General tab, where you configure:
  1. Formula name
  2. Calculation structure
  3. Display formatting
  4. Sequence order

Step 5: Formulas can be inserted into Financial Reports to calculate totals, variances, ratios, margins, or any custom values needed. This ensures more flexible and accurate reporting without manual calculations.

    • Related Articles

    • Financial Reports

      Article Content: This article provides an overview of the financial reports section found under system setup Step-By-Step Step 1: Go to System Setup → Report Setup → Financial Reports. This screen displays a list of all financial reports available in ...

    • Groups

      Article Content: This Is A Step By Step Guide On How To create, edit, and organize groups for Categorizing accounts and reporting elements used in financial statements Groups allow you to categorize and organize accounts, rows, or reporting elements ...