Skip to content
Splitfold
All guidesOther stores and import templates

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.

3 min readUpdated

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

  1. Go to Imports → Import sales and drop the CSV.
  2. If Splitfold doesn't recognise it, the Column setup step opens. You can also open it for any file with Set up columns yourself.
  3. 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.
  4. Name the store, like "Epic Games Store". That name is what statements and the overview show.
  5. 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

FieldNeededNotes
DateYesPick the date format too: ISO, day first, month first, year first or Excel serial numbers.
ProductYesThe title or product name.
SKU or product IDNoKeeps a product apart when its title changes.
Order IDNoWithout one, each row is identified by its contents, so re-importing the same rows still skips them.
QuantityNoCounted as 1 when not chosen.
GrossGross or netWhat the buyer paid.
FeeNoThe store's cut.
NetGross or netWhen 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.

Email