Media Summaries
      Back to home
      2. Media
      3. Media Summaries

      Media financial summary - (Strata/Freewheel)

      Accountability's integration automates the exchange of Strata/Freewheel receivables and payables data, offering media accounting users a unified view of billed and cleared amounts at the Media Schedule level.

      Steps: 

      1. Navigate to Media > Media Summaries > Media Financial Summaries.
      2. Use the Filters to narrow down your search.

      Maria Knowledge Base Template-Aug-01-2023-06-28-59-5591-PM

      Field Description
      Schedule No. Enter a schedule number.  This number is a concatenation of the Client + Product + Estimate Number from Mediaocean. 
      Schedule Description This is  Estimate Name from the client bill.  
      Client  Enter or search for a Client
      Supplier 

      Enter or search for a supplier (new filter) 

      Note: This filter will exclude data that does not have a supplier assigned to it, e.g., client bills that were assigned to a generic media type

      The filter doesn't work on billed-to-client data before mid-June 2023 due to a lack of vendor/supplier invoice data. However, past invoiced by supplier data remains accurate.
      Entity Click to select an entity. 
      Office  Click to select an office. 
      Include Inactive Schedule?  Check the box to include inactive schedules.
      Filter on 

      Click to select between

      • Accounting Month 
      • Month of Service 
      From Month  Click to select the start month you want to be displayed. 
      From Year Click to select the start year you want to be displayed. 
      To Month  Click to select the end month you want to be displayed.  
      To Year Click to select the end year you want to be displayed.  
      Display Currency  Click to select the currency you want to be displayed.  

      Manage cashflow

      In addition to AR and AP details received from Strata/Freewheel, the Media Financial Summary includes receipt and payment amounts for each media estimate.  

      Users can also Filter On the accounting month to view all client and supplier invoices within that range and display any receipts and payments against those invoices, even if they occur after the accounting month.

      Filter On Options  Description
      Accounting Month  This is the posting month, based on the client invoice date and supplier invoice clearance date.
      Month of Service Based on the MOS sent from the MO AR and AP files, This is available even without the cost of media extract. 

      Drill down to see additional details

      Steps: 

      1. Click on the Media Schedule No. & Description to view the billed and cleared amounts by vendor and month of service. 
      2. Click on the vendor hyperlink to drill down into the detailed transactions.
      3. From the summary page, click on Total Billed to view the full history of invoices, including cash receipt details. 
      Summary Detail Option  Description
      Schedule No. & Description Will give you a list of medium (aka vendor) and MOS.
      • For billed info, the medium reflects the media type from the AR file;  For DS agencies like W+K, this will reflect the vendor once we have the cost of media extract integrated.

      Total Billed 

      		 Will give you a list of all client invoices and receipt history. 


      Users can click List Export to download the report in these views:

      • Schedule Totals 
      • Medium/Supplier & Month of Service Totals
      • Transaction Details