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

107KB

Client_Projected_04262024_210411.xlsx