@kiwidude
I hang my head in shame on two counts; firstly you are correct about the original post and secondly, if I had bothered to read to the report from the Kindle Collections plugin a bit more then I would have seen that it lists which collection the book with no file entry is listed.
I'll go and lurk a bit more before posting
Andy