Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Information blockField Description
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.

Period

Specify the time interval for the report and a timezone. Please note that the Period field is mandatory.

Report Basis

Select a balance mode to show a respective set of data

  • Accrual - this mode is compiled by invoices and payments, it shows fixed balance
  • Cash - this 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 the following accessible options to group data in reports:

  • Time: Month, Date.
  • Document: Client ID, Payment Account ID.

Additional Filters

ClientDefine 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. You can also 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 (Clientclient), Debit (Clientclient), Opening Balance (Clientclient), Closing Balance (Clientclient), Client Currency.

Document
ClientName of the client/reseller/calling card/call shop, to which that current operation is assigned
Client IDA 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:

  • 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 InfoThe document that an operation corresponds to (charge, payment, invoice, etc.)
TypeIndicated type of document
NONumber of transactions
NotesNotes indicated in the comments of transactions or in invoices
DateAn operation date
Amount
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 CurrencyCurrency 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.

Select a type of table view:

  • Plain - a simple table view
  • Grouped - a table view with grouped data and a possibility to collapse it
Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning) Attention

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.


Send to

You can send generated reports via email. It is also possible to specify several emails.

Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning) Attention

This feature is available only for CSV/Excel XLS/Excel XLSx formats of the report. 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.

...