Sort a month of expenses into clean categories
A messy export becomes a category total you can trust.
- ForSmall offices and owners who pay everything from one account.
- HelperExpenses
- ModeBerri Strawberry 1
- AttachCSV
Copy the prompt
Here is last month’s expense export. Put each line into one of these categories: [categories]. Give me the total per category and list any line you were not sure about.
Change the words in [brackets] to your own.
What to attach
A CSV file, such as an export from your bank, billing or payments app.
Run it
Berri opens with the prompt filled in and the Expenses helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Give Berri your own category names and it uses them exactly.
- Ask "remember these categories" so next month you only send the file.
Sort a month of expenses into clean categoriesExpenses
CSVexpenses-oct.csv
Here is last month’s expense export. Put each line into one of these categories: rent, salaries, travel, office, software, other. Give me the total per category and list any line you were not sure about.
Reading expenses-oct.csv
212 lines, Rs 3,48,620 in total:
| Category | Lines | Total |
|---|---|---|
| Salaries | 9 | Rs 1,84,000 |
| Rent | 1 | Rs 65,000 |
| Travel | 74 | Rs 41,380 |
| Office | 96 | Rs 38,240 |
| Software | 6 | Rs 12,600 |
| Other | 26 | Rs 7,400 |
I was not sure about 5 lines marked "transfer". They are listed below for you to check.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.