Como exportar planilha de vendas de distribuição digital por período

How it’s done

1) Access the “Digital Distribution” tab and select a period.

On the left side menu, click on the “Digital Distribution” tab (1) within the Revenue section.
Select the “Start” (2) and “End” (3) period you wish to export a sales report for. If you don’t select an end period, the system will consider the date of the last information contained in the reports.
Select the type of information you want to view:

• Sales: Information about asset revenue
• Distribution: Information about the distribution of amounts between rights holders

Click the action button in the lower right corner and select “Export” (4) to download a spreadsheet with the displayed information.

2) Select the type of report you want to export

In the dialog window, choose the type of file to export. Select the type of spreadsheet as chosen on the previous screen and press the “Export” button to download your spreadsheet.

The exported spreadsheet contains the following information:

• Sales (CSV):
  • begin_date
  • end_date
  • import_date
  • country_code
  • country
  • isrc
  • track_title
  • upc
  • release_title
  • artist_name
  • label_name
  • composers
  • store_name
  • offer_type
  • sale_type
  • sales_product
  • monetization_type
  • usage_type
  • asset_type
  • total_sales
  • distributor_tax
  • distributor_net_sales
  • net_sales
  • currency
  • currency_rate
  • real_total_sales
  • real_distributor_net_sales
  • real_net_sales
  • units
  • distributor
  • client_name
  • report_name
  • report_id
  • created_at
• Distribution (CSV):
  • _id
  • distributor
  • distributor_date
  • report_name
  • units
  • sales_id
  • sale_type
  • asset_type
  • asset_id
  • owner_id
  • owner
  • percent
  • value
  • distributor_value
  • created_at
  • client_name
  • sales_date
  • isrc
  • upc
  • video_id
  • artist_name
  • release_title
  • track_title
  • country
  • country_code
  • label_name
  • store_name
  • monetization_type
  • usage_type

That’s it! Now you can import your sales report and then process it to generate the payroll.

 

Any doubts, any suggestions? Contact us!

 

[page_tags]