import vendor bill odoo 18

Question

I have Journal Vouchers from Tally, I want to import them as vendor bills into odoo, but I don't know the exact fields I need, I should include the vat and the cost center as well (Analytic distribution) in addition to the narration.
this is a sample of the journal Voucher I have

Date
Particulars

Vch Type
Vch No.
Debit
Credit

Amount
Amount

1-Apr-25
Piling & Foundation - Contract Cost

Journal
433
52500.00

Al Khan-Shj G+15 Plot No.211

VAT 5 %

2625.00 Dr

New Ref

Rani Tathod · Answer

Importing vendor bills from Tally into Odoo 18 requires a structured approach. Let's map your Tally data to Odoo fields for a smooth import.

*1. Data Preparation:* Create a CSV file from your Tally data. Ensure each column clearly represents an Odoo field. Key fields needed include:

• Date (invoice date)

• Vendor (partner ID or name)

• Invoice Number (Vch No.)

• Total Amount (Debit - VAT amount)

• VAT Amount (separate column)

• Analytic Account (Cost Center ID or name)

• Narration (desc

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

To import the vendor bills, please refer to the following,
*  https://www.youtube.com/watch?v=M1kDi7r-Xd0 [1]
*  https://www.cybrosys.com/blog/how-to-import-customer-invoices-and-vendor-bills-in-odoo-17 [2]

Hope it helps

[1] https://www.youtube.com/watch?v=M1kDi7r-Xd0
[2] https://www.cybrosys.com/blog/how-to-import-customer-invoices-and-vendor-bills-in-odoo-17

İlgili Gönderiler	Cevaplar	Görünümler
Accounting: Register Vendor Bill as paid by owner (Director loan) Çözüldü accounting vendorbill	4 Ağu 24	5262
Errors importing chart accounts in .xls accounting importing	1 Haz 24	1097
Import journal items entry in odoo accounting journal as opening balance from csv file accounting importing journal_entry	2 Şub 24	11679
Accounting Provision entries cannot be passed in Vendor Bill accounting journal_entry vendorbill	0 Ağu 23	8
Unnecessary invoice lines when importing invoices accounting invoice importing v15	1 Oca 25	1924

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!

Date	Particulars	Vch Type	Vch No.	Debit	Credit
				Amount	Amount
1-Apr-25	Piling & Foundation - Contract Cost	Journal	433	52500.00
	Al Khan-Shj G+15 Plot No.211
	VAT 5 %			2625.00 Dr
	New Ref
	STROMEK EMIRATES Foundations L.L.C				55125.00 Cr
	New Ref
	Paym. Application for Sub-contractor No. 1157 For piling Al Khan-Shj G+15 Plot No.211 Works : No.01 Inv.3321 Date 01/04/2025 10 % from all contract (525,000 AED ) For Al Khan-Shj G+15 .