Payment Receipts, Credit Notes, Customer Ledger, and Payment Allocation in Sales Pack

[sapyantuk]

Is there any ETA of new version ?

[yuri]

It's ready but delayed due to non-technical reasons. I hope it will be released soon.

[yuri]

I think there's a chance that we implement a customer ledger in Sales Pack in future. Not the double entry ledger, but a simple one, with transactions per customer (Account entity). Maybe the next year.

[yuri]

In the next feature release we're going to add the ability to allocate a Credit Note to Invoices. The way Payments are allocated now.

[sapyantuk]

Hello EspoCRM Team, yuri

I hope you are doing well.

Last time you mentioned:

“I think there's a chance that we implement a customer ledger in Sales Pack in future. Not the double entry ledger, but a simple one, with transactions per customer (Account entity). Maybe the next year.”

We would like to kindly ask if there is any update, timeline, or roadmap regarding this feature.

This functionality is extremely important for our daily accounting and customer and supplier credit management.

We have attached a sample image for reference. We are looking for a ledger-style view where we can see:

• Sales invoices
• Payments received
• Credit notes
• Allocations
• Outstanding balances

all in one place.

This should not be limited only to Customers (Accounts) — we also need the same functionality for Suppliers (Vendors) so that we can maintain Supplier Statements / Purchase Ledgers showing:

• Purchase invoices
• Supplier payments
• Credit notes
• Outstanding payables

---

Report Structure We Are Looking For


We have already designed and tested three report formats and are looking for similar functionality inside EspoCRM: 1) Ledger Summary / Balance Report


This report shows:

• Total charges (invoice total including VAT/Tax, freight, and other charges)
• Total credit (payments received + credit notes)
• Allocations
• Outstanding balance

This provides a clear snapshot of a customer’s or supplier’s financial position.

---

2) Detailed Ledger Report (with Running Balance)


This report shows transaction-level entries with separate columns for:

• Taxable amount
• VAT / Tax
• Freight
• Credit (payments & credit notes)
• Outstanding balance

The Outstanding Balance should be auto-calculated as a running balance, for example:

• Invoice A: 5,000 → Outstanding: 5,000
• Invoice B: 6,000 → Outstanding: 11,000
• Credit / Payment: 2,000 → Outstanding: 9,000

This running balance is critical for reconciliation, follow-ups, and audit.

---

3) Ledger Summary (Totals)


This report should show:

• Total charges
• Total credit
• Total freight
• Total tax
• Final outstanding balance

This is used for management reporting and decision-making.

---

We are looking for all three of these reports for both:

• Customers (Sales Ledger)
• Suppliers (Purchase Ledger)

Additionally, we request more flexibility in custom report generation, including the ability to filter by:

• Date range
• Customer / Supplier
• Transaction type
• Outstanding balances

These features would significantly enhance EspoCRM’s value as a combined CRM and financial operations platform.

Thank you very much for your continued support.

Best regards,
Yubraj Kafle