Projected Balance
It has the same structure as the Balance, the difference is that the Projected Balance is the actual Balance plus the pending transactions so the end value that will show you is not accurate, it will be approximate and will help you understand the possible future outcomes.
Note: The time is expressed in the time zone of the browser used by the user.
Description of the columns of the Projected Balance screen
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.
Projected Balance
The final amount of your account after impacting the transaction. Reporting in currency of field.
Payment
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.
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 in the account balance.
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 and opening and closing balance in each report to show you the inicial 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_Projected_<MMDDAAAA>_<HHMMSS>
Column definition
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.
Projected Balance of Currency
Currency of Proje Balance
Projected Balance
The final amount of your account after impacting the transaction.
Example File Projected Balance
Last updated