Customer Ledger by Date

SUGGESTED

Many of my customers receive recurring services, and often pay before the invoice is even issued.  In the aged report, this creates a deposit line on the date of payment and then an applied amount after the invoice.  Customers find the report impossible to understand, and request a ledger by date which shows them going into a negative balance, and then to zero on the invoice date.  Is there a way to generate a customer ledger which is based solely on the date of payment/invoices with a running balance instead of doing it manually for them?  Sage 50