ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

How to send statements to customers


I have to send physical and email statements to my customers every month end but with ERPNext I am unable to do so. Anyone please put light on this as it is a very basic requirement. Thanks


Go to Accounts > General Ledger
Under Party Type, select Customer
Under Party select the Customer you want to send your statement to.
The export to pdf and attach to your email client.


Thanks for the reply, I have more than 1000 customers. It’s impossible to create statements customer wise. I need to print all statements together


Mass Statement email/print is not available yet as a feature.
They are working on it though




Is there any solution for this situation now? … I also need to send Ledgers to many clients.


We had to create a custom doctype to do this and it’s a little hacky but works for us for now until ERPNext releases this.

Custom doctype includes a date field that we enter and then the custom child table pulls in all sales invoices for all customers due by that date. We click a button generate statements and it generates a print/pdf for each customer. Definitely not the most elegant of solutions but gets the job done for us.


Please share files.


Please guide me step by step to achieve this. I would be very thankful to you for this.