I built Ledger Mailer, a bulk ledger statement tool for both Customers and Suppliers. ![]()
What it does:
Customer OR Supplier: one tool for receivables and payables
Smart party fetch: filter by Customer Group, Territory, or Supplier Group (tree-aware), only parties with balance, skip parties with no transactions
Auto email resolution: Billing contact → Primary contact → party email, or send to all linked contacts
Preview before sending: see the exact PDF the party will receive
Send Test Email to Me: check subject, body, and attachment in your own inbox first
Email Templates with Jinja: {{ party_name }}, {{ closing_balance }}, {{ from_date }}, and more
Custom statement print design: account summary, running balance with Dr/Cr, a clear “Balance Due” card, and who owes whom
Optional PDF password per party
Background sending with live status: Sent / Failed / No Email / No Transactions
Re-send only Pending or Failed rows, never duplicates
Every email logged on the Customer/Supplier timeline as a Communication
Under the hood:
Numbers come from ERPNext’s standard General Ledger report, so opening, totals, and closing always match what accounts sees
Each run saves a Ledger Statement record as an audit trail
Built with Client Script + Server Scripts on Frappe
The sample statement is attached ![]()
Accounts teams spend hours on month-end and year-end balance confirmations. With this, it takes a few clicks.
Would this help your team? Comment “LEDGER” or DM me if you’d like it in your ERPNext.
