导入的扩展程序
导入扩展程序是额外的功能,允许您以特定格式导入其它程序导出的数据:
安装导入的扩展程序
为了使用导入的扩展程序,必须首先进行本地安装。
- 点击扩展程序菜单 → 管理扩展程序 → 导入
- 您还可以从导入到账套的命令查看管理扩展程序的对话框。
- 选择您想要使用的扩展程序,并点击安装。
一旦安装了扩展程序,它将显示在:
自定义扩展程序
安装扩展程序后,您可以通过设置按钮访问自定义的功能。
导入银行对账单
最常见的用途是将银行对账单导入会计账套。
- 点击操作菜单 → 导入到账套的命令。
- 从下拉菜单中,选择导入发生业务。
- 选择用于导入的扩展程序
- 如果尚未安装,请先安装扩展程序。
创建和更新CSV导入扩展程序
如果从您的银行或其它组织导入数据的合适格式尚不存在,您可以要求我们的开发人员创建一个导入的扩展程序。也请参见以下英文的页面。
为了创建或更新特定文件格式的导入扩展程序,需要执行以下步骤:
- 我们的程序员需要:
- 要导入的数据的示例文件,有一些动向 (没有个人的私人信息)。
- 生成文件的银行、组织或软件的确切详细信息。
- 关于所含数据类型的信息 (银行报表、发票数据、工资等)。
- 关于文件内容类型的解释,或由银行或软件制造商提供的规格链接。
- 文件生成的日期。
- 对于从其它程序导出的文件,具有无法立即理解的数据结构,应解释或举例说明应在账户中生成的发生业务。
- 对请求的评估:
- 这将取决于开发的复杂性以及其他用户是否对该导入感兴趣。
- 可能需要分摊开发或升级成本。
- 我们将考虑是否继续创建文件,如果是:
- 我们将使用发送给我们的示例文件作为参考和测试,其中内容将公开可用。
- 除非另有约定,本扩展程序将按照开源方式进行开发。
- 该扩展程序通常可供高级计划用户安装。
- 不能保证扩展程序会一直保持最新的状态。
银行经常在不事先通知的情况下更改文件格式。 - 已更新的现有的扩展程序:
- 随着时间的推移,.csv 文件的格式会发生变化或修改,因此相应的导入过滤器也必须更新。
- 旧的导入过滤器 (Banana 9 或更早版本) 将在更新后提供给拥有 Banana财务会计+ 高级计划的用户。
- 一些旧过滤器也可能与 Banana财务会计+ 一起正常工作。 在这些情况下,它们可以继续使用而不会出现任何问题,直到需要更新。
- 当用户告诉我们当前版本不再正常工作时,更新过滤器就完成了。
- 旧版本仍然可用,但不再更新或更正。
开发您自己的导入扩展程序
如果您是程序员,您可以创建符合您具体需求的导入扩展程序。详情见:
Developing a New Import Extensions
Programming a new import extensions
GPT Import Extensions Assistants
Extensions GPTs allow you to expand Banana Accounting’s functionality. We have multiple GPTs to help you with this area:
- GPT - Banana Accounting - CSV Bank Import Extension Assistant
This assistant generates extensions for importing bank transactions from CSV files.
It uses the Parameterizable Extension template and automatically adapts the JavaScript parameters to match the structure of the CSV files you upload in chat. Perfect when you need to import bank transactions from a CSV file with a custom extension.
Developers
If you are a programmer you can create your import extensions. Please visit:
The possibility of creating your own extensions is only available with the Advanced plan of Banana Accounting Plus.
Request for a new or update Import extensions
If a suitable format for importing data from your bank or other organization does not already exist or is not working, you can ask our developers to create an import extension.
See:
In order to create or update an import extension for a specific file format these steps are necessary:
- Our programmers need to receive:
- An example file of the data to be imported, with some transactions (without sensitive personal information).
- The exact details of the bank, organization or software that generated the file.
- Information on the type of data contained (bank statement, invoice data, salaries, etc.),
- Explanations on the file content type, links to specifications made available by the bank or software producer.
- The date on which the file was generated.
- For files exported from other programs, with data structures that are not immediately understandable, an explanation or examples of the transactions that should be generated in the accounts.
- Evaluation of the request:
- It will depend on the complexity of the development and whether the import may be of interest to other users.
- A share of the development or upgrade costs may be required.
- We will consider whether to proceed with the creation of the file and if so:
- We will use the example file sent to us as a reference and for testing, whereby the content will be publicly available.
- Unless otherwise agreed, the extension will be developed according to the open source method.
- The extension will generally be available for installation to Advanced Plan users.
- There is no guarantee that the extension will be kept constantly up-to-date.
Banks often change their file format without giving prior notice. - Update existing extensions:
- Over time, the formats of .csv files are changed or modified and consequently the corresponding import filters must also be updated.
- The old import filters (Banana 9 or earlier) will be made available to Banana Plus users with the Advanced plan after the update.
- It is possible that some old filters will also work correctly with Banana Plus. In these cases, they can continue to be used without any problems until they need to be updated.
- Updating a filter is done when users tell us that the current version no longer works correctly.
- Old versions remain available but are no longer updated or corrected.