How to Reconcile Book Sales With Distributor Statements
A title sold well, but the distributor statement shows less revenue than expected. Check which returns, discounts or date differences explain it.
What to pull
Use Excel sales and statement tabs or export ISBN-level sales from your distributor and returns and credits from accounting. Keep ISBN, territory, period, units and line type.
How to check it
Match by ISBN, territory and period. Reconcile net units and amounts separately. Keep late returns and prior-period corrections visible.
Select the relevant sheets in Jolene.pro and run this check.
Which titles have unexplained statement differences? Show adjustments and source rows.
What to do with the result
Send the distributor only the unresolved lines with ISBN, period and adjustment references.
Verify terms, timing and currency before posting an adjustment.