cancel
Showing results for 
Search instead for 
Did you mean: 
dawnjohnson
Level 5

How do I create a Transaction List Statement for Project on the new platform?I need all invoices and pmts made against those invoices for the duration of the project.

 
3 Comments 3
IrizA
QuickBooks Team

How do I create a Transaction List Statement for Project on the new platform?I need all invoices and pmts made against those invoices for the duration of the project.

Let's pull up a report to see the list of your invoices and payments made within specific projects, dawnjohnson.

 

In QuickBooks Online (QBO), we can run the Invoices and Received Payments or Transaction List by Customer report and customize it to display specific data. Also, please select the correct Report period so the system will display all details covered on that date.

 

Here's how:

 

  1. Go to the Reports menu on the left navigation panel.
  2. From the Find report by name search bar, enter the name of the report.
  3. Click the Customize option.
  4. Choose a date from the Report period dropdown.
  5. You can also change your Rows/Columns by clicking the Change columns, then tick what you wish to add to the report.
  6. Click the Filter dropdown.
  7. Press the Customer dropdown, then choose your customer's name or project.
  8. Once done, press Run report.  

 

If you're customizing in a modern view, kindly refer to this article: Customize reports in QuickBooks Online using modern view.

 

Afterward, you can export or print your report if you want to use it outside QBO.

 

We'll be around to help you further about accessing the list of your invoices and payments, dawnjohnson. Please let us know by clicking the Reply button.

dawnjohnson
Level 5

How do I create a Transaction List Statement for Project on the new platform?I need all invoices and pmts made against those invoices for the duration of the project.

What you're suggesting only seems to have the invoices that have been paid.  I would like to show a transaction history to my client including what has been paid, unpaid and a running total/balance due.  How do I accomplish that?

RoseJillB
QuickBooks Team

How do I create a Transaction List Statement for Project on the new platform?I need all invoices and pmts made against those invoices for the duration of the project.

I know another report you can use to see all invoices and payments linked to your project transactions in QuickBooks Online (QBO), dawn.

 

Aside from the Invoice and Received Payments report, we can also pull up the Transaction List by Customer and customize it to personalize the data displayed. In this report, transactions such as paid invoices, unpaid, and payments linked to them are visible. To make it possible, please follow the steps below:

 

  1. Go to the Reports menu and locate Transaction List by Customer.
  2. Using the modern view, click the Columns option to add additional data you want from the report. Then, choose mark check the following: Date, Transaction type, Num, Posting, Memo/Description, Account full name, Amount, Open Balance, and Customer full name.
    columns 11.png
  3. After that, filter the data with this information: Payment and Invoice.
  4. Select the Report Period, and click Save As.
    filter 123.png

     

Moreover, I've added an article that'll help you customize your report on a classic view. Also, you can save the current customization setting of your reports to prevent you from personalizing it again:

 

 

Please don't hesitate to reach out if you have further questions about reports. I'm here to assist you round the clock with any assistance you may require.

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

Need to get in touch?

Contact us