This guide shows the essential actions for importing sales statements in details. The Overview below is always visible in this article; all other sections are collapsible.
You typically move through these phases: prepare your file(s), upload and (if needed) map headers, resolve matches, review results, and account the statement.
Quick phases
- Prepare file(s) (format, sheets, country settings).
- Import file on DISTRIBUTION / IMPORTS.
- Map headers only if not saved yet otherwise mapping is prefilled.
- Resolve Import Matches (if any).
- Review Import Result totals [ACCOUNT STATEMENT].
► Preparation (file formats, tips & fixed country)
Supported files: .xlsx, .xls, .csv, .tab, .txt (tab-separated). For other formats, contact label_team@details.eu.
- Standardise formatting (Excel): Select all set neutral Standard/Number formats. Remove thousand separators if needed.
- Multiple sheets: Only combine if structure is identical and within the same import type; otherwise split into separate files.
- Remove extras: Delete pre-headers and grand totals (or use Delete when empty during import where offered).
- Large workbooks: Save as CSV (UTF-8) or TAB-TXT for stability before uploading.
Fixed Country (when your file has no country)
- Open the Distribution Account Import Setup.
- Edit or create the setup via [+ ADD NEW].
- Set [FIX COUNTRY] to the ISO2 code (e.g.
US,FR) and [SAVE].
Note: Fixed Country affects future imports for this setup and overrides the file s country if present; past imports remain unchanged.
► Importing Sales Statements (digital & physical)
- Go to DISTRIBUTION / IMPORTS, pick the correct month, click the tile for the target Import Setup.
- Upload your file preview appears.
- Header mapping:
- If you previously saved a configuration, the mapping is prefilled review and proceed.
- If not saved yet, map required fields (e.g., Identifier (ISRC/UPC), Artist, Title, Shop, Country, Usage Type, Qty/Sales, PPU/PPD, Sales Date/Period). Unused columns may stay blank.
- Click [SAVE CONFIGURATIONS] (recommended) and then [PROCEED].
- Watch status:
- Pending / Processing calculation running (a temporary 0.00 is normal).
- Matching Incomplete file in, some items may need matching.
- Matching Complete everything matched.
- Resolve matches: open Import Matches, click the bold item, choose the correct product/track, confirm with [OK]. Saved per account for future imports.
- Open Import Result and verify totals (units & amount) against the source statement.
► Accounting & Verification
- If totals are correct, click [ACCOUNT STATEMENT].
- In DISTRIBUTION ACCOUNT / CURRENT STATEMENTS select one or multiple statements to create invoice(s).
- Invoices appear in ACCOUNTING / INVOICES.
Need to undo a confirmed (green) import?
- Cancel/unlock the related invoice in Accounting, then delete the import (tile returns to orange). If already posted by accounting, use Cancelled instead of deleting.
► Troubleshooting & FAQ
Importer not visible on IMPORTS / OVERVIEW
- Create an Import Setup first in Distribution Account / Import Setup; without it, no tile appears.
Amounts look wrong (too low/zero)
- Refresh after a few minutes; re-check Import Result.
- Verify mapping of Qty/Sales, PPU/PPD, and currency.
- Try [RUN ID MATCHING], then resolve remaining manual matches.
Headers don t match
- Map once and [SAVE CONFIGURATIONS] for next time.
- Split sheets with different structures into separate files.
Need help? Contact label_team@details.eu.