Ledger Statement Mailer

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