You want the Customer Report.

Note, you can run it directly and set the customer in Options > General, or you can click the total amount owed for that Customer in the Receivable Aging Report. (it is a clickable link)

Also, note the Customer Report has Options > Display Columns > Transaction Links where you can show which payments applied to which invoices and vice versa. (there is a Simple and Detailed version of this info)

The aging information is for the entire account at the bottom. I don't know of a report that will show aging per invoice. And coming from using software in several other businesses, that info is very rare to find in a report. AR is usually handled per-account rather than per-invoice at least for tracking purposes with the general principles of:

1. Payments are always applied to an account before new charges on the same day. 2. Payments apply to the oldest outstanding invoice unless otherwise requested.

Of course, you may be required to operate differently.

Regards,
Adrien

On 8/20/23 10:05 AM, Adam Mackler via gnucash-user wrote:
Hi, sorry if this is a basic question, but I have not figured it out from the 
documentation.

How do I generate a report that shows all amounts owed as recorded in a given 
receivables account, itemized by invoice, showing the amount remaining due for 
each invoice and the amount of time past the due date for each invoice?

I tried Reports → Account Report from the register of the receivables account, but I got 
a blank tab with the header "Receivable Aging." The title sounds correct but 
the blank tab is not.

I also tried Reports → Receivable Aging which did the same thing.

I have multiple open invoices recorded in that receivables account, and I want 
to give the customer an account statement showing what he owes and how much is 
for which invoice (some invoices are partially paid). How can I generate such a 
report?

_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to