ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Importing bank statement


#22

same here also.
@shraddha any solution for this?


#23

@shraddha I’m also having the same problem - can’t select Bank Reconciliation from the Data Import Tool. The save button on the DocType setup page for Bank Reconciliation doesn’t seem to work as per @dhruv_pandit’s comment. Can you help, please? Thank you very much.


#24

We have the same problem. 'We check “Allow Import”, but when we save it will reset the checkbox back to unchecked. Is there a solution for this?

Thank you.

Mark


#25

Hi,

My understanding is that Bank Reconciliation should not be an importable doctype. There’s code in the controller that does an actual import of bank statement - although today it’s not really a proper bank reconciliation but an adjustment of the value date for already booked payment entries.

Proper bank reconciliation functionality is not yet available.

Regards,
cksgb


#26

Hi Chude,

Do you know if there is another way to import bank statements? We cannot enter everything by hand. Too many change on errors and takes ages.

Thanks!


#27

Hi Mark,

Can’t think of any way besides using Excel to transform the bank statement to an import file formated for Payment Entry.

I suspect a number of people are working on a proper bank reconciliation tool. There is an open issue in ERPNext github on the topic.

Regards,
cksgb


#28

Hi Chude,

Thank you. We will try that for now.

Best,
Mark


#29

Hi, I’m testing out v11.1.10 (local copy from the published VM) and trying to figure out how to get the bank data into the system so I can do reconciliation. Importing statement csv is a compromise to direct syncing (I assume that does not work with US banks?). So I’m trying to follow this thread. When I try “bench set-config developer_mode 1” it gives me error that command set-config does not exist. So then I tried to set the site_config.json to this:

image

I rebooted the server to make sure it took. Then I open the DocType “Bank Reconciliation” form and check the “Allow Import” box. But when I hit save the form resets to an unchecked box. So I’m unable to open that Data Import.

Suggestions?

Thanks


#30

I think the fix you are looking for is getting close: https://github.com/frappe/erpnext/pull/16202


#31

OK, that looks cool, any idea when it will be incorporated? Or is this some sort of plugin that can be tested?


#32

I don’t know much beyond what is posted on GitHub. Charles-Henri is amazing and very responsive. If the maintainers discover new issues, I am sure that he will work to quickly address them.


#33

Any idea when it will be incorporated