Timeslips 2016

Hi,

I have an attorney who just started who will be getting a commission on all of his billable hours once payment has been collected from the client. Because I can't get a report with both a slip listing with the respective invoice number it was billed on, and an invoice list with applied payments, I have to create multiple reports that I export to Excel where I can manipulate the data to get the information that I need.

So, I am trying to get an Excel report that lists the payments received within a range of dates that lists the invoice number for which it was applied. Simple A/R list reports do not breakout single payments that were applied to multiple invoices. Then, when I try to generate a custom report listing all A/R transactions, the field for "Billed on invoice no." for a payment brings up a global invoice number that doesn't match the actual invoice of the applied payment. It looks like it is associated with next invoice that included the A/R transaction list on that bill. A standard A/R Transaction listing that includes the payment distribution is cumbersome - it is generated in a columnar format, not a list, and the "Invoice Number Text" field includes the text "Applies to Invoice:" before each invoice number. I would rather not spend hours trying to manually change all of this data to get what I need. A G/L Transfer Register Report looks like it would have everything that I need, but it is only available in a print out.

Is there any report that I may be overlooking that will give me the correct invoice number for the applied payments?

Thanks in advance.