search

frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
21.27k stars 7.26k forks source link

Need to have an Excel Import Facility to import the Bank Entries directly from the Banking Excel Sheet which we download from the Bank Portal #39064

Open JitendraSAW opened 10 months ago

JitendraSAW commented 10 months ago

Frappe Team,

There is a requirement now from many companies, as the Banking Transactions are voluminous in number, and to do the Data Entry manually or through ERPnext Excel Sheet Template takes time to do the data entry or put into the ERPNext System, which presently we can do by entering manually or through Excel Sheet by downloading the Template of Payment Entry. Still, even this filling of details in the Excel Sheet also takes a lot of sufficient and sometimes more time it needs.

There should now be a facility to directly import the Banking Excel Sheet which we will download from the Banking Netbanking Portal and do the direct data Import of the same sheet.

We are attaching one Sample Format of an HDFC Bank for your reference Accountstmt_50200006603241_30122023101807.XLS

himugo commented 10 months ago

I think the only big issue and the main issue with implementing such feature is the ledger detection (or categorization of transaction).

JitendraSAW commented 7 months ago

We can push the Ledger to one Suspense A/c, It would be a Common Control A/c and the balance will go to the Bank A/c the System should provide 1 Report format where all these Transaction which got imported will be listed and the User will just map the Correct COA A/c.