[GNC] Follow up on Gnucash invoicing and payment - questions on process

[Adrien Monteleone]

As far as I know, that exact report doesn't exist in GnuCash, but there 
are various ways to see this information.

#1 Invoices Due Reminder

This is a dialog window, not a report. (and sadly no way to get that 
data to a report as far as I know.) It shows the Invoice, Customer, Date 
Due & Balance Due. It does not show original amount invoiced. (there is 
also a column to indicate credit notes)

I keep this and the Bills Due Reminder open at all times. (they run when 
you start GnuCash, but you can run them intentionally too.)


#2 Receivable Aging Report

This is a report. It shows all customers, one per line, with their 
current balance along with how much is current, or 30 days late, 60 days 
late, 90 days late, or exists as pre-payments. (deposits) It does not 
show individual invoices, just an overview of each customer's account. I 
also keep this open in a tab at all times.

#3 Customer Report

However, clicking an *amount* in the above report will get you a 
Customer Report *for that customer*. (like a Statement of Account) If 
you turn on 'Transaction Links' in Options for this report, you can see 
each invoice and payment, with dates, and then see which payments 
applied to which invoices, and which invoices were paid by which 
payments. This also shows aging information. You can see the original 
amount invoiced, but you do not see a balance due *per invoice*. You can 
see how much of a payment was applied though.

#5 Find Invoice Dialog

Again, not a report, but here you can do a search for invoices for a 
particular customer, or all customers. (by using criteria: Invoice ID > 
Matches Regex > .) This shows invoice #, Date opened, Date Due, Date 
Posted, Customer name, type (invoice or credit note) and if it is paid 
in full.

You can also do searches based on if the invoice is paid or not, by 
customer, or for all customers. (or even if the balance is a certain amount)

Unfortunately, there is no way to export the results of this dialog to 
elsewhere, not even copy and paste as far as I'm aware. The Printable 
Report button functions as a Print Invoice button here. That will show 
payments applied however.

Regards,
Adrien

On 10/14/22 2:21 AM, Charles Vincent wrote:
> Now if you guys can tell me how to produce a report (spreadsheet like)
> which shows all customers invoices in column A with the name of the
> customer and the invoices , amount invoiced per invoice in column B, amount
> paid per invoice in column C, and balance due per invoice in column D,
> you will have made my day!!!