View source for Module Import Bank statement, generation, payment and reconcile

<!-- BEGIN interlang links -->
<!-- Do NOT edit this section
     Links below are automatically managed by PolyglotBot
     You can edit links on the English source page : Module_importbankfromcsv -->
[[en:Module_Import Bank statement, generation, payment and reconcile]]
[[fr:Module_Import bancaire, génération, paiement et rapprochement]]

<!-- END interlang links -->

[[Category:Complementary modules]]
[[Category:importbankfromcsv]]

{{TemplateDocDevEn}}
{{TemplateDocUser}}

=Informations=
{{TemplateModuleInfo
|modulename=Import Bank statement, generation, payment and reconcile
|editor=Florian DUFOURG
|web=[http://dolitest.vps100069.mylogin.co demo]
|webbuy={{LinkToPluginDownloadDoliStore|keyword=importbankfromcsv}}
|status=stable
|prerequisites=
|minversion=10.0.0
|note=
}}

=Features=
This module allows to save time in Dolibarr thanks to your bank statement csv file. It allows to generate your vendor invoices, taxes, VAT, social charges, payment of loan and payment of invoice bill from a csv bank statement file.
It also mades automatic payment and conciliation of the bank statement.

=Install=
{{InstallModuleDoliStoreEn|keyword=importbankfromcsv}}

=Setup=
{{ActivationModuleEn}}

===Module Configuration===
Configure the module from the module setup page : Make sure to indicate your bank account ID. (to know your bank account ID go to Bank in the menu, select you bank account and read the URL, your bank account ID number is indicated by ?id= )

===Menu===
You can see this module in the left menu of the billing | payment top menu.

===Import a file===
Select a csv file from your bank account and click upload button.
<div class="divforimgcentpercent">
[[File:CaptureImportBankFromCsv3.PNG]]
</div>

===Setting of the lines===
Once your csv file is uploaded, select the category of each column (date of operation, date of value, amount, label, secondary label). You can choose a category only once (except for amount categorie that can be credit and debit). Press the hide column button to make the view easier to read.
<div class="divforimgcentpercent">
[[File:CaptureImportBankFromCsv1.PNG]]
</div>

Choose for each line the categorie of the line (provider invoice, charge, VAT, salary, loan, customer invoice). Let the categorie blank for the line you don't want to import.

Before to import give a name to the bank statement, it will help to reconcile.

===Select the statement===
In the billing | payment menu choose 'List of imported statements' and select the bank statement you want to transform as Dolibarr elements.

===Generate the elements (invoices, taxes, salaries,loan...)===
In the process page you can now check the information and click import to generate the new element (invoice, VAT, salary...).

<div class="divforimgcentpercent">
[[File:CaptureImportBankFromCsv2.PNG]]
</div>

 <br />If you prefer to generate a new file manually (without the help of the module), click the delete button.

 The customer invoices are not generate by this module, we  considere the customer invoices are already made by the user and the user will help to link the invoice to the payment from the bank account.<br />