How to Track Book Returns Before the Window Closes
Every unsold new book that came in on returnable terms has a date after which it is yours for good. Most stores know this and still miss windows, because the date lives on an invoice in a drawer and nobody sees the total until it is too late. The fix is a short weekly routine that turns those dates into a list ranked by money.
Record the return-by date when the book comes in
The window starts from the invoice date or the receiving date, depending on the vendor's terms. Either way, the moment to capture it is receiving. For each delivery, note the vendor, the invoice number and date, and the vendor's window. Every copy on that invoice then carries a return-by date. Without it, a returns list has to be rebuilt from paper every time.
Know which titles are returnable at all
- Non-returnable stock, often bought at a deeper discount, never goes on the list.
- Publisher returns conditions are carried in ONIX feeds for many titles, so a title record can say whether it is returnable without anyone looking it up.
- Wholesaler and publisher terms differ. A title bought from a wholesaler follows the wholesaler's terms, even if the publisher's own are different. Read each vendor's current terms; they change.
Rank by dollars at risk, by week
A list sorted by date tells you what is closing. A list summed by week tells you what it is worth. Group every returnable copy still on the shelf, with no sale in the last 90 days, by the week its window closes, and add up the cost:
| Window closes (example) | Titles | Copies | Cost at risk |
|---|---|---|---|
| Week of Oct 20 | 23 | 41 | $1,980 |
| Week of Oct 27 | 17 | 29 | $1,440 |
| Week of Nov 3 | 31 | 55 | $2,610 |
Work the nearest week first, but look one week ahead: a large week coming up is the time to put books on display rather than in a box.
Build the pull list and the paperwork together
- Print or open the pull list by section and shelf, so one person can walk the floor once.
- Scan each copy as it comes off the shelf. Anything not found is a count problem; note it.
- Check the vendor's minimums before you pack. Some vendors want a minimum number of copies or a minimum value per return.
- Request the return authorization the way the vendor asks for it, with the list of ISBNs and quantities.
- Pack, label each carton with the authorization number, and keep the list with the shipping receipt.
Check the credit comes back
The return is not done when the box leaves. Match each credit memo against what you sent: copies, ISBNs and the credit per copy. Short credits are common and rarely chased. A simple sheet with return date, authorization number, value sent, credit received and difference catches them.
Where Bookstore Counter fits. Bookstore Counter is the floor and back office on top of the POS you keep: scan books in with their return-by date, see the returns pull list, count a section, and look up on hand and last sold from a phone. It reads ONIX files and POS sales exports and never writes to the POS. Returns ranked by dollars at risk, used-book offers from your own sales history and special orders are being built next and are not in the app yet. More about Bookstore Counter.
More guides: all Adelyons guides