Table of Contents






Actualization Tab UI Elements

The Actualization tab displays information related to actualizing committed Cost Lines.

The Actualization tab contains the following elements:


Item

Description

1Campaign Header

2Standard and Margin selection

Click to switch between the Standard Actualization grid and the Margin Actualization grid.

3

Filters icon

Click the Filters icon to open the filter pane and filter through the list of all committed Cost Lines within the campaign.

4

Search bar

Search for a Cost Line by Entity (Supplier or Order Partner) or ID.

5

Roll settings

Click the Roll settings to select how any under- or over-delivery balance is carried over to future months:

  • None: The balance is not distributed. Instead, the overall totals on the Schedule Grid line are updated
  • Proportionally: The balance is evenly distributed over the remaining months of the campaign
  • Next Month: The entire balance is carried over to the next month of the campaign
  • Last Month: The entire balance is carried over to the final month of the campaign

For more information, see Types of Delivery Balance Roll

6

Apply Source button


 

On the Standard Actualization grid, click the Apply Source button to update the values in the Actual Cost for Period, Actual Units, and Actual Rate columns.

Source options:

  • Committed
  • Site
  • 3rd Party
  • Media (only applies to Assigned fees)

For more information, see Types of Actual Value Sources.

On the Margin Actualization grid, click the Apply Source button to update the values in the Vendor Net Cost (VC), Client Net Cost (VC), Actual Units, and Margin % columns.

Source option:

  • Media (only applies to Assigned fees)

For more information, see Types of Actual Value Sources.

7

Actualize button


If no Actualization grid lines are selected, the Actualize button is inactive.

If one or more Actualization grid lines are selected, the Actualize button is active.

Click the Actualize button to actualize the selected lines.

8

Billing Period(s) filter

Click the Billing Period(s) filter to select the billing periods that are displayed in the Actualization grid.

By default, only one billing period (month) is selected and displayed on the Actualization grid.

  • If the campaign is in-flight, the default billing period is the previous month of the campaign
  • If the campaign has not started yet, the default billing period is the first month of the campaign
  • If the campaign has already finished, the default billing period is the last month of the campaign
9

Actualization grid

A list of a campaign's committed Cost Lines, grouped by order and broken down into selected billing periods.

For more information, see Actualization Grid Reference.


Actualization Grid Reference

The Actualization grid is a list of a campaign's committed Cost Lines, grouped by order and broken down into the selected billing period(s). By default, only one billing period (month) is selected:

  • If the campaign is in-flight, the default billing period is the previous month of the campaign
  • If the campaign has not started yet, the default billing period is the first month of the campaign
  • If the campaign has already finished, the default billing period is the last month of the campaign

There are two types of Actualization grids:

  • Standard Actualization grid: Used to actualize standard Cost Lines
  • Margin Actualization grid: Used to actualize margin Cost Lines

Standard Actualization Grid Reference

The Standard Actualization grid is used to actualize standard Cost Lines, Cost Lines that have a Cost Method value of Standard.

The table below describes the Standard Actualization grid columns:


Margin Actualization Grid Reference

The Margin Actualization grid is used to actualize margin Cost Lines, Cost Lines that have a Cost Method value of Margin.

The table below describes the Margin Actualization grid columns:


Actualization Grid Reference

Column Name

DescriptionLine Type: OrderLine Type: Cost LineLine Type: Billing PeriodActualization Grid Type
Line Type

The type of the Actualization grid line, according to the following hierarchy:

  • Media
    • Order
      • Cost Line (Cost Package, Media Package, Placement) 
        • Billing Period
  • Non-Media
    • Order
      • Cost Line (Fee)
        • Billing Period

N/A

N/A

N/A

Standard,

Margin

Status (Actualization Status)



The actualization status of the Actualization grid line.

The possible actualization statuses are:

  • Not Actualized: None of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata

  • Partially Actualized: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata

  • Actualized: All of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata


