Balance
Last updated
Last updated
The report starts with the transactions dates, after it shows all the transactions IDs, your account properties, merchant and payment details plus status of the transactions. After that the numeric side to the right is shown below:
The Balance report is the accurate value of your account balance and it only includes completed transactions.
Note: The time is expressed in the time zone of the browser used by the user.
The Header Payment shows the requested Amount via API, then if applicable you will see the Financial Fees for Payin when Installments apply and the Withholdings for Payouts with according to the local regulation apply.
The Payment Amount is the Amount paid in the case of a Payin or received in the case of a Payout.
Payment amount = Amount - Financial Fees Withholding
The Header FX Quote shows the applied FX for each payment only in the case of DCC (Dynamic currency conversion) that Currency Exchange applies for each transaction in real time.
The Header Account shows the impact of each transaction in the account balance.
The values under this heading are expressed in the currency of the account.
Confirmed = If FX Quote has a value Payment amount / Fx Quote otherwise Payment amount
Total: Confirmed - (Local taxes + Financial Fees + Fees)
Balance: Previous balance + Current transaction.
You will find and opening and closing balance in each report to show you the inicial and last value parameters of the account balance.
Select the <Export> option to generate the report
Definition of File Projected Balance
Excel spreadsheet is generated
Extension .XLXS
Report name Client_Balance_<MMDDAAAA>_<HHMMSS>
Column definition
Example File Balance
Grouping | Display Column | Description |
---|---|---|
Column Title | Description |
---|---|
Date
Creation
Date when the customer create the transaction.Format AAAA-MM-DD HH:MM:SS.
Processed
Date when the transaction was processed. Format AAAA-MM-DD HH:MM:SS.
Settlement
For Payin. Date when the status will changged to completed and be credited in the cliente account. Format AAAA-MM-DD HH:MM:SS.
Expiration
Date when the transaction expires. Depends on the transaction type. Format AAAA-MM-DD HH:MM:SS.
ID
Internal
An ID that is meaningful to our system. It's unique.
External
An ID that is meaningful to you and your system. Must be unique.
Client
Name
Client name.
Account Number
Number of client account in our system.
Merchant Name
The name of the merchant sending the payment.
Payment Method
Transaction Type
Transaction Type. Example PayIn or PayOut.
Method Type
Type of Payment method defined for the transaccion. Verify it in the transaction type documentation.
Method Name
Name of Payment method defined for the transaccion. Verify it in the transaction type documentation.
Status
Installments
Number of payment plan installments.
Status
The status of the transaction in our system.
Description
Descripcion of status of the transaction in our system.
Comment
Comment of status of the transaction in our system.
Payment
Amount
Amount of the transaction. Reporting in currency of field.
Financial Fees Withholdings
Value of Withholdings / Financial Fee. Reporting in currency of field.
Payment Amount
Value of payment amount. Reporting in currency of field.
Fx Quote
Value of FX rate.
Account
Confirmed
Value confirmed of the transaction. Reporting in currency of field.
Local Taxes
Value of Local Tax. Reporting in currency of field.
Financial Fees Withholdings
Value of financial fee. Reporting in currency of field.
Fees
Value of fee. Reporting in currency of field.
Total
Value of transaction total. Reporting in currency of field.
Balance
The final amount of your account of completed transactions. Reporting in currency of field.
Creation
Date when the customer create the transaction.Format AAAA-MM-DD HH:MM:SS.
Processed
Date when the transaction was processed. Format AAAA-MM-DD HH:MM:SS.
Settlement
For Payin. Date when the status will changged to completed and be credited in the cliente account. Format AAAA-MM-DD HH:MM:SS.
Expiration
Date when the transaction expires. Depends on the transaction type. Format AAAA-MM-DD HH:MM:SS.
Internal ID
An ID that is meaningful to our system. It's unique.
External ID
An ID that is meaningful to you and your system. Must be unique.
Client name
Name of client.
Account Code
Code of client account in our system.
Account Number
Number of client account in our system.
Merchant Name
The name of the merchant sending the payment.
Transaction Type
Transaction Type. Example PayIn or PayOut.
Payment Method Type
Type of Payment method defined for the transaccion. Verify it in the transaction type documentation.
Payment Method Code
Code of Payment method defined for the transaccion. Verify it in the transaction type documentation.
Installments
Number of payment plan installments.
Status
The status of the transaction in our system.
Description
Descripcion of status of the transaction in our system.
Comment
Comment of status of the transaction in our system.
Amount Currency
Currency of transaction amount.
Amount
Amount of the transaction.
Withholdings / Financial Fee Currency
Currency of transaction Withholdings / Financial Fee.
Withholdings / Financial Fee
Value of transaction Withholdings / Financial Fee.
Payment Amount Currency
Currency of payment amount.
Payment Amount
Value of payment amount.
Fx Quote
Value of FX rate.
Confirmed Currency
Currency of amount confirmed of the transaction.
Confirmed
Value confirmed of the transaction.
Local Tax Currency
Currency of Local Tax.
Local Tax
Value of Local Tax.
Financial Fees Currency
Currency of Financial Fees.
Financial Fees
Value of Financial Fees.
Fees Currency
Currency of Fees.
Fees
Value of Fees.
Total Currency
Currency of transaction total.
Total
Value of transaction total.
Balance of Currency
Currency of Balance
Balance
The final amount of your account of completed transactions