1 Topic by alex1452 (edited by alex1452 07/11/2025 04:29:56 am)

  • From: Germany, Kiel
  • Registered: 06/26/2025
  • Posts: 12

Topic: Import Transactions for Bank Statements

I have installed and activated the "Import Transactions" module. I would like to use this module to import bank statements. To test the import, I modified the provided sample:
modules/import_transactions/templates/bank_en_GB.csv
By updating the date and adjusting to the standard US COE.
reference,date,memo,payment,receipt,accountcode,taxtype,dim1ref,dim2ref,person_type_id (supplier=3 customer=2),person_id,Branch_id
1,01/01/22,labour,100.5,,5410,0,,,,,
2,02/01/22,cash on account,,300,1065,0,,,2,1,1
QWE2,03/01/22,payment for rent,200.5,,5760,1,,,,,
4,04/01/22,purchased stock,,700,1540,0,,,,,
6,05/01/22,paid supplier,400,,2100,0,,,3,1,

However, the import does not work. There is no menu for Bank statement import. There is only "General Journal Processing", "Deposit Processing", "Payment Processing", "Sales Order Processing" and "Direct Invoice Processing". When I use "General Journal Processing", I get a quick view of the "green process bar" but then nothing has happened afterwards.

Does anybody have experience in importing CSVs with Bank Statements? How to best do that?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,256

Re: Import Transactions for Bank Statements

Count the number of data elements and the number of headers - they appear correct herein but if there are any tabs and / or other delimiters or blank values some issues may occur based on PHP version.
This extension last worked in FA v2.4.6.
Some corrections have been made in the unofficial extensions repo for this extension.

To download this extension visit:
https://download-directory.github.io/
and paste in the github folder:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/import_transactions
and press Enter and you will get the zip file of the extension.

Use a folder compare utility like ExamDiffPro or WinDiff or WinMerge to check on the files in your official extension at FAwebroot/modules folder with that in the zip file and upload the changes in the files as listed therein.

Post's attachments

ImpTxn_Data_sample.png 7.9 kb, 1 downloads since 2025-07-10 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

3 Reply by alex1452 (edited by alex1452 07/11/2025 08:37:51 am)

  • From: Germany, Kiel
  • Registered: 06/26/2025
  • Posts: 12

Re: Import Transactions for Bank Statements

I followed exactly your instructions and updated the import extension with the content of the repository you provided. However, nothing has changed by using this repository.

Given our interactions on other issues in the past please allow me the question: How sure are you that changing the repository of the import module might be a step towards solving the issue? Or did you just send me on another "tangent" that ultimately only consumes time but provides no real value?

I still see the following options under "Banking and General Ledger" -> "Import Transactions".
"General Journal Processing"
"Deposit Processing"
"Payment Processing"
"Sales Order Processing"
"Direct Invoice Processing"

I tried ALL of them with the encl. CSV (this is a modified version of modules/import_transactions/templates/bank_en_GB.csv and identical to the screenshot you shared)

NONE of these produced ANY import. All off them showed a green process bar in the top middle of the screen that quickly disappeared after approx. 30 percent. I got no message.

How can I import bank statements into FrontAccounting? Specifically which is the right Menu item to import bank_en_GB.csv? Should I chose "General Journal Processing" to import bank_en_GB.csv?

---------------------

reference,date,memo,payment,receipt,accountcode,taxtype,dim1ref,dim2ref,person_type_id (supplier=3 customer=2),person_id,Branch_id
1,01/01/22,labour,100.5,,5410,0,,,,,
2,02/01/22,cash on account,,300,1065,0,,,2,1,1
QWE2,03/01/22,payment for rent,200.5,,5760,1,,,,,
4,04/01/22,purchased stock,,700,1540,0,,,,,
6,05/01/22,paid supplier,400,,2100,0,,,3,1,

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,256

Re: Import Transactions for Bank Statements

I do not know of what changes PHP 8.x will have on these extensions. Also, if there is no Banking Transactions in the said list and the Journal Transactions did not suffice, the error logs with debug on should provide some pointers. If you consider my suggestions as a tangent then please seek professional assistance in the Job Offers board. Using the audit trail is another method of viewing the various SQL queries that get traversed through during it's execution.

I maintain the unofficial extensions repo as it has some third party extensions also, not officially vetted as yet to serve as a self help resource. Also I make sure that the white space in the changed code is synched with those in the core and official code base to make for ease of troubleshooting and development.

My requests on the board and its archives have not elicited any response from the original developers of the extensions till date. Nor have any users listed the way they have solved the issues at hand in the forum and in the wiki as far as I know.

apmuthu's Website