CashPri needs one row per unpaid invoice. In Xero that is the Aged Payables Detail report.
- Open Xero.
- Go to Accounting, then Reports.
- Open Aged Payables Detail.
- Use today as the report date.
- Group the report by supplier/contact.
- Include Invoice Date, Due Date, Invoice Reference and Total.
- Update the report.
- Export it as Excel.
- Return to CashPri and upload the Excel file.
Choose the detailed report, not the supplier summary.