cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
accounts-gapreno
Level 1

Create reports for income and expenses to show invoice date and payment date columns?

Hi 

I want to create two reports. One report for income to show all a list of invoices both paid and unpaid (showing this) and then a column for the invoice date and a column to show payment date is this possible?

I then went to create an expenses report with a column for bill / expense / DD date and then a column to show payment date along with the supplier and amount paid.  

Is this possible?  I've looked at the invoice list and the applied payments which looks good to begin with but it doesn't list unpaid invoices.  I've also looked at the Invoist List By Date report which shows both paid and unpaid invoices but doesn't show the payment date.  

Is the above two reports at all possible?
Solved
Best answer June 04, 2022

Accepted Solutions
KlentB
Moderator

Create reports for income and expenses to show invoice date and payment date columns?

I'll help you in generating that report, accounts-gapreno.

 

You can pull up and then customize the Transaction List by Customer report to show all the invoices you've issued for a certain period of time. Here's how:

 

 

  1. Go to the Reports menu.
  2. Search for Transaction List by Customer.
  3. Click the Customize button, then set the appropriate report date.
  4. Go to the Rows/Columns section, then add the Date and A/R Paid columns.
  5. Head to the Filter section, then select Invoices and Payments from the Transaction Type drop-down menu.
  6. From the A/R Paid drop-down menu, select All.
  7. When you're done, click Run report.

With regard to the expense report, we're unable to set a particular column for bills and expenses. QuickBooks Online will list them all in a single column. The closest report that you can customize to generate this data is the Transaction List by Supplier report. Here's how  to run it:

 

  1. Go to the Reports menu.
  2. Search for Transaction List by Supplier.
  3. Click the Customize button, then set the appropriate report date.
  4. Go to the Rows/Columns section, then add the Date and A/P Paid columns.
  5. Head to the Filter section, then select Bill, Bill Payment (Check), Bill Payment (Credit Card), and Expense from the Transaction Type drop-down menu.
  6. From the A/P Paid drop-down menu, select All.
  7. Once done, click Run report.

For more tips on how to speed up the  reporting process in QBO, you can read these articles:

 

I just comment away if you have any other concerns or further questions about this topic. Have a great day ahead.

View solution in original post

1 REPLY 1
KlentB
Moderator

Create reports for income and expenses to show invoice date and payment date columns?

I'll help you in generating that report, accounts-gapreno.

 

You can pull up and then customize the Transaction List by Customer report to show all the invoices you've issued for a certain period of time. Here's how:

 

 

  1. Go to the Reports menu.
  2. Search for Transaction List by Customer.
  3. Click the Customize button, then set the appropriate report date.
  4. Go to the Rows/Columns section, then add the Date and A/R Paid columns.
  5. Head to the Filter section, then select Invoices and Payments from the Transaction Type drop-down menu.
  6. From the A/R Paid drop-down menu, select All.
  7. When you're done, click Run report.

With regard to the expense report, we're unable to set a particular column for bills and expenses. QuickBooks Online will list them all in a single column. The closest report that you can customize to generate this data is the Transaction List by Supplier report. Here's how  to run it:

 

  1. Go to the Reports menu.
  2. Search for Transaction List by Supplier.
  3. Click the Customize button, then set the appropriate report date.
  4. Go to the Rows/Columns section, then add the Date and A/P Paid columns.
  5. Head to the Filter section, then select Bill, Bill Payment (Check), Bill Payment (Credit Card), and Expense from the Transaction Type drop-down menu.
  6. From the A/P Paid drop-down menu, select All.
  7. Once done, click Run report.

For more tips on how to speed up the  reporting process in QBO, you can read these articles:

 

I just comment away if you have any other concerns or further questions about this topic. Have a great day ahead.

Need to get in touch?

Contact us