Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

CSV, Comma Separated Values

Salvador Jaimes   ( User )

Commented 6 years ago

Hi. I got the CSV file from my bank account, and can open it in my spreadsheet software to work on it.
Is there an APP for akaunting to import this file into my company?
Thank for any advise

Störm Poorun   ( User )

Commented 5 years ago

CSV import would be a great app. You can get the OFX import app and then convert the CSV to OFX, but I'm not sure why there isn't a basic CSV app! :s

User11 User11   ( User )

Commented 1 week ago

Pretty strange that I cannot play with CSV import. As to XLSX import, I have downloaded transfers.xlsx (https://app.akaunting.com/public/files/import/transfers.xlsx) and then fed to back to Akaunting (https://app.akaunting.com/nnn/banking/transfers) using "Default Transfer Table". New accounts "Hic quasi." and "Nobis laborum." are created, but there are no transfers listed when I select any of them. Email I've received:

["SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transferred_at' in 'where clause' (Connection: mysql, SQL: select * from `eba_transfers` where `transferred_at` = 2020-01-01 and `from_account_id` = 477033 and `to_account_id` = 478003 and `amount` = 10 and `eba_transfers`.`deleted_at` is null and `eba_transfers`.`company_id` = 381626 limit 1)"] ["SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transferred_at' in 'where clause' (Connection: mysql, SQL: select * from `eba_transfers` where `transferred_at` = 2020-01-01 and `from_account_id` = 478004 and `to_account_id` = 478003 and `amount` = 20 and `eba_transfers`.`deleted_at` is null and `eba_transfers`.`company_id` = 381626 limit 1)"]

Please login or register to leave a response.

Showing 1 to 3 of 3 discussions