Invoice Reconciliation Extract
Overview
This extract provides detailed data from the automated invoice reconciliation process, helping to streamline billing accuracy and support faster issue resolution. It includes both matched and unmatched charge lines, giving users clear visibility into which charges have been automatically verified and which may require further investigation or manual review. By surfacing discrepancies early, this extract enables users to take proactive action, reduce billing errors, and ensure that any anomalies are quickly addressed. The data is all contained within the payable on QMS so the accounting team don't need to navigate away or open a new window.
Extract Data
| Column | Description |
|---|---|
| created_at | The date the payable was created for the invoice |
| invoice_date | The date of the invoice |
| supplier_id | The supplier the invoice is for |
| automated | If the payable was automated for the invoice |
| charge_lines_matched | Number of charge lines matched via automation |
| charge_lines_not_matched | Number of mismatched lines identified via automation |
Example Calculations
Hide Non-Automated Invoices
To accurately calculate metrics related to automated invoices, it's recommended to filter out all records where automated has a value of 0. This ensures you're only working with data related to automated invoice processing.
Automation Time Saved
To calculate the time saved by the automation process in checking invoice charge lines, add the values from charge_lines_matched and charge_lines_not_matched, then multiply the result by 0.5. This represents the estimated time (in minutes) saved per charge line.
(charge_lines_matched + charge_lines_not_matched) * 0.5 = total minutes saved