I would like to export details about pledge payments that are applied to two or more pledges. I mainly want the import id for pledge, import id for payment, and the amount applied from the payment to each pledge. I would probably expect the result in query for example to have two rows if the payment was applied to two pledges. So for a $30 payment split $20/$10;

• $20 to $100 pledge #1
• $10 to $80 pledge #2

Current functionality is missing or way over the top with unusable options.

More details.

1. Query does not expose the field for import id of payments applied to the pledge, nor does it expose the field for the import id of pledges a payment applies to.
2. Import to create a file does expose the pledge import ID for the payment, but it doesn't show the 2nd+ pledge info. I only get 1 pledge import id.
3. Export has this ability, but since you have to choose the number of payments (we could have a whole lot for payroll deductions and such), and the number of installments (we could have a whole lot here, too). This makes the export file populated with hundreds of columns for a single pledge. So Export is not sufficient for this.