This addon goes through the in-game bank transaction history and harvests all deposits that are older than a specified transaction ID. The results are then written to SavedVariables and can then be easily imported into various spreadsheets.
The addon is hardcoded to only work for Black Market Wares, but it would be trivial to update it to work for another guild.