cancel
Showing results for 
Search instead for 
Did you mean: 
Skellytonne
Level 3

How do I run a report that as to when the customer fully paid an amount?

Hello, I would like to know if there is a way to create a transaction report with the ff. features:

 

-Shows as to when the customer finally paid in full.

-Shows the full value of the payment. 

 

I only managed to create a transaction report as to when the customer fully paid, but I only managed to see the final down payment. (Context: In QB, we record the payments in installments, and sometimes it doesn't fall under the same month).

 

I need to use this to be able to compute the commission fee of our agents. They will only get the commission if the customer fully paid already, even if their order/invoice was months ago.

 

Thank you.

 

4 Comments 4
Kristine Mae
Moderator

How do I run a report that as to when the customer fully paid an amount?

You can pull up the Transaction List by Date report, Skellytonne. It will show you the partial payments and invoices.

 

Let me guide you how:

  1. Click Reports.
  2. Enter Transaction List by Date in the Find report by name field.
  3. Click Customize, then go to Filter.
  4. Click the Transaction Type drop-down arrow, then select Invoice and Payment.
  5. Hit Run report

 

You can memorize the report so you'll no longer go over to the same customization process.

 

If any questions arise, please feel free to leave a comment below. We're just one comment away. Keep safe!

Skellytonne
Level 3

How do I run a report that as to when the customer fully paid an amount?

Hello, Kristine Mae.

 

I appreciate the quick response.

 

Would it be possible to get the customer's full payment stated in the report even if they had several downpayments in the past month? Let's say I only want the number of customers who fully paid on the month of August. There is a 150,000 balance by one customer, and he paid the ff.:

 

50,000 DP on June

50,000 DP on July, 50,00

final 50,000 on August

 

- but the report for August will show 150,000 to signify full payment instead of just 50,000? Thank you.

Catherine_B
QuickBooks Team

How do I run a report that as to when the customer fully paid an amount?

Hello there, Skellytonne.

 

The Report period will also matter when you customize reports. If you include the month of June and July, the down payments including the total will show. You'll want to export the report to Excel and further customize the report to get the data you need. 

 

You can also look into this article to give you more details in customizing reports in QUickBooks Online.

 

Feel free to leave a reply below if there's anything else that you need help with. Take care!

Skellytonne
Level 3

How do I run a report that as to when the customer fully paid an amount?

I see. Looks like I'd have to tweak it in Excel, then. Thank you very much for your suggestions!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us