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.
Info
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 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 accounts 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 | 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.
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_Projected_<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 to 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. |
| Projected Balance of Currency | Currency of Projected Balance |
| Projected Balance | The final amount of your account after impacting the transaction. |
Example File Projected Balance:
Updated 2 months ago