Rico — Payin Ledger

rico.xyz99.online · upload adds to the stored data on the server — dashboard always reflects everything uploaded so far

Upload raw files (multiple files per box allowed)

Ramee Data (R)

Raw R export: Merchant Id, Amount, status, System Id, Vendor Id, UTR, Date Time

Merchant Id Code, OrderId, RRN, Amount, Txn Status, Transaction Date

TPR/TPS CSV or Daily Report (Payin Transactions)

BOI

Bank of India statement (.xls, HTML table)

IDBI

IDBI account statement (.xls)

This sends what you just uploaded to the server (rico.xyz99.online backend) — it merges into the stored data there. Rows already stored (same UTR/System Id) are skipped, so re-uploading an overlapping date range is safe. Go to the Dashboard tab afterwards — it always reflects everything stored on the server, no re-upload needed.

Current state (all stored data)

Resolve a transaction by R's TRX ID

Enter R's System Id or Merchant Txn Id — or click "Resolve" directly on a Suspicious row below. It's checked against the stored bank/vendor data by UTR + Amount before confirming.

R TRX ID (System Id or Merchant Txn Id)

Suspicious — R says Success, no vendor confirmation found (0)

Date	Merchant Id	Vendor Id	UTR	Amount	System Id

Unmatch Payment — vendor confirmed, no R record found (0)

Date	Source	UTR	Amount	Status

Merchant Id

Opening balance (before first tracked date)

Date	Opening	Payin (auto)	Payin (manual)	Total Payin	Closing

Opening for each date = previous date's Closing. Payin (auto) = reconciled Matched entries; Payin (manual) = TRX-ID resolved entries.