[om_account_bank_statement_import, v16] Import error

[quyetvk]

Hi

I tried to import bank statement but it always shows error:

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

I tried some samples such as:

<style> </style>

Date	Label	Reference	Partner	Amount	Currency
2020-12-01	Test 1	Ref 1	odoo mates	30	KWD
2020-12-01	Test 2	Ref 2	odoo mates	40	KWD

<style> </style>

date	payment_ref	partner_id	amount	Statement
11/07/2022	Customer payment 1		1000	S2-7th Nov 2022

Thanks for any support!

[gexiaut]

Same issue

[crispyduck00]

Same here.

[crispyduck00]

I added some debug lines and maybe it is not really the module causing the problem:
So the def create_statement(self, values): gives following error:

You can't create a new statement line without a suspense account set on the Exchainge journal.

But strange as I only have on currency.

[crispyduck00]

Fu** the solution was just one click away posted as pull request by @Naz1137
33b3777

Now import works. But still don't know how to reconcile in odoo 16 ce with Odoo Mates

[weldd1601]

still not working? has any one figured out his?

[nagybal]

I belive @crispyduck00 @weldd1601 You need
https://github.com/OCA/account-reconcile/tree/16.0

[imunisasi]

@odoomates any light on this issue sir ?

[hamza-mostafa]

the solution was just one click away posted as pull request by @Naz1137 33b3777

Now import works. But still don't know how to reconcile in odoo 16 ce with Odoo Mates

fix as the above and make sure the date is like the below format
'%Y-%m-%d'

[hamza-mostafa]

for reconciliation check this video -> https://www.youtube.com/watch?v=VxM7krqxG-s

[imunisasi]

@hamza-mostafa do you have xlsx and csv example for this, trying many times always

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

[cgomeznt1]

Does anyone have a solution to this module that does not import the csv file? still giving the same error

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

[odoomates]

hi @cgomeznt1 , could you share the file you have used to import

[imunisasi]

@crispyduck00 can you share your csv / xlxs format , thanks

[imunisasi]

@odoomates we use sample file inside om_account_bank_statement_import/sample_file
Import_Sample.csv
Import_Sample.xlsx

it never success

[ermias576]

Fu** the solution was just one click away posted as pull request by @Naz1137 33b3777

Now import works. But still don't know how to reconcile in odoo 16 ce with Odoo Mates

This is the solution all of us are looking for, but how the reconciliation works is the main question.