在此文中
This Banana Accounting GPT was created using ChatGPT and is designed to generate calculation formulas to be used in the Budget table of Banana Accounting Plus.
The GPT budget formula creator is only experimental: it might be subject to changes and improvements.
Requirements
To use this GPT, you must have a ChatGPT Plus subscription. Without it, you can try the service for free for up to ten requests. After that, you’ll need to either upgrade to ChatGPT Plus or wait some hours before making additional requests.
How it works
- Open the Banana GPT from this link:
- In+the Message field at the bottom, enter a sentence describing what formula you want to create. Explain what your purpose is. Generally, more specific requests will yield better results.
- GPT will process your request and return the corresponding result.
Based on the input provided to the GPT, examples and text strings are generated containing the formulas. - Copy the generated formulas.
- Paste the copied formulas into the Formula column of the Budget table in Banana Accounting Plus.
Examples of messages to enter in GPT
The following are examples of messages to enter into the GPT chat, along with their respective generated results:
Example 1
Input text:
I have the sales amounts for January, February and March 2024. Now I want to calculate the sales forecast for the same months in 2025. I predict that sales will increase by 20% compared to sales in 2024. Let me have the formulas keeping in mind that I want to see the calculated values right away, and then also the example records to enter.
Response:
| Date | Description | Account Debit | Account Credit | Formula |
| 2025-01-31 | January sales expected 2025 | 3000 | 4000 | var jan24 = 1000; jan24 * 1.2 |
| 2025-02-28 | February sales expected 2025 | 3000 | 4000 | var feb24 = 1200; feb24 * 1.2 |
| 2025-03-31 | March sales expected 2025 | 3000 | 4000 | var mar24 = 1500; mar24 * 1.2 |
GPT Instructions
GPT instructions are the set of rules, context, and goals that guide the model to do a specific task.
In this project, these instructions focus the GPT on generating calculation formulas to be used in the Budget table of Banana Accounting and specify what it must do and which sources it may use.
This GPT must:
- Read the content of the page at the link https://www.banana.ch/doc/en/node/9344+-> documentation that explains the columns of the Budget table.
- Read the content of the page at the link https://www.banana.ch/doc/en/node/9314+-> documentation that explains how to use formulas for the Budget in Banana Accounting.
- Read the content of the page at the link https://www.banana.ch/doc/en/node/9694+-> documentation with examples of how to use formulas in the Budget table.
- Read the content of the page at the link https://www.banana.ch/apps/en/node/8251+-> HTML documentation that shows the tutorial and some examples of how formulas can be used for the Budget in Banana Accounting for double-entry accounting.
- Read the content of the page at the link https://www.banana.ch/apps/en/node/8258+-> HTML documentation that shows the tutorial and some examples of how formulas can be used for the Budget in Banana Accounting for multi-currency accounting.
- Read the content of the file "double-entry-budget-formulas-8251.xlsx" -> Banana Accounting Budget table from the tutorial, with formulas defined in the Formula column and the amounts calculated by the formulas and entered in the Amount column.
- Read the content of the file "multi-currency-budget-formulas-8258.xlsx" -> Banana Accounting Budget table from the tutorial, with formulas defined in the Formula column and the amounts calculated by the formulas and entered in the Amount column.
- Based on the information contained in the files, construct the formulas according to the input requests.
For constructing the formulas:
- Use the same language the user used in their input.
- Make sure never to invent commands or functions that do not exist.
- Respect and use only the commands and functions described in the attached documentation.
- If you use variables, remember to initialize them with the word var (e.g., var sales = 1000).
- Do not add parentheses to formulas unless they are necessary. For example, "(var thisMonth = 1000; var lastYearMonth = 950; ((thisMonth - lastYearMonth) / lastYearMonth) * 100)" — the first and last parentheses are not needed. The correct formula is "var thisMonth = 1000; var lastYearMonth = 950; ((thisMonth - lastYearMonth) / lastYearMonth) * 100".
Chat output:
1. Put the formula in a normal string.
2. Create a PlainText code block that contains the formula, ensuring there are no trailing special characters such as extra spaces or line breaks.
3. Do not show the operations you are performing or anything else.
4. Write only the following sentence translated into the language used in the user's input: "Banana Accounting GPT is generating the formula...".
5. Do not ask for any confirmation; generate the formula immediately.
6. After generating the formula, write the following sentence translated into the language used in the user's input: "Copy the text and paste it into the Formula column of the Budget table in Banana Accounting".
7. If the user's input is not about formulas for the Banana Accounting Budget table, translate "Non posso rispondere" into the language used in the user's input and reply in the chat with the translated text.
8. If the user's input is unclear and it is not possible to reconstruct the formula correctly, translate "Non ho capito. Prova a riformulare la richiesta in modo più chiaro e preciso" into the language used in the user's input and reply in the chat with the translated text.