SRI YAVVANA VASAVI JEWELLERS
357/160 Main Road, Shevapet, Salem - 636002
Ph: 9080270006
Data is stored in this browser only.
Google Drive sync: not signed in.
Silver's purity dropdown is for labelling/seal only — sale rate is always the flat % above. Old-metal advances & discounts use melting % instead, for both metals.
Order book
Order#CustomerMobileItemsPricingTotalAdvanceBalanceStatus
Pricing basis
Customer
Items
Discount (optional)
Advances received
Cash or metal given to customer (refund, overpayment returned, excess old metal given back, etc.)
Quotation book
Quote#CustomerMobileItemsEstimated totalStatus
Pricing basis
Customer
Items
Discount (optional)
Advances received
Smith book
SmithMobileItems with himMetal balanceCash balance
Smith details
Items entrusted
General advances (not tied to a specific item — adjusts his whole balance)
Share this smith's account
Repair jobs
Job#CustomerMobileTotalAdvanceBalanceStatus
Pricing basis
Customer
Item(s) for repair
Discount (optional)
Advances received
Chit scheme
A/c#CustomerMobileInstallmentPaidAvailableStatus
Bonus: 1 free installment credited automatically once the customer completes all — installments.
Installments paid
Money given back to customer (e.g. they stopped paying and want a refund)
Gold chit scheme
A/c#CustomerMobileMetalInstallmentsGrams accumulatedValue todayStatus
Completion bonus
Installments paid
Pawn calculator
#ItemCapitalLoan dateAmount dueStatus
A standalone interest calculator — capital, wastage etc. here are not linked to the Pawn Book or the shared capital/cash-in-hand ledger. Interest is calculated only on whatever capital is actually outstanding at any given time, so a repayment correctly lowers interest going forward.
Item valuation (for resale/settlement — if the customer resells instead of repaying)
Capital given (in parts)
Repayments received
Resale settlement (if the customer resells the item instead of repaying)
Payouts to customer (cash actually given against the settlement)
Capital & cash in hand
Pawn book
Receipt#CustomerEst. valueAdvance givenDueStatus
Customer & address proof
Loan terms
Item particulars
Advances given (in parts)
Repayments received
Resale settlement (if the customer resells the item instead of repaying)
Payouts to customer (cash actually given against the settlement)
Cash ledger
Personal cash or metal advances to/from a customer, unrelated to any order, repair, or pawn — with a running debit/credit balance.
A/c#TypePartyMobileGivenReceivedBalanceStatus
Entries
SYVJ Rate Card
e.g. 22K (91.6%+1%=92.6%) sale rate: —/g
Flat sale rate (all purities): —/g
Silver's purity dropdown is for labelling/seal only — sale rate is always the flat % above.
Gold 22K — 1g: —
Gold 22K — 8g: —
Coin — 1g: —
Coin — 8g: —
Silver — 10g: —
Payment QR card
A clean, branded "scan to pay" card — automatically crops just the QR code out of whatever image was uploaded, so it's ready to share without any clutter around it.
Rate history
One entry per day — the day's board rate is logged automatically whenever you update it.
Add or correct a rate for a specific date
Use this to backfill a date you missed, or fix an entry that's wrong — for instance after a sync issue.
Board rate (pure)
Retail price
22K gold rate and silver rate — the actual customer-facing figures, including your markup settings.
DateGold rate (₹/g)Silver rate (₹/g)22K Gold — 1g22K Gold — 8gSilver — 10g
Expenses
DateCategoryNoteAmount
Staff Payroll
Attendance is tracked by exception — every day is assumed worked unless you mark a leave. Sundays are paid holidays by default; mark it specifically if someone works one.
Payroll
Leave days
Only add a day here if they were on leave — every other day in the month is assumed worked.
Sundays worked
Sunday is a holiday by default — only add one here if they actually came in and worked that day.
Shop holidays (other than Sunday)
Mark a day here if the shop itself was closed (festival, bandh, etc.) — staff are still paid for it like a Sunday, no leave needed, but it doesn't count toward tea allowance since the shop wasn't open to serve any.
Rates for this month (editable)
Yearly bonus
A separate, once-a-year payment — applies the same way regardless of pay type. Just type the amount you're giving; there's no automatic calculation.
All Slips
Every generated slip across every module, grouped by type. Deleting a record from its own module removes it here too — this isn't a separate copy, just one place to find anything.
Slip
Tap the slip itself to open the full record in its own module.
Customers
NameMobileAddressRecords
Customer details
History
Old jewellery estimate
Applied only to old jewellery estimate valuations — the board rate and every other module are unaffected.
Estimate#CustomerDateTotal value
Customer
Items
Reminders
Orders and repairs approaching their delivery due date, and pawn loans approaching their due date — anything overdue, due today, or due within the next 3 days. Closed and redeemed records are left out.
Deletion log
Anything deleted from the shop shows up here and can be restored. Kept for the most recent 300 deletions.
Closed order archive
A snapshot image of each order's final slip, saved automatically the moment it's closed — independent of the order record itself from that point on, so it survives even if the order is later deleted. Downloads only happen when you choose to, below.
Inventory
Spreadsheet needs columns for Rack, Tray/Cover/Category, Item name, and Weight — Metal, Purity/Melting %, and Quantity are picked up too if present. Leave the tray/cover cell blank for loose stock that's grouped straight under a rack without a tray or category. If a rack or tray cell is left blank because it's the same as the row above, that's handled automatically too. Uploading adds to what's already here — matching rack + tray + item entries get their weight updated rather than duplicated.
Outstanding balances
Every customer's combined balance across open orders, repairs, and pawn loans, added up in one place.
CustomerMobileOrdersRepairsPawnTotal owed