6.3.1.2.3.1.1 Management Ledger Source
This section describes using the Management Ledger as the Source in Allocation Rules.
The Management Ledger is a Seeded Table of a new Management Ledger Class of Tables (see the Data Model Extension Guide for details on adding User-Defined Dimensions to the Management Ledger or for defining new User-Defined Management Ledger Tables.)
When your Source is the Management Ledger Table, use the <Current Amount> macro as your column name. The Management Ledger Table is the default table for new Allocation Rules (except for the Constant type), and <Current Amount> is the default column. The <Current Amount> macro selects the current month from your Management Ledger based on your As-of-Date and Fiscal Year definitions. If your As-of-Date is set to any day in March, <Current Amount> is interpreted as Fiscal Month 3. If your fiscal year begins in April, your March data is stored in the Management Ledger under Fiscal Month 12, since March is the last month in your Fiscal Year.
Note:
Allocation Rules that aggregate instrument-level data to the Management Ledger Table maintain literal As-of-Dates when posting to the Management Ledger, but when data is retrieved from the Management Ledger Table (such as in Allocation Sources or Allocation Drivers), it is consolidated into a month-to-date balance. For example, if you perform daily instrument-level Funds Transfer Pricing and if you use an Allocation Rule to aggregate daily Funds Transfer Pricing Charges or Credits from the instrument level to the Management Ledger, each day's charges and credits are posted to the Management Ledger by As-of-Date (by business date). Allocation Rules that reference these Management Ledger balances, however, combine the daily postings to obtain month-to-date balances. Similarly, all outputs at the Management Ledger level are inherently month-to-date balances.When your Source is the Management Ledger table, the following macros are supported:
- <Current_Amount>
- <Last_Mo_Amount>
- <Last_Mo_YTD_Amt>
- <Months_Ago_Amt>
- <Months_Ago_Avg_Amt>
- <Months_Ago_YTD_Amt>
- <YTD_Amount>
<Current_Amount> - selects the current month balances based on your execution As-of-Date month.
<Last Mo_Amount> - selects month-to-date balances from the month immediately before your execution As-of-Date month.
<Months_Ago_Amount> - selects month-to-date balances as of a designated number of months ago from your execution As-of-Date month. For example, with a typical January to December fiscal year, if today's As-of-Date is March 31, 2026 (Fiscal Month = 3, Fiscal Year = 2026) and in the “Enter Months” field, enter 6 months ago. This corresponds to September 2025 (Fiscal Month = 9, Fiscal Year = 2025). The month range for entering Months is from -99 to 999.
<Months_Ago_Avg_Amt> - calculates the monthly moving average starting with the execution As-of-Date month (that is, including the current month) and going a designated number of months backwards. If the data for a whole month is missing in the Management Ledger table, the Moving Average calculation includes the data only for the available months within the specified number of months input in the “Enter Months” field. This macro is available only for Static Driver rules to be used only in the Source tab. For example, with a typical January to December fiscal year, if today's As-of-Date is March 31, 2026 (Fiscal Month = 3, Fiscal Year = 2026) and if the “Enter Months” field is input with 6 months. Then this corresponds to 6 months moving average starting from March 2026 to October 2025. Now suppose, if there is no data for January 2026, then also, the average will happen with the 5 months data from October 2025 to March 2026.
Note:
When you select any of these macros, the Entered_Balance column in the Management Ledger Table is selected.