Use * syntax for faster search

Versions Compared

Old Version 5

changes.mady.by.user Hub Admin

Saved on

compared with

New Version 6

changes.mady.by.user Hub Admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Section


Column
width50%


Panel
borderColor#c8c8c8
borderWidth1
borderStylesolid

Table of Contents

Table of Contents
maxLevel2
indent20px
stylenone



Column
width50%




Overview

OneStrata has a large number of fields and terms related to costs and cost calculations, in order to effectively handle complex pricing scenarios that may involve multiple types of currencies.

  • Cost methods: The cost method defines what types of cost-related fields interact in which types of ways, in order to determine what is billed to the client, what is paid to the vendor, and what is income to the agency
  • Agency, Client, and Vendor Currencies: What type of currency or currencies the agency, client, and vendor transact in.
  • Cost Types: Cost- and rate-related fields

Anchor
Cost-Methods
Cost-Methods
Cost Methods

Cost methods define what type of cost-related fields are available, and how they are calculated. Depending on the selected cost method option, some cost-related fields are related and can be calculated from each other, and some fields are not. 

Each top-level line on a Schedule Grid (a Cost Package, a standalone Media Package that is not part of a Cost Package, or a standalone Placement) can apply a different cost method.

There are three cost method options:

  • Standard: Available for all OneStrata enterprises by default

  • Margin: Gated and managed by FreeWheel, available on request

  • Allocated: Available for all OneStrata enterprises by default 
Cost MethodDescription

Anchor
Standard-Cost-Method
Standard-Cost-Method
Standard Cost Method

Vendor costs and client costs are connected: Vendor Gross Cost = Client Gross Cost

If one set of vendor or client costs (a combination of Unit and Rate, Unit and Total Cost, or Rate and Total Cost) are defined, all other Cost Types, like Client Commission or Vendor Discount, can be calculated from that set.

Anchor
Margin-Cost-Method
Margin-Cost-Method
Margin Cost Method

Vendor costs and client costs are not directly connected, and are calculated separately: Vendor Net Cost =/= Client Net Cost

If one set of vendor costs are defined, the other vendor cost types can be calculated from that set but the client cost types cannot, and vice versa.

Vendor and client costs are connected by a third value, the Margin Percentage value:

  • Vendor Net Cost = Client Net Cost - (Client Net Cost x Margin Percentage)
  • The difference between the Vendor Net Cost and the Client Net Cost creates a "margin", which is income to the Agency. This amount is captured in the Other Income value.

Anchor
Allocated-Cost-Method
Allocated-Cost-Method
Allocated Cost Method

The client has allocated, or set aside, a fixed amount of budget to cover both the cost of the media and any related agency fees.

Costs are calculated in the following order:

  1. The Allocated Amount is entered.
  2. The Allocated Fee Cost is calculated and subtracted from the Allocated Amount. The difference is the Client Net Cost.
    1. Client Net Cost = Allocated Amount - Allocated Fee Cost
  3. All other costs and rates are calculated from the Client Net Cost, similar to the Standard cost method option.


 

Anchor
Currencies
Currencies
Currencies

OneStrata provides support for up to three different currencies within a single transaction:

  • Agency Currency, or AC for short
  • Client Currency, or CC for short
  • Vendor Currency, or VC for short

Costs and rates are shown in one or more of these currencies, with AC, CC, orVC appended to indicate which currency type the value is in.

Currency TypeDescriptionOrigin

Anchor
Agency-Currency
Agency-Currency
Agency Currency

AC

Base Currency

Local Currency


A Shared Block
shared-block-keyAgency-Currency

The currency in which the Agency transacts. All cost lines in a campaign must be in the same Agency Currency.


Agency Currency is defined on the Agency record, on the Administration > Entity Management > Agencies > (Specific Agency) > Details tab.

Each Agency has only one Agency Currency.

Anchor
Client-Currency
Client-Currency
Client Currency

CC

Billing Currency


A Shared Block
shared-block-keyClient-Currency

The currency in which the Agency bills the Client. All cost lines in a campaign must be in the same Client Currency.


