Invoices and received payments

Hi SvitlanaP!

Thanks for posting again here. Let me help you in running the report you need.

When you run the Invoices and Received Payments report, click the small Gear icon next to the Export button. Then, add the A/R Paid column by checking it. This allows you to see if the invoice is fully paid or not. If not, you can click the transaction to see how much payment is applied to it.

You can also create a customer statement in QuickBooks Online. This will list all the transactions with the settlement amount.

I added some links you can check. These will list all available reports in QuickBooks Online and how to customize them:

• Customize reports in QuickBooks Online

• Reports included in your QuickBooks Online subscription

Comment below if you need more help. Take care!

How do I created this report in Quickbooks Enterprise Desktop?

Hello @SrTeM,

Welcome to the Community. I'd be glad to help you create the report in QuickBooks Desktop Enterprise.

You can run the Customer Balance Detail report to show the details you need. Personalize the columns and filters to show the invoices and payments, as well as the specific filters.

Here's how:

1. Click the Reports tab at the top menu bar.
2. Hover your cursor to Customers & Receivables.
3. Press Customize Report.
4. Go to the Display tab.
5. Choose the date range.
6. Filter the columns. 
7. Go to the Filters tab.
8. Choose the transaction types you want to include in the report.
9. Hit OK.

Additionally, I recommend visiting the following link to learn more about how you can track your sales using predefined reports in QuickBooks: Customize customer, job, and sales reports in QuickBooks Desktop.

Reach out to me if you need further assistance running the report in the Desktop version. I'll be happy to help you some more.

These instructions must be incorrect. I get a report that shows payments and invoices, but not which payment goes with which invoice(s).  Where is that information?

Thanks for joining this thread, corneroffice.

I ran a copy of the Invoices and Received Payments report in our test drive account and was able to see customer payments as well as invoices after customizing it with AlexV's instructions.

To identify which invoice(s) a payment is linked with, you can click its record in the report, then review which transactions it's applied to in your Outstanding Transactions section.

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

If there's any additional questions, I'm just a post away. Have a great day!

It is ridiculous that after decades, QB can't provide a report showing:  Customer, Invoice #, Invoice date, Paid status, Payment amount, Payment date - all on one row.  It is a simple ask.  Ridiculous.

It is ridiculous that QB can't provide a report with: Customer name, Invoice #, Invoice date, Paid status, payment date, payment amount.  Maybe even show sales tax amount.  All on one row.  Simple.  Effective.  I've wasted hours trying to get the info I need.  Ridiculous.

You are absolutely correct awolfe7. I too want a report to show me how many days it took a customer to pay and what the payment method was. Instead I spend hours manually updating the Invoices and Received Payments report to move the payment data to the same line as the invoice and adding a column to make the calculation. I've even tried writing a macro but cannot quite get it done.

Hello there, @lynneb99. 

I appreciate you sharing your ideas about adding additional customization when pulling up the Invoices and received payments report in QuickBooks Online (QBO). We'd love to hear more of your insights regarding this so I recommend sending feedback to our product developers. This way, they can further review which parts of the program need enhancements and consider adding them to future updates. Please refer to the steps below:

1. In your QBO account, navigate to the Gear icon.
2. Next, select the Feedback option.
3. From there, enter the details of your product comments, suggestions, and requests. 
4. Then, click Next to submit. 

You can also visit our Customer Feedback for QuickBooks Online website to track the suggestion you've submitted. 

For additional guidance in running reports in QBO, feel free to visit this article: Run reports in QuickBooks Online. 

If you have any other concerns about running reports in QBO, please don't hesitate to post a reply below. I'd be glad to lend you a hand. Have a good one and keep safe. 

NONE of these answer the question.  It is a simple report, it shows the payment and what invoices that payment paid!  NOT by clicking on each payment and seeing the payment screen.  That is NOT helpful at all!

This is the most basic of reports I don't understand why it isn't anywhere!

 I know a report that shows the payment and its associated payment, Kimisyntec.

It isn't the kind of experience we want you to come across. We can run the Invoices and Received Payments report to show the mentioned details. Here's how:

1. Click the Reports tab.
2. Enter and select Invoices and Received Payments.
3. Click the Customize button.
4. On the Row/Column section, select Num and Amount.
   
5. Hit Run report.

I've also added included this article if you want to pull up the report with the same customization: Create and access memorized reports.

I'm just a post-away to help with any of your concerns.

Hi Adrian

I am using QBs Enterprise, I believe your info below is for QBO?

Thanks

I manage a membership organization and this is what I have worked out to create a report with days to pay calculated and optionally the method of payment.

Run a Profit and Loss for All Dates or Custom dates if that works for you.
Choose the income item which will return what came in during your chosen timeframe.
In my example it is Annual Dues 2022.
Customize the report to include: Name, Number, Date, Create Date (added from the list of columns), Amount (omitted for this example).
Run the report.
Export to Excel.
Delete the header (or cut it and save it to put back in later) the merged cells can cause issues when trying to work quickly.
Sort by Name field if you will be adding the payment method steps.
Insert two columns after Create Date.
Select the data in Create Date.
Select the Data tab in the ribbon.
Choose Text to Columns, Delimited with Space. Next, Finish.
Delete the two columns containing the time stamp.
In the first empty column to the right, change the format to Number and remove the decimal. In the first cell, enter the formula =C2-D2 (or whichever columns your Date and Create Date are). On enter, the number of days between the Invoice date and the Payment date should appear.
Copy the formula down. Select this column of data, copy and paste values in the same column.

