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!!!
_______________________________________________
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.
