Average Invoice Processing Time

The Average Invoice Processing Time widget shows the time spent monthly on processing invoices from receipt to payment.

The widget provides insights into invoice processing efficiency. It identifies the time cost of processing invoices and highlights opportunities to reduce processing time. Faster processing enables early payment discounts and improves supplier relationships through timely payments.

The widget displays a line chart, where the horizontal axis represents months and the vertical axis represents the average processing time in days.

The Average Invoice Processing Time query logic

Average Invoice Processing Time = Processing days for all invoices รท Total number of invoices

The Average Invoice Processing Time widget query retrieves all purchase invoices for the selected period. It uses:
  • The Transaction date as the invoice receipt date.
  • The Paid date as the actual payment date on the journal.
The widget calculates the processing time for each invoice by subtracting the receipt date from the payment date. It then sums all processing days and divides the total by the number of invoices to determine the average. The results are grouped by month and displayed on a line chart.