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

Grouping
Display Column
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.

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

Column Title
Description

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