Invoices

From Kolmisoft Wiki

(Difference between revisions)
Jump to: navigation, search
(XLSX Invoices)
(XLSX Invoices)
(44 intermediate revisions not shown)
Line 11: Line 11:
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.  
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:Invoices_types.png]]
+
[[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:
+
Invoices can be viewed, generated, recalculated, sent, also <!---...from MOR 9---> list of Invoices can be exported to CSV file (Invoice number and TAX Registration Number are included in the output CSV file) in '''SETTINGS –> Accounting –> Invoices'''. 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.  
<br>
<br>
-
'''NOTE''' Each Invoice generated in particular Time Zone and on particular Currency. In different currency you are able to check just total value of all selected Invoices.
+
'''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>
Line 29: Line 50:
<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==
Line 48: Line 71:
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''' xlsx file shows information which are set by you. Check [[Invoices_(MOR_X6)#XLSX_Invoices | XLSX Invoice]]
+
*'''Invoice XLSX''' xlsx file shows information which are set by you. Check [[Invoices#XLSX_Invoices | XLSX Invoice]]
-
*'''Invoice detailed''' PDF shows same information like simple invoice and includes calls list.
+
*'''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.
+
*'''Invoice detailed''' 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 File:x6invoicetmpl.xlsx
+
Example of template can be downloaded [http://www.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'''
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'''
-
<br><br>
+
* Check '''New XLSX template apply for old Invoices''' if you want to change XLSX template for Invoices which is already generated.
-
[[Image:invoice_xlsx_settings_x6.png]]
+
* Check '''Group regular Calls by Destinations''' if you want XLSX file use as detailed Invoice.
-
<br><br>
+
<br>
'''Balance Line settings'''
'''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.
''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>
'''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.
-
 
+
<br><br>
 +
[[File:Setttings xlsx.png]]
 +
<br><br>
For example "A2", "B15", "AA9"
For example "A2", "B15", "AA9"
<br><br>
<br><br>
[[File:callc.png]]
[[File:callc.png]]
<br><br>
<br><br>
 +
 +
'''NOTE''': If you do not want to use particular dynamic value just leave empty input for it.
=== PDF invoices ===
=== PDF invoices ===
Line 85: Line 116:
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 ===
Line 143: Line 177:
Select which type of Invoices or whose Invoices to recalculate.
Select which type of Invoices or whose Invoices to recalculate.
<br><br>
<br><br>
-
 
=== Recalculate a single Invoice ===
=== Recalculate a single Invoice ===
Line 150: Line 183:
[[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>
<br><br>
-
[[Image:invoices_send_x6.png]]
+
[[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 =
 +
 
 +
In list of Invoices click [[Image:icon_edit.png]]'''Bulk management''' and button '''Delete all invoices''' will appear.
 +
<br><br>
 +
[[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.
 +
<br><br>
 +
 
 +
= 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 160: Line 215:
* '''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 all to XLSX =
 +
 +
In Invoices list you can click on '''Export all to XLSX''' link to download all Invoices' XLSX files in a single ZIP. It includes all Invoices matching your search.
 +
 +
<br><br>
 +
=See also=
=See also=
Line 170: Line 240:
* [[MOR API invoices_get]]
* [[MOR API invoices_get]]
* [[Cannot generate Invoice]]
* [[Cannot generate Invoice]]
 +
* [[Duplicate value in Cell Address field]]

Revision as of 13:48, 1 August 2017

Contents

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.

File:Invoice types.png

Invoices list

Invoices can be viewed, generated, recalculated, sent, also list of Invoices can be exported to CSV file (Invoice number and TAX Registration Number are included in the output CSV file) in SETTINGS –> Accounting –> Invoices. In the main window, you can see list of all Invoices:

Image:Invoice list small.png

The icons Image:icon_check.png and Image:icon_cross.png show whether this invoice is Paid or Unpaid, Sent or Not Sent.
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 Image:icon_details.png icon to get details of the Invoice:

Image: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 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 XLSX xlsx file shows information which are set by you. Check XLSX Invoice
  • Invoice PDF shows separate services Prices and Total Invoice Prices, CSV shows just Total Invoice Prices.
  • Invoice detailed 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

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

  • 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.


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.

File:Setttings xlsx.png

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

File:callc.png

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

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

Image:Service_details.png

to get Services Details of the Invoice:

Image:invoice_services_x6.png

Services:

  • 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)
  • 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 Image:icon_generate_invoices.png Generate Invoices to generate additional invoices:

Image: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: For Prepaid User after every executed Manual Payment will be generated Invoice automatically.
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 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:

Image:ivoicesnewnew.png

Recalculate a group of Invoices

To recalculate invoices in the main Invoices window click Image:icon_generate_invoices.png Recalculate invoices:

Image: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:

File:Recalculate_single_invoice_x6.png

Pay unpaid Invoices

In list of Invoices click Image:icon_edit.pngBulk management and button Pay unpaid Invoices will appear.

File: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

In list of Invoices click Image:icon_edit.pngBulk management and button Delete all invoices will appear.

File: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.

Send invoices by email (manual)

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

Image: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 all to XLSX

In Invoices list you can click on Export all to XLSX link to download all Invoices' XLSX files in a single ZIP. It includes all Invoices matching your search.



See also

Personal tools

Try MOR

Try M2