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

Customize receivable report with payment detail

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

7 Comments 7
JessT
Moderator

Customize receivable report with payment detail

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.

  1. Go to Reports.
  2. Search for Invoice List.
  3. Change the date range of the report.
  4. Click the Export icon and choose Export to Excel.
  5. In Excel, add another column for payments and create a formula to get the difference.

We'll be here if you have other questions. Have a good day!

Billing_Team
Level 1

Customize receivable report with payment detail

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

JenoP
Moderator

Customize receivable report with payment detail

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:

 

  1. Go to the Reports menu, then look for Transaction List by Customer.
  2. Click Customize and scroll down to the Filter section.
  3. Look for Transaction Type and select Payment.
  4. Click Run Report.

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. 

Billing_Team
Level 1

Customize receivable report with payment detail

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

SophiaAnnL
Moderator

Customize receivable report with payment detail

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.

Billing_Team
Level 1

Customize receivable report with payment detail

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)

Screenshot 1.pngScreenshot 2.png

JenoP
Moderator

Customize receivable report with payment detail

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. 

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

Need to get in touch?

Contact us