Account Statement

Owned by dtshop.docs
Last updated: Jul 19, 2024
2 min read
https://app.tango.us/app/workflow/How-To-Generate-Reports--Account-Statement-52979d0b78584a0ba4cf52f7c35a034a

Account Statement is a document consolidating all information about account activity. 

Along with account statement Detailed .csv Reports are available. These reports include:

  • Balance Movements: This report will outline the changes in the account balance over a specific period.

  • Transactions: This report will provide a detailed list of all the transactions made on the account within the specified time frame.

  • Reversed Transactions (if applicable): If any transactions have been reversed or canceled, this report will list those transactions.

  • Pending Transactions (if applicable): If any transactions are still pending and have not been processed, this report will include information about them

 

1. ACCOUNT STATEMENT TAB

Account Statement is available on the ACCOUNT STATEMENT Tab

2. DATE RANGE

Select pre-set ranges or select CUSTOM and enter the needed DATE RANGE.

Note: You can generate reports in one-month incremental periods. If you need more than one month, please generate several reports with one-month increments.

3. STATEMENT TYPE

Select statement type: Default or Intermediation.

  • The default Statement contains information on all account movements

  • Intermediation Statement contains information on all account movements and if you set Retail Prices in DT Shop, it will additionally contain information on Profit (Wholesale Prices - Retail Prices)

4. GET STATEMENT

Click on GET STATEMENT

5. Click on alert

Account Statement and additional csv reports will be sent to the registered user's email.

6. DOWNLOAD STATEMENT AND DETAILED REPORTS

Download by clicking on report link

7. ACCOUNT STATEMENT DESCRIPTION

Section 1. Balance Movement Overview

  • All balance changes, both debits and credits.

  • Check the Balance Movements Report for in-depth details on each change.

  • The Transaction Report provides a complete look at all transactions.

Section 2. Reversals Overview

  • A combined view of all reversed transactions.

  • Access further information on each transaction, such as date and amount, in the Transaction Report.

Section 3. Pending Transactions Summary

  • Transactions awaiting final status.

  • Review the Pending Transactions Report for specifics on each transaction.

  • Find the available balance at the end of the reporting period in a separate line under the Pending Transactions Summary.

8. DETAILED REPORTS

 

Balance Movements Report Fields

  • MOVEMENT ID: This field contains a unique identifier for each balance movement recorded in the report. It helps in tracking and referencing specific balance movement.

  • CREATION DATE: This field records the date and time when the transaction or record was created. It helps in maintaining a chronological order of transactions and activities.

  • CHANGE IN BALANCE: This field indicates the amount by which the balance has changed due to the transaction. It can be positive (credit) or negative (debit).

  • TYPE: This field specifies the type of balance movement that has occurred: for example TRANSACTION _WHOLESALE (means transaction posting).

  • TYPE DESCRIPTION: This field provides a more detailed description of the transaction type. It elaborates on the type field, giving more context to the nature of the transaction.

  • CATEGORY: Credit of Debit.

  • TRANSACTION ID: This field contains a unique identifier for each transaction, similar to the Movement ID, but specific to the transaction processing aspect. It ensures each transaction can be individually tracked and verified.

  • NOTES: This field allows for any additional information or comments related to the transaction. It can include remarks, explanations, or any relevant details that need to be recorded alongside the transaction.

 

Detailed Transactions Report Fields

  • TRANSACTION ID: This field contains a unique identifier for each transaction, ensuring each transaction can be individually tracked and verified.

  • EXTERNAL ID: This field records an identifier provided by your user for cross-referencing with Transaction ID

  • PRODUCT ID: This field contains a unique identifier for the product involved in the transaction.

  • CREATION DATE: This field records the date and time when the transaction was created.

  • LAST STATUS UPDATED DATE: This field indicates the most recent date and time when the status of the transaction was updated.

  • PRODUCT NAME: This field provides the name of the product involved in the transaction.

  • PRODUCT VALUE: This field indicates the face value of the product in the transaction.

  • SERVICE: This field specifies the type of service related to the product (Mobile, Gift Cards, eSIM, etc)

  • SUBSERVICE: This field provides more detailed classification of the service related to the product (for example, Airtime, Data or Bundles for Mobile).

  • OPERATOR: This field indicates the operator involved in the transaction, for example, a telecom operator for Mobile recharge that was initiated with this particular transaction.

  • COUNTRY: This field records the country related to the transaction, where the product/service’s Operator provides servcies.

  • CREDIT PARTY MOBILE NUMBER: This field contains the mobile number of the party receiving the credit in the transaction.

  • WHOLESALE PRICE: This field indicates the wholesale price of the product involved in the transaction.

  • WHOLESALE FEE: This field records any fees associated with the wholesale transaction. May be empty.

  • SOURCE CURRENCY: This field specifies the currency used in your wallet.

  • WHOLESALE RATE: This field indicates the exchange rate applied for the wholesale transaction, if applicable.

  • REVENUE: This field records the revenue generated from the transaction.

  • RETAIL PRICE: If configured on the Price List level by you or DT One Pricing manager, this field indicates the retail price of the product involved in the transaction.

  • RETAIL FEE: This field records any fees associated with the retail transaction.May be empty.

  • PROFIT: This field calculates the profit from the transaction, if retail prices/fees are configured.

  • DESTINATION CURRENCY: This field specifies the currency at the destination (typically country of Operator)

  • USER EMAIL: This field contains the email address of the user associated with the transaction.

  • CREDIT PARTY: This field indicates any provided identificators/information of the party receiving the transaction.

  • ACCOUNT NUMBER: This field indicates any provided identificators/information of the party receiving the transaction.

  • DEBIT PARTY MOBILE NUMBER: This field contains the mobile number of the sender, if provided or required by the Operator

  • DEBIT PARTY ACCOUNT NUMBER: This field contains the mobile number of the sender, if provided or required by the Operator

 

Pending Transactions Report

Includes the same fields as in the Detailed Transactions Report, but only shows transactions that have not yet reached their final status.

9. MANAGE SUBSCRIPTIONS

To start receiving report regularly (daily, weekly, monthly) got to SETTINGS -> SUBSCRIPTION TAB

10. ADD ACCOUNT STATEMENT TO SUBSCRIPTIONS

11. ADD ACCOUNT STATEMENT TO SUBSCRIPTIONS