July 14, 2025
Question
Report Data: Invoice Payment Date
- July 14, 2025
- 1 reply
- 21 views
Hello,
In attempting to do some automation and analytics, I need the payment date of invoices. My previous solution, prompted by @BigRedConsulting , was to use "Average Day's to Pay" report and heavily customize it. I have hit a wall with this though, as it seems that there is a size limit on what QuickBooks can export in one report, ~32k lines. I think I can get around this, at least for a little while, by reducing the "fluff" in the report. For example, I don't need the total rows or the customer and job name rows.
Does anyone know how I can remove that from the report, or if there is another report where the "Paid Date" or the "Avg Days to Pay" column works?
For the SS, the red boxes are the ones I don't need.