Is anyone doing this? We are clearly getting having more issues than those picked up by the Incomplete Credit Card Transaction Report, and we're working towards frequent reconciliation with Windcave for card purchases, so I am investigating importing their reports into a local table to do some of the reconciliation automatically. I don't really understand all of the columns, for instance there are several columns that look like they might be a transaction id column, but none are unique, even with just a month's transactions.
Also, is it just me or is the time field mangled, with month encoded as day and vice-versa?
I just made a post related to this here. Would someone be willing to share their reconciliation report? I can make any adjustments to accommodate our organization but it would be super helpful to have an existing report to work off of.
Thanks!