Client Currency is defined on the Client record, on the Administration > Entity Management > Clients > (Specific Client) > Details tab.

Each Client has only one Client Currency.

Anchor
Vendor-Currency
Vendor-Currency
Vendor Currency

VC

Payable Currency



A Shared Block
shared-block-keyVendor-Currency

The currency in which the Agency pays the Vendor. Each cost line in a campaign can be in a different Vendor Currency.


Vendor Currency is defined on the Contract record, on the Administration > Entity Management > Contracts > (Specific Contract) tab.

A Contract may have one or more Vendor Currencies.


Anchor
Cost-Types
Cost-Types
Cost Types

In OneStrata, cost types—fields related to calculating costs—are broadly grouped into three types:

  • Client costs: Costs between the agency and the client
  • Vendor costs: Costs between the agency and the vendor
  • Other costs: Non-client-related and non-vendor-related costs

When a cost type is displayed or used, it specifies which type of currency the cost type is in:

  • Example: Vendor Net Cost (VC) refers to the vendor net cost, displayed in the Vendor Currency
  • Example: Vendor Net Cost (CC) refers to the vendor net cost, displayed in the Client Currency
 
  • Vendor Gross Cost:
    • Table Filter
    totalrow,,,,
    hidelabelsfalse
    sparkNameSparkline
    hidePaneFiltration panel
    sparklinefalse
    isFirstTimeEntertrue
    cell-width250
    hideColumnsfalse
    customNoTableMsgfalse
    disabledfalse
    enabledInEditorfalse
    globalFilterfalse
    id1708356776579_2072945891
    order0
    hideControlsfalse
    inversefalse
    columnCost Type Group
    disableSavefalse
    separatorPoint (.)
    labelsCost Type Group
    ddOperatorOR
    datepatterndd M yy
    updateSelectOptionsfalse
    worklog365|5|8|y w d h m|y w d h m
    isORAND


    Vendor Discount Percentage

    Vendor Discount Rule

    Vendor Discount %

    The percentage of Vendor Net Cost or Vendor Gross Cost that the Vendor gives as a discount.

    Vendor Net Cost: include-shared-block-inline
    Cost Type GroupCost TypeDescriptionOriginCalculation (Standard Cost Model With 1 Tax)
    Client

    Anchor
    Client-Commission-Cost
    Client-Commission-Cost
    Client Commission Cost

    Client Commission


    A Shared Block
    shared-block-keyClient-Commission-Cost

    The amount of commission that the client is charged.


    		CalculatedClient Commission = Client Commission Percentage x Client Commission Basis
    Client

    Anchor
    Client-Commission-Percentage
    Client-Commission-Percentage
    Client Commission Percentage

    Client Commission Rule

    Client Commission %

    Commission Percent



    A Shared Block
    shared-block-keyClient-Commission-Percentage

    The percentage of commission that the client is charged.


    Defined on the Administration > Entity Management > Clients >(Specific Client) > Commissions tab

    		N/A
    Client

    Anchor
    Client-Commission-Basis
    Client-Commission-Basis
    Client Commission Basis

    Commission Basis

    Basis


    A Shared Block
    shared-block-keyClient-Commission-Basis

    The cost type that the Client Commission Percentage is applied to: Client Gross Cost or Client Net Cost.

    • Client Gross Cost: 
      Include A Shared Block Inline
      shared-block-keyClient-Gross-Cost
      pageCosts and Calculations
    • Client Net Cost:
      Include A Shared Block Inline
      shared-block-keyClient-Net-Cost
      pageCosts and Calculations


    		Defined on the Administration > Entity Management > Clients >(Specific Client) > Commissions tabN/A
    Client

    Anchor
    Client-Discount
    Client-Discount
    Client Discount

    Client Passback

    The amount of the Vendor Discount that is passed on to the client.

    • Vendor Discount:
      Include A Shared Block Inline
      shared-block-keyVendor-Discount
      pageCosts and Calculations


    		CalculatedClient Discount = Vendor Discount x Client Passback Percentage
    Client

    Anchor
    Client-Discount-Percentage
    Client-Discount-Percentage
    Client Discount Percentage

    Client Discount Rule

    Client Discount %


    The percentage of the Vendor Net Cost or Vendor Gross Cost that is passed on to the client as a discount.

    • Vendor Net Cost:
      Include A Shared Block Inline
      shared-block-keyVendor-Net-Cost
      pageCosts and Calculations
    • Vendor Gross Cost:
      Include A Shared Block Inline
      shared-block-keyVendor-Gross-Cost
      pageCosts and Calculations
    		CalculatedClient Discount Percentage = Vendor Discount Percentage
     x Client Passback Percentage
    Client

    Client Gross Cost

    Anchor
    Client-Gross-Cost
    Client-Gross-Cost

    Client Gross


    A Shared Block
    shared-block-keyClient-Gross-Cost

    The amount that the client is quoted, before any discounts are applied.


    • Entered in schedule
    • Calculated

    Client Gross = Vendor Gross

    Client

    Client Net Cost

    Anchor
    Client-
    Net
    Gross-
    Cost
    Rate
    Client-
    Net
    Gross-
    Cost
    Rate
    Client     NetGross Rate


    A Shared Block
    shared-block-keyClient-NetGross-CostRate

    The amount cost per unit that the client is charged for the media purchases, after quoted, before any discounts are applied but before any commission or taxes are added.

    Entered in schedule


    		Calculated

    Client Net = Client Gross - Client Discount

    If Rate Type is not CPM-based:
    Client Gross Rate = Client Gross Cost / Units

    If Rate Type is CPM-based:
    Client Gross Rate = (Client Gross Cost / Units) x 1000


    ClientClient

    Client Net Cost

    Anchor
    Client-Net-RateCost
    Client-Net-RateCost

    Client Net Rate


    A Shared Block
    shared-block-keyClient-Net-RateCost

    The cost per unit amount that the client is charged .for the media purchases, after any discounts are applied but before any commission or taxes are added.


    • Entered in schedule
    • Calculated
  • Defined in Administration > Reference Data > Fees & Tech Rates > (Specific Fee Record) > Client Rate Details

    • Client Net = Client Gross - Client Discount


    N/A

    		Client

    Anchor
    Client-
    Passback
    Net-
    Percentage
    Rate
    Client-
    Passback
    Net-
    PercentageClient Passback Percentage

    Client Passback Rule

    Client Passback %

    Rate
    Client Net Rate


    The percentage of the Vendor Discount that is passed on to the client as a discount.

    Vendor Discount: include-
    A Shared Block
    -inline
    shared-block-key
    Vendor
    Client-Net-
    Discount
    pageCosts and Calculations
    Rate

    The cost per unit that the client is charged.


    • Entered in schedule
    • Calculated
    • Defined in Administration > Reference Data > Fees & Tech Rates > (Specific Fee Record) > Client Rate Details

    Defined in

    Administration > Entity Management > Client > (Specific Client) > Passbacks

    N/A

    Client

    Anchor
    Client-Passback-
    Tax
    Percentage
    Client-
    Tax
    Passback-Percentage
    Client     Tax

    A Shared Block
    shared-block-keyClient-Tax

    The tax on activity that the client is charged, not including any commission.

    		Calculated

    Passback Percentage

    Client Passback Rule

    Client Passback %

    The percentage of the Vendor Discount that is passed on to the client as a discount.

    • Vendor Discount:
      Include A Shared Block Inline
      shared-block-keyVendor-Discount
      pageCosts and Calculations

    Defined in

    Administration > Entity Management > Client > (Specific Client) > Passbacks    		N/A

    Depending on Client Tax Rule settings:

  • Client Tax = Client Tax Rule x Vendor Gross
  • Client Tax = Client Tax Rule x Vendor Net
  • Client Tax = Client Tax Rule x Client Gross
    • Client Tax = Client Tax Rule x Client Net
    Client

    Anchor
    Client-Tax-on-Commission
    Client-Tax-on-Commission
    Client Tax on Commission


    A Shared Block
    shared-block-keyClient-Tax-on-Commission

    The tax on commission activity that the client is charged, not including any commission.


    		CalculatedClient Tax

    Depending on

    Commission =

    Client Tax Rule

    x Client Commission

    settings:

    • Client Tax = Client Tax Rule x Vendor Gross
    • Client Tax = Client Tax Rule x Vendor Net
    • Client Tax = Client Tax Rule x Client Gross
    • Client Tax = Client Tax Rule x Client Net
    ClientClientClient Total Cost

    Anchor
    Client-TotalTax-on-CostCommission
    Client-Tax-Totalon-CostCommission
    Client TotalTax on Commission


    A Shared Block
    shared-block-keyClient-TotalTax-Coston-Commission

    The amount tax on commission that the client is charged, after any discounts are applied and commission is added, but before any taxes are added.


  • Entered in schedule
    • Calculated    		Client Total Tax on Commission = Client Net + Tax Rule x Client Commission
    Client

    Client Total Cost with Tax

    Anchor
    Client-Total-Cost-with-Tax
    Client-Total-Cost-with-Tax

    Client Total with Tax


    A Shared Block
    shared-block-keyClient-Total-Cost-with-Tax

    The amount that the client is charged, after any discounts are applied and after any commission or commission is added, but before any taxes are added.


    • Entered in schedule
    • Calculated
    		Client Total = Client Net + Client Commission
    Client

    Client Total Cost with Tax

    =

    Anchor
    Client

    Total + Client Tax on Cost + Client Tax on Commission

    -Total-Cost-with-Tax
    Client-Total-Cost-with-Tax

    Client Total with Tax


    A Shared Block
    shared-block-keyClient-Total-Cost-with-Tax

    The amount that the client is charged, after any discounts are applied and after any commission or taxes are added.


    		CalculatedClient Total Cost with Tax = Client Total + Client Tax on Cost + Client Tax on Commission
    Client

    Client Total Rate

    Anchor
    Client-Total-Rate
    Client-Total-Rate


    A Shared Block
    shared-block-keyClient-Total-Rate

    The cost per unit that the client is charged, after any discounts are applied and commission is added, but before any taxes are added.


    		Calculated

    If Rate Type is not CPM-based:
    Client Total Rate = Client Total Cost / Units

    If Rate Type is CPM-based:
    Client Total Rate = (Client Total Cost / Units) x 1000

    Vendor

    Anchor
    Vendor-Discount-Percentage
    Vendor-Discount-Percentage
    Vendor Discount Percentage

    Vendor Discount Rule

    Vendor Discount %

    The percentage of Vendor Net Cost or Vendor Gross Cost that the Vendor gives as a discount.

    • Vendor Net Cost:
      Include A Shared Block Inline
      shared-block-keyVendor-Net-Cost
      pageCosts and Calculations
    • Vendor Gross Cost:
      Include A Shared Block Inline
      shared-block-keyVendor-Gross-Cost
      pageCosts and Calculations
    		Defined in Administration > Entity Management > Contracts > (Specific Contract)N/A
    Vendor

    Anchor
    Vendor-Discount
    Vendor-Discount
    Vendor Discount

    Vendor Discount Cost


    A Shared Block
    		Vendor
    Anchor
    Vendor-Discount-PercentageVendor-Discount-Percentage
    shared-block-keyVendor-
    Net-Cost
    pageCosts and Calculations
    Include A Shared Block Inline
    shared-block-keyVendor-Gross-Cost
    pageCosts and Calculations
    Defined in Administration > Entity Management > Contracts > (Specific Contract)
    Discount

    The amount of the discount that the vendor gives.


    Calculated

    Depending on the Vendor contract:

    • Vendor Discount = Vendor Net x  (1 / (1 - Vendor Discount Percentage) - 1)
    • Vendor Discount = Vendor Gross x Vendor Discount Percentage
    N/AVendor

    Anchor
    Vendor-
    Discount
    Gross-Cost
    Vendor-
    Discount
    Gross-Cost
    Vendor     DiscountGross Cost

    Vendor Discount CostGross


    A Shared Block
    shared-block-keyVendor-Gross-DiscountCost

    The amount of the discount that the vendor gives.quotes, before any standard discounts are applied and any taxes are added.


    • Entered in schedule
    • Calculated

    Depending on the Vendor contract:

    • Vendor Discount = Vendor Net x  (1 / (1 - Vendor Discount Percentage) - 1)
    • Vendor Discount = Vendor Gross x Vendor Discount Percentage
    Vendor Gross = Vendor Net  + Vendor Discount Vendor

    Anchor

    Vendor

    Vendor-Gross-Cost
    Anchor
    Vendor-Gross-CostRate
    Vendor-Gross
    Cost
    -Rate
    Vendor Gross Rate


    A Shared Block
    shared-block-keyVendor-Gross-CostRate

    The amount cost per unit that the vendor quotescharges, before any standard discounts are applied and any taxes are added.


    • Entered in schedule
    • Calculated
    • Defined in Administration > Reference Data > Fees & Tech Rates > (Specific Fee Record) > Vendor Rate Details

    N/A

    Vendor Gross = Vendor Net  + Vendor Discount 

    Vendor

    Vendor Net Cost

    Anchor
    Vendor-Net-Cost
    Vendor-Net-Cost

    Vendor Net


    A Shared Block
    shared-block-keyVendor-Net-Cost

    The amount that the vendor charges for the media purchase(s), after any discounts are applied but before any taxes are added.


    • Entered in schedule
    • Calculated
    Vendor Net = Vendor Gross - Vendor DiscountVendor

    Anchor
    Vendor-Net-Rate
    Vendor-Net-Rate
    Vendor Net Rate



    A Shared Block
    shared-block-keyVendor-Net-Rate

    The cost per unit that the vendor charges, after any discounts are applied but before any taxes are added.


    • Entered in schedule
    • Calculated
    • Defined in Administration > Reference Data > Fees & Tech Rates > (Specific Fee Record) > Vendor Rate Details

    N/A

    Vendor

    Anchor
    Vendor-Tax-Cost
    Vendor-Tax-Cost
    Vendor Tax Cost

    Vendor Tax


    A Shared Block
    shared-block-keyVendor-Tax-Cost

    The tax on activity that the vendor charges.


    Calculated

    Depending on Vendor Tax Rule settings:

    • Vendor Tax = Vendor Net x Vendor Tax Percentage
    • Vendor Tax = Vendor Gross x Vendor Tax Percentage
    Vendor

    Anchor
    Vendor-Total-Cost
    Vendor-Total-Cost
    Vendor Total Cost

    Vendor Total


    A Shared Block
    shared-block-keyVendor-Total-Cost

    The amount that the vendor charges, after any discounts are applied but before any taxes are added.




    Other

    Anchor
    Allocated-Amount
    Allocated-Amount
    Allocated Amount


    Info

    Allocated Amount is part of the Allocated cost method.


    A Shared Block
    shared-block-keyAllocated-Amount

    The client budget allocated to a media line within the schedule.


    Entered in schedule

    N/A

    Other

    Anchor
    Allocated-Fee-Cost
    Allocated-Fee-Cost
    Allocated Fee Cost

    Allocated Fee


    Info

    Allocated Fee Cost is part of the Allocated cost method.


    A Shared Block
    shared-block-keyAllocated-Fee-Cost

    Client Net Cost of any fees applied to the line, where the fee is a percentage of the Allocated Amount.


    Calculated

    N/A

    Other

    Margin Percentage

    Anchor
    Margin-Percentage
    Margin-Percentage

    Margin Rule

    Margin %


    Info

    Margin Percentage is part of the Margin cost method.


    A Shared Block
    shared-block-keyMargin-Percentage

    The difference between the cost of a media purchase (Vendor Net Cost) and the price at which it is sold (Client Net Cost), as a percentage of the price at which it is sold (Client Net Cost).

    Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost


    • Entered in schedule
    • Calculated
    N/AOther

    Anchor
    Other-Income-Cost
    Other-Income-Cost
    Other Income Cost

    Other Income


    A Shared Block
    shared-block-keyOther-Income

    The general term for any type of additional income that an agency makes, aside from commission.

    Sources of Other Income include:

    • A margin between client costs and vendor costs
    • A markup on vendor costs
    • A partial client passback on a vendor discount


    Calculated

    Depends on the source of the additional income.



    ...