This article is part of our Complete Guide to Royalty Management.
If you distribute titles through Pathway, you already know the drill — download a sales report, wrestle with the spreadsheet, and spend far too long turning raw numbers into something your royalty workflow can actually use. Pathway is a valuable sales channel for many independent publishers, but manually processing their reports each period is time you could spend on almost anything else.
The good news is that Royalties HQ natively supports Pathway sales files, so you can upload them directly without reformatting columns, converting file types, or building custom import templates. This guide walks you through exactly where to find your reports, how to prepare them, and how to get them into the system quickly.
Where to find your Pathway sales reports
Your sales data lives inside your Pathway account dashboard. Log in and navigate to the reporting or statements section to find your sales reports for each period. Depending on your arrangement with Pathway, reports may be available monthly or quarterly.
Download the report file for the period you need. If you are catching up on multiple periods, grab them all — you will import them one at a time in chronological order to keep your data clean and easy to audit.
Understanding Pathway’s reporting format
Pathway’s sales files follow a structured spreadsheet format that includes your title information, quantities sold, pricing, and earnings data. The file typically contains one row per title per territory or sales channel, which gives you a detailed breakdown of where your books are selling and at what price.
The key columns you will see include ISBN, title, quantity, unit price, and your net earnings. Royalties HQ reads all of these fields automatically during import — you do not need to understand the file structure in detail or do any manual column mapping. The system handles it for you.
Payment timeline
Pathway typically operates on a quarterly payment cycle, with sales data and corresponding payments arriving some time after the close of each quarter. The exact timing can vary depending on your distribution agreement, so check with your Pathway account manager if you are unsure of the schedule.
This delay matters when you are reconciling sales data against actual payments received. If you work with multiple distributors — say, Amazon KDP alongside Pathway — the payment timelines will not align neatly. Keeping track of which distributor pays when is one of the trickiest parts of managing royalties across channels. For a broader look at how different distributors handle payment timing, see our post on distributor payment timelines.
File preparation — download and do not edit
Once you have downloaded your Pathway sales file, the single most important rule is: do not open or edit the file before uploading it. Even something as simple as opening a spreadsheet in Excel and hitting save can alter formatting, strip hidden metadata, or change date formats — any of which can prevent a clean import.
If you want to rename the file for your own organisation — something like “Pathway-Sales-2026-Q1.xlsx” — that is perfectly fine. Just rename it in your file manager without opening it. The contents need to stay exactly as Pathway delivered them.
Step-by-step: uploading your Pathway sales file
With your file downloaded and untouched, the import process in Royalties HQ takes about a minute:
- Go to the main menu and click Add New Sales
- Drop your sales file into the upload zone, or click to browse for it
- Royalties HQ automatically detects the file as a Pathway format — confirm the detection and click Continue
- The system validates the file contents. If everything checks out, the status will show “Ready to import”
- Click Import to bring the data in
- Each row in your file becomes a sales line, grouped into one or more sales batches
After importing, you will link a publisher income payment to each sales batch. This connects your sales data to the actual money you received from Pathway, which is what drives your royalty calculations downstream.
Royalties HQ supports 12 native file formats from major distributors, so your Pathway files sit alongside data from IngramSpark, Amazon KDP, Lightning Source, and others — all in one place with a consistent structure and full audit trail.
How Pathway fits into a multi-distributor workflow
Most publishers do not rely on a single sales channel. You might have titles on Pathway, Ingram, Amazon, and several others — each with their own report format, payment schedule, and delivery method. The challenge is not any one distributor; it is managing all of them together without letting something slip through the cracks.
A good starting point is getting your file organisation sorted. A consistent folder structure — one folder per distributor, subfolders by period — saves a remarkable amount of time when you are importing files or tracking down a discrepancy months later. We wrote a full guide on this: how to organise your distributor sales files.
Tips for a smooth Pathway import
- Keep original files untouched. Rename them if you like, but never open or edit the contents before uploading.
- Process files in chronological order. This helps you catch any gaps in your data and keeps your records tidy.
- Reconcile against payments. After importing, match each sales batch to the corresponding Pathway payment when it arrives.
- Import regularly. Do not let several periods stack up. The longer you wait, the harder it becomes to spot errors or missing data.
- Organise your downloads. A dedicated folder for Pathway files — named clearly and filed by period — makes every future import faster.
Getting started
If you are setting up your royalty workflow for the first time — or finally moving away from spreadsheets — download our free guide for a complete walkthrough of the process from start to finish. For detailed documentation on every supported file format and the full import process, see importing sales data in our docs.