How to Import Vendor Bills in Odoo 19: Complete Step by Step Guide
By Braincuber Team
Published on May 26, 2026
Importing Vendor Bills in Odoo 19 is essential for improving accounting efficiency and reducing manual data entry errors. The import feature allows businesses to upload multiple supplier invoices using structured files, saving time when handling large transaction volumes. It ensures accurate recording of vendor references, taxes, payment terms, and bill dates while maintaining consistency across accounting records. By importing Vendor Bills, organizations can streamline accounts payable processes, enhance financial accuracy, support faster reconciliation, and improve overall workflow management within the Accounting module. This complete step by step guide will walk you through the entire process from template creation to successful import.
What You'll Learn:
- What vendor bills are and why importing them improves efficiency
- How to export a structured import template from an existing bill
- How to select the right fields for your vendor bill template
- How to prepare your data in CSV or Excel format
- How to upload, map, and validate imported data in Odoo
- How to review and post imported bills created in draft state
Understanding Vendor Bills in Odoo 19
In Odoo 19, a Vendor Bill is used to record supplier invoices and manage payable transactions within the Accounting module. It helps businesses validate purchase costs, track outstanding amounts, and automate bill processing through vendor references, payment terms, and journal entries. Users can link bills to purchase orders, apply taxes, reconcile payments, and monitor due dates using smart accounting features, ensuring accurate financial reporting and streamlined vendor management.
Bulk Processing
Upload multiple supplier invoices simultaneously using structured CSV or Excel files, saving significant time when handling large transaction volumes.
Structured Templates
Export a ready-made template with all mapped accounting fields, partner information, taxes, and invoice lines. Reuse the same template format for consistent data entry.
Validation Before Import
The Test feature validates imported data and detects mapping errors before creating records. Ensures partner references, product data, and tax configurations are correct.
Draft Review Safety
Imported bills are created in draft state by default, allowing you to review all data before posting the accounting entry, preventing incorrect journal postings.
Step 1: Export an Import Template
The first step is to generate a structured import template by exporting an existing vendor bill. This template will contain all the mapped accounting fields that Odoo uses for import.
Access the Vendor Bills List
Go to the Accounting module and navigate to Vendor > Bills. Select an existing bill record or generate one for template creation purposes.
Use the Export Feature
Select the required bill record, then click the Action menu and choose Export. Odoo will generate a structured spreadsheet template containing all mapped accounting fields, journal details, partner information, taxes, payment terms, and invoice lines.
Choose Export Fields
Select the fields you need in the template. After removing the sample transaction data while retaining the field structure, the same file can be reused to import multiple vendor bills efficiently.
Step 2: Select the Required Fields
For importing a vendor bill, select the following fields from the export dialog. You can also save the list of selected fields as a template for future importing purposes.
| Field | Description |
|---|---|
| Number | Unique reference number assigned to the vendor bill |
| Partner | Vendor partner who maintains a business relationship with the company |
| Invoice/Bill Date | Date on which the vendor bill is generated or recorded |
| Journal | Accounting journal where the bill will be recorded |
| Payment Terms | Due date rules, payment schedule, and settlement conditions |
| Invoice line/Product | Individual products, services, or expense items in each invoice line |
| Invoice line/Quantity | Quantity of each product or service in the invoice line |
| Invoice line/Unit Price | Cost assigned to each quantity of the product or service |
| Invoice line/Unit | Unit of Measure defining the standard measurement |
| Invoice line/Taxes | Tax configurations assigned to each product or service line |
| Invoice line/Accounts | Ledger account used to record each invoice line transaction |
| Incoterm | Buyer and vendor responsibilities, shipping obligations, and delivery conditions |
| Currency | Transaction currency used for recording the vendor bill |
After selecting the fields, click the Export button to download the template. You can also save your field selection as a reusable template for future imports.
Save Template for Reuse
You can save your selected field list as a named template. This allows you to reuse the same field configuration for future import operations without re-selecting fields each time.
Step 3: Prepare Your Data
Open the exported file in Excel, Google Sheets, or any spreadsheet application. The template contains the column headers that Odoo expects. Remove any sample data that was exported while keeping the field structure intact.
Open the Exported File
Open the exported CSV or Excel file. The first row contains the column headers mapped to Odoo fields. Remove the sample transaction data row while keeping the headers.
Add Your Vendor Bill Data
Enter your vendor bill records row by row. Ensure each column contains the correct data type — dates, numbers, text, and references as expected by Odoo. Include the bill number, partner name, invoice date, products, quantities, unit prices, taxes, and accounts.
Save the File
Save the file in CSV or Excel (XLSX) format. Ensure the column structure matches the original exported template to avoid mapping errors during import.
Step 4: Import the File into Odoo
Once your data file is ready, navigate back to Odoo to perform the import.
Open the Import Dialog
Go to the list of vendor bills. Click the Action button and select the Import option from the dropdown menu.
Upload Your Data File
Click the Upload Data File option and select your prepared CSV or Excel file. Alternatively, you can use the Import Template for Bills option to download a blank template if you need to start from scratch.
Map Fields Automatically
Odoo automatically maps the uploaded file columns to the corresponding accounting fields such as vendor, journal, invoice date, products, quantity, and unit price. Review the mapping to ensure correctness.
CSV Column -> Odoo Field
------------------------------+------------------------------
Number -> Bill Reference Number
Partner -> Vendor (res.partner)
Invoice/Bill Date -> Bill Date
Journal -> Accounting Journal
Payment Terms -> Payment Terms
Invoice line/Product -> Product (product.product)
Invoice line/Quantity -> Quantity
Invoice line/Unit Price -> Unit Price
Invoice line/Unit -> Unit of Measure
Invoice line/Taxes -> Tax Configuration
Invoice line/Accounts -> Ledger Account
Incoterm -> Incoterm
Currency -> Transaction Currency
Step 5: Validate and Import
Before creating the bills, Odoo provides a validation step to ensure data accuracy.
Click the Test Button
The Test option validates the imported data and detects mapping errors before import. Odoo checks field mappings, partner existence, product references, tax configurations, and account validity.
Review Validation Results
If the validation passes, you will see the message "If everything seems valid". If there are errors, Odoo will highlight the problematic rows and fields for correction.
Click Import
After successful validation, click the Import button. Odoo automatically creates vendor bills with related accounting entries, invoice lines, taxes, and payment terms.
Understanding the Draft State
The imported bill will be in the draft state. Odoo creates imported accounting documents as unposted records by default. This behavior is designed to allow users to review imported data — such as vendor details, invoice lines, taxes, journals, accounts, and totals — before validating the accounting entry. Keeping the bill in draft helps prevent incorrect journal postings and ensures accounting accuracy.
When you open the imported bill, verify these fields:
Bill Number - Check the unique reference
Vendor Partner - Confirm supplier name
Invoice Lines - Products, quantities, unit prices
Taxes - Tax configurations applied correctly
Accounts - Ledger accounts in each line
Currency - Transaction currency
Total - Verify the calculated total
Always Review Draft Bills
Imported bills remain in draft for a reason. Always review the imported data — vendor details, invoice lines, taxes, and totals — before validating. This prevents incorrect journal postings and ensures accounting accuracy.
Frequently Asked Questions
What file formats are supported for importing vendor bills in Odoo 19?
Odoo 19 supports CSV and Excel (XLSX) file formats for importing vendor bills. The import feature automatically detects the file format and maps columns to the corresponding Odoo accounting fields.
Why are imported vendor bills created in draft state?
Odoo creates imported bills as draft (unposted) records by default to allow users to review the data — vendor details, invoice lines, taxes, journals, and totals — before validating the accounting entry. This prevents incorrect journal postings.
Can I reuse the same import template for future vendor bill imports?
Yes, after selecting the required fields for export, you can save the field list as a template for future imports. This allows you to maintain consistent field mappings across multiple import operations.
What fields are required when importing a vendor bill in Odoo 19?
Key fields include Number, Partner, Invoice/Bill Date, Journal, Payment Terms, Invoice line/Product, Invoice line/Quantity, Invoice line/Unit Price, Invoice line/Unit, Invoice line/Taxes, Invoice line/Accounts, Incoterm, and Currency.
How does Odoo validate imported vendor bill data?
The Test option validates the imported data and detects mapping errors before importing. It checks field mappings, partner existence, product references, tax configurations, and account validity. Only after successful validation can you proceed with the import.
Need Help with Odoo Accounting?
Our Odoo accounting experts can help you configure vendor bill imports, set up import templates, and streamline your accounts payable processes.