{% set r = report %} {% set c = r.cashflow %}

Daily Audit — {{ day|date('l, F j, Y') }}

{{ r.from|date('M j, Y g:i A') }} to {{ r.to|date('M j, Y g:i A') }} (Asia/Manila) · test accounts excluded · generated {{ generatedAt|date('M j, Y g:i A') }}{% if generatedBy %} by {{ generatedBy.firstName }} {{ generatedBy.lastName }}{% endif %}
{# ── 1. Cash flow ── #}
Cash flow
{% for label, row in {'Deposits': c.deposits, 'Withdrawals': c.withdrawals} %} {% endfor %}
ApprovedPendingRejected
{{ 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 }})
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
{% for g in r.bets.rows %} {% endfor %} {% set t = r.bets.totals %} {% if t.manualRevenue != 0 %} {% endif %}
GameWonLostVoidPendingStakePayoutGGRCommissionNet revenue
{{ 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) }}
Manual revenue entries₱{{ t.manualRevenue|number_format(2) }}
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 %} {% if ev.issueCount == 0 %} {% else %} {% for kind, n in ev.issues %}{% if n %}{% endif %}{% endfor %} {% endif %}
Event #{{ ev.eventId }}{{ ev.checked|number_format }} bets re-graded · {{ ev.settled|number_format }} settled{% if ev.open %} · {{ ev.open|number_format }} open{% endif %}
✓ 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 %}.
{{ attribute(lrIssueLabels, kind) }}{{ n }}
{% if ev.list is not empty %} {% for i in ev.list %} {% endfor %}
TicketTypePlayerIssueRecordedShould be
{{ 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 %}
{% 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 }}
{% for i in ev.cancelled %} {% endfor %}
TicketTypePlayerRefundedSettlement would have given
{{ 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 %}
{% 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 %} {% for row in a.list %} {% endfor %}
TimePlayerAmountReasonBy
{{ row.adjusted_at|date('g:i A') }} {{ row.player }} · {{ row.mobile_number }} ₱{{ row.amount|number_format(2) }} {{ row.reason }} {{ row.adjusted_by }}
{% 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 %} {% for row in rows %} {% endfor %}
#PlayerStakePayoutNet
{{ loop.index }}{{ row.name }} · {{ row.mobile }} ₱{{ row.stake|number_format(2) }}₱{{ row.payout|number_format(2) }} ₱{{ row.net|number_format(2) }}
{% endif %} {% endfor %} {# ── 6. Staff actions ── #}
Staff actions
{% if r.staffActions is empty %}
No staff actions logged this day.
{% else %} {% for row in r.staffActions %} {% endfor %}
StaffActionTimes
{{ row.name }}{{ row.action|replace({'-': ' '})|capitalize }}{{ row.count }}
{% endif %}