The possible actualization statuses are:

  • Not Actualized: None of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata

  • Partially Actualized: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata

  • Actualized: All of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata


The possible actualization statuses are:

  • Not Actualized: The Billing Period line is not actualized in OneStrata

  • Actualized: The Billing Period line is actualized in OneStrata

Standard,

Margin

Invoice Status

The invoice status of the Actualization Grid line.

The possible invoice statuses are:

  • Not Invoiced: None of the Billing Period lines displayed under the Order line or Cost Line are invoiced

  • Partially Invoiced: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are invoiced

  • Invoiced: All of the Billing Period lines displayed under the Order line or Cost Line are invoiced


The possible invoice statuses are:

  • Not Invoiced: None of the Billing Period lines displayed under the Order line or Cost Line are invoiced

  • Partially Invoiced: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are invoiced

  • Invoiced: All of the Billing Period lines displayed under the Order line or Cost Line are invoiced


The possible invoice statuses are:

  • Not Invoiced: The Billing Period line is not invoiced (no invoice has been created for the billing period)

  • Invoiced: The Billing Period line is invoiced (an invoice has been created for the billing period)

Standard,

Margin

Entity Name

The name and identification number of the entity associated with the Actualization grid line.

The displayed values are:

  • Order Partner: The name of the Order Partner of the order. Click the Entity Name link to open the Order Details page of the order.
  • Order ID: The OneStrata-generated identification number of the order

The displayed values are:

  • Supplier: The Supplier entity assigned to the Cost Line

  • Cost Line ID: The OneStrata-generated identification number of the Cost Line

This displayed values are:

  • Month & Year: The calendar month and year of the Billing Period line

  • Billing Period ID: The OneStrata-generated identification number of the Billing Period line

Standard,

Margin

Line Name

The name of the Actualization grid line.

N/A

The name of the Cost Line.

Copied from the media schedule.

N/A

Standard,

Margin

External ID


The external identification number of the Actualization grid line.

N/A

N/A

The identification number used by the external financial system to reference the Billing Period line.

Only available if the Billing Period line has been exported to an external financial system.

Standard,

Margin

Start and End Date


The start and end dates of the Actualization grid line.

N/A

The start and end dates of the Cost Line.

Copied from the media schedule.


The start and end dates of the Billing Period line.

Copied from the media schedule.

Standard,

Margin

Contract Total

The total committed vendor cost of the Actualization grid line.


The total committed vendor cost of the entire order.

Copied from the order.

The total committed vendor cost of the Cost Line.

Copied from the media schedule. 

The committed vendor cost of the Billing Period line.

Copied from the media schedule.

Standard,

Margin

Rate Type


The rate type of the Actualization grid line.

N/A

The Rate Type of the Cost Line.

Copied from the media schedule.

N/A

Standard,

Margin

Rate


This value is part of a triangulation set.

For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.


The committed vendor rate of the Actualization grid line.

N/A

The committed vendor rate of the Cost Line.

Copied from the media schedule.

The committed vendor rate of the Billing Period line.

Copied from the media schedule.

Standard,

Margin

Client Net Rate (VC) 

The Client Net Rate (VC) of the Actualization grid line.


N/A

The client net rate of the Cost Line.

Copied from the media schedule.

The client net rate of the Billing Period line.

Copied from the media schedule.

Margin

Units

The total number of committed units for the Actualization grid line.

The total number of committed units for the entire order.

The total number of committed units for the Cost Line.

Copied from the media schedule.

The number of committed units for the Billing Period line.

Copied from the media schedule.

Standard,

Margin

Current for Period

The committed vendor cost of the Actualization grid line, for the selected billing period(s).

The committed vendor cost of the order, for the selected billing period(s).

The committed vendor cost of the Cost Line, for the selected billing period(s).

The committed vendor cost of the Billing Period line

Standard,

Margin

Pre-Actualized

The pre-actualization vendor cost of the Actualization grid line, for the selected billing period(s).

