FAQ/Invoicing

From ISP admin

< FAQ
Jump to: navigation, search

Contents

FAQ - Invoicing

General


Routers & MikroTik

Invoicing

Unclassified


Tips

FAQ - Invoicing

Client scoring

This entry can be found in the client card in the section for invoicing data. These are numeric expressions of payment morals of a specific client. The value is expressed by the sum of positive days if the client pays before the due date and by the sum of negative days if the client pays after the due date.

According to this figure, you can take a certain approach for solving problems towards every client, or also to assess the priority or the time delay between reporting and the service intervention. The client who pays in time may be prefered before bad payers, which may bring the certain motivational effect for timely payments.

The initial financial state

If you switch from the old system to the ISP admin and a client has some over- or underpayment, file it here. Then in the bookmark of Invoicing / Initial state where the initial state shows as over- or underpayment from the previous period; save the record and the initial states will be reseted. By doing this they will be added to the invoicing and you will not have to take care of the financial balance from the previous system any more. Thus all the clients` initital states will be enlist into the system.

Instead of the year, "initial state" headline will appear in an imaginary invoice in the client card.

The intitial state invoices were saved into the system.

An overview of issued invoices

You can create an overview of issued invoices within the system; the overview may be enclosed as a paper record into the bookkeeping.

A change in a paid invoice

Sent or even paid invoices cannot be additionally edited. It would mean a change in bookkeeping which is not rather appropriate.

Setting a logo or a stamp on the invoice

Logo or invoice stamp shielding

If we need remove the logo or the stamp from the invoice created due to any reason, you may do so in the bookmark of Invoicing / Settings / Invoicing groups. The button will get you to the settings edits of the invoicing group. You will enter "0" value into the boxes of width and boundary, those marked (mm). By doing this, you will remove displaying the logo or the stamp on the next issued invoice. The already issued invoices may be edited only manually by an intervention into the system. These edits, however, do not concern the already sent invoices.

How to copy the login data into the user interface directly on the invoice

For this purpose you can use "appendix" which copies onto every invoice. In the settings of Invoicing / Settings / Invoicing group in the lower part of the field for the "Appendix" where you will enter these two variables: $USERNAME$ and $PASSWORD$.

The text given in the appendix may look for example like this:

All issued invoices may be viewed also in the electronic form in the user interface, the access information is:
User name: $USERNAME$
Password: $PASSWORD$

Automatic service suspension

The function of automatic service suspension serves for temporary blocking of the service without any physical intervention into the installation or manual editing of the configuration of the router. Suspending of the service may be useful especially to automatic suspension of bad payers in relation to invoicing module. To a suspended client defined info page, which was preset by you, appears while they are attempting to show a web page. This is also often used for temporary "cutting off" of the customer whose computer has a virus until there is an amendment. Your defined info page may appear to them again.

Even when a client is suspended, the invoicing is still in operation in the way like he was still connected. It is a kind of penalisation for breaching the payment morals towards the service provider, or breaching the contract terms. It is, however, suitable to have these dealt with in the contract ( not paying invoices in time, exceeding of the due payment, sending spam, breaching the copyright, etc... ).


Service suspension may thus be applied in four ways


There has been an article created for this topic: Client suspension (Internet service).

Clients send payments for the service to another account number

If your client pays for the invoice to another account number and you do not upload the statements into the ISP admin to be able to match them. Thus you have the possibility to pay for the settlements in the bookmark of Invoicing / Settlements where you pay for the settlement like you were matching the payment which has been marked as unmatched.

CSV export - usage example

The universal CSV text format designated for the exchange of the table data. The file in the CSV format is comprised of lines in which the individual items are separated by a semi-colon ";". Thanks to the simplicity and readability of the information even without a specialized software, this format is used for the exchange among various systems.

Such exported data may be easily used as a sourse for other accounting systems or be easily imported into an arbitrary table processor and be furtherly worked on .


Display of the CSV file as clear text data:


Import of the CSV file into a table processor ( MS Excel, OpenOffice Calc ):


The structure of an exported CSV file:

The file comprises of lines which represent individual invoices and values separated by semi-colons, which are the items of the invoice.


The first seve fields are always the values relating to an issued invoice:

Field 1 - SS (specific symbol)
Field 2 - VS (variable symbol)
Field 3 - Date of issuance
Field 4 - Due date
Field 5 - Payment day
Field 6 - Rounding
Field 7 - Price with VAT 

Then there are four fields which describe one invoice item. These repeat according to the number of items on the invoice:

Field 8 - Service type
Field 9 - Description
Field 10 - Price without VAT
Field 11 - VAT tax


Example of the data

SS;VS;Date of issuance;Due date;Payment day;Rounding;Price with VAT;Service type; Description; Price without VAT;VAT tax;
56159;11252;1.7.2010;21.7.2010;1.7.2010;0.00;100,00;7;Služba ii za období  07/10 ;84.03;15.97;
56159;11253;1.7.2010;21.7.2010;1.7.2010;0.00;595,00;6;Hosting;500.00;95.00;
20011111001;11249;1.7.2010;21.7.2010;1.7.2010;0.06;14,00;1;Internet BASIC in the period  07/10 ;11.71;2.23;
090124;11244;1.7.2010;21.7.2010;1.7.2010;0.00;660,00;2;Cable TV TAR1 in the period  07-09/10 ;554.62;105.38;
1420;11236;1.7.2010;21.7.2010;1.7.2010;-0.26;2 154,00;1;Internet in the period 07/10 ;27.88;5.30;1;Internet in the period 07/10;4.18;0.80;1;    
Internet 10Mb in the period 07/10 ;390.00;74.10;3;DVBC - Porn package;242.86;46.14;3;DVBC– HBO package;209.24;39.76;3;DVBC-Cable TV 
aio in the period 07/10 ;923.53;175.47;99;Sending of the invoice by mail;12.61;2.39;


Example usage of the CSV file:

Setting a discount for the Internet service

Export of the invoices into the accounting program

An individual invoice issuing

Edit an issued invoice

Submitting a cash payment

VAT not stated on the cash receipt

If the client pays for the invoice in cash, the VAT tax is not stated on the cash receipt. The VAT is not given for a simple reason - the tax is stated right on on the issued invoice. If the VAT were stated also on the cash receipt, the customer might happen to enter it among their expenses and this would be incorrect.

The invoice preview cannot be opened


This situtation happens only when using Internet Explorer web browser. This browser does not use standard ways of verifying the security certificates. That is why the identity of the ISP admin server cannot be verified and thus the download of the required pdf file will not be permitted.

We strongly recommend to use Firefox web browser for which the ISP admin system is optimised.