Simple outstanding payables extraction from Xero


Can anyone help, I just want to extract a set of data from xero to match an aged payables from xero. I ma using the Outstanding Payables report. But it seems that some creditors I must use the Total Column (as the ā€œAmount Outstandingā€ column sometimes seems to show zero if the payment has since been allocated against the bill in xero even though dated after the report date, while sometimes I need to use the Amount Outstanding column as the Total column does not take account of part payments since. Seems like a simple enough requirement but finding it hard to get this working. Any guidance would be great.


Hi Chris

Did you have a look at the sample Aged Receivables (including a sample pivot table) provided in the Templates Library - this might help you solve the issue you are experiencing.