Zoho POS Automated Payment Settlement Reconciliation
Every night, WebRun opens Zoho POS, totals the day's sales by UPI, card, and cash, checks the UPI and card totals against what Xero shows settled to the bank, and logs a reconciliation row to Google Sheets flagging any mismatch for you to investigate the next morning.
How do I reconcile Zoho POS UPI, card, and cash takings each night?
WebRun totals Zoho POS sales by UPI, card, and cash every night, checks the UPI and card totals against what Xero shows settled to the bank, and logs a reconciliation row to Google Sheets. Any mismatch beyond your rounding tolerance is flagged, so a missing settlement or a cash discrepancy gets caught the next morning, not weeks later.
- Payment mismatches are caught the next morning instead of at month end
- UPI and card settlement lag no longer hides a real discrepancy
- Cash handling stays visible with an expected drawer figure every night
Built for retail store owners · store accountants · Zakya POS users · multi-outlet retailers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.zoho.com/posin a real browser with your saved login - no setup, no API keys. -
1
Zoho POS - total the day's UPI, card, and cash sales
zoho.com
WebRun opens Zoho POS to total the day's UPI, card, and cash sales. - Open Zoho POS and total the day's sales by payment mode: UPI, card, and cash
- Capture the expected cash in drawer figure for the day
- Note the number of bills per payment mode
Done when The day's sales are totaled by UPI, card, and cash with an expected cash figure.
-
2
Xero - check bank settlement for UPI and card
xero.com
WebRun opens Xero to check bank settlement for UPI and card. - Check the bank feed in Xero for UPI and card settlement amounts received for the day
- Match each settlement against the Zoho POS total for that payment mode
- Note the settlement date if it lags the sale date
Done when UPI and card totals from Zoho POS are matched against Xero's bank settlement records.
-
3
Google Sheets - log the reconciliation and flag mismatches
google.com
WebRun opens Google Sheets to log the reconciliation and flag mismatches. - Log a reconciliation row for the day with each payment mode's POS total, settled amount, and difference
- Flag any row where the difference is more than a small rounding tolerance
- Carry forward unresolved mismatches so they are not lost the next night
Done when The nightly reconciliation log is updated with every mismatch flagged for review.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it move money or correct the mismatch for me?
No. It only compares totals and flags a difference in the log. Any correction, bank query, or adjustment entry is made by you or your accountant.
What counts as a mismatch worth flagging?
Any difference between the Zoho POS payment total and the amount Xero shows settled that is larger than the small rounding tolerance you set at setup. Smaller gaps are logged but not flagged.
What if a UPI settlement takes a day or two to land in the bank?
Settlement lag is expected. Unresolved rows carry forward to the next night's log instead of disappearing, so a late settlement still gets matched once it lands.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.