Skip to main content
A
accountingnwt
May 31, 2023
Solved

Payments applied to invoices

  • May 31, 2023
  • 4 replies
  • 0 views

Is there a report to show the original invoice amount and the payments applied to that invoice by the invoice number for a particular customer?

Best answer by ChristineJoieR

Yes! There is. @accountingnwt. I can show you the report you need to pull up in QuickBooks Online.

 

Reports show you the best picture of your company. It shows your data on your sales and expenses. 

 

Since the data you need to view consists of the invoice number, invoice, payment applied, and the customer name, I recommend pulling up the Invoice and Received Payments. This way, it will let the data show on your screen. We'll have to customize the file a bit.

 

  1. Go to the Report tab, and find the Invoice and Received payment in the Search bar.
  2. Next, sort the dates and other details. 
  3. Then, press the Customize button in the upper left to change the column.
  4. Navigate to the Rows/Columns dropdown and put a checkmark on the Customer checkbox.
  5. Hit Run Report once done.

 

 

 

See the result below:

 

 

Pick this article for additional insight into personalizing your report in QuickBooks Online.

 

Visit this article for further information on how to keep track of your client's account growth: QuickBooks Help Articles. It includes topics about account management, banking, and expenses and vendors, to name a few. You can click the + More topics button to view other selections.

 

Please feel free to remark with your response. I'm excited to provide more information on importing and exporting-related matters. Have a great day.

4 replies

C
ChristineJoieRAnswer
May 31, 2023

Yes! There is. @accountingnwt. I can show you the report you need to pull up in QuickBooks Online.

 

Reports show you the best picture of your company. It shows your data on your sales and expenses. 

 

Since the data you need to view consists of the invoice number, invoice, payment applied, and the customer name, I recommend pulling up the Invoice and Received Payments. This way, it will let the data show on your screen. We'll have to customize the file a bit.

 

  1. Go to the Report tab, and find the Invoice and Received payment in the Search bar.
  2. Next, sort the dates and other details. 
  3. Then, press the Customize button in the upper left to change the column.
  4. Navigate to the Rows/Columns dropdown and put a checkmark on the Customer checkbox.
  5. Hit Run Report once done.

 

 

 

See the result below:

 

 

Pick this article for additional insight into personalizing your report in QuickBooks Online.

 

Visit this article for further information on how to keep track of your client's account growth: QuickBooks Help Articles. It includes topics about account management, banking, and expenses and vendors, to name a few. You can click the + More topics button to view other selections.

 

Please feel free to remark with your response. I'm excited to provide more information on importing and exporting-related matters. Have a great day.

A
accountingnwtAuthor
June 1, 2023

Christine,

 

Thanks for the information. It helps me to match invoices with payments. It groups the payments near the invoices.

 

Jo Ann

R
rvrfrf
June 1, 2023

Thanks for getting back with the Community, accountingnwt.

 

I'm happy to hear ChristineJoieR was able to help you find a report that shows your original invoices amounts and which payments are applied to invoices by invoice numbers.

 

I've also included a detailed resource about working with reports which may come in handy moving forward: Reports included in your subscription

 

Please feel welcome to send a reply here or create a new thread if there's ever any questions. The Community's always here to help. Have an awesome day!

A
ablasco
November 17, 2023

As of today, there is no Invoices & Received Payments report in qbo.  They have removed the only report where you can track the application of your payment to a corresponding invoice.

 

Very frustrating as their "patch" report instructions do not work.  I've tried the "Cash Receipts" journal instructions as well as the "Customer Balance Detail" report.  Which, by the way, does not offer selection of transaction types in the filter.  As a Quickbook Pro, I'm astonished at the nonsense reports versus the needed reports.

 

Please get someone in your tech department that actually uses QB's and knows what reports we, as accountants, need.

 

 

    N
    NHRiverGal
    November 20, 2023

    @ablasco 

     

    I have QBO Advanced & just ran that report.  It's located under the "Who Owes You"  section

    K
    Kfagan41
    January 11, 2024

    Every time i try to access Invoice and Received payment

     

     

     

    S
    ShyMae
    January 11, 2024

    Hello there, @Kfagan41. Let's do some troubleshooting steps for you to access the invoice and receive the payment report. 

     

    First, let's ensure you're connected to a strong connection. If the issue continues, let's open your QuickBooks account in a private window to rule out browser-related issues. Here are the keyboard shortcuts:

     

    • Google Chrome and Microsoft Edge: Ctrl+ Shift + N
    • Mozilla Firefox: Ctrl + Shift + P
    • Safari: Command + Option + P

     

    If you can successfully access the report, return to your regular browser and clear your cache. Occasionally, the accumulated cache and cookies in the system can become outdated or corrupted, leading to unexpected behaviors. You can also switch to other installed supported browsers, which is a good alternative.

     

    After generating the Invoices and Received Payments report, you can customize and save the customization process by memorizing it.

     

    I'm here available to help you, @Kfagan41. Please do not hesitate to return here if you require further assistance generating reports in QuickBooks Online. 

    L
    LHCbz
    October 16, 2024

    This report no longer exists after the update to the new Modern View format. Where did it go? 

    B
    bottomlineusa
    October 13, 2024

    The report does not show you the amount that was applied to the invoice.  It shows the total invoice amount.  If you add all the invoices listed under the payment, they do not match the payment amount.  It is important to see a payment report that shows the amount applied to the invoice(s).  There are no filters or options to show the amount applied to the invoice. 

    A
    AnneMariee
    October 13, 2024

    Thanks for joining this thread, bottomlineusa. 

     

    I understand how valuable it would be to add a column for applied payments on the Invoices and Received Payments report for better tracking and management of your business finances. However, the option to do so is currently unavailable in QuickBooks Online. That said, I recommend submitting your suggestion through the feedback section, as our product development team reviews these inputs to consider new functionalities for future updates. Your insights are essential as we work to continuously improve our product.

     

    Here's how to send feedback:

     

    1. Head to the gear icon.
    2. Under Profile, select Feedback.
    3. Enter your product suggestions.
    4. Click Next to submit.

     

    For additional details on generating reports, you can explore this article: Run reports.

     

    To streamline your process in the future, consider this guide on saving your report customization settings: Memorize reports.

     

    Running reports is crucial for gaining insights into your business. While the feature you suggested isn't available yet, your feedback is appreciated. If you have any other concerns about running and customizing reports, feel free to reach out. The Community is always available for you, bottomlineusa.

      Terms & ConditionsAccessibility statement