En este artículo
We have started exploring how Artificial Intelligence (AI) can be used to improve our software. Our goal is to make your accounting work easier, faster, and more effective. Many people have heard about AI, but not everyone is familiar with what it is or how it can be helpful in practice.
This guide explains AI in simple terms and introduces the GPT assistants we are developing for Banana Accounting Plus.
What is AI
Artificial Intelligence (AI) refers to computer systems that can "think" and "learn" in ways similar to humans. AI can read, understand, and generate information, helping you complete tasks more efficiently. Instead of just following fixed instructions, AI can adapt to your request and provide smart answers.
We see AI as a helpful assistant that works with you. It does not replace you; it supports you. For example, AI can:
- Suggest solutions when you are not sure how to proceed.
- Generate formulas or code snippets that you can use directly.
- Answer questions about the software without you having to search through long manuals.
What is ChatGPT
One of the most popular AI tools today is ChatGPT. It is an advanced program that allows you to communicate with AI through a simple chat box, just like talking to a person. You write a question or describe a task, and ChatGPT replies in natural language.
Key points about ChatGPT:
- It has been trained on a huge amount of text so it understands many topics.
- You don’t need technical knowledge; you just ask questions in plain language.
- It can explain, generate ideas, and even write text or code.
However, there is one limitation: standard ChatGPT is very general. It tries to answer anything in the world, from cooking recipes to physics problems. While that is useful, it means it doesn’t always know the specifics of Banana Accounting Plus.
What is a GPT
GPT (Generative Pre-trained Transformer) is the name of the artificial intelligence technology used by ChatGPT. The great thing is that we can create Custom GPTs: special versions of ChatGPT that are trained and configured to focus on specific topics or tasks.
Think of it this way:
- Standard ChatGPT: Like a general encyclopedia. It has a lot of knowledge but may not know your specific situation.
- Custom GPTs: Like specialized assistants that are configured with specific knowledge and instructions, providing answers adapted to particular topics or tasks.
For example, Banana GPTs are specialized assistants that have read our documentation and follow our instructions. They provide answers specific to Banana Accounting Plus.
With Custom GPTs:
- You still use the same ChatGPT chat interface, you type your questions in the chat box and read the answers in the conversation.
- Instead of talking to a "generic" ChatGPT, you select the GPT created for a specific purpose.
- The answers are more reliable, precise, and relevant to the specific topic or purpose.
Banana Accounting GPT Assistants
We have created several GPT assistants designed to help with different areas of Banana Accounting. Here’s a detailed list of what they do and when you should use them. All these GPTs are created using specific instructions and the documentation published on our website.
- Command generator for Filter search GPT
- What it does: Helps you build advanced search commands to filter rows in the Transactions table.
- When to use it: If you need to find specific transactions using complex criteria but don’t know the correct syntax.
- Example: "Show only transactions with income amount over 1000 and category ‘Sales’."
The GPT will generate the exact filter command you can paste into Banana Accounting.
- Budget Formula Creator GPT
- What it does: Creates calculation formulas for the Budget table.
- When to use it: If you want to calculate values (e.g., percentages, projections) but are unsure how to write the formula.
- Example: "Create a formula to increase monthly rent by 2% every year."
- Extensions GPTs
Extensions allow you to expand Banana Accounting’s functionality. We have multiple GPTs to help you with this area:- Extensions Maker GPT
- What it does: Generates extensions to create reports with accountng data. Helps you create extensions or answers questions about extension development.
- Example: "Create an extension that prints a the accounts list and balances".
- Extensions GPT Documentation
- What it does: Generates extensions to create reports with accountng data, using only our official Banana documentation. The difference with the previous one is that this GPT only uses official documentation without any additional instructions.
- Example: "Create an extension that prints a the accounts list and balances".
- Journal Transactions GPT
- What it does: Generates extensions to create reports with current and budget transactions extracted from the Journal of the accounting file..
- Example: “Make an extension that summarizes expenses by category and compares them to the budget.”
- CSV Importer GPT
- What it does: 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 bank CSV files you upload in the chat of the GPT.
- Extensions Maker GPT
How to use a Banana Accounting GPT
Requirement: you must have a ChatGPT Plus subscription.
Using a Banana Accounting GPT is as easy as chatting:
- Choose the GPT assistant you need (see the list above) by opening the link provided on the corresponding page.
- Write your question or describe the problem in the chat.
- The GPT will respond with answers relevant to Banana Accounting, using our documentation and predefined instructions.
- After you use a GPT, it stays saved on the left side (above your chats), making it easy to open again later with a single click.
Excel and Office Scripts Integration with Banana Accounting
- Excel Reports Add-in
Create worksheets in Excel with formulas, charts, formatting, and more. The add-in automatically retrieves the data from your Banana Accounting file. - Excel Custom Functions
The free Banana Accounting Functions Add-in lets you retrieve and display accounting data in Excel using simple formulas. - Office Scripts
With Banana Accounting Plus, you can use Office Scripts in Excel (the modern successor to VBA) to retrieve and display your accounting data. Data is accessed through the integrated Banana Web Server. - Excel VBA functions
Access your accounting data directly in Excel through VBA functions. (Note: this technology has been replaced by the newer Excel Add-in and Office Scripts.)
Other
Following you find documentation that is only mantained in English: