Money tools
UPI reconciliation — match invoices to UTRs
Upload your monthly sales register, enter received amounts, and spot short-payments instantly. All data stays in your browser.
FAQ
Reconciliation questions
How does the UPI reconciliation tool work?
Upload a CSV of your sales register (Date, Invoice, Amount), then enter the UPI amount you actually received for each row. The tool calculates the difference, flags unmatched rows, and generates a settlement summary you can export as PDF or CSV.
Is my sales data uploaded to a server?
No. All data stays inside your browser in localStorage. The tool never sends invoice numbers, UTRs, amounts, or customer names to any server. The PDF is rendered client-side and downloaded directly.
Can I match partial payments?
Yes. Enter any received amount — the tool calculates the exact difference in paise. A row is marked as settled only when the received amount exactly matches the expected amount.
What CSV format do I need?
Your CSV must have at least three columns: Date, Invoice, and Amount. An optional Customer column makes the report clearer. The column headers can be capitalised or lowercase — the parser is case-insensitive.
Can I use this for monthly bank statement reconciliation?
The tool is designed for invoice-to-UTR matching. For a full bank-statement import, export your bank statement as CSV and use the Invoice column to tag each UPI credit to a specific invoice row.