Income and Expense Report
1. What is this page for?
The Income and Expense Report page is used to audit inbound deposit totals (Income) and outbound withdrawal totals (Expense) broken down by individual bank account and automated payment gateway (including Jinlipay). Site administrators and finance staff use this report to monitor cash flow, verify remaining account balance caps, check transaction limits, inspect account operational statuses, drill down into itemized transaction logs per bank account, and benefit from real-time live updates whenever new transactions occur.
2. Before you start
- Permissions: You must have the 'Bank History' permission granted in your role to view reports and transaction logs on this page.
- Prerequisites:
- Determine the date range to audit income or expense activity (defaults to the current day).
- Have bank account numbers, account holder names, or transaction reference numbers ready if searching for specific records.
3. Page layout
When opening the Income and Expense Report page, you will see the following key sections from top to bottom:
- Page Header: Displays the title Account Report (or Account Transaction Details when viewing a specific bank account), description, navigation breadcrumbs, and the Export Excel button.
- View Tabs:
- Income: Displays a green upward arrow icon for auditing inbound player deposits.
- Expense: Displays a red downward arrow icon for auditing outbound player withdrawals.
- Search & Filter Section: Contains search input for account number/name/bank, search submit button, More filters toggle (bank selector and date range picker), and active filter chips.
- 4 Stat Cards:
- Income tab: Displays Total Income (green), Deposit Transactions (count), Auto Deposit (amount), and Manual Deposit (amount).
- Expense tab: Displays Total Expense (red), Withdrawal Transactions (count), Auto Withdrawal (amount), and Manual Withdrawal (amount).
- Bank Accounts & Payment Gateways Main Table: Displays accounts with order number, bank logo, balance/limit info, status, channel type, bank name, account number, account holder name, transaction counts, total amount, manual counts, and manual amounts, along with a grand totals footer row.
- Account Transaction Details Drill-Down View: Clicking on any bank account row opens the itemized ledger page for that account, featuring summary badges, a transaction search bar, a transaction table, and a Back to report button.
4. Search and filters
Filters in main accounts overview (Main Page)
| Field / Filter | Type | Options / How to use | Result |
|---|---|---|---|
| Search by account number / name / bank | Text input | Type an account number, account holder name, or bank name and press Enter or click Search | Filters the table to display matching bank accounts |
| Bank (Advanced Filter) | Dropdown | Click More filters and select a specific bank or choose All | Filters accounts belonging to the selected financial institution |
| Date Range (Advanced Filter) | Date range picker | Click More filters and pick start date and end date | Recalculates transaction totals that occurred within the selected date window |
| Search | Button | Click to execute the query | Reloads the table and recalculates stat cards |
| More filters | Toggle button | Click to expand or collapse advanced filter controls | Shows count of active advanced filters in a badge |
| Active filter chips / Clear all | Filter chips | Appears below the search bar; click the X on a chip or click Clear all | Clears active filters and restores full overview |
Filters in account itemized transactions view (Drill-Down Page)
| Field / Filter | Type | Options / How to use | Result |
|---|---|---|---|
| Search transaction number | Text input | Type a transaction reference number and press Enter or click Search | Filters the itemized table to show only matching transaction bills |
| Date Range (Advanced Filter) | Date range picker | Click More filters and select start and end dates | Filters transactions executed within the specified date range |
5. Data table
1. Main Bank Accounts Overview Table
| Column | What you see | Meaning | Visual badge / styling |
|---|---|---|---|
| # | Sequence number | Row order in table | Center-aligned numeric font |
| Bank | Bank logo icon | Financial institution owning the account | Standard bank brand logo |
| Info | Balance and limit data | - Standard accounts: shows remaining balance (Bal:) and remaining daily limits (Limit:)- Jinlipay: shows live balance or Snapshot (Frozen) | Monospace font, shows Unlimited if uncapped; Jinlipay badge shown in orange |
| Status | Operational badge | Availability of the account to receive or transfer funds | Green badge (Active), Gray badge (Inactive), Red badge (Frozen Deposit or Frozen Withdraw) |
| Type | Channel badge | Gateway payment type, e.g. Auto, Upload Slip, QR Scan, Decimal, Jinlipay P2P | Center-aligned bordered gray badge |
| Bank Name | Localized bank name | Bank name linking to account itemized transaction ledger | Bold blue text with underline on hover |
| Account | Account number | Bank account number | Bold monospace numeric font |
| Full Name | Account holder name | Registered legal owner name of the bank account | Dark text |
| Total Deposits / Total Withdrawals | Transaction count | Total count of successful transactions through this account within the selected dates | Center-aligned monospace font; click header to sort |
| Total Amount | Total currency sum | Total monetary volume processed through this account within the selected dates | Green numbers for Income / Red numbers for Expense; click header to sort |
| Manual Count (Income only) | Transaction count | Number of times staff manually credited players to this account | Center-aligned monospace font; click header to sort |
| Manual Amount (Income only) | Currency amount | Total monetary volume credited manually by staff | Monospace font; click header to sort |
| Total (Footer) | Summary text and numbers | Combined totals of transaction counts, amounts, and manual entries across all accounts | Highlighted gray row with bold numbers |
[!NOTE] On mobile devices, the table adapts into responsive bank cards displaying the bank logo, account name, account number, channel badge, status badge, balance info, total amount, and manual adjustment amounts.
2. Itemized Transactions Table (Account Detail View)
| Column | What you see | Meaning | Visual badge / styling |
|---|---|---|---|
| Created Date | Date and time | Timestamp when the transaction was created (Bangkok time) | Bold date with gray time below; click header to sort |
| Transaction Number | Reference string | Unique transaction reference identifier | Bold monospace font |
| Amount | Currency number | Transaction amount (+ for deposit, − for withdrawal) | Green text (+) for Income / Red text (−) for Expense; click header to sort |
| Credit Before | Currency amount | Agent wallet credit balance prior to transaction processing | Gray monospace font; click header to sort |
| Promotion (Income only) | Promotion badge | Promotion claimed by the player on this deposit bill; click badge to view rules modal | Purple rounded pill (shows - if no promotion was claimed) |
| Promo Credit (Income only) | Bonus amount | Extra promotional bonus credited by the system | Green text (+) (shows - if zero bonus) |
| Credit After | Currency amount | Agent wallet credit balance following transaction processing (including promo bonus) | Bold monospace font; click header to sort |
Action buttons in the table
| Action / Button | Position | What happens when clicked | Notes / Conditions |
|---|---|---|---|
| Open Account Ledger | Click row or bank name in main table | Navigates to the itemized transaction ledger for that bank account | Available for every bank account |
| Back to report | Top-right button or breadcrumb | Returns to the main accounts overview table | Preserves previously selected tab and date filters |
| View Promotion Details | Purple promotion badge in ledger | Opens a popup modal displaying full rules, bonus rates, and turnover terms | Only present in Income ledger on deposit bills with active promotions |
| Sort Column | Headers with sort arrows | Toggles sorting between descending and ascending | Click again to invert order |
| Refresh Data | Spinning arrow button | Immediately refetches the latest transactions from the server | Can be clicked anytime |
6. Step-by-step instructions
1. Reviewing daily income and expense totals
- Go to Reports > Income and Expense from the left navigation sidebar.
- Select the Income tab to audit inbound deposit volumes, or click the Expense tab to audit outbound withdrawals.
- Review the 4 stat cards at the top for high-level totals, transaction counts, auto amounts, and manual adjustments.
- Scroll through the table to inspect which bank accounts handled the highest transaction volumes.
2. Filtering by a specific bank and date window
- Click the More filters button (slider icon).
- In the Bank dropdown, select the target bank (e.g. Kasikornbank or SCB).
- In the Date Range picker, choose the start and end dates.
- Click Search.
- The table updates to show only matching bank accounts, and stat cards recalculate automatically.
3. Drilling down into an account's itemized transaction ledger
- Locate the target account in the main table.
- Click anywhere on the row or click the blue bank name.
- The system opens the Account Transaction Details view displaying account metadata in the header.
- Scroll down to review itemized transaction timestamps, reference numbers, amounts, and before/after balances.
4. Inspecting promotion terms claimed on a deposit bill
- In the account itemized transaction view (under the Income tab).
- Locate the Promotion column; bills that claimed a promotion will show a purple badge.
- Click the purple promotion badge.
- The Promotion Details popup modal opens, displaying bonus structures, categories, and turnover multipliers.
- Review the rules, then click Close or the X button at the top-right.
5. Returning to the main accounts overview
- After reviewing transaction items in the detail view.
- Click the Back to report button at the top-right corner of the page.
- Alternatively, click the Account Report link in the breadcrumb trail above.
- You return directly to the main bank overview table.
7. Form fields and filter specifications
As this is an analytical financial report, there is no form to add or modify bank account settings directly (to manage bank accounts, navigate to Payment Setup > Bank Accounts). Query inputs adhere to the following rules:
| Field | Required? | What to enter | Example | Validation rules / Limitations |
|---|---|---|---|---|
| Search account / name / bank (Main) | No | Account number, holder name, or bank name | 0123456789 or John Doe | Case-insensitive partial matching |
| Bank (Main) | No | Bank to filter | Kasikornbank | Options: All, and integrated bank list |
| Date Range (Main) | No | Start and end dates | 01/10/2026 - 15/10/2026 | Defaults to today |
| Search transaction number (Ledger) | No | Transaction reference code | TX202610210001 | Partial match search |
| Date Range (Ledger) | No | Ledger transaction timeframe | 01/10/2026 - 05/10/2026 | Filters transactions within this account |
8. Modals and popups
1. Popup window: Promotion details
- Trigger: Click the purple promotion pill in the Promotion column of the transaction ledger (Income tab only).
- Contents:
- Bilingual promotion titles (Thai / English)
- Promotion category, code, and operational status
- Reward structure (fixed bonus credits or percentage matching)
- Turnover multiplier requirements and maximum bonus caps
- Action: Review the bonus terms against credited amounts.
- Outcome: Click Close to dismiss the modal and return to the ledger.
9. Badges and color indicators
| Badge / Display | Color | Meaning | Next Action |
|---|---|---|---|
| Active | Green (green border) | Bank account is actively processing deposits or withdrawals | Normal operation |
| Inactive | Gray (gray border) | Bank account is temporarily disabled; no transactions accepted | Verify if account should be enabled |
| Frozen Deposit / Frozen Withdraw | Red (red border) | Bank account is temporarily frozen (e.g. during accounting cutoff) | Wait for accounting cutoff or inspect bank settings |
| Snapshot (Frozen) | Orange (orange border) | Shows Jinlipay frozen balance at accounting cutoff | Review Jinlipay ledger |
| Promotion Badge | Purple (light purple background) | Deposit transaction claimed a promotional bonus | Click badge to inspect terms |
| Income Amount (+) | Green | Funds deposited into the account | Standard financial credit |
| Expense Amount (−) | Red | Funds withdrawn from the account | Standard financial debit |
10. Frequently asked questions (FAQ)
Q: Why does the "Manual Count" column only appear under the Income tab?
A: The system categorizes automated payment gateway deposits separately from manual credit top-ups performed by staff, giving finance teams a transparent audit trail. For withdrawals, manual payouts are aggregated in the top stat cards.
Q: How do I return to the main overview after drilling into an account ledger?
A: Click the Back to report button in the top-right corner, or click the Account Report breadcrumb link.
Q: Why do some bank accounts display a red "Frozen Deposit" or "Frozen Withdraw" badge?
A: The account has been locked or the system is currently conducting its daily accounting cutoff. Once cutoff concludes or payments are resumed, this badge clears automatically.
Q: Does this report update automatically when new deposits arrive?
A: Yes. The page incorporates real-time live updates that refresh summary cards and table rows automatically upon transaction updates. If connectivity drops, click the refresh button (spinning arrow) to refetch data immediately.