Average Invoice Processing Time

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

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

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.