BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
DW-000000
Level 2

Reply to message

Hi there, 

This report is kind of what I need, but if I have a payment that I partially apply across multiple invoices, I cannot retrieve that data. It will tell me the total payment number and the invoice portions show to invoice amount, not the amount of the payment applied against that invoice.

 

For example 

2024-04-18   Payment   371006    86.00     Store Sales
2024-04-17   Invoice      1256        400.00   Store Sales
2024-04-16   Invoice      1254        410.00   Store Sales

 

In this example, there is no way to know how the $86 was allocated without drilling down into each payment. 

 
I would like to get a non-grouped list of payments that have been put against each invoice number. Or even change this report to show the allocation rather than the invoice total.

 

Here is what I would ideally like to see:

 

2024-04-18   Payment   371006    43.00     Store Sales  1256    Visa       
2024-04-18   Payment   371006    43.00     Store Sales  1254    Visa     

 

 

Need to get in touch?

Contact us