Contents x
    Bulk Cost Import v1
      • Dark
        Light
      Contents

      Bulk Cost Import v1

        • Dark
          Light
         

        This article is deprecated. We've released a new version of our bulk cost import feature that simplifies the import process and error management. The newest bulk cost import now available on ALL plans. Please note: you need to be subscribed to our latest pricing (not a legacy plan) to access this feature.

        Article summary

        The v1 of the bulk cost import feature is now deprecated. While it remains available under Indie and Record Company legacy plans, it will no longer be maintained. To access the latest features and improvements, we recommend upgrading to our latest pricing.

        Bulk Cost Import

        Recoupable costs can be created in bulk using our Bulk Cost Import feature. To do this, fill in our Bulk Cost Import template and simply upload it to eddy.app.

        The feature is accessible from the Costs section. Use our template to make sure that your file contains all the required data.

        Template, Data Requirements and Extension

        First, download our template and fill it in with your cost data. Make sure to follow the data requirements specified in this section.

        Template

        This template has all the necessary columns in the same order as the bulk import column mapping.

        Data Requirements

        The data in your file needs to respect the following requirements:

        Data field

        Mandatory

        Notes

        Name

        YES

        String

        Description

        String

        Contract/Reference ID

        YES

        This field links costs to a specific contract. Make sure you use the exact reference/ID shown on the contract.

        Product Code

        This can be a barcode, ISRC, or catalog number. For barcodes, make sure you're using the barcodes as shown in eddy.app.

        Categories

        String

        Spend date

        The format should be YYYY-MM-DD. In Excel files, format as text not date.

        Amount

        YES

        Use "." (a period) as the decimal separator. Currency symbols and thousand separators are not accepted.

        Cost type

        YES

        Accepted values: shared or artist.

        Recoupment percentage

        This is mandatory with artist cost.

        Use "." (a period) as the decimal separator. Currency symbols and thousand separators are not accepted.

        Payment method

        String

        Important

        • The contract/reference ID must be identical to the reference ID specified in your contracts.

        • No data except the header and actual costs should be present in the file.

        • Don't use any totals or formulas in the file.

        Extension

        Accepted file extensions are CSV, XLS or XLSX.

        When importing a CSV, it should be formatted as follows:

        • Character encoding: UTF-8

        • Column separator: comma-delimited ","

        • Row/line separator: "\r" or CR

        The easiest method is to export your spreadsheet using Google Sheets: google sheet export CSV .png

        File Upload  and Column mapping

        Now that your Bulk Cost Import file is ready, it is time to upload it to eddy.app.

        File Upload

        Head to Costs - Advances > Click on the small arrow next to the New Cost button > Bulk Import. Simply drag and drop the file in the appropriate field.

        Bulk cost import.gif

        Column Mapping

        Within the Bulk Import page, you'll need to map your file's columns to the appropriate fields so that our system can locate data. Our Bulk Cost Import template follows the suggested order, so you can simply add each column letter in the corresponding field.

        Important

        Within the column mapping table, you need to map all fields to a column, even if the column is empty in your file.

        Was this article helpful?
        Related articles
        What's Next