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