Balance

📘
Info
The Balance report is the accurate value of your account balance and it only includes completed transactions.

📘
Info
The time is expressed in the time zone of the browser used by the user.

Description of the columns of the Activity screen

Grouping	Display Column	Description
Date	Creation	Date when the customer created the transaction. Format AAAA-MM-DD HH:MM:SS.
Date	Processed	Date when the transaction was processed. Format AAAA-MM-DD HH:MM:SS.
Date	Settlement	For Payin. Date when the status will change to completed and be credited to the client's account. Format AAAA-MM-DD HH:MM:SS.
Date	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.
ID	External	An ID that is meaningful to you and your system. Must be unique.
Client	Name	Client name.
Client	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.
Payment Method	Method Type	Type of Payment method defined for the transaction. Verify it in the transaction type documentation.
Payment Method	Method Name	Name of Payment method defined for the transaction. Verify it in the transaction type documentation.
Status	Installments	Number of payment plan installments.
Status	Status	The status of the transaction in our system.
Status	Description	Description of the status of the transaction in our system.
Status	Comment	Comment of the status of the transaction in our system.
Payment	Amount	Amount of the transaction. Reporting in currency of field.
Payment	Financial Fees Withholdings	Value of Withholdings/Financial Fee. Reporting in currency of field.
Payment	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.
Account	Local Taxes	Value of Local Tax. Reporting in currency of field.
Account	Financial Fees Withholdings	Value of financial fee. Reporting in currency of field.
Account	Fees	Value of fee. Reporting in currency of field.
Account	Total	Value of transaction total. Reporting in currency of field.
Account	Balance	The final amount of your account of completed transactions. Reporting in currency of field.

Payment

The Header Paymentshows the requested Amount via API, then, if applicable, you will see the** Financial Fees** for Payin when Installments apply and the Withholdings for Payouts according to the local regulation.

The Payment Amount is the amount paid in the case of a Payin or received in the case of a Payout.

Column value explanation

Payment amount = Amount - Financial Fees Withholding

FX Quote

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.

Account

The Header Account shows the impact of each transaction on the account balance.

📘
Info
The values under this heading are expressed in the currency of the account.

Column values explanation

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 an opening and closing balance in each report to show you the initial and last value parameters of the account balance.

How to generate a file

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.

Column Title	Description
Creation	Date when the customer created 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 change to completed and be credited in the client's 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 accounts 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 transaction. Verify it in the transaction type documentation.
Payment Method Code	Code of Payment method defined for the transaction. Verify it in the transaction type documentation.
Installments	Number of payment plan installments.
Status	The status of the transaction in our system.
Description	Description of the status of the transaction in our system.
Comment	Comment of the 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

Example File Balance:

Client_Balance_04282024_113604.xlsx