Try ERPNext Try Frappe Cloud Buy Support Partners Foundation

Bank Reconciliation Tool Error

Hi,
We’re having some inconvenients with bank reconciliation tool.
First, it doesn’t work if you’re importing with goggle sheet. It recognizes the field, but doesn’t import the file.

Captura de Pantalla 2021-04-27 a la(s) 12.47.09

Captura de Pantalla 2021-04-27 a la(s) 12.48.24

And this is all.

Error log:

Traceback (most recent call last):
File “/home/diamo/Frappe/apps/frappe/frappe/utils/background_jobs.py”, line 100, in execute_job
method(**kwargs)
File “/home/diamo/Frappe/apps/erpnext/erpnext/accounts/doctype/bank_statement_import/bank_statement_import.py”, line 100, in start_import
import_file = ImportFile(“Bank Transaction”, file = import_file_path, import_type=“Insert New Records”)
File “/home/diamo/Frappe/apps/frappe/frappe/core/doctype/data_import/importer.py”, line 331, in init
frappe.throw(_(“Invalid template file for import”))
File “/home/diamo/Frappe/apps/frappe/frappe/init.py”, line 433, in throw
msgprint(msg, raise_exception=exc, title=title, indicator=‘red’, is_minimizable=is_minimizable, wide=wide, as_list=as_list)
File “/home/diamo/Frappe/apps/frappe/frappe/init.py”, line 412, in msgprint
_raise_exception()
File “/home/diamo/Frappe/apps/frappe/frappe/init.py”, line 366, in _raise_exception
raise raise_exception(msg)
frappe.exceptions.ValidationError: Invalid template file for import

It’s strange because model template have been downloaded from the ERP. The only way that it works is importing files from the device. Both images are exactly the same, but the difference is that from my device it works and from google sheet doesn’t.
After that,

Captura de Pantalla 2021-04-27 a la(s) 12.52.51

The statement from my device has been successfully imported, but I couldn’t find the way to do the reconciliation. The only option I have is “go to transactions list” button, that shows this

Captura de Pantalla 2021-04-27 a la(s) 12.54.58

So, I’ve imported the statement, but I can’t find the way to reconcile automatically those. I can do it individually, but it it’s practical if you have a lot of transactions.

Is anybody using this? Could you explain me how they do, and if I’m doing something wrong or if it’s a bug?

Thanks in advance!

Hey,

Can you please share the link to the google sheet file that is failing to import?

Not the exact file but something that faces the same error should help

There is a tool that is called Bank Reconciliation Tool1

Hi, this is the GSheet file https://docs.google.com/spreadsheets/d/1Lj5ilX6i-WaGxF4AG9eQBg5neR3g3eOukbLU5H4Errw/edit#gid=0
It doesn’t matter because it’s a test file, not a real one. It isn’t working…
I did the import but with uploading a file, not with GSheet link. And I can’t do the conciliation either.
Thanks!

@Irina_SB

Thanks for sharing the link and the traceback

The issue was replicated. The reason seems that addition of the bank account column to the uploaded file is breaking when the source is a google sheet.

A fix will be raised soon by someone