Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
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!
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.
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!
I see. Looks like I'd have to tweak it in Excel, then. Thank you very much for your suggestions!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here