METHOD / RULES 1.0.1
Every finding needs evidence.
Billquiet checks a transaction export for a small, explicit set of invoice anomalies. It is a review aid for finance teams, not a statutory audit, tax assessment or guarantee of recovery.
Three checks, with clear boundaries
- Repeated supplier and invoice references: a high-priority candidate requires identical amounts, paid status and distinct payment IDs.
- Conflicting amounts: matching supplier and invoice references with different positive amounts require source-document review.
- Negative entries: credits are flagged for reconciliation. The export alone cannot show whether they remain unallocated.
Repeated export rows with consistent paid amounts are counted once per payment ID when estimating candidate exposure. All original row references remain visible. Missing IDs or conflicting amounts/status prevent a high-priority duplicate-payment classification.
What never counts as confirmed savings
A repeated payment ID may just be a duplicated export row. Different invoices for the same amount can be legitimate recurring bills. Credits may already be applied. Even distinct payment IDs need bank reconciliation and may represent installments. None of these signals alone proves a refund is due.
Accepted data
CSV up to 1 MB, 5,000 rows and 250 findings. Required headers: vendor, invoice, amount, currency. Optional: date, status, payment_id. One row per transaction. Supported currencies: EUR, USD, GBP, CHF, CAD, AUD. Dates are retained in the input but are not used for matching in this version.
Comma and semicolon delimiters are supported, including quoted fields. Amounts accept 1234.56 or 1234,56. For unambiguous imports, omit thousands separators. Never mix currencies in one total.
Matching and limitations
Supplier names and invoice references are matched after removing punctuation and spaces and ignoring case. This can create false matches between different legal suppliers or invoice years; always verify. We do not perform fuzzy supplier matching, bank reconciliation, contract review, tax calculations or checks against documents not in the export.
Your workflow
Export transactions, run the local check, inspect the matched rows, then save a dossier if useful. The saved dossier includes neutral supplier verification drafts. No message is sent and no transaction is changed by Billquiet.
Check a CSV →