Sales FTP Fetcher: Automating Sales Report Retrieval and Reconciliation
Sales 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.
You remain in full control throughout the process. Sales reports are only imported into your account once you review the reconciliation and confirm the import.
Getting Started
Before using Sales Fetcher, complete these one-time setup steps:
Plan requirement: Sales Fetcher is available on the Record Company plan.
Connection credentials: Go to Settings > Company Settings > Integrations and input your distributor credentials. For Merlin, retrieve your FTP credentials from their platform.
Admin fee: Configure your admin fee in the Royalty Sources section to ensure accurate fee calculations.
Each month, gather your remittance advice PDFs (received via email from your distributor) before creating a new fetch.
How to Create a Sales Fetch
Navigate to Sales > Sales Fetcher
Select the reporting period
Upload your remittance advice PDFs for each currency (EUR, GBP, USD)
Input exchange rates
Click “Create”
The system retrieves the corresponding sales reports from the connected distributor server and matches them against your uploaded invoices. In most cases, all items are automatically reconciled and ready for import.
Reviewing and Importing
Once your fetch is created, the summary shows the reconciliation result for each invoice. When all items display a "Reconciled" status, use the bulk action "trigger all" to import the sales reports into eddy.app.
Verify that the total sales import value matches the revenue on your remittance advice, then mark the fetch as complete.
Tips:
Include all remittance advice PDFs from the same period
Match exchange rates with those provided by your bank
Verify the reporting periods on your remittance advice to avoid discrepancies.
Start with Spotify, Deezer, and Apple Music reports to minimize matching errors before triggering bulk imports.
Fetch Summary
After a fetch is created, the summary displays the following:
Items on hold: Excluded from the total remittance advice value.
Sales imports triggered: Number of reports successfully imported.
Sales imports to correct: Reports with discrepancies that need resolving.
Auto-corrected lines: Lines eddy.app has automatically corrected.
Items not implemented: Invoices not recognized by the system.
Missing invoices: Invoices not found on the connected server.
Handling Exceptions
In some cases, items in a fetch may require manual attention. Below are the statuses you may encounter and how to resolve them.
Reconciliation statuses:
Reconciling: The system is still processing. Wait for it to complete.
Amount Mismatch: A difference of over 1% exists between the invoice and report amounts. Review both documents to identify the discrepancy. Discrepancies below 0.01 in any currency are deemed negligible.
Manual fetch: An import was manually linked to an invoice, typically for items that lack a report or have specific issues.
Reconciliation error: A minor issue occurred during reconciliation. You can still import the report, but verify the total import value aligns with the invoice value.
Actions by status:
Missing invoices: Invoices not found on the connected server. Investigate with your distributor directly.
Not implemented: An unrecognized DSP invoice. Contact our support team.
No report: For DSPs where no report is expected, use the Breakage Revenue tool to create one manually.
Sales report not found: Check if the report is available in your distributor's dashboard (for Merlin, check their platform). Set the item on hold if necessary.
Refetch needed: Initiate a refetch from the bulk action menu.
Matching errors: Click "Fix matching errors" to resolve content matching issues.
Errors: Hover over the error for details. Often caused by unexpected changes in reporting formats.
Creating Manual Reports
When your distributor does not supply a report for a specific invoice, you can create one using the Breakage Revenue tool:
Use the Link Function to manually connect the created report to the corresponding invoice.
Ensure the currency in your manually created import file matches the template currency. If dealing with a different currency, specify the exchange rate, the same one used during the fetch creation.
This method is particularly useful for platforms where you might encounter "no report" invoices.
For a detailed guide on creating breakage revenue reports, refer to our dedicated Breakage Revenue article.
eddy.app is an independent platform and integrations with third-party services do not imply affiliation, endorsement, or official partnership.