Hoopla Circulation Reports
Turning library borrows into royalty data
hoopla digital, run by Midwest Tape, lends ebooks, comics and audiobooks to library patrons in the US, Canada, Australia and New Zealand. Libraries pay for each borrow, and you get a share of that payment. Hoopla doesn't send a sales report. It sends a circulation report, with one line per borrow, and Familiar adds those borrows up into monthly totals for each book.
Do you deal with hoopla directly?
This guide is for publishers with their own hoopla vendor account. If your books reach hoopla through Draft2Digital, INaudio (formerly Findaway Voices), IPG or another distributor, you won't get this report. Your hoopla earnings are already in that distributor's statement, so upload that instead and don't count them twice.
The Report You Need
Circulation report (.csv)
The file opens with a Vendor: line naming your company, then a blank line, then a table whose first column is Model. Each row is one borrow, with its date and time, title, format, ISBN, the borrowing library and country, what the library paid (Revenue) and your share (Net Due). Upload it exactly as hoopla provides it; you don't need to delete the Vendor line.
How to Get Your Report
Sign In to the hoopla Vendor Portal
Content providers sign in at vendor.hoopladigital.com, which is also linked from Midwest Tape's content providers page.
Download the Circulation Report as CSV
Download the circulation report for the period you're paying royalties on. hoopla doesn't publish documentation for the vendor portal, so we can't point you to the exact menu. If you can't find the report, ask your hoopla content contact for the circulation report in CSV format.
Upload to Familiar
Upload the CSV and choose Hoopla if it isn't selected for you (a filename containing “hoopla” is recognized automatically). You don't pick a month: every borrow carries its own date, so a report that spans more than one month is split correctly.
How Familiar Reads the Report
- • Each row counts as one unit. Borrows are added up by book, country and month, so 300 borrows of one title in July become a single line with 300 units.
- • Revenue (what the library paid) is recorded as gross revenue, and Net Due (your share) as your royalties received.
- • Format comes from the Format column: EBOOK and COMIC count as ebooks, AUDIOBOOK as digital audio.
- • No returns or printing costs: a borrow can't be returned for a refund, and digital lending has no manufacturing cost.
- • Familiar keeps the country of each borrow. The library name, state and postal code stay in your original file.
Troubleshooting
“This file does not look like a Hoopla circulation report”: Familiar couldn't find the header row that starts with Model. Make sure you uploaded the circulation report, not a payment summary, and that it hasn't been edited.
An error about a missing ISBN: every borrow needs an ISBN to match it to a book. Check the row the error names. If hoopla has listed a title without an ISBN, contact hoopla to correct the metadata.
Very small amounts per row: that's normal. Each borrow typically earns cents, and the totals come from volume.