Account-based Calculation Rule

Account-based calculations read and aggregate the values posted to specific combinations of accounts, flow types, and audit members in order to post the aggregated amount under an alternate destination account, flow and audit member combination.

Features

The following dimensions can be specified in order to define source and target members in the calculation:

  • Category (C-type dimension)

  • Account (A-type dimension)

  • Flow (S-type dimension)

  • Datasource (D-type dimension)

The account-based calculations business rule can invert the sign when posting calculated amounts when appropriate, which alternates debit and credit amounts.

This rule can also use reference data in other periods and years to determine amounts to post.

This rule also supports year-to-date calculations in period-based models.

You can utilize account-based calculations in both financial and legal consolidation models.

Example

You can use this business rule to calculate and post values that you need for cash flow reporting.