Other stores and import templates
Import a CSV from any store by choosing which column holds what, then save the mapping as a template for next month.
Stores without a built-in importer still work: Epic Games Store, GOG, Humble, Fab, the console portals, Draft2Digital, IngramSpark, DistroKid and anything else that can give you a CSV. You tell Splitfold which column holds what once, save that as a template, and next month's file is read with it automatically.
Map a file
- Go to Imports → Import sales and drop the CSV.
- If Splitfold doesn't recognise it, the Column setup step opens. You can also open it for any file with Set up columns yourself.
- Choose a column for each field. Guesses are filled in from the column names, so check them against the two previews: the file as it is, and how Splitfold reads it.
- Name the store, like "Epic Games Store". That name is what statements and the overview show.
- Tick Save as a template for next month, give it a name, and choose Save and continue. Products, then the import, work as for any other store.
What to map
| Field | Needed | Notes |
|---|---|---|
| Date | Yes | Pick the date format too: ISO, day first, month first, year first or Excel serial numbers. |
| Product | Yes | The title or product name. |
| SKU or product ID | No | Keeps a product apart when its title changes. |
| Order ID | No | Without one, each row is identified by its contents, so re-importing the same rows still skips them. |
| Quantity | No | Counted as 1 when not chosen. |
| Gross | Gross or net | What the buyer paid. |
| Fee | No | The store's cut. |
| Net | Gross or net | When not chosen, net is gross minus the fee. |
Currency: choose a currency column, or one currency for the whole file. Amounts are read in that currency's smallest unit, so yen have no decimals and euros have two.
Refunds: either negative amounts are refunds (minus signs and amounts in brackets both count), or a column says so. A column counts a row as a refund when it says refund, refunded, reversed, chargeback or yes.
Number format: choose the decimal separator (dot or comma) and the thousands separator. A German export with 1.234,56 uses a comma for decimals and a dot for thousands. A row that doesn't fit the format is listed with its row number and skipped; nothing is guessed.
Rows above the header: some exports start with a title, an account number or totals. Set how many rows to skip so the header row is read as the header.
Templates
A file whose column names match a saved template is read with it as soon as you drop it. Matching ignores order, case and punctuation, but a store that adds or renames a column needs the mapping checked again; choose Change column setup and save the changes to the template.
Manage templates in Settings → Import templates: rename them, change the store name or delete them. Deleting a template doesn't touch sales already imported. Editors and owners can save and change templates; viewers can use them to preview files.
Getting the file
Each store names its reports differently and moves them around. In general, export the sales or payout report as CSV, for one month at a time, from the store's partner or publisher dashboard.
- Epic Games Store, GOG, Humble, Fab and the console portals: export the sales or payout report as CSV.
- Draft2Digital and IngramSpark: export the sales or compensation report as CSV. If you only get an Excel file, save it as CSV first.
- DistroKid: export the earnings report as CSV.
itch.io, Gumroad, DriveThruRPG, Bandcamp, Amazon KDP, ACX, Kickstarter and BackerKit are read without any setup. See Which file to export from each store.
CSV files can be up to 20 MB, with up to 50,000 rows. Excel files can be up to 10 MB. Larger reports should be exported in smaller date ranges. Files are stored privately.
Duplicates and store names
Rows from different store names are kept apart, so an order 1001 at GOG and an order 1001 at Humble are two sales. Keep the same store name every month: a sale imported under "Epic" and again under "Epic Games Store" would count twice.
Still have a question?
We reply by email.