Importing DSP/Sales Reports

Overview

When your connected DSP integrations don’t cover every service you use—or if you receive custom reports in specific file formats—you can manually import these sales reports. Revelator will then parse each file’s data, match or create tracks as needed, and display the resulting revenue lines in the Finance section for further processing, matching, and payout distribution.


Prerequisites

  1. Access to Finance: You must have the appropriate user permissions to view and manage the Finance section.

  2. Supported File Formats: Ensure your report is in a format Revelator can parse. For example, CSV, or TXT from recognized DSPs or distributors.

  3. Catalog Management: Ideally, you have a clean catalog with accurate metadata (ISRC codes, track titles, etc.), to minimize unmatched lines upon import.


How It Works: Step by Step Guide

1. Access the Finance Section

  1. Navigate to Finance in the left-hand menu.

  2. The Finance page displays any existing reports, including auto-ingested and previously uploaded files.

2. Initiate the Import

  1. Click the Import reports (or + Import Report(s)) button, typically located in the top-right corner of the Finance page.

  2. A dialogue or side panel appears, prompting you to upload your sales report.

3. Upload Your File

  1. Drag and Drop: Drag your sales report file from your computer onto the upload area.

  2. Browse: Alternatively, click a Browse or Choose File button to navigate to the file on your computer.

  3. Confirm you’re using a supported file format (e.g., CSV, TXT).

5. Confirm Import

  1. Click Import, Upload, or Confirm (the wording may vary) to finalize the process.

  2. Revelator processes the file and adds the new report to your Finance list once parsing is complete.


Expected Outcomes

  • The newly imported file appears in the Finance list, typically with a date/timestamp of import.

  • Any lines that match existing catalog entries will be automatically linked. Unmatched lines will appear flagged for manual review in the report details.


Frequently Asked Questions

Which file formats are supported?

Supported formats include CSV,TXT.

Can I upload multiple reports at once?

Current versions generally support one file at a time. If you have multiple reports, repeat the import steps for each file.

Will imported reports show in my main Finance dashboard?

Yes, once processed, manually uploaded reports appear alongside auto-ingested reports under the selected time range.

What if I see unmatched lines or track errors?

  • Use the Matcher in the Finance section to link or approve lines. You can also update your catalog with missing metadata, then reprocess the lines.


Additional Resources

  • Account Settings & Integrations: Learn how to configure DSP integrations and authentication.

  • Managing Unmatched Lines: Troubleshoot lines that don’t match your catalog.

  • Foreign Currency & Adjustments: See how imported revenues in multiple currencies are handled.

Last updated

Was this helpful?