Total your income by client from a payments export
Know who pays you most, and who pays late.
- ForFreelancers whose payments come from many clients.
- HelperNone needed
- ModeBerri Strawberry 1
- AttachCSV
Copy the prompt
This is my payments export for [period]. Group the credits by client, give the total and number of payments for each, and the average days between invoice and payment if the column exists.
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. Nothing is sent until you press send.
Run this in BerriTips
- Remove your account numbers from the export before you share it.
- Ask for the same view every quarter with a reminder.
Total your income by client from a payments export
CSVpayments-2026.csv
This is my payments export for April to October. Group the credits by client, give the total and number of payments for each, and the average days between invoice and payment if the column exists.
Reading payments-2026.csv
Rs 6,82,000 from 7 clients:
| Client | Payments | Total | Avg days |
|---|---|---|---|
| Client A | 7 | Rs 2,10,000 | 9 |
| Client B | 4 | Rs 1,64,000 | 31 |
| Client C | 6 | Rs 1,26,000 | 12 |
| Others | 5 | Rs 1,82,000 | 18 |
Client B pays a month late on average. Ask for an advance on the next project.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.