Skip to Content

Odoo 16 Account Bank Statement Import

by ,
Odoo 8
v 16.0 Third Party 4394
Download for v 16.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Lines of code 540
Technical Name om_account_bank_statement_import
LicenseLGPL-3
Websitehttps://www.odoomates.tech
Versions 14.0 15.0 16.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Lines of code 540
Technical Name om_account_bank_statement_import
LicenseLGPL-3
Websitehttps://www.odoomates.tech
Versions 14.0 15.0 16.0

Generic Wizard to Import Bank Statements In Odoo 16 Community Edition. (This module does include any CSV and XLSX type import format.)

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
Wonderful Module
by
Muthamizhan
on 5/12/23, 2:50 PM

I'm getting an error message saying

"Please upload in the specified format!
"date, payment reference, reference, partner, amount, currency !"

When I'm debugging the lines, I'm getting a new error message saying 
"You can't create a new statement line without a suspense account set on the Miscellaneous Operations journal." But my bank journal is configured with "Bank Suspense Account" not Miscellaneous Journal.

Not sure, if this belongs to any configuration issue or any improvement needed in the code. Please help us to use the module. Thanks in advance, your help is highly appreciated.

date payment reference reference partner amount currency
2023-05-01 ABC1001 DEF2001
100 INR
2023-05-02 ABC1002 DEF2002
350 INR
2023-05-03 ABC1003 DEF2003
250 INR
2023-05-04 ABC1004 DEF2004
251 INR
2023-05-05 ABC1005 DEF2005
252 INR
2023-05-06 ABC1006 DEF2006
253 INR
2023-05-07 ABC1007 DEF2007
254 INR

Attached is a sample data that I'm trying to import.

Validation Error - not working
by
Rakesh Kumar
on 5/1/23, 10:48 AM

Validation Error


Please upload in specified format ! date, payment reference, reference, partner, amount, currency !

can you resolve this?

ERROR
by
KONE MOUSSA
on 3/21/23, 5:09 PM

error when I try to import

Please upload in specified format ! date, payment reference, reference, partner, amount, currency !

i used also you samples file , return the same message.

can you assit me to solve the problem

Its Not working
by
Khaled
on 2/3/23, 3:48 PM

It's not working 

Always showing this message 

Please upload in specified format ! date, payment reference, reference, partner, amount, currency !

i used also you samples file , return the same message.

Please solve it 



by
Rachid OUCHAOU
on 1/15/23, 12:35 PM

I also have the same problem when importing

Please download in the specified format! date, payment reference, reference, partner, amount, currency!

And does not allow to manually create
Please advise.

Hi odoo mates
by
test
on 12/5/22, 3:42 AM

i can't import it. Could you help to provide the sample csv? Thanks a lot. 

can not able to import the file
by
Salih Mohammed Hassan Mohammed
on 11/28/22, 4:43 AM

Hi Odoo mates  

I try diferent with diferent date formats but it was impossible.

I have not been able to import the file
by
tovarich_rmo@hotmail.com
on 11/21/22, 3:35 AM

Hi Odoo mates support,

After trying to import the files using the sample formats you provide, I couldnt achived it. The validation windows pops up every time I try to import it.

I try diferent with diferent date formats but it was impossible.

How can I do it?,  Do you have a video turorial where I can learn it?

Please advise.


Having trouble importing statements with this module
by
Denis Bukenya
on 11/10/22, 3:10 AM

Hello,

Thank you for the module. However, I have failed to import any bank statement in Odoo 15 and Odoo 16 community.

This is the response I get: 

Please upload in specified format ! date, payment reference, reference, partner, amount, currency !

Please advise.