Thanks Katrina! This is my organization's request, so just to give a little feedback:

We would love to reconcile all individual Dancewave transactions in our accounting system against the monthly Wallet statements. But the transactions that comprise the payouts included in those statements don't actually match the calendar month represented on each statement (seemingly ending ~2 days before the end of the month, but also with a 5 PM ET cutoff on that date before switching mid-date to the next statement month).

This alone makes it difficult to batch, import, and reconcile the transactions against each statement in our accounting software (without manually determining where the final payout of each month's statement cuts off, excluding all following transactions, and saving them for the next month's import).

However, the fact that payouts on the same calendar date can hit one of two statements will then still make it impossible to reconcile in our books (at least without manually changing the transaction date of all those straggler transactions) - since the statement period reconciliation filter is applied by date, and transactions on that single boundary date span two different statements.

What would at least allow us to import a single valid date for each transaction is to add a final column to the Payout Details export that represents the "payout date" for each transaction, which could then become the accounting date in our software. (This isn't perfect - we'd rather use the donation date - but it's an option.)

Please feel free to contact me directly at [email protected] to discuss further if helpful - thanks!