[GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

Adrien Monteleone adrien.monteleone at lusfiber.net
Mon Oct 3 10:35:57 EDT 2022


If you are looking for 'aging', that is, how much of an amount owed is 
say 30days, 60days, or 90+days due, then that is at the bottom each 
Customer or Vendor report. (and also shows any unused 
pre-payments/deposits in the case you use that feature)

It doesn't show any sort of average, but it does give you the exact 
amounts and how aged they are.

If you want to know the 'average' age of your AR/AP, then most likely 
you'd have to export those individual reports to a spreadsheet and do 
some math there. (there might be a way to extract this info via 
gnucash-cli or piecash and automate this process.)

If indeed you're looking for an overall average, that might be a good 
Request For Enhancement (also to be filed on bugs.gnucash.org) maybe to 
be added to the Summary Bar for each of the AR/AP accounts, and/or the 
experimental 'Dashboard' report.

Regards,
Adrien

On 10/3/22 8:50 AM, Uttam Chakravorty wrote:
If there is a way to get the average debtor/creditor days this would be 
the icing on the cake.





More information about the gnucash-user mailing list