Reads Column B (DISCOM) and Column L (BBPS) from a Sheet tab and pulls any manually-edited values into BillKhata — the reverse of the normal direction. BBPS is never pulled for a "Not Paid" bill (that column shows its Not Paid reason instead). Pick one date, or a From–To range (up to 31 days) to read several tabs in one go — leave "To" empty for a single date.
Employees
#
Name
Role
Status
Actions
Not Paid — Awaiting Your Review
Pending Review always shows everything regardless of date — it still needs action. Switch to Reviewed/All to look at history; date filter (defaults to today) narrows that down.
Bill ID
Employee
Client
Board
Consumer
Amount
Reason
Marked At
Review Status
Reviewed By
Action
Extra Paid — Awaiting Approval
Bills where the Paid Amount landed outside the allowed tolerance for that card — nothing was deducted from the card yet. Approve to finalize and debit the card, or Reject to unlock the bill back to the employee for correction.
Bill ID
Employee
Client
DISCOM
Consumer
Bill Amount
Paid Amount
Intended Status
Status
Note / Reason
Decided By
Decided At
Action
Update Payment — Approve / Reject
Showing today's requests + anything still Pending. Clear or widen the date to see older history, or download a report for a specific range.
Date
Bill ID
Employee
Client
Consumer
Old Amount
Requested
Diff
Status
Action
Recently Resolved — Portal Response
Bill ID
Employee
Requested
Diff
Status
Approved/Rejected By
Portal Response
Resolved At
Action
All clients
Quick range
💳
Start typing to search. Select a card from the list; its balance is shown alongside.
Click Search to generate the report.
Bills Report
Set the filters above (Status included), click Search to see the summary, then Download the same filtered set as
one Excel file — it covers status/employee/client/DISCOM/sync-date summaries, and the actual bill-by-bill detail rows
(same column layout as the client sheets). Status = Paid for a paid-bills list, Pending for a pending-bills list, or leave it on All.
From / To filters by whichever date is picked in the dropdown beside them. Sync Date (the default) is the day a bill
actually landed in BillKhata, same as its sheet tab — so "this month's report" means bills synced this month. Switch it to
Payment Date for bills actually paid in a period, regardless of when they came in.
Fund Requests and Update Payment requests have their own filter + download on their own pages now.
Matching Bills
ID
Client
DISCOM
Consumer
Amount
Status
Bill Date
Employee
Payment Modes
How money actually moved (NEFT, UPI, PAYZAPP, CASH, etc) — separate from Cards, which are what the money moved through.
This list is what Submit Payment's Payment Mode field is checked against.
Existing Payment Modes
Name
Added On
Actions
Mewar Voucher Portal (Vananam)
Requests are raised and approved entirely on the voucher portal itself, not here — this is a read-only mirror
so you can check status without opening a second site. An approved request auto-credits the shared
"VANANAM VENTURES" card, so paying a bill with it draws the balance back down naturally.
Opening Balances
What each person was already holding on the day this server took over. Their balance is otherwise worked out
from approved vouchers minus spend, which only counts what this server has actually seen — so without this,
everyone starts near zero on a fresh install even though the money is real. Set once; after that it carries
on by itself.
Employee
Role
Opening Balance (₹)
Last set
Employee-wise Summary
Employee
BillKhata Match
Requests
Opening
Requested Total
Approved Total
Spent (Vananam Card)
Net Available
All Requests
Requested Day
Employee
Order ID
Quantity
Amount
Status
Decided At
Decided By
My Requests
Requested Day
Order ID
Quantity
Amount
Status
Decided At
Vananam Statement
Card Statement
Submit Payment
Defaults to today — change it if this payment was actually made on an earlier date.
Request Fund
Pick your card and how much you need
Add Card
Register a card and its current balance — cards aren't tied to one employee, anyone can use any card
Approve Fund Request
Confirm the amount you're sending and the UTR / transaction reference for the transfer
Mark In Progress
Reject Fund Request
Give a reason so the employee knows why
Correct Balance
Bulk Import Cards
Step 1 — download the format file, fill it in, then upload it below. A name that already exists gets skipped.
Or paste rows straight from Excel instead — one card per line, columns: Card Name, Card Number, Starting Balance (optional). Tab or comma separated.
Add Employee
Create a new login
Update Amount
Only allowed within the client's approved range — this goes to your approver, who decides. If approved, it automatically updates here and on the client's portal.
Bill Details
Activity
Mark as Not Paid
⚠ This unassigns the bill and marks it "Not Paid". If you actually paid it, use Submit Payment instead — do not use this.
Reopen Bill
Unlocks this bill so it can be resubmitted — give a reason so there's a record of why.
Please Confirm
Enter Value
⚠ Could Not Complete
Confirm Assignment
Return to Client (Agency Failed)
⚠ This unassigns the bill, unlocks it, marks it "Agency Failed", and calls the client portal's own Return action — the same as returning it by hand on the portal.
Reopen Selected Bills
Unlocks these bills so they can be resubmitted — give a reason so there's a record of why.
Reject Payment
⚠ Unlocks the bill and clears the submitted payment details so the employee can correct and resubmit. Nothing was deducted from the card yet, so there's nothing to reverse.
Change Password
Changing this signs you out everywhere else, but keeps you signed in here.