Related articles

DevelopersAPI guides

Generate a daily earnings report

The daily earnings report provides insight into your trading partners' time-based performance. Primarily this allows you to report on the actual, actual forecast, and accrual earnings over a given time. Primarily, this report is of interest to finance-focused users; you can learn more about the result types here. You can preview and download a full CSV file of any report you run. This article will cover:

An over view is available here:

What data can I extract from the daily earnings report?

  • Trading partner: this will be changed to your systems-specific label, for example, Supplier, Customer, etc. The label change is consistent within the download and preview of the report.
  • Trading partner reference: this will be changed to your systems-specific label, for example, Supplier reference, Customer reference, etc. Each row will have the reference of the trading partner the data is reconciled to.
  • (Optional) Trading program reference: this is the user-set reference on the program line; this is only available if the by program line filter is checked.
  • (Optional) Trading program ID: this will be the system-generated ID available on the settings page of the program denoted by an S. This is only available if the by program line filter is checked.
  • (Optional) Interim trading program?: provides a yes or no identifier to highlight if the program line is part of an interim program. This is only available if the by program line filter is checked.
  • (Optional) Transaction date: only visible when the frequency filter is set to none or daily. See the frequency filter here to learn more.
  • (Optional) Transaction date from: only visible when the frequency filter is set to a weekly, monthly, quarterly, annual, or full period. This is the start of the period the total transacted units and value apply to (inclusive of the selected date).
  • (Optional) Transaction date to: only visible when the frequency filter is set to weekly, monthly, quarterly, annual, or full period. This is the end of the period the total transacted units and value apply to (inclusive of the selected date).
  • (Optional) Program line reference: this is the user-set reference on the program line. This is only available if the by program line filter is checked.
  • (Optional) Program line ID: the system-generated ID for the specific program line denoted by a D. This is only available if the by program line filter is checked.
  • (Optional) Program line type: shows which program line type has been assigned to the program line.
  • (Optional) Mechanism: visible when by program line filter is selected, the name of the mechanism used on the program line will be displayed.
  • (Optional) External reference: when the frequency is set to none, you obtain a transaction-level report allowing the individual external references to be reviewed.
  • (Optional) Dimension data: depending on the view by filter setting, you can increase granularity to levels comparable to your transaction granularity. For each selection made, you will add a corresponding column to the report. You can learn more about the view by filter here.
  • Total transacted units: the total units transacted (actual) for the qualifying earnings for the trading partner for the date (or date range) indicated.
  • Total transacted value: the total value transacted (actual) for the qualifying earnings for the trading partner for the date (or date range) indicated.
  • Effective rate: this is dependent on the result type filter and will include an effective rate for each of the selected result types. Each effective rate column will be labeled with its corresponding result type in brackets, for example, effective rate (actual). Learn more when filtering the daily earnings report.
  • Earnings: this is dependent on the result type filter and will include an effective rate for each of the selected result types. Each effective rate column will be labeled with its corresponding result type in brackets, for example, earnings (actual). Learn more when filtering the daily earnings report.
  • Currency: the currency of the program line.
  • Status: the calculation status of the program line, green, shows no pending calculations. You can hover your cursor over the icon to see the status text.

How to filter the daily earnings report

  • Trading partner: this will be labeled as your trading partner designation (i.e., supplier or customer, etc.). You can individually select one or multiple trading partners. If you have trading partner attribute data, then you can also select groups of trading partners.
  • Transaction date: Filling in the first field sets a from date; the report will only include transactions that occurred after this date set (this is inclusive). The second field sets a date that defines a cut-off point; only transactions ending before this date will be included. This allows you to see transactions (and earnings) based on any period of time. The first and second filter fields can be used independently to only allow transactions before or after a specific date.
  • Trading program status: filter to view trading programs with the active, proposal, interim or archived status or a combination of these options.
  • Program line type: choose from a list of your program line types; leave this as none to select them all.
  • By program line: this will increase the reporting granularity from a trading partner summary to the program line level. This will add multiple fields to each data row providing program and program line information.
  • Currency: select from your channel’s currencies. Leaving this as none will include all currencies as separate rows in the report.
  • Program line: used to filter specific program lines, you can search the list of program lines by description, reference, or ID.
  • Frequency: this changes the report totals to daily, weekly, monthly, quarterly, annual, none, or full period. Please note none will show individual transactions uploaded. You will need to select none to use the reference filters.
  • Program line results type: Choose to filter either actual, accrual or actual forecast program line result types; this will add effective rate and earnings columns for each of the selections made.
  • The actual option will be set as default and will show earnings based on the current effective transactions, and for tired program lines, earnings based on current attainment.
  • The accrual option will show the earnings (accrual) and effective rate (accrual). These earnings are calculated from the total transacted (actual) against the accrual attainment set on a program line (for tired mechanisms).
  • The actual forecast option will show the earnings (actual forecast) and effective rate (actual forecast). These earnings are calculated from the total transacted (actual) against the forecasted attainment set on a program line (for tiered mechanisms).
  • View by: adjust the granularity of the report based on dimension. You can split the earnings reported by ay any granularity across any of your dimensions or included trading partners; each selection will add a corresponding dimension data column to the report. Your selections will be limited to three dimensions.
  • Dimension filters: filter by selecting dimension items or attributes of the report data from the transaction and earnings columns. Learn how to use the dimension filter here.
  • Trading partner on transactions: this will use your label for your trading partner (i.e., supplier or customer etc.). Selecting this will only show earnings, where the trading partners selected are the owners of the transactions. For example, if on your program line, the qualifying transactions include other trading partners, this filter allows you to filter to a specific trading partner's contribution.
  • External reference: a text field your organization manages; this filter lets you do a free text search on the column when the frequency is set to none.
  • Order reference: a text field your organization manages; this filter lets you do a free text search on the column when the frequency is set to none. This field is not included in the report.
  • Delivery reference: a text field your organization manages; this filter lets you do a free text search on the column when the frequency is set to none. This field is not included in the report.
  • Invoice reference: a text field your organization manages; this filter lets you do a free text search on the column when the frequency is set to none. This field is not included in the report.

How to use the dimension filters

The precise format of the dimension filter is influenced by your organization's instance (channel) within Enable. Once a dimension filter is set, only data matching that filter will be included in the report preview or download.

The steps below outline the process of setting the dimension item filter. To simplify the explanation, this example is for a customer with only two dimensions, products, and branches, each with only a single collection.

  1. Click on the filter button.
  2. Click on add.
  3. Select a dimension in the drop-down. For the example above, we can select branches.
  4. (Optional) Select item to add individual items (branches) to include in the report. After making selections click Done.
  5. (Optional) Select attribute you can then select attributes (i.e. groupings) to include multiple items. After making selections click Done. This can be done in addition to step 4.
  6. Click on add to create a new dimension filter.
  7. Repeat steps 2-6 for each dimension you wish to filter on. The report will only include data that meet the conditions defined by each filter.

Not useful
1
2
3
4
5
Very useful
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Still have questions?
Raise a ticket or contact our support team.