To add the payment method:
Run Invoices and Received Payments from the report list.
Select a Custom date range that matches the Profit and Loss report that was just run.
Customize to keep only the Payment Method and Member (Customer) columns, in that order.
Export to Excel.
Delete headers. Delete Column A. Optional - Delete the new Column B or keep for verification.
Select all data.
Ctrl+G -> Click Special -> Choose Blanks -> click Ok
Ctrl+- (minus sign) All blank or name only rows will be deleted.
Copy and Paste Column A and B if kept to the Profit and Loss spreadsheet.
Close the Invoices and Received Payments spreadsheet without saving.

For this example, I changed the member names to Member 1, 2... to protect the guilty who take forever to pay.

Thank you for telling me that!  Its almost the type of report I created myself as well.  Mine too more work!

Thank you for getting back to us and providing us with more information about your concern, @Kimisyntec.

I can help you with running the same report in QuickBooks Desktop. 

Yes, you're right! The steps provided above by Adrian_A are for QuickBooks Online (QBO). For QuickBooks Desktop (QBDT), you can run the Customer Balance Detail report. It'll show you the invoices and payments that make up each customer's balance. 

Here's how:

1. Go to the Reports menu.
2. Hover your cursor on Customers & Receivables and choose Customer Balance Detail.
3. Click the Customize Report.
4. Go to the Filters tab to set all the information that you'd like to include in this report.
5.  Select OK once you're done.

Check this article for more information about other reports that you can run: Customize customer, job, and sales reports in QuickBooks Desktop.

For more information about managing and customizing reports in QBDT, consider checking out this article for future reference: Customize reports in QuickBooks Desktop.

Reach out to me if you need further assistance running the report in the Desktop version. I'll be glad to assist you further. Enjoy the rest of the week!

I found a way to show the payment with the invoices that it was applied towards. On QuickBooks Online, Start with the Invoices and Received Payments Report.

1. Change Columns.

The Columns I use are: Customer, Date, Transaction Type, Number, Amount, and Open Balance.

2. Change the date filter as needed.

3. Filter: Customer. Select only the customer(s) you want included in the report.

4. Run the report.

5. Save Customization. Title it what you want.

Works for what I need it for, hopefully this will work for you also.

Corneroffice's question was how to do it in Enterprise, your answer shows how to do it in Online.

When I run the invoices and Received Payment report it shows several payments but no invoice that was paid with the payment reported on the report.

Further down the report it will break out invoices and payments. We have QB online it should be a simple report to run but I don't understand why this report is not accurate.

Hi there,

Let me provide information about generating the Invoices and Received Payments report in QuickBooks Online (QBO).

Before anything else, I'd like to clarify what you mean exactly by the report breaking out invoices and payments further down. You can also reply to this post and add a screenshot about how the report was inaccurate. Providing additional information will help me offer you the most precise solution.

The Invoices and Received Payments report allows users to track payments received for specific invoices, providing a detailed overview of which payments are linked to which invoices. For further insights into the transactions listed in the report, simply click on the payment link in the report. By doing so, QBO will direct you to the transaction page, providing detailed information.

For more info on running reports, please refer to this article: Run reports in QuickBooks Online.

For future use, here's a guide on saving a report's customization settings: Memorize reports in QuickBooks Online.

Keep your posts coming if you have any other concerns about generating specific reports in QuickBooks. I'll be right here to help out.

Hello QB Support - I use QBO.  Maybe it would help to start with the question we are trying to answer.  For me, I am looking for a report that shows the date an invoice is paid (on the same line as the invoice) because I want to answer the question of "what has been the average number of days that it has taken for this customer to pay me over the past x months?".

If there a report that would show me this?  Or that I can run where I can easily export to Excel and add a formula that subtracts the payment date from the due date?

If not, can we simply get a field added to the "Change columns" section of the "Invoices and Received Payments" report that has the payment date?

Knowing how your customers pay you is a very important metric.  It would be great if this were easy to get from QBO.

Hello there, andyb6. I understand you are looking for a report that displays payment dates for invoices in QuickBooks Online.

As of now, additional columns for the payment date in the Invoices and Received Payments report in QuickBooks Online are unavailable. We'd love to hear more of your insights regarding this. I recommend sending feedback to our product developers. This way, they can further review which parts of the program need enhancements and consider adding them to future updates. Please refer to the steps below:

1. Go to the Gear icon.
2. Select Feedback.
3. Enter your suggestion and click Submit Feedback.

For more information on running reports in QuickBooks Online, you can check out this article: Run reports in QuickBooks Online. 

Furthermore, memorizing a report allows you to save it with its current customization settings.

If you have any other concerns about running reports in QBO, please don't hesitate to post a reply below. I'd be glad to lend you a hand. Keep safe.

@andyb6 

Run a 'Invoices and Received Payments' report.  Export it to Excel and then subtract the invoice date from the payment date.  Although an 'Average Days to Pay' report would be super helpful, this works.  

Thank you rainflurry.  Unfortunately for me the "Payment" and the "Invoice" lines do not easily match up so this becomes a terribly manual process which is not feasible due to the time required.  If QB could add a "Date Invoice Paid" column (maybe using the last payment date if there are multiple payment dates for a particular invoice), that would work.  Thanks again for your feedback.