--- title: "Sales FTP Fetcher" slug: "sales-ftp-fetcher" description: "Sales FTP Fetcher automates the retrieval of sales reports from your distributor's server and reconciles them with your remittance advice invoices. Instead of manually downloading reports and cross-checking invoices, the system handles file retrieval and matching on your behalf, so you can review and import directly into eddy.app." updated: 2026-09-18T17:52:15Z published: 2026-09-18T17:52:15Z canonical: "help.eddy.app/sales-ftp-fetcher" excludeFromExternalSearch: true --- > ## Documentation Index > Fetch the complete documentation index at: https://help.eddy.app/llms.txt > Use this file to discover all available pages before exploring further. # Sales FTP Fetcher The Sales FTP Fetcher removes the manual work of downloading reports from your distributor's portal, cross-referencing them against remittance advice, and uploading them one by one. Instead, eddy retrieves the files from your distributor's server automatically and matches each report against the corresponding invoice. You review the reconciliation results and confirm the import; you remain in full control at every step. > The Sales FTP Fetcher is available on the **Record Company plan** only. If you are on a different plan and want to upgrade, go to **Settings > Subscription**. --- ## Before your first fetch Two things need to be in place. **Your distributor's FTP credentials**, so eddy can reach their server. See the article on connecting your distributor's FTP credentials. **Your admin fee**, so eddy calculates net amounts accurately during reconciliation. In **Settings > Royalty Sources**, open the relevant source template and configure it. Then each month, gather your remittance advice PDFs (received by email from your distributor) before creating a new fetch. You upload them during fetch creation. --- ## How to create a sales fetch 1. **Navigate to the sales fetcher.** Go to **Sales > Sales Fetcher** in the left sidebar. 2. **Select the reporting period.** Choose the period that corresponds to the remittance advice documents you received. 3. **Upload remittance advice PDFs.** Upload the remittance PDFs for each currency you received invoices in (EUR, GBP, USD). Include **all** PDFs from the same period in the same fetch. 4. **Input exchange rates.** Enter the exchange rates to use for each currency. Use the rates provided by your bank for the most accurate reconciliation. 5. **Click Create.** eddy retrieves the corresponding sales reports from the connected distributor server and matches them against your remittance advice. In most cases, all items are automatically reconciled and ready to import. --- ## Reviewing and importing Once a fetch is created, the summary screen shows the reconciliation status for each invoice. Work through any exceptions (see below), then: ![](https://cdn.document360.io/a34ddd2c-ef7e-4e2d-a4ae-c659757a204e/Images/Documentation/image-1789753927566.png) 1. When all items display a **Reconciled** status, use the **bulk action menu** and select **Trigger All** to import the sales reports into eddy. 2. Verify that the total import value matches the revenue shown on your remittance advice. 3. Mark the fetch as **complete**. > Start by reviewing Spotify, Deezer, and Apple Music reports first. These are the highest-volume sources, and resolving their matching issues before triggering bulk imports reduces the chance of the same problem cascading through every later file. --- ## Fetch summary statuses After a fetch is created, the summary panel shows the following counters: ![Fetch summary panel showing the reconciliation counters](https://cdn.document360.io/a34ddd2c-ef7e-4e2d-a4ae-c659757a204e/Images/Documentation/ftp-fetcher-fetch-summary.png) | Status | Description | | --- | --- | | **Items on hold** | Excluded from the total remittance advice value calculation | | **Sales imports triggered** | Reports that have been successfully sent for import | | **Sales imports to correct** | Reports with discrepancies that require your attention | | **Auto-corrected lines** | Lines eddy resolved automatically without manual input | | **Items not implemented** | Invoices that the system does not recognize | | **Missing invoices** | Invoices present in the fetch but not found on the connected server | ## Handling exceptions Some items in a fetch may require manual action. Use the reconciliation statuses below to identify what to do next. ****Reconciling**** The system is still processing. Wait for it to complete before taking any action. ****Amount Mismatch**** A difference of more than 1% exists between the invoice total and the imported report value. Review both documents to identify the discrepancy. Differences smaller than 0.01 in any currency are automatically deemed negligible. ****Manual Fetch**** An import was manually linked to an invoice, typically for items that lack a report or have a specific issue that the automated fetch cannot resolve. ****Reconciliation Error**** A minor issue occurred during reconciliation. You can still import the report, but verify that the total import value aligns with the invoice before confirming. ****Missing Invoices**** The invoice was not found on the connected distributor server. Investigate directly with your distributor to confirm whether the report has been published. ****Not Implemented**** An unrecognized DSP invoice appeared in the fetch. Contact [support@eddy.app](mailto:support@eddy.app) with the invoice details so the team can add support. ****No Report**** No sales report is expected from this DSP. Use the **Breakage Revenue** tool to create a manual report for the invoice amount, then link it using the procedure below. ****Sales Report Not Found**** The report exists in principle but could not be retrieved. Check your distributor's dashboard (for Merlin, check the Merlin member portal) to confirm the report has been published. If it is not yet available, set the item **on hold** and come back to it when the report is ready. ****Refetch Needed**** The file needs to be retrieved again. Open the bulk action menu and initiate a **Refetch** for the affected item. ****Matching issues**** The report was retrieved and imported, but some sales lines could not be matched to catalog items. Open SolvX from the affected item and resolve the content matching issues there. ![Resolving content matching issues in SolvX from a fetch item](https://cdn.document360.io/a34ddd2c-ef7e-4e2d-a4ae-c659757a204e/Images/Documentation/ftp-fetcher-handling-exceptions.png) --- ## Creating manual reports for missing DSP reports When your distributor does not supply a report for a specific invoice, you can create one manually using the Breakage Revenue tool and link it to the invoice. 1. **Generate a report with the breakage revenue tool.** Go to **Sales > Breakage Revenue** and follow the steps to define your scope and generate a pro-rated distribution file. 2. **Link the report to the invoice.** Use the **Link** function on the invoice row in the fetch summary to connect the manually created import to the corresponding invoice. 3. **Match currencies.** Ensure the currency in your manually created import file matches the template currency. If the invoice is in a different currency, specify the same exchange rate you used when creating the fetch. ## Where to go next - **Connect your distributor's FTP credentials.** The one-time connection setup this feature runs on. - **Resolve import issues.** Lines that need review once a report has imported. > eddy is an independent platform. An integration with a third-party service does not imply affiliation, endorsement, or official partnership. ## Related - [Breakage Revenue](/breakage-revenue.md)