Upload all the day's data
Three things go in here. Upload them in any order, then click Run reconciliation at the bottom. Everything is processed locally — nothing leaves your machine.
1 Customer payment screenshots
Drop a folder of WhatsApp / camera-roll receipt images, or pick many files at once. OCR runs in the background and extracts the UPI Transaction ID, amount, time, and payer name from each image. You can keep working — refresh later to see progress.
2 GPay Business CSV files
Download the day's settlement CSV from each GPay Business merchant
account (one CSV per account). Upload them all together — Google's
record of money received. Files must look like
GPay_Business_Transactions_YYYYMMDD-YYYYMMDD_<account>.csv
(or the header is auto-detected if renamed).
3 Internal deposit log (XLSX or CSV)
The sheet of deposits credited — one row per deposit. Either the agent
panel export with a header row (UserName, Credited, UTR,
PaymentDate, Status…; rows with a failed/rejected status are
skipped) or the headerless Sr.No, Username, Amount, UTR, Time
sheet. After upload you'll see how many rows were read. Reconcile uses
the newest log unless you pick another.
Manual-Deposit-Agent_1.xlsx 14 KB