Jump to content

Pre-Invoice Processing Extract

From PBI Reporting Wiki

Overview

This extract contains data generated by the pre-invoice automation process. It highlights both matched and mismatched charge lines before the final invoice is issued, allowing users to review and validate billing data in advance. By identifying discrepancies early, the extract helps prevent errors from reaching the final invoice stage, reduces the need for manual corrections later, and supports smoother, more accurate billing workflows. This visibility enables teams to take timely action on any issues, ensuring greater confidence in invoice accuracy.

Extract Data

Column Description
created_at The date when the pre invoice was processed by the automation
supplier_id The supplier for the pre invoice
total_matches The number of charge lines matches by the automation
total_non_matches The number of charge lines not found or not matches by the automation

Example Calculations

Automation Time Saved (Pre Invoice Processing)

To calculate the time saved by the pre-invoice automation process, you need to add the values of both total_matches and total_non_matches, as each line represents a task that would otherwise require manual review. Multiply the total by 0.5 to estimate the number of minutes saved, based on an average of 30 seconds per line item. This provides a quick and effective way to quantify the efficiency gained through automation.

(total_matches + total_non_matches) * 0.5 = total minutes saved