If the line has never been actualized, the Pre-Actualized value is equal to the Current for Period value.

Once the line is actualized, the Pre-Actualized value becomes locked and no longer changes, even if the Current for Period value (which is copied from the media schedule) changes.

For example, imagine a Cost Line that has never been actualized:

  • Its Current for Period value is $100.
  • Its Pre-Actualized value is set to whatever the Current for Period value is, which is $100.
  • If the Cost line's Current for Period value changes, its Pre-Actualized value also changes.

Then, the Cost line is actualized:

  • At the time of actualization, its Current for Period value is $100.
  • The Pre-Actualized value is locked to $100.
  • Afterwards, if the Cost Line's Current for Period value changes (for example, it increases to $125), its Pre-Actualized value does not change.

The pre-actualization vendor cost of the order, for the selected billing period(s).

The pre-actualization vendor cost of the Cost Line, for the selected billing period(s).

The pre-actualization vendor cost of the Billing Period line.

Standard,

Margin

Balance

The cost balance (the difference between the actualized and committed values) of the Actualization grid line, for the selected billing period(s).

Balance = Actual Cost for Period - Current for Period

The cost balance of the order, for the selected billing period(s).

The cost balance of the Cost Line, for the selected billing period(s).

The cost balance of the Billing Period line.

Standard,

Margin

Actual Source

The source(s) of the Actualization grid line's Actual Cost for Period, Actual Rate, and Actual Units values.

For more information, see Types of Actual Value Sources.

The source(s) of the actual values of the order.

The source(s) of the actual values of the Cost Line.

The source(s) of the actual values of the Billing Period line.

Standard

Actual Cost for Period


The actual vendor cost of the Actualization grid line, for the selected billing periods(s).

When a Billing Period line is actualized, this value is sent to the external finance system.

The actual vendor cost of the order, for the selected billing period(s).

The actual vendor cost of the Cost Line, for the selected billing period(s).

The actual vendor cost of the Billing Period line.

Standard

Actual Rate


The actual vendor rate of the Actualization grid line.

When a Billing Period line is actualized, this value is sent to the external finance system.

If the Actual Source value is Site, 3rd Party, or Media, the value of Actual Rate is calculated according to the following formula:

Actual Rate = Actual Cost / Actual Units

N/A

The actual vendor rate of the Cost Line.

The actual vendor rate of the Billing Period line.

Standard

Actual Units 


The number of actual units for the Actualization grid line, for the selected billing periods(s).

When a Billing Period line is actualized, this value is sent to the external finance system.

N/A

The number of actual units for the Cost Line, for the selected billing period(s).

The number of actual units for the Billing Period line.

Standard


Calculated Fee Cost

This value only applies to Assigned fees.

The system-calculated vendor cost of the Assigned fee, for the selected billing period(s).

For more information, see Media (Source).

The system-calculated vendor cost of the Assigned fee's order, for the selected billing period(s).

The system-calculated vendor cost of the Assigned fee, for the selected billing period(s).

The system-calculated vendor cost for the Assigned fee's Billing Period line.

Standard

Fee Calculated Units

This value only applies to Assigned fees.

The system-calculated number of units of the Assigned fee, for the selected billing period(s).

For more information, see Media (Source).

The system-calculated number of units of the Assigned fee's order, for the selected billing period(s).

The system-calculated number of units of the Assigned fee, for the selected billing period(s).

The system-calculated number of units for the Assigned fee's Billing Period line.

Standard

Site Cost


The vendor delivery cost of the Actualization grid line for the selected billing period(s), as retrieved from the Site source (if any).

For more information, see Site (Source).

The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Site source.

The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Site source.

The vendor delivery cost of the Billing Period line, as retrieved from the Site source.

Standard

Site Units


The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Site source (if any).

For more information, see Site (Source).

The number of delivered units for the order, for the selected billing period(s), as retrieved from the Site source.

The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Site source.

The number of delivered units for the Billing Period line, as retrieved from the Site source.

