Skip to main content

Importing Distribution Deal Expenses

How to Import expenses for Distribution Deals

Written by Sara

  1. Download the Distribution Deal Expenses Template

    1. The Distribution Deal Expenses Template can be found in the templates menu of SR1.

    2. Navigate to the templates menu then select Distribution Deal Expense Import
      ​

    3. Select where you would like to save the file and Click Save

  2. Open and Fill Out the Distribution Deal Expenses Template

    1. Navigate to the Distribution Deal Expenses file saved earlier

    2. Open the file

    3. The following information belongs in the fields

      1. Deal ID: This is the Distribution deal ID that the expense needs to be tied to. It can be found on the deal.
        ​

      2. Alternate Deal ID: Can be found in the Alt ID field on the deal. This field is optional if you have the Deal ID field of the template filled out

      3. Expense Date: The date of the expense charge It must be in DD/MM/YYY Format

      4. Expense type: What variety of expense is it? Some suggestions can be found in the screenshot below
        ​

      5. Description: Other descriptive information needed for the expense

      6. Company: Who/What charged the expense (Optional)

      7. Reference: Any internal reference numbers related to this expense (Optional)

      8. Amount: The amount of the expense

  3. Save and Close the Distribution Deal Expenses Template

    1. Once the template is filled out, save and close the file.

  4. Import the Distribution Deal Expenses Template

    1. Initiate Distribution Deal Expenses Template Import

      1. From The Import Menu

        1. Navigate to the Import Menu

        2. Click Expenses

        3. Click Distribution Deal Expenses
          ​

      2. From Distribution Deal Expenses

        1. Click Deals in the Purple Navigation Bar

        2. Click on Distribution in the menu box

        3. Click the Expenses tab

        4. Click Import Expenses at the bottom of the screen
          ​

      3. Import data

        1. In the window that pops up click import expenses

        2. Navigate to the file that you previously saved

        3. Click open

        4. All of the expenses in the sheet will be imported into this table

  5. Map and Activate Distribution Deal Expenses

    1. SR1 will automatically analyze the data and find matches. A green dot will appear next to anything that found a match. You can click activate all at the top of the screen to assign all the matched expenses to their deals to be included in statements and royalty reporting.

    2. For any red dots, you can resolve errors by making changes in this window then use the golden arrows in the upper left corner to match. Then click activate. Repeat until all errors are resolved.

Did this answer your question?