{% set r = report %}
{% set c = r.cashflow %}
{# ── 1. Cash flow ── #}
Cash flow
| Approved | Pending | Rejected |
{% for label, row in {'Deposits': c.deposits, 'Withdrawals': c.withdrawals} %}
| {{ label }} |
₱{{ row.approved.total|number_format(2) }} ({{ row.approved.count }}) |
₱{{ row.pending.total|number_format(2) }} ({{ row.pending.count }}) |
₱{{ row.rejected.total|number_format(2) }} ({{ row.rejected.count }}) |
{% endfor %}
| Net cash (approved deposits − withdrawals) | ₱{{ c.net|number_format(2) }} | | |
| Expenses ({{ c.expenses.count }}) | −₱{{ c.expenses.total|number_format(2) }} | | |
| Cash on Hand (net cash − expenses) | ₱{{ c.cashOnHand|number_format(2) }} | | |
| Bonuses credited | ₱{{ c.bonuses.total|number_format(2) }} ({{ c.bonuses.count }}) |
| Commissions credited | ₱{{ c.commissions.total|number_format(2) }} ({{ c.commissions.count }}) |
| Refunds credited | ₱{{ c.refunds.total|number_format(2) }} ({{ c.refunds.count }}) |
Deposits and withdrawals by the day they were requested, and Cash on Hand net of the day's expenses — the same as Finance ▸ Report.
{# ── 2. Bets by game ── #}
Bets by game
| Game | Won | Lost | Void | Pending | Stake | Payout | GGR | Commission | Net revenue |
{% for g in r.bets.rows %}
| {{ g.label }}{% if g.tickets is not null %} ({{ g.tickets }} tickets){% endif %} |
{{ g.won }} | {{ g.lost }} | {{ g.void }} | {{ g.pending }} |
₱{{ g.stake|number_format(2) }} | ₱{{ g.payout|number_format(2) }} |
₱{{ g.ggr|number_format(2) }} |
₱{{ g.commission|number_format(2) }} |
₱{{ g.netRevenue|number_format(2) }} |
{% endfor %}
{% set t = r.bets.totals %}
{% if t.manualRevenue != 0 %}
| Manual revenue entries | ₱{{ t.manualRevenue|number_format(2) }} |
{% endif %}
| Total | {{ t.won }} | {{ t.lost }} | {{ t.void }} | {{ t.pending }} |
₱{{ t.stake|number_format(2) }} | ₱{{ t.payout|number_format(2) }} |
₱{{ t.ggr|number_format(2) }} |
₱{{ t.commission|number_format(2) }} |
₱{{ t.netRevenue|number_format(2) }} |
GGR = stake − payout of bets placed this day (settled only). Commission and Net revenue are the dashboard's figures for the day: Net revenue = GGR − agent commission, house-agent commission counted back as revenue, plus manual revenue entries. Live Racing counts each combination.
{# ── Live Racing payout check ── #}
{% set lrIssueLabels = {wrong_outcome: 'Wrong outcome', wrong_payout: 'Wrong payout amount', not_settled: 'Should be settled but still pending', credit_missing: 'Win/refund not credited to wallet', credit_duplicate: 'Credited more than once', credit_amount: 'Credited amount differs'} %}
Live Racing payout check
{% for ev in lrAudit %}
| Event #{{ ev.eventId }} | {{ ev.checked|number_format }} bets re-graded · {{ ev.settled|number_format }} settled{% if ev.open %} · {{ ev.open|number_format }} open{% endif %} |
{% if ev.issueCount == 0 %}
| ✓ Every settled bet matches its dividend, and every win and refund was credited exactly once{% if ev.cancelled is not empty %} (bets cancelled by admin listed below){% endif %}. |
{% else %}
{% for kind, n in ev.issues %}{% if n %}| {{ attribute(lrIssueLabels, kind) }} | {{ n }} |
{% endif %}{% endfor %}
{% endif %}
{% if ev.list is not empty %}
| Ticket | Type | Player | Issue | Recorded | Should be |
{% for i in ev.list %}
| {{ i.reference }} | {{ i.betType|replace({'_': ' '}) }} | {{ i.player }} | {{ attribute(lrIssueLabels, i.issue) }} |
{{ i.status }}{% if i.payout is not null %} ₱{{ i.payout|number_format(2) }}{% endif %} |
{{ i.expectedStatus }}{% if i.expectedPayout is not null %} ₱{{ i.expectedPayout|number_format(2) }}{% endif %} |
{% endfor %}
{% if ev.issueCount > ev.list|length %}Showing the first {{ ev.list|length }} of {{ ev.issueCount }}.
{% endif %}
{% endif %}
{% if ev.cancelled is not empty %}
Cancelled by admin and refunded: {{ ev.cancelled|length }}
| Ticket | Type | Player | Refunded | Settlement would have given |
{% for i in ev.cancelled %}
| {{ i.reference }} | {{ i.betType|replace({'_': ' '}) }} | {{ i.player }} | ₱{{ i.refund|number_format(2) }} |
{{ i.expectedStatus }}{% if i.expectedPayout is not null %} ₱{{ i.expectedPayout|number_format(2) }}{% endif %} |
{% endfor %}
{% endif %}
{% else %}
No Live Racing event on this day.
{% endfor %}
{# ── 3. System adjustments ── #}
{% set a = r.adjustments %}
System adjustments
| Adjustments | {{ a.count }} |
| Credits | ₱{{ a.credits|number_format(2) }} |
| Debits | ₱{{ a.debits|number_format(2) }} |
| Net | ₱{{ a.net|number_format(2) }} |
{% if a.list is not empty %}
| Time | Player | Amount | Reason | By |
{% for row in a.list %}
| {{ row.adjusted_at|date('g:i A') }} |
{{ row.player }} · {{ row.mobile_number }} |
₱{{ row.amount|number_format(2) }} |
{{ row.reason }} |
{{ row.adjusted_by }} |
{% endfor %}
{% endif %}
{# ── 4. Players ── #}
{% set p = r.players %}
Players
| New registrations | {{ p.registrations }} |
| Players who bet | {{ p.bettors }} |
| Players with an approved deposit | {{ p.depositors }} |
| Players with an approved withdrawal | {{ p.withdrawers }} |
| Last login on this day | {{ p.lastLogin }} |
{# ── 5. Top players ── #}
{% for key, title in {topStake: 'Top players by stake', topWinners: 'Top winners (net)'} %}
{{ title }}
{% set rows = attribute(r, key) %}
{% if rows is empty %}
No bets this day.
{% else %}
| # | Player | Stake | Payout | Net |
{% for row in rows %}
| {{ loop.index }} | {{ row.name }} · {{ row.mobile }} |
₱{{ row.stake|number_format(2) }} | ₱{{ row.payout|number_format(2) }} |
₱{{ row.net|number_format(2) }} |
{% endfor %}
{% endif %}
{% endfor %}
{# ── 6. Staff actions ── #}
Staff actions
{% if r.staffActions is empty %}
No staff actions logged this day.
{% else %}
| Staff | Action | Times |
{% for row in r.staffActions %}
| {{ row.name }} | {{ row.action|replace({'-': ' '})|capitalize }} | {{ row.count }} |
{% endfor %}
{% endif %}