Sales

Track book revenue across your distribution channels by importing the sales and royalty reports your retailers produce.

What Sales Are

Sales is where you monitor how your books are performing across every channel you sell through. Rather than typing figures in by hand, you upload the sales and royalty reports that retailers like Amazon KDP and IngramSpark generate. Inkwren parses each report, matches its rows to your publication formats, and aggregates the totals into summary cards, a revenue chart, and a set of grouped tables.

The royalty and revenue figures come straight from the channel reports — Inkwren shows you what the channel paid. It does not calculate royalties itself or apply royalty splits.

Feature Availability

Sales is part of the Sales Module feature. If you don't see Sales in your sidebar, your workspace administrator may need to enable it.

Viewing Your Sales

Click Sales in the sidebar under the Business section. The page has three parts, top to bottom:

• Summary cards — headline totals, with optional period-over-period comparison
• Revenue Overview chart — a bar chart of your revenue or units over time
• A tabbed table — the underlying sale records, grouped three ways

A header at the top of the page carries the Import button and an Export CSV button (disabled when you have no sales).

Summary cards

Four cards summarize your data:

• Total Royalty — total royalty earned, with gross revenue shown beneath
• Units Sold — total units, excluding KENP page-reads, with KENP pages shown beneath when present
• Channels — the number of distinct channels with sales
• Imports — the number of import batches you've run

Use the Compare dropdown to add change badges to the Royalty and Units cards. You can compare against Last Month, Last Quarter, or Same Month Last Year, or choose No comparison. A green up-arrow marks a positive change, a red down-arrow a negative one.

Revenue Overview chart

The chart plots your sales as bars. Two toggles control what it shows:

• Metric: Royalty (default) or Units
• Grouping: Monthly (default), By Channel, or By Book

If you haven't imported anything yet, the chart shows an empty state prompting you to import sales data.

The sales table

Below the chart, a tabbed table gives you three views of the same data:

Tab	What it shows
All Sales	Individual sale records — Date, Book, Channel, Marketplace, Type, Qty, Unit Price, Revenue, Royalty, Currency, and Format
By Book	Rolled up per publication — Units, Revenue, Royalty, and KENP Pages
By Channel	The same roll-up, grouped by distribution channel

The All Sales tab supports search, pagination, and filtering by channel, transaction type, and currency. You can delete individual rows from this view.

note

The Type column marks each record as a Sale, Return, Free, KENP (page reads), Subscription, or Pre-order. KENP page-reads are tracked separately and are excluded from Units Sold.

Importing Sales

Sales data enters Inkwren through import only — there's no manual entry form. Click Import to open the import wizard, which walks through four steps: Upload → Preview → Importing → Done.

1. Upload

1. Choose the Sales Channel for this report (required)
2. Upload the Sales Report File

Inkwren accepts CSV, TSV, and Excel (.xlsx/.xls) files, up to 20 MB — large enough to hold a full year of KDP data. If your Excel file has multiple sheets, a Select Sheet picker appears so you can choose the right one. Files are virus-scanned on upload.

2. Preview

Inkwren auto-detects the channel from the file's headers and shows you what it found before anything is saved:

• A column-mapping table showing each column in your file, what it maps to, and a match badge of Exact, Alias, or Unmapped
• Sample rows — Date, Title/ISBN, Matched Book, Qty, and Royalty
• A summary of total, matched, and unmatched rows, plus the detected channel

Rows are matched to your publication formats automatically by ISBN, ASIN, external ID, or title. For any row Inkwren can't match, use the dropdown to assign the right format by hand.

Choose how to handle duplicates before continuing:

• Skip duplicates (default) — ignore rows that are already imported
• Replace existing — overwrite matching records
• Import anyway — import everything regardless

3. Importing

The import runs as a background job and a progress bar tracks it. You can watch the status update as it processes.

4. Done

When the import finishes, you'll see the number of records imported and the first few row errors if any occurred. Inkwren also offers to save this column mapping for future imports — if you accept, the mapping is reused automatically the next time you import from that channel.

Exporting Sales

Click Export CSV in the page header to download your sales as a CSV file named sales-export-YYYY-MM-DD.csv. The export includes the same columns as the All Sales table (Date, Book, Channel, Marketplace, Type, Qty, Unit Price, Revenue, Royalty, Currency, Format) and respects whatever filters you have applied — search, channel, type, and currency. Exports are capped at 10,000 rows.

Deleting Sales

There's no edit form for sales records — the only direct changes you can make are deletions:

• Delete a single sale from the All Sales tab
• Delete an import batch, which removes all the sale records that came in with it

How Sales Connects to Other Features

• Channels — every sale is tied to a channel, which you pick at import time. Inkwren comes with pre-built column mappings for Amazon KDP, Apple Books, Kobo, Barnes & Noble Press, Google Play Books, Draft2Digital, IngramSpark, Smashwords, BookFunnel, and Direct Sales. See Managing Channels.
• Publication formats — each sale row matches to a specific format (ebook, paperback, and so on) by identifier or title, and from there to the parent publication for the By Book view. See Publication Command Center.
• Royalty splits — Sales and royalty splits are not connected. Royalty figures are imported verbatim from your channel reports; they are not run through split percentages or divided among payees.

Tips

• Import the retailer's own report unchanged: Inkwren recognizes the standard KDP, IngramSpark, and other channel formats, so upload the file as you download it rather than reformatting it.
• Save your column mapping: Accept the save-mapping prompt after your first import from a channel, and future imports from that channel map themselves.
• Skip duplicates when re-importing: If you re-upload an overlapping report, leave duplicate handling on Skip duplicates to avoid double-counting.
• Match unmapped rows before finishing: The preview flags rows it couldn't match to a book — assign them a format there so they're included in your totals.
• Watch KENP separately: Page-reads don't count as units sold, so read the KENP figures on their own rather than expecting them in Units Sold.
• Use Compare to spot trends: Switch the Compare dropdown to Same Month Last Year to see how a title is doing against its own seasonal baseline.