Difference between revisions of "Invoices"

From Kolmisoft Wiki
Jump to navigationJump to search
 
(95 intermediate revisions by 14 users not shown)
Line 5: Line 5:
= Configuration =
= Configuration =
   
   
You can manage Invoices settings, details, address information and functionality in the Invoices section of the [[Configuration_from_GUI#Invoices | SETTINGS -> Setup -> Settings]] window.<br>
You can manage Invoices settings, details, Address information and functionality in the Invoices section of the [[Configuration_from_GUI#Invoices | SETTINGS -> Setup -> Settings]] window.<br>
If you want show user_billsec instead of billsec in Users invoices and last calls, go to [[Configuration_from_GUI#Visual | Settings –> Various]] and check ''Show user_billsec for Users instead of billsec''
If you want show user_billsec instead of billsec in Users invoices and last calls, go to [[Configuration_from_GUI#Visual | Settings –> Various]] and check ''Show user_billsec for Users instead of billsec''
<br><br>
<br><br>
Go to User's edit page to enable or disable types of invoices he can see in his invoices details. And also these selected types will be the ones that are sent to user via email.
[[File:Invoice types.png]]
=Invoices list=
=Invoices list=


Invoices can be viewed, generated, recalculated, sent, also <!---...from MOR 9---> list of Invoices can be exported to CSV file (Invoice number is included in the output data) in '''SETTINGS –> Accounting –> Invoices'''. In the main window, you can see list of all Invoices:
Main invoices page is available in '''SETTINGS –> Accounting –> Invoices'''. Invoices can be viewed, generated, recalculated, sent over email and exported to different formats (CSV, XLSX, PDF). In the main window, you can see list of all Invoices:
<br><br>
<br><br>
[[Image:invoices_list_x6.png]]
[[Image:Invoice list small.png]]
<br><br>
<br><br>
The icons [[Image:icon_check.png]] and [[Image:icon_cross.png]] show whether this invoice is Paid or Unpaid, Sent or Not Sent.  
The icons [[Image:icon_check.png]] and [[Image:icon_cross.png]] show whether this invoice is Paid or Unpaid, Sent or Not Sent, Hidden or Not Hidden. If invoice is Hidden, it will not be shown for User.
<br>
The icon [[Image:icon_money_delete.png]] deletes the invoice and associated Payments.
<br>
'''NOTE''' Each Invoice generated in particular Time Zone and on particular Currency. That means that in each line of Invoice Price and Price with TAX will be shown in currency which is written in Currency column. The Currency column tells which currency Invoice was generated with. Also the exchange rate at the invoice generation moment is saved in the database so it may differ from the up to date exchange rate.
<br>
Total Price and Price with TAX are calculated into viewing Currency, which you can choose in upper corner of page. In Total price calculation there are used saved exchange Rate of each Invoice.
<br><br>
'''Example'''
<br><br>
Default system Currency is USD
<br>
Invoice A is generated on price = 100 in currency EUR with exchange rate 0.5<br>
Invoice B is generated on price = 100 in currency DZD with exchange rate 0.25<br>
Invoice C is generated on price = 100 in currency ALL with exchange rate 0.75<br>
<br>
But now exchange rate are different: EUR - 0.75, DZD - 0.5 and ALL - 1.0. <br>
<br>
If you want to see Total price(sum of these 3 Invoices) in EUR. For Invoice B and C will be set exchange rate of today, but for Invoice A exchange rate will be from that day when Invoice was generated (0.5).<br>
 
Same calculations with other currencies:<br>
If you want to see Total price in USD. For Invoice A, B and C the exchange rates will be set from the day when invoice was generated (EUR - 0.5, DZD - 0.25 and ALL - 0.75).<br>
If you want to see Total price in DZD. For Invoice A and C will be set exchange rate of today, but for Invoice B exchange rate will be from the day when Invoice was generated (0.25).<br>
If you want to see Total price in ALL. For Invoice A and B will be set exchange rate of today, but for Invoice C exchange rate will be from the day when Invoice was generated (0.75).<br>
<br>
Total price will be 733.3333 USD, or 500 EUR, or 266.6667 DZD, or 700 ALL<br>
<br><br>
<br><br>
=Invoice details=
=Invoice details=


Line 21: Line 52:
<br><br>
<br><br>
[[Image:invoice_details_x6.png]]
[[Image:invoice_details_x6.png]]
<br><br>
Invoice details are shown in Currency which was used to generate Invoice.
<br><br>
<br><br>
==General Details==
==General Details==


'''Payment date''' - An option which will set the period of payment on current month. By default ''Years'' and ''Month'' is current, it is only possible to change ''Day of Month'' which is indicating the last date of ''Invoice'' issue.
'''Payment date''' - An option which will set the period of payment on current month. By default ''Years'' and ''Month'' is current, it is only possible to change ''Day of Month'' which is indicating the last date of ''Invoice'' issue.<br>
'''Currecy of Invoice''' - <!---This functionality is available from MOR 11---> From Administrator account Invoices for Users are exported according to selected currency in the top of page. From User account Invoices are exported in Users currency.
'''Currecy of Invoice''' - <!---This functionality is available from MOR X6---> Invoices are exported in Invoice currency.


'''Language of Invoice'''
'''Language of Invoice'''
Line 31: Line 64:
Default language in MOR is English. However, you can send invoices in different languages (click on the flag icon on the top of the page).
Default language in MOR is English. However, you can send invoices in different languages (click on the flag icon on the top of the page).
<br><br>
<br><br>
==User Details==
==User Details==


Line 39: Line 73:
Here you can view the details of all invoices and click on the [[Image:icon_pdf.png]] or [[Image:icon_csv.png]] icons to generate invoice files in PDF or CSV formats accordingly. First icon [[Image:icon_csv.png]] will download a xlsx file.
Here you can view the details of all invoices and click on the [[Image:icon_pdf.png]] or [[Image:icon_csv.png]] icons to generate invoice files in PDF or CSV formats accordingly. First icon [[Image:icon_csv.png]] will download a xlsx file.


*'''Invoice''' shows common information like time period,  total price and total price with tax. PDF also shows services list, their quantity, unit prices...
*'''Invoice XLSX''' XLSX file shows information which are set by you. Check [[Invoices#XLSX_Invoices | XLSX Invoice]]. Clicking on PDF icon will convert XLSX file to PDF format.
*'''Invoice detailed''' PDF shows same information like simple invoice and includes calls list.
*'''Simplified Invoice''' PDF shows separate services Prices and Total Invoice Prices, CSV shows just Total Invoice Prices.
*'''Invoice by CallerID'''  shows calls list grouped by CallerID.
*'''Detailed Invoice''' shows same information like simple Invoice and includes Calls list grouped by Destination.
*'''Invoice Destinations''' shows calls list grouped by Destination.  
*'''Invoice by CallerID'''  shows Calls list grouped by CallerID.
*'''Invoice Destinations''' shows Calls list grouped by Destination.  


You can manage what kind of Invoice should be showed for User and/or sent to User as email attachment in [[User_Details#Invoices |User Details]]. Here you can check ''Show zero Calls'' option if you need to calculate 0 price Calls into Invoices.
You can manage what kind of Invoice should be showed for User and/or sent to User as email attachment in [[User_Details#Invoices |User Details]]. Here you can check ''Show zero Calls'' option if you need to calculate 0 price Calls into Invoices.
<br><br>
=== XLSX Invoices ===
=== XLSX Invoices ===


XLSX file to export an Invoice is made from your own XLSX format template and information from Invoices main window.  
XLSX file to export an Invoice is made from your own XLSX format template and information from Invoices main window.
Example of template can be downloaded [http://packets.kolmisoft.com/packets/x6_invoice_template.xlsx here].
<br><br>
Example of XLSX Invoice can be downloaded [http://wiki.kolmisoft.com/images/9/93/Invoice_example_for_wiki.xls here].
<br><br>
<br><br>
'''Default XLSX template'''
'''Default XLSX template'''


Create a xlsx file. Template you can prepare as you wish, you can fill it with information of company, draw tables with column names, describe information taken from Invoice main window and so on. Template '''have to be uploaded in SETTINGS -> Setup -> Settings''', Invoices - XLSX tab setting  '''XSLX Template'''
This is XLSX file used as template which MOR uses as base and fills up with billing information. You can fill template with information of company, draw tables with column names, describe information taken from Invoice main window and so on. When creating template, reserve only one line for Prefixes/Destinations list. MOR will automatically add as many lines as needed. Do not draw borders within this line. Instead, draw a border on Cells above and below this line.
Template '''have to be uploaded in SETTINGS -> Setup -> Settings''', Invoices - XLSX tab setting  '''XSLX Template'''
* Check '''New XLSX template apply for old Invoices''' if you want to change XLSX template for Invoices which is already generated.
* Check '''Group regular Calls by Destinations''' if you want XLSX file use as detailed Invoice.
<br>
 
'''Converting to PDF format'''
 
It is possible to convert XLSX invoice to PDF format using the following methods:
 
* By clicking on PDF icon in [[Invoices#Invoice_details|Invoice details]] page in XLSX row.
* By clicking on Export all to PDF link in [[Invoices#Invoices_list|Invoice list]] page.
* If [[Configuration_from_GUI#XLSX|Send XLSX Invoices converted to PDF]] options is enabled, sending invoices over email manually or using Cron actions will convert XLSX files to PDF.
<br><br>
<br><br>
[[Image:invoice_xlsx_settings_x6.png]]
 
'''Balance Line settings'''
 
''Outstanding balance (Debt)'', ''Outstanding balance (Debt) with TAX'', ''Total amount due'' options are present when ''Show balance line'' ('''SETTINGS -> Setup -> Settings''', Invoices - Postpaid - Settings) setting is enabled.
<br><br>
<br><br>
'''Configuration for Dynamic information'''
'''Configuration for Dynamic information'''


When you already have a template for example with all data of your company, with drawn tables and so on, you need to define where should be shown the dynamic information of invoice. How and what information is displayed can be set same '''SETTINGS -> Setup -> Settings''', Invoices - XLSX tab. Just need to define cell address in correct format.  
When you already have a template for example with all data of your company, with drawn tables and so on, you need to define where should be shown the dynamic information of invoice. How and what information is displayed can be set same '''SETTINGS -> Setup -> Settings''', Invoices - XLSX tab. Just need to define cell address in correct format:
Group regular Calls by Destination:
Send XLSX Invoices converted to PDF.
'''Possible Addresses of Cells:'''
 
Number of Invoice:
 
*Issue Date
*Period Start Date
*Period End Date
*Time Zone
*User full Name
*User Address
*User City
*User Postcode/ZIP
*User State
*User Country
*User Phone
*TAX Registration Number of the User
*Number for numeration of Services
*Destination Prefix
*Service Name
*Rate of particular Destination
*Units amount to Service
*Duration to particular Destination
*Price of particular Service
*Total Price of Invoice
*Tax amount
*Total Price of Invoice with applied TAX
*Comment
*Company/Personal ID
*Agreement number
*Service Discount
*Service SUM
*Total Discount of Invoice
*Total Discount of Invoice with applied TAX
*Total SUM of Invoice
*Total SUM of Invoice with applied TAX


For example "A2", "B15", "AA9"
For example "A2", "B15", "AA9"
Line 63: Line 154:
[[File:callc.png]]
[[File:callc.png]]
<br><br>
<br><br>
So you should enter number of cells as in example below:
<br><br>
[[File:XLSX invoice cells.png]]
<br><br>
'''NOTE''': If you do not want to use particular dynamic value just leave empty input for it.
Client Address Cell is different than other ones - once you will define this, all other Address Related Cells will be filled automatically and will not be editable. Also, no empty space will be left if any Address sub-cell is not defined. For example, if Client State is not defined in User's Settings, then this Cell will not be empty in Invoice - all Address Cells bellow will go up by one Cell. This allows nice Address formatting without leaving spaces if some Address data is not defined in User's settings.
<br><br>
'''Custom XLSX template For Users'''
By default, a global (default) template is used for all users. It is possible to enable specific templates for different users. This can be done by clicking on Excel Icon in the User's edit window.
<br><br>
[[File:Mor_users_settings_custom_invoice.png]]
<br><br>
After clicking on this icon, a new window will appear (similar to the Global XLSX template), where you can upload and enable/disable the custom template and adjust cell values.
<br><br>
[[File:Mor_users_custom_invoice_values.png]]
<br><br>
=== PDF invoices ===
=== PDF invoices ===


Line 70: Line 182:


You can print your invoices on paper with a pre-printed logo if you want to send paper invoices.
You can print your invoices on paper with a pre-printed logo if you want to send paper invoices.
Example of PDF invoice can be downloaded by clicking [http://wiki.kolmisoft.com/images/a/a0/Example-Invoice-for-wiki.pdf here] and for detailed invoice click [http://wiki.kolmisoft.com/images/e/e1/Example-Detailed-Invoice-for-wiki.pdf here].
<br><br>
<br><br>
=== CSV invoices ===
=== CSV invoices ===


Detailed CSV invoice does not include list of all calls. Please use [[How_to_export_CDRs|CDR export]] if you need list of calls in CSV format.
Detailed CSV invoice does not include list of all calls. Please use [[How_to_export_CDRs|CDR export]] if you need list of calls in CSV format.
<br><br>
<br><br>
==Comment==
==Comment==
<br>
<br>
Line 91: Line 207:
'''Services:'''
'''Services:'''
<br>
<br>
* '''SMS''' – quantity and price of SMS sent in selected period. Invoice for Reseller counts all SMS that was sent by his users using price for Reseller. Note, that SMS are included to Invoice only when [[SMS Addon]] is used
* '''DID Owner Cost''' – price for having and using own DID(s)
* '''DID Owner Cost''' – price for having and using own DID(s)
* '''Subscriptions''' – price of subscription applied to selected period. Period considered as month is from first till last day of month and from concrete day of month till next month one day before selected last month. Eg. from 2013-02-26 till 2013-03-25
* '''Subscriptions''' – price of subscription applied to selected period. Period considered as month is from first till last day of month and from concrete day of month till next month one day before selected last month. Eg. from 2013-02-26 till 2013-03-25
Line 105: Line 220:
[[Image:generate_invoices_x6.png]]
[[Image:generate_invoices_x6.png]]
<br><br>
<br><br>
Select for which users to generate invoices. Prepaid and Postpaid users can have separate details. Also, you can check to generate an invoice for only one particular user. Invoice will be generated if selected User existed at least one day of all Invoice period.
Select for which users to generate invoices. Prepaid and Postpaid users can have separate details. Also, you can check to generate an invoice for only one particular user. Invoice will be generated if selected User existed at least one day of all Invoice period. When Invoice Generation Task is created, admin can check the progress in [[Background Tasks]].  


'''NOTE:''' For Prepaid User after every executed Manual Payment will be generated Invoice automatically.<br>
<!---This functionality is available from MOR X5--->
<!---This functionality is available from MOR X5--->
'''NOTE:''' If Currency of User is different than default System Currency. All his Invoices will be generated with [[Currencies| Currency]] Exchange Rate of current day.  
'''NOTE:''' If Currency of User is different than default System Currency. All his Invoices will be generated with [[Currencies| Currency]] Exchange Rate of current day. <br>
'''NOTE:''' When generating invoice, current user details will be used.  <br>
<br><br>
<br><br>
=Invoice cannot be generated error=
Invoices will be generated only if Elasticsearch data is up to date and consistent with MySQL data. This is usually seen in MOR main page ES Sync Status:
<br>[[Image:ES_SYNC_100%.png]]<br>
If there are data inconsistencies between Elasticsearch and MySQL, you will see a notification '''Invoice cannot be generated due to data inconsistencies, please contact support''' and Invoice will not be generated. This is done to prevent generating incorrect Invoices. Please contact support if you get this message or you may solve it manually by following this [http://wiki.kolmisoft.com/index.php/No_data_in_Statistics_pages guide].
= Invoice recalculation =
= Invoice recalculation =


Line 123: Line 247:
[[Image:recalc.png]]
[[Image:recalc.png]]
<br><br>
<br><br>
Select for which users to recalculate invoices.
Select which type of Invoices or whose Invoices to recalculate.
<br><br>
<br><br>
=== Recalculate a single Invoice ===
=== Recalculate a single Invoice ===
Line 131: Line 255:
[[File:Recalculate_single_invoice_x6.png]]
[[File:Recalculate_single_invoice_x6.png]]
<br><br>
<br><br>
= Send invoices by email =


Click [[Image:icon_email_send.png]] to open more options to enter the period in which you want to send invoices. Click '''Send''' to send invoices to their Users in this period:
= Pay unpaid Invoices =
 
In list of Invoices click [[Image:icon_edit.png]]'''Bulk management''' and button '''Pay unpaid Invoices''' will appear.
<br><br>
[[File:Pay_unpaid_invocies.png]]
<br><br>
Click '''Pay unpaid Invoices''' and '''All''' unpaid Invoices will be marked as paid. For each marked Invoice Payment will be created.
<br><br>
 
 
= Delete all Invoices =
 
== This applies to MOR versions from MOR X18 ==
 
In list of Invoices click [[Image:icon_edit.png]]'''Bulk management''' and button '''Delete all invoices''' will appear.
<br><br>
[[File:Delete_all_invoices_x18.png]]
<br><br>
Click '''Delete all invoices''' and '''all listed Invoices in all pages''' will be deleted (with respect to search filter).
<br><br>
'''Note:''' Deleting invoices will not remove associated Payments, so the current user balance will not be affected.
<br>
To delete invoices and associated payments, you need to press the delete the invoice and associated Payments icon [[Image:icon_money_delete.png]].
 
'''Note:''' Invoices, which were already sent, are possible to delete only with option enabled in: Invoices->Functionality-> Invoice allow recalculate after send.
 
 
== This applies to MOR versions until MOR X18 ==
 
In list of Invoices click [[Image:icon_edit.png]]'''Bulk management''' and button '''Delete all invoices''' will appear.
<br><br>
<br><br>
[[Image:invoices_send_x6.png]]
[[File:Delete_all_invoices.png]]
<br><br>
Click '''Delete all invoices''' and '''all listed Invoices in all pages''' will be deleted (with respect to search filter).
<br><br>
'''Note:''' Invoices, which were already sent, are possible to delete only with option enabled in: Invoices->Functionality-> Invoice allow recalculate after send.
 
'''Note:''' Deleting invoices will remove associated Payments, so the current user balance will be affected.
<br><br>
 
= Hide/Unhide all invoices =
 
In list of Invoices click [[Image:icon_edit.png]]'''Bulk management''' and button '''Hide all invoices''' will appear.
<br><br>
[[File:Hide invoices.png]]
<br><br>
Click '''Hide all Invoices''' or '''Unhide all Invoices''' and '''all listed Invoices in all pages''' will be Hidden/Unhidden (with respect to search filter).
 
'''Note:''' Invoices will be hidden for users only. Admin will still see invoices in the list.
 
= Send invoices by email (manual) =
 
Click '''Send Invoices over Email to Users''' to send invoices to their Users in this period:
<br><br>
[[Image:Invoce email.png]]
<br><br>
<br><br>
You can use these settings to choose which users should get an email with the invoice. Using these settings you can send emails in parts.
You can use these settings to choose which users should get an email with the invoice. Using these settings you can send emails in parts.
Line 141: Line 316:
* '''Email sending''' option must be enabled in Email Settings to use this feature
* '''Email sending''' option must be enabled in Email Settings to use this feature
* Tip: you can '''send invoices in parts''' by using text fields to send invoices for users which '''Username, First name, Last name''' or '''Number''' begins with some letters. For example: you have users with usernames john, albert and alex. You want to send invoices only for users whose usernames begins with '''"a"''' so you just have to enter '''"a"''' in a '''Username text field''' to send invoices only to albert and alex.
* Tip: you can '''send invoices in parts''' by using text fields to send invoices for users which '''Username, First name, Last name''' or '''Number''' begins with some letters. For example: you have users with usernames john, albert and alex. You want to send invoices only for users whose usernames begins with '''"a"''' so you just have to enter '''"a"''' in a '''Username text field''' to send invoices only to albert and alex.
<br><br>
<br><br>
= Generate and send invoices by email (automatically) =
Use [http://wiki.kolmisoft.com/index.php/Cron_actions#Generate_Invoices_and_send_by_Email Cron Actions] to Generate and send Emails automatically.
<br><br>
= Export Invoices =
In Invoices list window it is possible to export all matching Invoices to different formats. Available options are:
* '''Export to CSV''' - Exports information (Invoice number, Username, Accounting Number, Export to CSV and other) about invoices to CSV file
* '''Export all to XLSX''' - Generates all matching Invoices' XLSX files and provides them in a single ZIP archive file.
* '''Export all to PDF''' - Generates all matching Invoices' PDF files (converted from XLSX files) and provides them in a single ZIP archive file.
<br><br>
=See also=
=See also=


Line 151: Line 345:
* [[MOR API invoices_get]]
* [[MOR API invoices_get]]
* [[Cannot generate Invoice]]
* [[Cannot generate Invoice]]
* [[Duplicate value in Cell Address field]]

Latest revision as of 08:21, 28 March 2024

Description

An invoice, bill or tab is a commercial document issued by a seller to a buyer, relating to a sale transaction and indicating the products, quantities, and agreed prices for products or services the seller had provided the buyer.

Configuration

You can manage Invoices settings, details, Address information and functionality in the Invoices section of the SETTINGS -> Setup -> Settings window.
If you want show user_billsec instead of billsec in Users invoices and last calls, go to Settings –> Various and check Show user_billsec for Users instead of billsec

Go to User's edit page to enable or disable types of invoices he can see in his invoices details. And also these selected types will be the ones that are sent to user via email.

Invoice types.png

Invoices list

Main invoices page is available in SETTINGS –> Accounting –> Invoices. Invoices can be viewed, generated, recalculated, sent over email and exported to different formats (CSV, XLSX, PDF). In the main window, you can see list of all Invoices:

Invoice list small.png

The icons Icon check.png and Icon cross.png show whether this invoice is Paid or Unpaid, Sent or Not Sent, Hidden or Not Hidden. If invoice is Hidden, it will not be shown for User.
The icon Icon money delete.png deletes the invoice and associated Payments.
NOTE Each Invoice generated in particular Time Zone and on particular Currency. That means that in each line of Invoice Price and Price with TAX will be shown in currency which is written in Currency column. The Currency column tells which currency Invoice was generated with. Also the exchange rate at the invoice generation moment is saved in the database so it may differ from the up to date exchange rate.
Total Price and Price with TAX are calculated into viewing Currency, which you can choose in upper corner of page. In Total price calculation there are used saved exchange Rate of each Invoice.

Example

Default system Currency is USD
Invoice A is generated on price = 100 in currency EUR with exchange rate 0.5
Invoice B is generated on price = 100 in currency DZD with exchange rate 0.25
Invoice C is generated on price = 100 in currency ALL with exchange rate 0.75

But now exchange rate are different: EUR - 0.75, DZD - 0.5 and ALL - 1.0.

If you want to see Total price(sum of these 3 Invoices) in EUR. For Invoice B and C will be set exchange rate of today, but for Invoice A exchange rate will be from that day when Invoice was generated (0.5).

Same calculations with other currencies:
If you want to see Total price in USD. For Invoice A, B and C the exchange rates will be set from the day when invoice was generated (EUR - 0.5, DZD - 0.25 and ALL - 0.75).
If you want to see Total price in DZD. For Invoice A and C will be set exchange rate of today, but for Invoice B exchange rate will be from the day when Invoice was generated (0.25).
If you want to see Total price in ALL. For Invoice A and B will be set exchange rate of today, but for Invoice C exchange rate will be from the day when Invoice was generated (0.75).

Total price will be 733.3333 USD, or 500 EUR, or 266.6667 DZD, or 700 ALL


Invoice details

Click on the Icon details.png icon to get details of the Invoice:

Invoice details x6.png

Invoice details are shown in Currency which was used to generate Invoice.

General Details

Payment date - An option which will set the period of payment on current month. By default Years and Month is current, it is only possible to change Day of Month which is indicating the last date of Invoice issue.
Currecy of Invoice - Invoices are exported in Invoice currency.

Language of Invoice
Default language in MOR is English. However, you can send invoices in different languages (click on the flag icon on the top of the page).

User Details

User Details which will be used in xlsx file of invoice. These Details are taken form User Details and it can be changed manually, but after recalculate it will be reset to same information as it is in User Details.

Files to send or download

Here you can view the details of all invoices and click on the Icon pdf.png or Icon csv.png icons to generate invoice files in PDF or CSV formats accordingly. First icon Icon csv.png will download a xlsx file.

  • Invoice XLSX XLSX file shows information which are set by you. Check XLSX Invoice. Clicking on PDF icon will convert XLSX file to PDF format.
  • Simplified Invoice PDF shows separate services Prices and Total Invoice Prices, CSV shows just Total Invoice Prices.
  • Detailed Invoice shows same information like simple Invoice and includes Calls list grouped by Destination.
  • Invoice by CallerID shows Calls list grouped by CallerID.
  • Invoice Destinations shows Calls list grouped by Destination.

You can manage what kind of Invoice should be showed for User and/or sent to User as email attachment in User Details. Here you can check Show zero Calls option if you need to calculate 0 price Calls into Invoices.

XLSX Invoices

XLSX file to export an Invoice is made from your own XLSX format template and information from Invoices main window. Example of template can be downloaded here.

Example of XLSX Invoice can be downloaded here.

Default XLSX template

This is XLSX file used as template which MOR uses as base and fills up with billing information. You can fill template with information of company, draw tables with column names, describe information taken from Invoice main window and so on. When creating template, reserve only one line for Prefixes/Destinations list. MOR will automatically add as many lines as needed. Do not draw borders within this line. Instead, draw a border on Cells above and below this line. Template have to be uploaded in SETTINGS -> Setup -> Settings, Invoices - XLSX tab setting XSLX Template

  • Check New XLSX template apply for old Invoices if you want to change XLSX template for Invoices which is already generated.
  • Check Group regular Calls by Destinations if you want XLSX file use as detailed Invoice.


Converting to PDF format

It is possible to convert XLSX invoice to PDF format using the following methods:



Balance Line settings

Outstanding balance (Debt), Outstanding balance (Debt) with TAX, Total amount due options are present when Show balance line (SETTINGS -> Setup -> Settings, Invoices - Postpaid - Settings) setting is enabled.

Configuration for Dynamic information

When you already have a template for example with all data of your company, with drawn tables and so on, you need to define where should be shown the dynamic information of invoice. How and what information is displayed can be set same SETTINGS -> Setup -> Settings, Invoices - XLSX tab. Just need to define cell address in correct format: Group regular Calls by Destination: Send XLSX Invoices converted to PDF. Possible Addresses of Cells:

Number of Invoice:

  • Issue Date
  • Period Start Date
  • Period End Date
  • Time Zone
  • User full Name
  • User Address
  • User City
  • User Postcode/ZIP
  • User State
  • User Country
  • User Phone
  • TAX Registration Number of the User
  • Number for numeration of Services
  • Destination Prefix
  • Service Name
  • Rate of particular Destination
  • Units amount to Service
  • Duration to particular Destination
  • Price of particular Service
  • Total Price of Invoice
  • Tax amount
  • Total Price of Invoice with applied TAX
  • Comment
  • Company/Personal ID
  • Agreement number
  • Service Discount
  • Service SUM
  • Total Discount of Invoice
  • Total Discount of Invoice with applied TAX
  • Total SUM of Invoice
  • Total SUM of Invoice with applied TAX

For example "A2", "B15", "AA9"

Callc.png

So you should enter number of cells as in example below:

XLSX invoice cells.png

NOTE: If you do not want to use particular dynamic value just leave empty input for it.

Client Address Cell is different than other ones - once you will define this, all other Address Related Cells will be filled automatically and will not be editable. Also, no empty space will be left if any Address sub-cell is not defined. For example, if Client State is not defined in User's Settings, then this Cell will not be empty in Invoice - all Address Cells bellow will go up by one Cell. This allows nice Address formatting without leaving spaces if some Address data is not defined in User's settings.

Custom XLSX template For Users

By default, a global (default) template is used for all users. It is possible to enable specific templates for different users. This can be done by clicking on Excel Icon in the User's edit window.

Mor users settings custom invoice.png

After clicking on this icon, a new window will appear (similar to the Global XLSX template), where you can upload and enable/disable the custom template and adjust cell values.

Mor users custom invoice values.png

PDF invoices

The layout of PDF invoices is not customizable.

Logos are not supported in PDF invoices.

You can print your invoices on paper with a pre-printed logo if you want to send paper invoices.

Example of PDF invoice can be downloaded by clicking here and for detailed invoice click here.

CSV invoices

Detailed CSV invoice does not include list of all calls. Please use CDR export if you need list of calls in CSV format.

Comment


Sometimes it is useful to add a comment to the invoice. It can be used in xlsx file also.

Invoice Details

Click on the Invoice Details icon in the Invoice details page

Service details.png

to get Services Details of the Invoice:

Invoice services x6.png

Services:

  • DID Owner Cost – price for having and using own DID(s)
  • Subscriptions – price of subscription applied to selected period. Period considered as month is from first till last day of month and from concrete day of month till next month one day before selected last month. Eg. from 2013-02-26 till 2013-03-25
  • Calls – quantity and price of outgoing calls
  • Calls from Users – quantity and price of resellers users calls
  • Calls to DIDs – price for calling to DID(s)



Invoice generation

In the main Invoices window, click Icon generate invoices.png Generate Invoices to generate additional invoices:

Generate invoices x6.png

Select for which users to generate invoices. Prepaid and Postpaid users can have separate details. Also, you can check to generate an invoice for only one particular user. Invoice will be generated if selected User existed at least one day of all Invoice period. When Invoice Generation Task is created, admin can check the progress in Background Tasks.

NOTE: If Currency of User is different than default System Currency. All his Invoices will be generated with Currency Exchange Rate of current day.
NOTE: When generating invoice, current user details will be used.


Invoice cannot be generated error

Invoices will be generated only if Elasticsearch data is up to date and consistent with MySQL data. This is usually seen in MOR main page ES Sync Status:


ES SYNC 100%.png

If there are data inconsistencies between Elasticsearch and MySQL, you will see a notification Invoice cannot be generated due to data inconsistencies, please contact support and Invoice will not be generated. This is done to prevent generating incorrect Invoices. Please contact support if you get this message or you may solve it manually by following this guide.

Invoice recalculation

An invoice cannot be modified after being sent. But if you want to allow recalculations after sending invoices, go to: Settings -> Setup -> Settings. Then click on the tabs: Invoices -> Functionality. Select Invoice allow recalculate after send:

Ivoicesnewnew.png

Recalculate a group of Invoices

To recalculate invoices in the main Invoices window click Icon generate invoices.png Recalculate invoices:

Recalc.png

Select which type of Invoices or whose Invoices to recalculate.

Recalculate a single Invoice

If an invoice is not marked as paid - it can be recalculated for the same user, same period. To achieve this - press the marked icon:

Recalculate single invoice x6.png

Pay unpaid Invoices

In list of Invoices click Icon edit.pngBulk management and button Pay unpaid Invoices will appear.

Pay unpaid invocies.png

Click Pay unpaid Invoices and All unpaid Invoices will be marked as paid. For each marked Invoice Payment will be created.


Delete all Invoices

This applies to MOR versions from MOR X18

In list of Invoices click Icon edit.pngBulk management and button Delete all invoices will appear.

Delete all invoices x18.png

Click Delete all invoices and all listed Invoices in all pages will be deleted (with respect to search filter).

Note: Deleting invoices will not remove associated Payments, so the current user balance will not be affected.
To delete invoices and associated payments, you need to press the delete the invoice and associated Payments icon Icon money delete.png.

Note: Invoices, which were already sent, are possible to delete only with option enabled in: Invoices->Functionality-> Invoice allow recalculate after send.


This applies to MOR versions until MOR X18

In list of Invoices click Icon edit.pngBulk management and button Delete all invoices will appear.

Delete all invoices.png

Click Delete all invoices and all listed Invoices in all pages will be deleted (with respect to search filter).

Note: Invoices, which were already sent, are possible to delete only with option enabled in: Invoices->Functionality-> Invoice allow recalculate after send.

Note: Deleting invoices will remove associated Payments, so the current user balance will be affected.

Hide/Unhide all invoices

In list of Invoices click Icon edit.pngBulk management and button Hide all invoices will appear.

Hide invoices.png

Click Hide all Invoices or Unhide all Invoices and all listed Invoices in all pages will be Hidden/Unhidden (with respect to search filter).

Note: Invoices will be hidden for users only. Admin will still see invoices in the list.

Send invoices by email (manual)

Click Send Invoices over Email to Users to send invoices to their Users in this period:

Invoce email.png

You can use these settings to choose which users should get an email with the invoice. Using these settings you can send emails in parts.

  • Email sending option must be enabled in Email Settings to use this feature
  • Tip: you can send invoices in parts by using text fields to send invoices for users which Username, First name, Last name or Number begins with some letters. For example: you have users with usernames john, albert and alex. You want to send invoices only for users whose usernames begins with "a" so you just have to enter "a" in a Username text field to send invoices only to albert and alex.




Generate and send invoices by email (automatically)

Use Cron Actions to Generate and send Emails automatically.



Export Invoices

In Invoices list window it is possible to export all matching Invoices to different formats. Available options are:

  • Export to CSV - Exports information (Invoice number, Username, Accounting Number, Export to CSV and other) about invoices to CSV file
  • Export all to XLSX - Generates all matching Invoices' XLSX files and provides them in a single ZIP archive file.
  • Export all to PDF - Generates all matching Invoices' PDF files (converted from XLSX files) and provides them in a single ZIP archive file.



See also