Automated Khatabook Credit vs Cash Report
Every Monday, WebRun opens Khatabook, pulls every entry from the previous week, splits the total into udhaar given on credit versus cash collected, builds a week over week comparison in Google Sheets, and stages the same split as a draft voucher in Tally, left unposted until your accountant confirms it.
How do I see credit versus cash sales each week?
WebRun pulls a full week of Khatabook entries every Monday, splits them into udhaar credit versus cash collected, and builds a week over week comparison in Google Sheets. It also stages the same split as a draft voucher in Tally, left unposted until your accountant confirms it, so nothing touches your books unreviewed.
- A swing toward too much credit shows up before it becomes a cash problem
- Your accountant gets a ready draft voucher instead of a manual re-entry
- Four weeks of trend sit next to this week's split for instant context
Built for kirana store owners · wholesale traders · small retailers · shop accountants
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
khatabook.comin a real browser with your saved login - no setup, no API keys. -
1
Khatabook - pull last week's entries
khatabook.com
WebRun opens Khatabook to pull last week's entries. - Open Khatabook and pull every entry from the previous Monday through Sunday
- Tag each entry as either udhaar given on credit or cash received
- Note the customer and amount for the largest entries in each category
Done when Every entry from last week is pulled and tagged.
-
2
Google Sheets - split credit versus cash
google.com
WebRun opens Google Sheets to split credit versus cash. - Total the credit and cash columns for the week
- Compare this week's split against the previous 4 weeks
- Chart the trend so a swing toward more credit stands out
Done when The week's credit versus cash split is totaled and charted.
-
3
Tally - stage the split for your accountant
tallysolutions.com
WebRun opens Tally to stage the split for your accountant. - Stage the week's credit and cash totals as a draft voucher
- Leave it unposted so your accountant can review it against the books
- Never post the voucher automatically, even if the totals look routine
Done when A draft voucher is waiting in Tally for your accountant to confirm.
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 change my books in Tally automatically?
No. WebRun only stages a draft voucher with the week's totals. It stays unposted until your accountant reviews and confirms it in Tally.
How is credit told apart from cash?
By how each entry was logged in Khatabook. Anything recorded as udhaar counts as credit, everything else counts as cash, and the split is totaled fresh every week.
What if I don't use Tally?
The Google Sheets breakdown works on its own. Skip connecting Tally and WebRun will just leave that draft voucher step out of the run.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.