Checks BGD submission status on passtrack.net and records receivedAtCenter per applicant.
⏱ Auto run — runs TODAY's range automatically at these Dhaka times (same durable job, shows in history with an AUTO tag).
🔒 Lock days — freeze a Dhaka day's done files into a copy so billing always uses the frozen set; later changes to the main data can't shift a finalized bill. Uses the date range below.
Checkout filter selects applications that got a payment link (paymentUrl set), dated by paymentLinkTime (Dhaka tz). Uncheck to filter by createdAt instead. Recheck only re-runs just the applications already checked before that are still not submitted / No Data Found — never-checked applications are left out.
Run history
Started
Mode
Range / Params
Status
Progress
Submitted
Not Sub.
Failed
Duration
Checks every applicant (main + attendees) on this application and writes their status.
Checks each BGD number on passtrack and marks SUBMITTED / NOT_SUBMITTED — nothing is written to the database. A failed check reports NOT_SUBMITTED with Check Failed in the Detail column. A CSV row that already carries a SUBMITTED/NOT_SUBMITTED status (2nd column) is skipped; blank rows and rows whose detail says Check Failed are re-checked. Download the result and re-upload it to resume — tick Recheck all to force every row.
Builds one Submission_report row per application from visa_applications (upsert by application id — re-generate any time to refresh). Submitted / Not Submitted BGDs come from the tracker's receivedAtCenter results, so run the tracker first for fresh numbers.
✦ AI analysis
Billing summary — mission & service (your hierarchy)
Mission
Service
Links
BGDs
Submitted
Claim
SameBGD Adj
Done
Declined
Billable
Reference summary — RM › Distributor › Agent (mission & visa type wise)
Reference
Mission
Visa Type
Apps
BGDs
Submitted
Not Submitted
Claim
SameBGD Adj
Billable
Done
Declined
Applicant Phone
BGD Number
Submitted BGD
Not Submitted BGD
BGD Count
IVAC Location
Visa Type
Status
State
Submission Count
Not Submission
Claim
Billable
SameBGD Adj
Outcome
URL No
Paid By
Invoice Link
Agent
Read-only payment history from visa_applications — one row per application with its payment link details. BGD marks (✓/✗) come from the tracker's receivedAtCenter results. Times shown in Dhaka.
✦ AI analysis
SL
OTP Phone
BGD Numbers
Location
Status
Payment
Link Generated
Agent
Invoice
✔Claim & discount requests. Pick BGDs from your own history (up to 1 month back) to request a claim, or raise a discount request with a reason. Every request goes to Ninza for approval — approved requests are settled on your next bill as an OLD_CLAIM_ADJUSTMENT deduction.
Only BGDs found in your submission history (max 1 month back) are acceptable — anything older or outside your chain is refused.
✔Claimable rules — Ninza only. These rules drive the claim math everywhere it appears: submission report, payment history, BillingIQ, summaries, and the claim-request limits. Defaults reproduce the standing behaviour; changes apply immediately (within ~30 seconds on other sessions).
Raised
By
Type
Cause / Reason
BGDs
Amount
Status
Decision
Applied bill
✔Payment reconciliation. Collectors record what they paid the Partners; members record what they paid their RM. Every entry stays pending until the receiving side accepts it. All amounts are end-to-end encrypted at rest — unreadable from the database.
Record a payment
My payment methods — publish HOW you receive money; your downstream sees these when submitting a payment (group heads and RMs only)
When
From
To
Shown as
Amount
Note
Recorded by
Status
Decision
Partner receivables (manual) — entered and edited by Ninza only; collector bills are never stored, so their share is added here and stacks on top of the calculated bill share
Date
Partner
Amount
Note
Entered by
Partner expenses — entered by Ninza or a Partner; added to that partner's receivable and deducted from the distributable bill
Date
Partner
Amount
Note
Entered by
✦
✔Bulk billing — your daily book. File counts per mission and service for every party under you, valued with your own rates, with the dues ledger: Previous Due + Today's Bill − Today's Payment = Current Due. Accepted payments from the Reconciliation tab reduce dues automatically; saved individual bills replace the computed amount for their party. Single day or any range.
Google Sheets import — link your existing sheet (Share → "Anyone with the link → Viewer"), fetch a tab, review every row, then apply. Nothing imports without your review.
Day-wise total check: Partners (whole book) must equal the collector groups added together. Outside counts applications whose refUsers chain belongs to no group — chase those in the Hierarchy tab. Billable uses the exact arithmetic of a normal bill.
✦ AI analysis
🛡️CONFIDENTIAL — your billing is fully protected. Every rate and bill amount is end-to-end encrypted before it ever reaches the database (AES-256) — nobody can read your numbers from storage, not even the administrator. Ninza → RM bills are never saved at all (generate, export, and it's gone); collector bills save only for the registered device. We take your confidentiality seriously.
Edit billable & rates
Mission
Service
Billable
Rate (BDT)
Bill (BDT)
Adjust claims — flip a claimable to billable (or a billable to claimable) for THIS book only; every flip is tagged with your reason. SameBGD duplicates are already deducted automatically.
OTP Phone
Mission · Service
Claim
Billable
Override
🛡️CONFIDENTIAL — your rates are yours alone. Your rate chart is private: no one else can see it — not even the administrator. Every rate is encrypted before it touches the database, so it can't be read from storage either. Set your rates freely; we keep them seriously confidential.
One card per party. Click any cell to type today's rate (Enter saves, Esc cancels) — green = set today, yellow = carried from an earlier date, + = not set. Bills pre-fill from these automatically.
Active billing users — switch OFF anyone you do not bill day-to-day; they disappear from the party dropdowns and rate cards (their files still count everywhere). Search and toggle.
Paste rates — paste a rates message (WhatsApp style); it maps onto the chart below. Lines that cannot be read come back for manual setting.
Advanced: custom mission/service & full history
Set by
Bill to
Mission
Service
Rate
Effective
Active
🛡️CONFIDENTIAL — protected history. All amounts in your saved bills are stored encrypted (AES-256): anyone looking at the database sees unreadable ciphertext, not even the administrator can read your figures there. Only you and the party you billed can open these cards. We take your confidentiality seriously.
Ninza → RM bills are confidential and never appear here. Deletions are audit-logged.
Created
Card No
Level
Bill to
Period
Status
Grand total
Every billing action — including confidential Ninza → RM exports and deletions — is recorded here.
When
By
Action
Level
Bill to
Grand total
Note
Map agents/distributors under each RM so they’re selectable in billing even without applications in range. Role “both” shows them under RM→Agent and RM→Distributor.
RM
Member
Role
API key (only if the server requires X-Tracker-Key)