Module Import Bank statement, generation, payment and reconcile

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search


Informations

Module name Import Bank statement, generation, payment and reconcile
Editor / Editeur Florian DUFOURG - demo
Download or buy page / Page achat ou téléchargement www.dolistore.com
Status / Statut / Estado Stable
Prerequisites / Prérequis Dolibarr min version 10.0.0   
Last update date / Date mise à jour fiche / Fecha última actualización 2019-11-3
Note / Nota

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

  • Download archive file of module (.zip file) from web site www.dolistore.com or from any other source.
  • Install module into the custom folder of Dolibarr:
    • Go to Home - Setup - Modules - Deploy/install external app/module
    • Upload the file. Note: If it fails, you can manually unzip the file into the custom directory from command line: Go into the *custom* directory and uncompress file with command unzip modulefile.zip
  • Module is ready to be activated and used.

Setup

To use this module, you must first enable it using an administrator account, via the menu option "Home - Setup - Modules".

Choose the tab where the module is listed. Then click on "Activate".

The module is now activated.

If an icon appears at end of the line for the module, click on it to access the setup page specific to the module.

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.

CaptureImportBankFromCsv3.PNG

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.

CaptureImportBankFromCsv1.PNG

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

CaptureImportBankFromCsv2.PNG


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.