Ask, reply and learn. Join the community of Akaunting.
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
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
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)"]
Showing 1 to 3 of 3 discussions