A big thank you to all of you for your posts!

I've solved the problem - its actually quite simple. Selling Manager Pro has a view called 'Sold Awaiting Shipment'. In that view you get a list of all the transactions that have been paid for. All you ned to do is select transactions (using the checkboxes on the left hand column) and then click on the drop down menu titled 'Other Actions' and select the 'Download' option. Within a few seconds you get a .csv.txt file. If you rename the suffix of the file to just '.csv' (by deleting the '.txt' part) and open it in Excel - voila!

Thanks,

Meher.