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

accounts-gapreno · ‎June 04, 2022

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?

KlentB · ‎June 04, 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:

Go to the Reports menu.
Search for Transaction List by Customer.
Click the Customize button, then set the appropriate report date.
Go to the Rows/Columns section, then add the Date and A/R Paid columns.
Head to the Filter section, then select Invoices and Payments from the Transaction Type drop-down menu.
From the A/R Paid drop-down menu, select All.
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:

Go to the Reports menu.
Search for Transaction List by Supplier.
Click the Customize button, then set the appropriate report date.
Go to the Rows/Columns section, then add the Date and A/P Paid columns.
Head to the Filter section, then select Bill, Bill Payment (Check), Bill Payment (Credit Card), and Expense from the Transaction Type drop-down menu.
From the A/P Paid drop-down menu, select All.
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

KlentB · ‎June 04, 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:

Go to the Reports menu.
Search for Transaction List by Customer.
Click the Customize button, then set the appropriate report date.
Go to the Rows/Columns section, then add the Date and A/R Paid columns.
Head to the Filter section, then select Invoices and Payments from the Transaction Type drop-down menu.
From the A/R Paid drop-down menu, select All.
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:

Go to the Reports menu.
Search for Transaction List by Supplier.
Click the Customize button, then set the appropriate report date.
Go to the Rows/Columns section, then add the Date and A/P Paid columns.
Head to the Filter section, then select Bill, Bill Payment (Check), Bill Payment (Credit Card), and Expense from the Transaction Type drop-down menu.
From the A/P Paid drop-down menu, select All.
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.

Topics

Training

Community

Resources

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

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

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

Need to get in touch?