Automate UPI Entries in Excel

I already run my daily-meal tracking system on Excel. Customers pay me through UPI, but at the moment I still copy every confirmation into their individual sheets by hand. I’m looking for a clean upgrade that will pull each UPI payment confirmation automatically and drop the amount into the correct customer row or ledger the moment the transaction succeeds.

Key points you should cover
• Automatic data entry: once the UPI provider sends its confirmation (SMS, email, webhook, or downloaded statement—whichever is most reliable), the script or add-in should parse it, match the virtual payment address / phone / reference number to my existing customer list, and post the amount, date, and reference ID to the right column.
• Excel-based automation: I’d like to stay inside the current workbook structure, so VBA, Power Query, Office Scripts, or a lightweight connector that writes straight to .xlsx all work for me—no third-party dashboards necessary.
• Error handling: flag any payment that can’t be matched so I can resolve it manually.
• Scalability: today it’s about 80 transactions a day; I’d like headroom for more without the file slowing down.

Deliverable
An Excel solution (macro-enabled workbook, add-in, or script package) with clear setup instructions and a quick demo that shows one live or sample UPI confirmation flowing straight into the correct customer sheet.