cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here

Reply to message

View discussion in a popup

Replying to:
chris99
Level 2

Reply to message

Thanks but this still does not easily give me how often they pay their invoices late.  Using this report you still need to go through line by line and manually workout yourself whether or not the payment is in accordance with the payment terms of the invoice.  Yes, it gives the invoice date and payment date but that is all.  I was looking for something that indicates if it is within the terms or not.  The closet I got is using the INVOICES AND RECEIVED PAYMENTS report and then exporting that to Excel and then taking away the Invoice Due Date from the Payment Due Date ate to see how many days it was paid either before or after payment term.  A bit clumsy but it works.  

 

What I need from a report is to list all the invoices by customer, the date the invoice was due, the date it as paid and some kind of indication if it was paid within the invoice term.  This could be a boolean response or a simple calculation where a positive number is the number of days over or a negative one which is the number of days before which is what I do in Excel.  I would just nice to be able to do something this simple in QuickBooks