cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
MJ Spire
Level 1

Invoice Date & Payment Date

Has anyone run the table that shows the invoice date with the payment date for that same invoice. We match these but I am unable to run these for each invoice.

Essentially I am trying to understand how many days from invoice to payment date for each invoice. 

Solved
Best answer April 15, 2021

Best Answers
JonpriL
Moderator

Invoice Date & Payment Date

Hello @MJ Spire,

 

You can pull up and customise one of your transaction list reports to see the list of invoices with their corresponding payments. Let me show you how.

  1. Go to Reports.
  2. Enter Invoices and Receive Payments in the Search address.
  3. Select Customise.
  4. Under Report period, select the date based on the entry you wanted to review.
  5. Click Run report.

In addition, here's an article you can read to learn more about how you can customise a report: How to get the most out of your financial reports?

 

Lastly, I've also included this reference for a compilation of articles you can use while working with us: Know where you stand financially.

 

If you have any other questions, please let me know in the comments below. I'll be here to lend a hand.

View solution in original post

10 Comments 10
JonpriL
Moderator

Invoice Date & Payment Date

Hello @MJ Spire,

 

You can pull up and customise one of your transaction list reports to see the list of invoices with their corresponding payments. Let me show you how.

  1. Go to Reports.
  2. Enter Invoices and Receive Payments in the Search address.
  3. Select Customise.
  4. Under Report period, select the date based on the entry you wanted to review.
  5. Click Run report.

In addition, here's an article you can read to learn more about how you can customise a report: How to get the most out of your financial reports?

 

Lastly, I've also included this reference for a compilation of articles you can use while working with us: Know where you stand financially.

 

If you have any other questions, please let me know in the comments below. I'll be here to lend a hand.

dannaFlorius
Level 1

Invoice Date & Payment Date

I have tried this, but I faced issue on Customers with Sub-customers.
If payment is recorded in Parent Customer and applied to invoices in Sub-customers, the invoices applied is not included in this report. Only payment transaction will show.
Is there any solution to this?

ReymondO
QuickBooks Team

Invoice Date & Payment Date

Thanks for joining the thread, @dannaFlorius.

 

I'll share another workaround to help view your invoice & payment dates in QuickBooks Online (QBO). 

 

You can run the Transaction List by Customer to view your invoice and payment transactions. Let me show you how:

 

  1. Go to Reports.
  2. Search for the Transaction List by Customer report.
  3. Click Customise.
  4. Under Report period, select the date based on the entry you wanted to review.
  5. Click Run report.

Moreover, you can filter your reports to show specific accounts or customers, or format the layout so the right data shows up in the right place. Here's how to customise reports and focus on the details that matter the most to you. 

 

Please feel free to contact me if you need further assistance. I'm just here to lend a hand.

dannaFlorius
Level 1

Invoice Date & Payment Date

Yeah I know this, but still it won't show when the invoice is actually paid.
What my goal is to generate a report showing the invoices due date and when it was actually paid.
I'm trying to avoid doing this manually.

QueenC
Moderator

Invoice Date & Payment Date

Let me assist you further, @dannaFlorius, and help you in running a report that'll show the due dates of invoices and when it was paid.

 

I've read the thread and replicated your goal and found out that we can run the Invoices and Received Payments report in QuickBooks Online (QBO). However, we need to customise it first to view the desired data.

 

I've created a Parent customer and a Sub-customer. I've recorded the invoice under the Sub-customer and the payment is under the Parent customer. When running the report, the names of both Parent and Sub-customers show. 

 

See the attached screenshot below. Sy Noe is the Sub-customer and Jio Van is the Parent customer:

 

 

Also, as per the screenshot provided, we're able to see the Due Date of the invoice and when it was paid. This can be possible by customising the report:

 

  1. From the Invoices and Received Payments report page, click on the little gear icon then hit on the Show More dropdown.
  2. Mark the Due Date box from the list of filters.
  3. When done, click on Run report.

 

 

 

Additionally, in case you want to save the report's customisation so you won't have to repeat the process over again, feel free to browse through this article: Save custom reports in QuickBooks Online.

 

