Balance Report

In this article

Section overview

Balance report section is a helpful balance analysis tool aimed at making the control over your funds as painless as it can possibly be. It shows a full history of client's charges and payments 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

Сreating 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 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 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 *Accountant* - this mode is compiled by invoices and payments, it shows fixed balance Live balance - this report mode is compiled by payments and charges, it shows live balance
	Client Type	Choose the system entity for the report from the following Client Reseller Calling Card Call Shop
	Group By	Select from the list of following accessible options to group the data in reports: Time: Month, Date. Document: Client ID, Payment Account ID.
	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 plus sign next to Columns and select 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 following columns 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 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: This icon shows different payments in the system. This icon defines extra incoming/outgoing charges. This icon means different charges or payments of the calls. This icon represents payments of the packages. This icon displays service charges. This icon represents the invoices in the system.
	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 respective operation, displayed in report currency
	End Balance (report)	Final client's balance after respective operation, displayed in report currency
	Debit (report)	Operation sum that has positive income (incoming payment / invoice), displayed in report currency
	Credit (report)	Operation sum that has negative income (outgoing payment / invoice), displayed in report currency
	Start Balance (client)	Start client's balance prior to respective operation, displayed in client currency
	End Balance (client)	Final client's balance after respective operation, displayed in client currency
	Debit (client)	Operation sum that has positive income (incoming payment / invoice), displayed in client currency
	Credit (client)	Operation sum that has negative income (outgoing payment / invoice), displayed in client currency
	Client Currency	Currency, indicated in 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 of table view: Plain - a simple table view Grouped - a table view with grouped data and possibility to collapse it Attention Please note that Grouped type of table view is available only for Excel XLSx and Web formats, it doesn't work with CSV and Excel XLS.
	Send to	You can send generated reports via email. Also, it is possible to specify several emails. Attention This feature is available only for CSV / Excel XLS / Excel XLSx formats of the report, although it doesn't work with Web.
	Currency	Specify a currency for the report. And all values will be automatically converted in the report to the specified currency.

Screenshot: Balance Report section

Warning

Please note, the system shows rounded values in the reports. But while calculating the system takes an exact value. Hence, the procedure of the rounding is following:

system rounds currency values according to the settings of a respective currency;
other parameters are rounded to the nearest ten thousandth. For example, 3.879256 to 3.8793.

Simple scheme: how to generate a balance report

In order to create a simple report you need to:

On the Filters menu, select target parameters for the report.
Enter the interval and specify a timezone
Select the Mode and Client Type.
Specify parameters in the Group By field, for example, Client ID.
Then, choose columns in the Output form, for example, Client, Payment Account, Document Icon, Document Info, Start Balance, Debit, Credit, End Balance, Date.
Specify Type field or leave its default settings (Web / Grouped)
Click the Query button.

Tip

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 signs.
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 sorting by values specified in the Group By field.

Creating Query Template

To create a template for reports and save specified parameters, click on Save Query button. A pop-up window with settings will appear, and you need to fill in the following form:

Screenshot: New Query Template 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: Public - anyone can view this template Private - only template owner can view it
Watch	This tool allows to automatically generate reports at the appropriate time and send the results to the list of emails. Attention Please note that this tool is not available for Web output type, only for CSV / Excel XLS / Excel XLSx.
	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. 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. For example, you can run a report only on Monday or each day of week
Report Query	Here you need to specify filters that will be used for generating a correct report and choose the output type to view the report.

To load already existing templates while generating statistic reports, click Load Query button.

Export Generated Report

You can export data to XLSx or CSV file, which contains currently presented data by pressing Export to XLSx or Export to CSV button, respectively. Please note that Export to CSVis available only when the Type of the output is Plain.

Screenshot: Balance Report section

Attention

You can check an actual date interval of the report by clicking on 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 Balace Report in Excel XLS/CSV formats, values will be displayed in the report currency. The client and transaction currencies will not be shown in the exported file.

Error rendering macro 'contentbylabel'

parameters should not be empty