Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

I'm trying to calculate what I have collected form last year's AR. How to get a report showing all current year payments that refer only to invoices from last year?

 
Solved
Best answer April 03, 2020

Best Answers
QuickBooks Team

I'm trying to calculate what I have collected form last year's AR. How to get a report showing all current year payments that refer only to invoices from last year?

Hi there, @francisconeto.

 

You can utilize the Invoices and Received Payments report. However, the Date filter for this report is based on the Payment date. As a workaround, you'll need to export an excel file that shows all the current year payments. Then, customize the excel file to show the last year's invoices only.

 

Here's how:

  1. Go to Reports.
  2. In the Find report by name field, enter 'Invoices and Received Payments.'
  3. In the Report period drop-down button, select This Year.
  4. Select the Export icon. Then select Export to Excel.

The screenshots below show you the third and fourth step.
Capture5.PNG

Once done, you can customize the report using the excel file. 

 

If you need further assistance, please comment down below. I'll be around to help. Keep safe.

 

 

View solution in original post

1 Comment
QuickBooks Team

I'm trying to calculate what I have collected form last year's AR. How to get a report showing all current year payments that refer only to invoices from last year?

Hi there, @francisconeto.

 

You can utilize the Invoices and Received Payments report. However, the Date filter for this report is based on the Payment date. As a workaround, you'll need to export an excel file that shows all the current year payments. Then, customize the excel file to show the last year's invoices only.

 

Here's how:

  1. Go to Reports.
  2. In the Find report by name field, enter 'Invoices and Received Payments.'
  3. In the Report period drop-down button, select This Year.
  4. Select the Export icon. Then select Export to Excel.

The screenshots below show you the third and fourth step.
Capture5.PNG

Once done, you can customize the report using the excel file. 

 

If you need further assistance, please comment down below. I'll be around to help. Keep safe.

 

 

View solution in original post

Need to get in touch?

Contact us