Let’s explain to you how to create an Excel with your monthly movements wearing artificial intelligenceand from your bank statements. We will go far beyond the spreadsheets that your bank can generate with your expenses. The AI will list what you spend and what you earn, and at the end of each month it will show you your total balance.
But we are also going to ask that at the end of each month there be custom totals for specific expensessuch as Amazon purchases, Bizum movements, etc. This is something quite complex to do, and after testing we are going to give you the guide using Claudebecause it is by far the one that has given us the best results.
The prompt that we are going to tell you you can also use it in ChatGPTwhere it will give you very good results. The only difference is that in ChatGPT You won’t have a button to save it to Drive, but at least you can download it. As to GeminiGoogle’s AI gives the worst results with this prompt, I would try to avoid it.
In Claude we are going to seamlessly generate different pages for each month, it will use color coding, and we will tell you that add a button to save it to Google Drivesomething quite useful, although you can also ask it to simply allow you to download the file.
Get your bank statements first
The first thing you have to do is download a document with all your banking transactions from your bank application. In some cases you will already be able to download it in Excel, but our idea is to make one with AI in which specific totals are also calculated at the end of each month.
Many banks will allow you to choose the time periods you want to take into account when downloading expenses. Here, you should keep in mind that AIs usually have a limit in the context of your requests. This means that it is better to cover shorter periods of time.
For example, you will be able to download statements for each month or every two months, because then you can ask the artificial intelligence to update your spreadsheet with the new data from each extract.
If you use Claude, link your Drive account
One of the positive aspects of Claude is that you can add and activate the connector Google Drive. The connectors are used to connect Claude to other services, in this case Google Drive. You’ll have to give the AI access to your entire Drive, so be careful if you’re looking for maximum privacy.
In our case, this will help us be able to create a save button in Drive our document. Thus, not only will you be able to view the spreadsheet directly in Claude, but you will also be able to download it or save it to your cloud.
Create your spreadsheet
Now let’s get to work. Open Claude and attach the document with your banking transactions that you have downloaded from your bank application. When you do it, you have to include the prompt explaining what you want. We have used this:
“This is a statement from my bank. From your data, I want you to generate a spreadsheet showing the total expenses for each month. Each month must be separated, and you must list all expenses and income with negative and positive signs. At the end of each month you must show me a box where I see the total to know if I have had a positive or negative balance.
At the end of each month I also want you to make two extra boxes where you show me the total expenses on Amazon purchases, and the balance of Bizum movements. Each month should then be separated on a different page within the spreadsheet. Additionally, I want you to use a color code, to put the rows that represent an expense in red and an income in green.
The spreadsheet should be a .xlsx file, and I also want you to generate a button so I can save this document directly to Google Drive.
Also, from now on, every time I share a bank statement with you in this conversation, you will update that document to add the data.”
As you can see, we have asked for it to be a multi-page spreadsheet, one for each month, and to use color coding. We have also requested boxes for extra balancessuch as the total spent on Amazon or the balance of movements in Bizum.
You can also ask for other types of balances, but it is better that stick to requests that the AI can identify. This means that perhaps if you ask it how much you spend on subscriptions, it may not be able to identify all of them correctly or it may charge you more than necessary. It’s best to include specific expenses with a name that appears on your statements.
If you want to include subscriptionsto give you an idea, in another conversation you can ask him to identify your subscriptions from your bank statements. And after doing so, you can include in your prompt that puts the monthly expenses of those specific subscriptions in a cell.
Claude will take a few minutes to do everything and will show you each step he takes. In the end, you will have a document with the Excel XLSX format that we have requested. If you click on it you will open it directly in Claudealthough you will also have a button to open it in the application compatible with the format you have by default.
When you click on the file that has been generated, in Claude it will open in the same chat. If you use ChatGPT you will have to download it. When you open it, you can check that everything is the way you like it, and check the totals and expense list. That’s it, you will have the spreadsheet with your accounting total.
You will be able to update your spreadsheet by simply adding a new bank statement to the chat and saying something like “Update the spreadsheet with the data from this other statement”. With this, the AI will regenerate the document it has created by adding the new month or the new movements.
Furthermore, another positive thing is that You will also be able to ask questions about all the data with those that generated the document. For example, after creating it, in the same chat you can ask how much you have spent in a specific store in a certain period of time, or whatever comes to mind.
In Xataka Basics | How to have your own specialized AI with the data and knowledge that you give it using NotebookLM
GIPHY App Key not set. Please check settings