Skip to main content
A
accounts-gapreno
June 4, 2022
Solved

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

  • June 4, 2022
  • 1 reply
  • 0 views
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?
Best answer by KlentB

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.

1 reply

KlentB
KlentBAnswer
June 4, 2022

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.

Terms & ConditionsAccessibility statement