Standard

3rd Party Cost


The vendor delivery cost of the Actualization grid line for the selected billing period(s), as retrieved from the Ad Server provider (if any).

For more information, see 3rd Party (Source).

The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Ad Server provider.

The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.

The vendor delivery cost of the Billing Period line, as retrieved from the Ad Server provider.

Standard

3rd Party Units


The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Ad Server provider (if any).

For more information, see 3rd Party (Source).

The number of delivered units for the order, for the selected billing period(s), as retrieved from the Ad Server provider.

The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.

The number of delivered units for the Billing Period line, as retrieved from the Ad Server provider.

Standard

Vendor Net Cost (VC)


The Vendor Net Cost (VC) of the Actualization grid line, for the selected billing period(s).

The vendor net cost of the order, for the selected billing period(s).

The total vendor net cost of the Cost Line, for the selected billing period(s).

The vendor net cost of the Billing Period line.

Margin

Margin %


The Margin % of the Actualization grid line, for the selected billing period(s).

N/A

The average margin percentage of the Cost Line, for the selected billing period(s).

The margin percentage of the Billing Period line.

Margin

Client Net Cost (VC)


The Client Net Cost (VC) of the Actualization grid line, for the selected billing periods(s).

N/A

The client net cost of the Cost Line, for the selected billing period(s).

The client net cost of the Billing Period line.

Margin

Actual Units


The number of actual units for the Actualization grid line, for the selected billing periods(s).

N/A

The number of actual units for the Cost Line, for the selected billing period(s).

The number of actual units for the Billing Period line.

Margin

Fee Calculated Vendor Cost

This value only applies to Assigned fees.

The system-calculated vendor cost of the Assigned fee, for the selected billing period(s).

For more information, see Media (Source).

The system-calculated vendor cost of the Assigned fee's order, for the selected billing period(s).

The system-calculated vendor cost of the Assigned fee, for the selected billing period(s).

The system-calculated vendor cost for the Assigned fee's Billing Period line.

Margin

Fee Calculated Client Cost

This value only applies to Assigned fees.

The system-calculated client cost of the Assigned fee, for the selected billing period(s).

For more information, see Media (Source).

The system-calculated client cost of the Assigned fee's order, for the selected billing period(s).

The system-calculated client cost of the Assigned fee, for the selected billing period(s).

The system-calculated client cost for the Assigned fee's Billing Period line.

Margin

Fee Calculated Units

This value only applies to Assigned fees.

The system-calculated number of units of the Assigned fee, for the selected billing period(s).

For more information, see Media (Source).

The system-calculated number of units of the Assigned fee's order, for the selected billing period(s).

The system-calculated number of units of the Assigned fee, for the selected billing period(s).

The system-calculated number of units for the Assigned fee's Billing Period line.

Margin

Other Income (VC) 


The margin amount (the difference between the Client Net Cost (VC) and Vendor Net Cost (VC) values) of the Actualization grid line, for the selected billing period(s).

Other Income (VC) = Client Net Cost (VC) - Vendor Net Cost (VC)

The margin amount of the order, for the selected billing period(s).

The margin amount of the Cost Line, for the selected billing period(s).

The margin amount of the Billing Period line.

Margin

Invoiced Amount 

The sum of all invoices that have been matched or cleared against the Actualization grid line, for the selected billing period(s).

The sum of all invoices that have been matched or cleared against the order, for the selected billing period(s).

The sum of all invoices that have been matched or cleared against the Cost Line, for the selected billing period(s).

The sum of all invoices that have been matched or cleared against the Billing Period line.

Standard,

Margin

Cleared Invoiced Amount 

The sum of all invoices that have been cleared against the Actualization grid line, for the selected billing period(s).

The sum of all invoices that have been cleared against the order, for the selected billing period(s).

The sum of all invoices that have been cleared against the Cost Line, for the selected billing period(s).

The sum of all invoices that have been cleared against the Billing Period line.

Standard,

Margin