I'll be around in case you need further assistance with regard to accessing reports in QBO. Simply leave a comment below, and I'll get back to you. Keep safe.

tania6
Level 1

Invoice Date & Payment Date

Why can't you give the option of adding the paid date as an additional column next to the invoice?

jenop2
QuickBooks Team

Invoice Date & Payment Date

Allow me to join you here and share details about customizing reports, tania6.

 

For now, there's no option to add a column for payment date. However, you can still see when an invoice was paid by looking at the Invoices and Received Payments report. 

 

The date to the left of the payment transaction is technically the date of the payment. Then, the transaction below it is the invoice the payment was attached to. 

 

 

I totally agree that being able to add a Payment Date column would help you determine when it was paid.

 

Having said that, I would recommend sending feedback about this to product engineers. Feature requests and customer suggestions are reviewed when new updates are designed.  Please go to this article for more details: How Do I Submit Feedback?

 

Don't hesitate to ask follow questions if you still need more help with your invoices. You can also visit the Community and post any other QuickBooks-related inquiries. 

itsGreghere
Level 3

Invoice Date & Payment Date

The other issue with the proposed solutions with respect to the original question is that the payments do not actually list the invoice. Sure, they are grouped together assuming the payment always follows the invoice in a timely fashion, but that's not real life (at least in the AEC industry). This makes it very problematic to use in a spreadsheet or any non-manual workflow..

 

We "match" all payments to invoices so that information is available. The invoice # should be included in the example reports for payment line items.

gkbrenne
Level 2

Invoice Date & Payment Date

I found that jenop2's response from 3/28/2023 is correct:  in this report, the payment(s) for the invoice(s) are listed before the invoices.  But that didn't get me my date paid, until I started doing some extra work in Excel.  (Please read all the way through before completing, you may be able to just use the revised at the bottom.)

 

  1. Run the report "Invoices and Received Payments"
  2. Add a column for Date Paid
  3. Use this formula in cell I8, which is the first line where I have an invoice:
     =IF(C7="Payment",B7,"")
    {English translation: If the Transaction Type (Column C) of the row above = Payment, then show the Date field from the line above, if no match, display nothing}
  4. Make your report into a table.  Click in cell A5, then press CONTROL+SHIFT+END.  (This will highlight all the lines in your report
  5. Create a table - Insert > Table.  Check the box that My table has headers
  6. Filter your report by transaction Type = Invoice and your new column for payment date = Blank
    (You can also filter A/R Paid =Paid)
  7. These are the invoices that have been paid, but were paid with a payment applied to multiple invoices.  I filled the blank payment date column with a color, then removed the filters.  Now all I have to do is manually review the colored boxes and manually type in the dates.

 

In my case, this took my 769 line report of 309 invoices to only having to look at 47 records.

 

Then as I was reviewing these transactions, I made a change to my formula

 

=IF(C7="Payment",B7,IF(AND(C7="Invoice",NOT(ISBLANK(I7))),I7,""))

{The second IF statement in English reads if the line above's transaction type = Invoice and the line above in the Invoice Date column is not blank, put in that date in this cell.}

 

Now, it got the correct date for the invoice for almost everything.  The only thing this didn't take into account is credit memos used to pay invoices.  If you use that second invoice, you don't have to put your report in a table and highlight the missing numbers.

 

Few extra notes: don't forget to copy and paste special your new column over itself.  If your report is resorted or if you delete any lines before doing this, you will lose all your hard work.

 

If your date field isn't acting like a date field, use Excel's replace command to find a 0 and replace with a 0.  This will covert anything that looks like a date into a date.  You can also use this to change numbers displaying as text - just search for a . and replace with a .  (Yes, I know you can use that help box to do this same thing, but sometimes I get tired of dragging that cursor!)

avgirl927
Level 1

Invoice Date & Payment Date

I don't think that QuickBooks should consider this issue as "Solved" when a user had to go through several extra steps to achieve a workable solution. I'm following the revised instructions regarding parent and sub-customers with no luck; I still only see the payments attributed to the parent customer, no invoice data whatsoever. So this report is completely useless.