Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi
Is it possible if I would like to customize report of "Invoice and received payment". Currently the report only provide the payment detail & invoice detail in separated line. I would like to show the invoice list and payment is allocated for which invoice
Hi Billing_Team,
We're unable to customize the Invoice and Received payment report like what you've described. As a workaround, you can use the Invoice List report. This shows the invoice amount and open balance on one line. You can export it to Excel and add a column for the difference. The difference would be the payment applied to each of the invoices.
We'll be here if you have other questions. Have a good day!
Hi Jess,
Thank you for your reply.
But is there any report which can show up payment details. While we post payment transaction in Quickbook, we did allocated the paid amount to specific invoices. But I can not find any report which match invoice & allocated paid amount
Hi there, Billing_Team.
QuickBooks Online doesn't have a report that shows a list of invoices with a column for allocated payments. You can customize the Transaction List by Customer report to show all payments made by the customer.
Here's how:
You can also send feedback about getting more report options in QuickBooks Online. Just go to the Gear icon and click Feedback.
Add another comment or reply below if you have follow-up questions. The Community is always here to answer them for you.
Hi QB team,
I have another concern with report Invoices and Received Payments. In this report, the column of MEMO/DESCRIPTION does not show up infomation even we did input the note in Memo field while post the trasaction in Quickbook
But in another reports, such as "Transaction list by clients", the memo could be shown up.
I don't know why we have diffrences in showing Memo/Description.
Could you please help to advise how we can show up info in the column Memo/Description of Invoices and Received Payments report
I've replicated this and I know where to put the memo so it shows on the report, Billing_Team.
When creating an invoice, make sure to enter the memo or description in the Message displayed on statement field as well. This is located in the lower left-hand corner of the invoice.
The memo you enter on this field is for recording purposes only and will not be displayed when printing the invoice. The ones that you enter on the description or memo box are for the customers to see.
Please let me know if you have any other concerns.
Hi,
I mean here is the received payment transaction journal. There is one memo field only while I input this transaction. I added screenshot for your reference. The 1st screenshot is the received payment transaction I input & added note in the memo field
However, while I run the Invoices and Received Payments report, it did not show up the memo I already noted in received payment transaction. (the 2nd screenshot capture the report did not show up the memo)
Hi again, Billing_Team.
The Memo/Description column of the Invoices and Received Payments report will only include the entries from the Message displayed on statement field. The Received Payment screen does not have this field, which is why they're showing in the report.
You might want to use the Message displayed on statement field in the invoice if you'd like to have the information displayed in the report.
You can also include this in your feedback so our engineers can review this as well. Add another reply below if you have other questions.
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