Importing bank statement

ERPNext Accounting
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: feat: Reconciliation dashboard and Plaid integration by chdecultot Ā· Pull Request #16202 Ā· frappe/erpnext Ā· GitHub

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