No database connection
Introduce only database structure metadata. Pelarivo never asks for a password or connects to your database.
SQL invoice number matching and missing invoice queries
Build read-only SQL to match payments, orders or deliveries with invoices by invoice number, customer, amount and an explicit date tolerance.
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
- Confirm which structures represent invoices, payments, orders or deliveries.
- Choose the invoice number, customer, amount and date fields that identify the same record.
- Set an explicit same-day, ±7-day, ±30-day or custom date tolerance.
- Pelarivo generates a read-only reconciliation or missing-invoice query.
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.