Mediaocean AR and AP integration

Automate media invoice import and posting from Mediaocean

Overview 

Accountability's integration with Mediaocean automates the import of media client and vendor invoices.  This automation eliminates steps and errors from a manual process and centralizes all of your receivable and payable activities in your financial management platform. 

Pre-requisites

Master data management

1. Add your Mediaocean Media Names as Accountability Media Types.  Navigate to Media>Media Master Files>Media Types and click on the Create Media Type button.   On the Media Type Name field, enter the Name of the Media Type in Mediaocean.  
2. Import your active Mediaocean "pubs" as Accountability Medium records.  This optional set-up allows you to pre-map the station/network/publication where ads are running to the vendor payee (aka Supplier) within Accountability.  Navigate to Media>Master Files>Medium and click the Excel-Medium hyperlink.  Select the Import option and download the template. 
3. Ensure that there is a corresponding Accountability Client and Product records for all active media clients and products within Accountability.   
4. Ensure that there is a Supplier record for all active media payees. 
   
   

Mediaocean configuration 

To enable the Mediaocean configuration, navigate to Set Up Files>Set Up Options and go to Media Options.  Ensure that the Use Media and Use Mediaocean Media options are selected. 

Once the integration is enabled, you'll be able to access the  Mediaocean Configuration  sub menu item from the Media menu. 

See Mediaocean Configuration for details on each field. 

SFTP set-up 

Your Accountability Implementation Team will provide you with the SFTP credentials for Mediaocean to securely send your media AR and AP files to Accountability. 

Account mapping

Client and supplier invoice transactions received from Mediaocean are automatically approved and posted to the relevant accounts.  To set up your media account mappings, navigate to Media>Media Accounting>Media GL Posting Accounts and click the Default Media GL Posting Accounts hyperlink.    

Once the default posting accounts have been defined, can optionally create media type-level account mappings by clicking on the Create a New Media GL Posting Account button. 

Mediaocean files 

Accounts Receivable 

Your Accountability Implementation team will work with your Mediaocean Representative to schedule an automated report to automatically populate the Accountability's standard MO AR template. 

Once a media client invoice is generated in Mediaocean, a file is automatically created and sent to Accountability. 

Accounts Payable 

Your Accountability Implementation team will work with your Mediaocean Representation to schedule an automated report to automatically populate the Accountability's standard MO AP template. 

Once a vendor invoice is cleared for payment in Mediaocean, a file is automatically created and sent to Accountability.