Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

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 Berri

Tips

  • Remove your account numbers from the export before you share it.
  • Ask for the same view every quarter with a reminder.
What Berri sends back
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:

ClientPaymentsTotalAvg days
Client A7Rs 2,10,0009
Client B4Rs 1,64,00031
Client C6Rs 1,26,00012
Others5Rs 1,82,00018

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.

Your own job, in your own words.

Try Berri