Our Most Suggested Products
Import Invoices Through Excel
Import Invoices Through Excel is an Odoo productivity module designed to simplify invoice creation and accounting data entry by enabling bulk import of invoice records directly from Excel or CSV files. It supports customer invoices, vendor bills, credit notes, and debit notes, helping businesses reduce manual effort, minimize entry errors, and accelerate financial operations.
Features
Bulk Import of Multiple Invoice Types
The module allows users to import multiple accounting document types through a single structured Excel process, including customer invoices, vendor bills, credit notes, and debit notes. This flexibility makes it suitable for businesses handling large transaction volumes across sales and purchasing operations.
Flexible Product Identification During Import
Invoice lines can be matched using different product references such as product name, internal product code, or barcode, making the import process adaptable to different business data formats.
Missing Product Detection and Import Validation
When invoice data contains products that do not exist in Odoo, the module helps identify those missing entries during import. This prevents incomplete accounting records and allows users to correct product data before final posting.
Screenshot
1.) Import Invoices by Product Name
Invoice data can be uploaded by matching products using their names, making spreadsheet preparation simple for users who already maintain product labels in their accounting files.
2.) Import Invoices by Product Code
Using internal product codes allows highly accurate invoice line matching during import. It supports businesses that manage inventory and accounting records through SKU-based product identification.
3.) Import Invoices by Product Barcode
Barcode-based import provides an efficient way to process invoices when products are identified through barcode systems. It helps maintain consistency in environments where barcode references are part of daily operations.
4.) Import Invoices Menu
The invoice import option is available inside the reporting section of the invoicing module, allowing accounting users to access the feature directly within their regular workflow.
Navigation : Invoices â Reporting
5.) Wizard for Importing Customer Invoices
A dedicated import wizard guides users through file selection, import configuration, and execution. It simplifies bulk invoice creation while reducing the possibility of formatting mistakes.
6.) Customer Invoice Import Through Excel File
Customer invoices can be generated in bulk from Excel files, helping finance teams process multiple records quickly without manual entry.
7.) Missing Products in Customer Invoices
When imported invoice lines contain products that are not yet available in Odoo, the system highlights them clearly so corrections can be made before completing the import.
8.) Wizard for Importing Vendor Bills
Vendor bill imports are handled through a structured wizard that helps users upload supplier billing data accurately and efficiently
9.) Vendor Bill Import Through Excel File
Supplier bills can be imported directly from Excel into the bills section, reducing repetitive accounting work for purchase-related transactions.
Navigation : Invoice â Vendors â Bills
10.) Missing Products in Vendor Bills
Missing product references are identified during vendor bill import, helping users maintain clean purchasing records and avoid incomplete entries.
11.) Wizard for Importing Credit Notes
Credit note imports are managed through an easy-to-follow wizard that supports file upload and structured validation before record creation.
12.) Credit Note Import Through Excel File
Bulk credit notes can be added through Excel files, making return adjustments and customer corrections easier to manage.
Navigation : Invoicing â Customers â Credit Notes
13.) Missing Products in Credit Notes
Any unavailable product references are listed before import completion, allowing users to correct product data without affecting accounting accuracy.
14.) Wizard for Importing Debit Notes
The debit note import wizard provides a guided process for uploading refund-related accounting documents.
15.) Debit Note Import Through Excel File
Debit notes can be imported from Excel into vendor refund records, helping businesses process supplier adjustments more efficiently.
Navigation : Invoicing â Vendors â Refunds
16.) Missing Products in Debit Notes
Unavailable product entries are identified during debit note import, ensuring that all records remain complete before validation.
User Guide
Teams
team@inkerp.com
Suggested Products
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 205 |
| Technical Name |
eg_import_invoices_through_excel |
| License | OPL-1 |
| Website | http://www.inkerp.com/ |
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.
Please log in to comment on this module