Balance Report
Section overview​
Balance report section is a helpful balance analysis tool aimed at taking control over your funds as painlessly as it can possibly be. It shows a full client's charges and payments history for the selected period and provides a possibility to export the report data to .csv, .xls or .xls files depending on your preferences.
Creating a new Balance Report​
To create a new Balance Report, you need to fill in the following parameters in the form and press "Query" button:
Filters​
On the Filters menu, select the required parameters for the report. To cancel any filter, click on the delete icon next to the filter.
You can start a quick search by typing filters' names in the bar at the top of a drop-down menu with filters.
| Field | Description |
|---|---|
| Period | Specify the time interval for the report and a timezone. Mandatory. |
| Report Basis | Select a balance mode: - Accrual – compiled by invoices and payments, shows fixed balance - Cash – compiled by payments and charges, shows live balance |
| Client Type | Choose the system entity for the report: Client, Reseller, Calling Card, Call Shop |
| Group by | Select a grouping option: - Time: Month, Date - Document: Client ID, Payment Account ID |
Additional filters​
| Field | Description |
|---|---|
| Client | Define an origination client for the report |
| Payment Account | Enter a target payment account for the report |
Output​
This form contains settings of the output data of the report.
Click the plus icon next to Columns and select the required columns to add them to the Output information block. Also, you can cancel any chosen item.
Accessible columns in the report​
The following columns are to add in the report: Client, Client ID, Payment Account, Document Icon, Document Info, Opening Balance (report), Debit (report), Credit (report), Closing Balance (report), Type, NO, Notes, Date, Credit (client), Debit (client), Opening Balance (client), Closing Balance (client), Client Currency.
Document​
| Column | Description |
|---|---|
| Client | Name of the client/reseller/calling card/call shop, to which that current operation is assigned |
| Client ID | A client identification number that is also present in the full list of Transactions and Invoices |
| Payment Account | Respective payment account, used for the indicated transactions |
| Document icon | File icons that generally display a type of document in the report: -  different payments -  extra incoming/outgoing charges -  different charges or payments of the calls -  package payments -  service charges -  invoices |
| Document Info | The document that an operation corresponds to (charge, payment, invoice, etc.) |
| Type | Indicated type of document |
| NO | Number of transactions |
| Notes | Notes indicated in the comments of transactions or in invoices |
| Date | An operation date |
Amount​
| Column | Description |
|---|---|
| Opening Balance (report) | Start client's balance prior to a respective operation, displayed in the report currency |
| Closing Balance (report) | Final client's balance after a respective operation, displayed in the report currency |
| Debit (report) | Operation sum that has positive income (incoming payment/invoice), displayed in the report currency |
| Credit (report) | Operation sum that has negative income (outgoing payment/invoice), displayed in the report currency |
| Opening Balance (client) | Start client's balance prior to a respective operation, displayed in the client currency |
| Closing Balance (client) | Final client's balance after a respective operation, displayed in the client currency |
| Debit (client) | Operation sum that has positive income (incoming payment/invoice), displayed in the client currency |
| Credit (client) | Operation sum that has negative income (outgoing payment/invoice), displayed in the client currency |
| Client Currency | Currency indicated in a client's profile |
Other output settings​
| Field | Description |
|---|---|
| Type | Choose a format of the report from a drop-down list: Web/CSV/Excel XLS/Excel XLSx. Also, a type of table view: - Plain - a simple table view - Grouped - a table view with grouped data and a possibility to collapse it |
| Send to | You can send generated reports via email. Also, it is possible to specify several emails. Available only for CSV/Excel XLS/Excel XLSx formats; it doesn't work with Web. |
| Currency | Specify a currency for the report. All values will be automatically converted in the report to the specified currency. |
Please note that the Grouped type of table view is available only for Excel XLSx and Web formats, it doesn't work with CSV and Excel XLS.
Please note, the system shows rounded values in the reports. However, while calculating, the system takes an exact value. Hence, the procedure of the rounding is as follows:
- the system rounds currency values according to the settings of a respective currency
- other parameters are rounded to the nearest ten thousandths. For example, 3.879256 to 3.8793
Simple scheme: how to generate a balance report​
To create a simple report you need to:
- select target parameters for the report in the Filters menu;
- enter the interval and specify a timezone;
- select the Mode and Client Type;
- specify parameters in the Group by field; for example, Client ID;
- choose columns in the Output form; for example, Client, Payment Account, Document Icon, Document Info, Opening Balance, Debit, Credit, Closing Balance, Date;
- specify the Type field or leave its default settings (Web/Grouped);
- click the Query button.
- If the data is grouped in the report, it will be shown initially collapsed. To expand or collapse data in your report, click the plus or minus icons.
- Please note, the Order by option is active when the Type of the Output form is Plain. When it is Grouped, the data is only sorted by values specified in the "Group by" field.
Creating a Query template​
To create a template for reports and save specified parameters, click on the "Save Query" button. A pop-up window with settings will appear, and you will need to fill in the following form:
To load the already existing templates while generating statistic reports, click the "Load Query "button.
Export generated report​
You can export data to XLSx file, which contains currently presented data, by clicking "Export to XLSx" respectively.
- You can check an actual date interval of the report by clicking the "Info" icon, and it could be different from the Interval specified above if there is no date for the period.
- When you export the file from the Balance Report in Excel XLSx format, values will be displayed in the report currency. The client and transaction currencies will not be shown in the exported file.