Balance Report
Learn how to access and use the Balance report in Localpayment Business Portal to view your account balance and completed transactions with detailed filtering and export options.
The Balance report provides a comprehensive view of your account balance and completed transactions. This report displays transaction dates, IDs, account properties, merchant details, payment information, and transaction status with corresponding financial data.
The Balance report reflects the accurate value of your account balance and only includes completed transactions.
Prerequisites
Before accessing the Balance report, ensure you have:
Access Requirements
- Valid credentials for the Localpayment Business Portal
- User account with appropriate report viewing permissions
Navigation Path
Side Menu → Reports → Client → BalanceStep-by-Step Instructions
-
From the main business portal, click on Reports in the side menu.
-
Within the Reports section, choose Client.
-
Click on Balance to access the report interface.
-
Use the available filters to refine your search:
-
Examine the displayed transactions that match your criteria.
Exporting Report Data
-
Click the Export button located above the transaction list.
-
Choose your preferred File Type.
-
Click Export to download the file. If your search returns more than 15,000 rows, the request is queued and listed in Historical Reports instead.
File Naming Convention
Reports are automatically named as:
Client_Balance_<MMDDYYYY>_<HHMMSS>
Available Filters
Refine your activity search using the following criteria:
- Client: Select the originating client name
- Country: Choose the account country for transactions
- Account Number: Enter the Localpayment account number
- Date Range: Specify the time period for transaction history
Report Columns Reference
Time Zone Information
All timestamps are displayed in your browser's local time zone.
The following table indicates which columns appear in the business portal view versus the downloaded report:
| Group | Column Name | Description | Business Portal | Download |
|---|---|---|---|---|
| Date | ||||
| Creation | Transaction creation date (YYYY-MM-DD HH:MM:SS) | ✓ | ✓ | |
| Processed | Processing completion date (YYYY-MM-DD HH:MM:SS) | ✓ | ✓ | |
| Settlement | PayIn credit date (YYYY-MM-DD HH:MM:SS) | ✓ | ✓ | |
| Expiration | Transaction expiration date (YYYY-MM-DD HH:MM:SS) | ✓ | ✓ | |
| Internal | ||||
| Internal ID | Unique system-generated identifier | ✓ | ✓ | |
| Internal LotIn ID | Batch processing identifier (when applicable) | ✓ | ✓ | |
| External | ||||
| External ID | Your custom reference ID (must be unique) | ✓ | ✓ | |
| Client Information | ||||
| Client Name | Name of the client account | ✗ | ✓ | |
| Account Code | System account code | ✗ | ✓ | |
| Account Number | Localpayment account number | ✗ | ✓ | |
| Merchant | ||||
| Merchant Name | Payment sender identification | ✓ | ✓ | |
| Payment Method | ||||
| Transaction Type | Type of transaction designation | ✓ | ✓ | |
| Payment Method Type | Specific payment method used | ✓ | ✓ | |
| Method Name | Payment method display name | ✗ | ✓ | |
| Payment Method Code | System payment method code | ✗ | ✓ | |
| Status | ||||
| Installments | Number of payment installments | ✓ | ✓ | |
| Status | Current transaction status | ✓ | ✓ | |
| Description | Status description | ✓ | ✓ | |
| Comment | Additional status notes | ✗ | ✓ | |
| Payment | ||||
| Amount Currency | Original transaction amount's currency | ✗ | ✓ | |
| Amount | Original transaction amount | ✓ | ✓ | |
| Withholdings / Financial Fee Currency | Withholding/fee amounts' currency | ✗ | ✓ | |
| Financial Fees Withholdings | Withholding/fee amounts | ✓ | ✓ | |
| Payment Currency | Net amount's currency | ✗ | ✓ | |
| Payment Amount | Net amount (Amount - Fees/Withholdings) | ✓ | ✓ | |
| FX Quote | ||||
| FX Quote | Exchange rate (if applicable) | ✓ | ✓ | |
| Account | ||||
| Confirmed Currency | Confirmed transaction value's currency | ✗ | ✓ | |
| Confirmed | Confirmed transaction value | ✓ | ✓ | |
| Local Taxes Currency | Local tax amounts' currency | ✗ | ✓ | |
| Local Taxes | Local tax amounts | ✓ | ✓ | |
| Financial Fees Currency | Processing fee amounts's currency | ✗ | ✓ | |
| Financial Fees | Processing fee amounts | ✓ | ✓ | |
| Fees Currency | Additional fee amounts' currency | ✗ | ✓ | |
| Fees | Additional fee amounts | ✓ | ✓ | |
| Total Currency | Net amount's currency | ✗ | ✓ | |
| Total | Net amount after all deductions | ✓ | ✓ | |
| Balance Currency | Running account balance currency | ✗ | ✓ | |
| Balance | Running account balance | ✓ | ✓ | |
| Created by | ||||
| Created by | User who initiated the transaction | ✓ | ✓ |
Understanding Key Report Sections
Payment Information
The Payment section displays:
- Amount: Original amount requested via API
- Financial Fees: Applied for PayIn transactions with installments
- Withholdings: Applied for PayOut transactions per local regulations
FX Quote Details
The FX Quote section shows:
- Exchange rates for Dynamic Currency Conversion (DCC) transactions
- Real-time currency conversion rates applied to each transaction
Account Balance Impact
The Account section displays:
- How each transaction affects your account balance
- Values expressed in your account currency
- Opening and closing balances for the report period
Balance Calculation
Balance = Previous Balance + Current Transaction Total
Sample Report
View a sample Balance report to understand the data structure and format:
Need Help? If you have questions about this process or any other feature, our support team is here for you. We can assist with troubleshooting, integration planning, and optimization.
Updated 3 months ago