Powerful feature: Invoice-Level Amount Variance Detection in Statement Reconciliation
In the current Statement Reconciliation feature, Dext matches invoices from the supplier statement with invoices pulled from Xero. While it checks for missing or unmatched invoices, it does not compare the invoice amount from the statement against the actual amount of the corresponding invoice in Xero (shown in the "Due" column).
This becomes a challenge when there's a variance in the amounts—for example:
- A revised invoice was issued by the supplier, but the statement reflects the old amount.
- The invoice in Xero shows $1,100, but the statement lists $1,000 (or vice versa).
Currently, the system only shows the total statement amount vs. the total matched invoice amount in Xero, and highlights the difference in an orange box. However, it doesn’t identify which individual invoice is causing the variance, unless it is completely missing or unmatched.
A powerful enhancement would be:
- To compare invoice amounts line by line, not just totals.
- To flag variances at the invoice level (e.g., in red font or with a warning label like “Variance Detected”).
This would help users immediately identify discrepancies, especially when working with suppliers who issue frequent revised invoices.
Adding this functionality will greatly improve the efficiency and accuracy of the reconciliation process.
