Docs for all releases
Page History
...
Balance report section is a helpful balance analysis tool aimed at making the taking control over your funds as painless as painlessly as it can possibly be. It shows a full history of 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.
Screenshot: Balance Report query form
...
Creating a New Balance Report
To create a new summary report, you need to fill in the following parameters in the form and press Query button:
Information block | Field Description | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
Filters | On the Filters menu, select required select the required parameters for the report. To cancel any filter, click on the delete sign 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. | |||||||||
Period | Specify the time interval for the report and a timezone. Please note that the Period field is mandatory. | |||||||||
Mode | Select a balance mode to show a respective set of data
| |||||||||
Client Type | Choose the system entity for the report from the following:
| |||||||||
Group Byby | Select from the list of the following accessible options to group the data in reports:
| |||||||||
Additional Filters | ||||||||||
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 sign next icon next to Columns and select the required columns in order to add them to Output information block. Also, you can cancel any chosen item. | |||||||||
Accessible columns in the report | ||||||||||
There are The following columns are to add in the report: Client, Client ID, Payment Account, Document Icon, Document Info, Start Balance, Debit, Credit, End Balance, Type, NO, Notes, Date. | ||||||||||
Document | ||||||||||
Client | Name of the client/reseller/calling card/call shop for , to which that current operation is assigned to | |||||||||
Client ID | 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 the document in the report:
| |||||||||
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 | ||||||||||
Start Balance (report) | Start client's balance prior to a respective operation, displayed in the report currency | |||||||||
End 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 | |||||||||
Start Balance (client) | Start client's balance prior to a respective operation, displayed in the client currency | |||||||||
End 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 | ||||||||||
Type | Choose a format of the report from a drop-down list: Web/CSV/Excel XLS/Excel XLSx. Also, a kind type of table view:
| |||||||||
Send to | You can send generated reports via email. Also, it is possible to specify several emails.
| |||||||||
Currency | Specify a currency for the report. And all values will be automatically converted in the report to the specified currency. |
...
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Warning Please note, the system shows rounded values in the reports. But However, while calculating, the system takes an exact value. Hence, the procedure of the rounding is followingas follows:
|
Simple scheme: how to generate a balance report
In order to To create a simple report you need to:
- On the Filters menu, select target parameters for the report .in the Filters menu;
- enter Enter the interval and specify a timezone;
- Select select the Mode and Client Type.;
- Specify specify parameters in the Group Byby field, ; for example, Client ID.;
- Then, choose columns in the Output form, for ; for example, Client, Payment Account, Document Icon, Document Info, Start Balance, Debit, Credit, End Balance, Date.;
- Specifyspecify the Type field or leave its default settings (Web/Grouped) ;
- Click the click the Query button.
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Tip
|
Creating a Query Template
To create a template for reports and save specified parameters, click on on the Save Query button. A pop-up window with settings will appear, and you will need to fill in the following form:
...
Information block | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Balance Report | Here you can specify parameters for the template that will be used while running reports. | ||||||||||
Title | Specify a name of the template | ||||||||||
Reseller | Indicate a Reseller for the report template | ||||||||||
Visibility | Define who can review this template:
| ||||||||||
Watch | This tool allows to automatically generate reports automatically at the appropriate time and send the results to the list of emails.
| ||||||||||
Recipients | Specify recipients: it can be your own email, other users of the system or even 3rd parties. | ||||||||||
Run Time | Define an appropriate time to automatically generate a report automatically. It could be several times, for example: 10:00, 12:00, 18:00. | ||||||||||
Days of Week | Indicate days of the week to automatically generate a report automatically. For example, you can run a report only on Monday Mondays or each day of week. | ||||||||||
Report Query | Here you need to specify the filters that will be used for generating a correct report and choose the output type to view the report. |
To load the already existing templates while generating statistic reports, click click the Load Query button.
Export Generated Report
You can export data to XLSx or CSV file, which contains currently presented data, by pressingclicking Export to XLSx or Export to CSV button, respectively. Please note that Export to CSV is available only when the Type of the output is Plain.
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Attention
|
...