Overview
The IBT Balance Report presents details about the merchant’s available balance:
Available (Open) Balance = Cleared Purchases – (Returns + Reserves + Adjustments + Fees + Payouts)
Funds are credited to the merchant account at the end of the 5th banking business day after the transaction is completed. However, a payout or return is debited from the merchant account immediately.
The end balance reflects the current amount in the Merchant’s account that has been cleared and settled:
End (Close) Balance = (Settled Purchases + Reserve TBR) – (Settled Credits + Returns + Reserves + Adjustments)
The end balance amount can be reimbursed or used to credit consumers. Funds are credited to the merchant account at the end of the 5th banking business day after the transaction is completed. However, a payout or return is debited from the merchant account immediately.
Report Filters
The following filters are available when generating an IBT Balance Report:
Parameter | Description | Notes |
---|---|---|
Daily Settlement Date | You can select a few days and they are presented in the grid data per day. | You can search up to 1 year back. The current day is not available. |
Client | Select a client. | The results are displayed for each client within their account. |
Acquirer Bank | Automatically populated with Mazooma Direct Bank. | |
Currency | Automatically populated with USD. | |
Balance View | Select how the report displays your transactions. All collapsed: Only the total activity per period per currency link is displayed. This link displays the total of your transactions throughout the report for the defined period of time. You can press this link to display each transaction that occurred in your account during the defined time period. All expanded: Displays each movement type that occurred in your account during the defined time period. |
Generating an IBT Balance Report
Refer to the Reports page that explains the basic format of the reports that can be generated using the Control Panel. The page also describes how to create, schedule, and manage queries.
To generate an IBT Balance Report:
- From the Menu bar, select Finance > Instant Bank Transfer > IBT Balance.
- Use the Report Filters to narrow the search parameters for your report.
- Press Run Report. The report is displayed according to the filters you have selected.
IBT Balance Report
In the IBT Balance Report, your activity is displayed according to the time interval you select. The opening and closing balance is displayed with each change, positive and negative. The data is displayed in Red or Green. Green indicates a positive change in your account, while Red indicates a negative change.
The following table describes the information displayed in the report:
Parameter | Description | Notes |
---|---|---|
Details | Press next to Total for Period to display Sales and Credits. | |
Activity | An activity is any movement of funds to or from your Payment Balance or Reserve Balance.
| |
From/To | The period of time in which the results of the report are based. | The filter of the Daily Settlement Date only affects the dates that appear in the To column, not the From column. This means that the dates that appear in the From column can be outside the range selected in Daily Settlement Date. |
Currency | The 3-letter code of the Settlement currency. | |
Settlement Balance (Open Balance) | The available balance at the start of the reporting period. | The start balance is usually $0 (zero); however, if the merchant requests a partial reimbursement, or pre-funds their merchant account to make payouts, the start balance may be positive. |
Settlement Balance (Close Balance) | The available balance at the end of the reporting period. | The end balance is $0 (zero) unless the merchant requests an amount to be carried over to use for credits. |
Transaction Fee | The total amount of processing fees charged for Purchases, Payouts, and Returns within the reporting period. | |
Adjustment | The total amount of adjustments during the reporting period. | Adjustments to the merchant balance include transactions outside of the system. For example, wire transfers into the merchant account to fund credits. |
Reserve (TBR) | The total amount of matured reserves reimbursed within the reporting period. | |
Purchase (Sales) | The total amount of all debits within the reporting period. | |
Reserve (Sales) | The total reserve amount deducted for purchases within the reporting period. | |
Payout (Credits) | The total amount of credits processed during the reporting period. | |
Return (Credits) | The total amount final returns deducted during the reporting period. |
Sample IBT Balance Report
Press here to download a sample of an exported report.