Skip to Content

Journal Entry Import from Excel

by

6.74

15.0 0
Live Preview
Required Apps Invoicing (account)
Discuss (mail)
Technical Name odoo_journal_entry_import
License OPL-1
Also available in version 17.0 16.0 15.0
You bought this module and need support ? Click here!
Technical Name odoo_journal_entry_import
License OPL-1
Also available in version v 17.0 v 16.0 v 15.0

Introduction

The Journal Entry Import module for Odoo streamlines the accounting process by enabling users to import journal entry items directly from Excel files. This feature reduces manual work, minimizes human errors, and ensures accurate financial data. With template-driven import functionality, businesses can efficiently manage large volumes of journal entries in Odoo.

Key Features

  • Import journal entry items seamlessly from Excel files into Odoo.

  • Includes sample Excel templates for quick and easy setup.

  • Supports importing key fields such as account code, partner, label, currency amount, debit, credit, due date, reference, and date.

  • Requires the xlrd Python library to process Excel file data.

Benefits

  • Save time by importing bulk journal entries instead of manual input.

  • Improve accuracy and consistency of financial records.

  • Reduce errors in accounting workflows with structured import.

  • Enhance productivity and streamline data management in Odoo.

Compatibility & Technical Details

  • Technical Name: odoo_journal_entry_import

  • Required Modules: Invoicing (account), Discuss (mail)

  • License: LGPL-3

  • Installation Steps: Copy the module into your Odoo addons directory, update the app list, and install it via the Odoo Apps interface.

Journal Entry Items Import from Excel

Import Journal Entry / Items Odoo Module

This app allows your accounting team to import journal items from excel files.

Main Features:

  • Allow you to import journal items from excel file into Odoo.
  • Excel samples are available inside the module.
  • Make sure you have xlrd Python module installed. https://pypi.python.org/pypi/xlrd
  • For more details please see video and below screenshots.

Following fields can be import:

  • ACCOUNT CODE
  • PARTNER
  • LABEL
  • AMOUNT CURRENCY
  • CURRENCY
  • DEBIT
  • CREDIT
  • DUE DATE
  • REFERENCE
  • DATE

Edition Compatibility:


Enterprise Odoo.sh Community

Bank Journal Item Details

Button to Import Journal Items

Wizard to Select Excel

Imported Journal Items(Bank)

Sample Bank Excel File (Also available inside Module/Sample Folder)

Cash Journal Item Details

Button to Import Journal Items

Button to Import Journal Items

Button to Import Journal Items(Cash)

Sample Cash Excel File (Also available inside Module/Sample Folder)

Product Sales Journal Item Details

Button to Import Journal Items

Button to Import Journal Items

Button to Import Journal Items(Cash)

Sample Product Sales Excel File (Also available inside Module/Sample Folder)

Contact / Support
Introducing Probuse Consulting Services Pvt. Ltd.

If you need any help or want more additional features, you may contact us through:
Email: [email protected]
Website: www.probuse.com
Skype: mustufa_probuse

Probuse Consulting Service Pvt Ltd is an Software and Web development specialist which offers complete business application together. We are well experienced to provide a face for your business on the software and Internet level.

Probuse Consulting Service Pvt Ltd is a specialist in Odoo/OpenERP services and could give your business open source hand to drive.

Our Services

  • Odoo Implementation

  • Odoo Support

  • Odoo Customization

  • Odoo Migration

  • Odoo Training

Odoo Proprietary License v1.0
This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.