No database connection
Introduce only database structure metadata. Pelarivo never asks for a password or connects to your database.
Match payments to invoice numbers with SQL or exported results
Build read-only SQL or upload exported Excel, CSV and JSON results to match payments, split collections, partial payments and refunds to invoice numbers with explainable evidence. Save verified matching setups for the next period.
Open SQL ToolsBusiness-language guidance
Describe the result you need. Pelarivo asks only for unresolved business rules and does not guess uncertain relationships.
Review before use
Receive read-only SQL, parameters, a plain-language explanation and a static safety classification. Pelarivo does not execute the query.
How SQL invoice number matching works
- Export collection and invoice results from your business software as Excel, CSV or JSON.
- Explicitly choose customer, amount, date, invoice-number and optional branch columns.
- Set date and amount tolerances; Pelarivo matches only a unique candidate satisfying every rule.
- Save the setup and safely reuse it with next-period files; Pelarivo never guesses ambiguous columns.
- Review matched, ambiguous and unmatched records with evidence, then export Excel, CSV or JSON.
Example uses
- Find payments without invoices
- Find orders that have not become invoices
- Find deliveries without a matching order
Safety boundary: Pelarivo does not connect to databases, request credentials or execute generated SQL.
Your data stays under your control
Original files stay unchanged. Calculations use explicit rules. Review source evidence before acting. Optional usage analytics requires consent and excludes file names, cell values and business results.
Frequently asked questions
Does Pelarivo connect to or run queries on my database?
No. Pelarivo uses structure metadata or a schema you provide, generates reviewable SQL and never executes it against your database.
Can I use SQL Tools without knowing table names?
Yes. Guided Mode suggests business roles from metadata, asks only for uncertain business rules and stops instead of guessing.
Start with the file problem you already have.
One focused task. A result you can review.