cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
gprince
Level 1

With QuickBooks Online, how can I create a statement for a customer that shows each invoice and each payment applied to each invoice for the past year?

All I get is a list of invoices and the summary of the payments applied to that invoice. I want to get a separate line for each item:
1. invoice amount
2. first payment for that invoice
3. second payment for the invoice
4. second invoice date & amount
5. payment applied to balance
6. next payment applied to balance
at bottom show outstanding balance.
Solved
Best answer November 25, 2019

Best Answers
JamesM
QuickBooks Team

With QuickBooks Online, how can I create a statement for a customer that shows each invoice and each payment applied to each invoice for the past year?

I see what you're saying. That feature isn't available yet in QuickBooks. I recommend sending feedback about this to our engineers by clicking the Gear icon and looking for Feedback. New product ideas and improvements are based on the feedback we get from users like you.

 

Let me know if you have other question. I'll be here to help. 

View solution in original post

3 Comments 3
JamesM
QuickBooks Team

With QuickBooks Online, how can I create a statement for a customer that shows each invoice and each payment applied to each invoice for the past year?

Hi there,

 

Congrats on your first post in the Community. I'd be glad to show you how to create a statement for a customer which shows each invoice.

 

Based on what you've described, you'd need to run a Transaction Statement to view the info you're looking for. To do this, click the Plus (+) icon and look for Statement. Once you have the Statement page pulled up, change the Statement Type to Transaction Statement. I'll attach an image below for visual reference: 

 

 

 

Let me know if you have other questions. I'll be here to guide you through the right path. :) 

gprince
Level 1

With QuickBooks Online, how can I create a statement for a customer that shows each invoice and each payment applied to each invoice for the past year?

Thanks for trying on this. But I'm not getting what I need. I get

Invoice #1 amount - payments = balance one line

Invoice #2 amount - payments = balance on second line

 

I need Invoice #1 on line 1

payment on line 2

payment on line 3

payment on line 4

invoice #2 on line 5

payment on line 6

 

In chronological order, showing what happened on each date.

 

Thanks.

JamesM
QuickBooks Team

With QuickBooks Online, how can I create a statement for a customer that shows each invoice and each payment applied to each invoice for the past year?

I see what you're saying. That feature isn't available yet in QuickBooks. I recommend sending feedback about this to our engineers by clicking the Gear icon and looking for Feedback. New product ideas and improvements are based on the feedback we get from users like you.

 

Let me know if you have other question. I'll be here to help. 

Need to get in touch?

Contact us