← All Xero reports
Xero report

Xero unpaid bills report: a list of bills to pay

Before a payment run you want the actual bills: supplier, reference, due date and amount. The unpaid bills list is that list.

Sample Unpaid Bills report for a demo company, as sent by Reportpost
A sample Unpaid Bills for a demo company, as Reportpost sends it.

What it shows

  • Each unpaid bill
  • Due dates, amounts outstanding and how overdue each one is
  • In Xero, a planned payment date column

Working from the list rather than the summary makes payment runs quicker: you can pick bills by due date, leave disputed ones aside and check nothing is paid twice.

Where to find it in Xero

The closest Xero report is Aged Payables Detail (Reporting > All reports). Payable Invoice Detail is an alternative for bills raised in a period.

Settings worth knowing

  • Ageing by due date or invoice date
  • Grouping by contact group, document type or tracking category

Things to watch out for

  • It's a snapshot at the report date.

Getting it by email on a schedule

Xero can't email reports on a schedule, so the usual routine is to export the report and attach it by hand. Reportpost sends a clean list of every unpaid bill as at the day it sends, with supplier, reference, dates, amount due and days overdue, timed for the day before your payment run. Choose weekly, every two weeks, monthly or quarterly, and the recipients. You can try the demo without connecting Xero.

Related: Emailing the unpaid bills report and Xero month-end checklist.

Other Xero reports

Xero reportProfit and LossWhat the Xero Profit and Loss report shows, where to find it, the settings that matter (comparisons, tracking, cash or accrual) and how to email it every month.Xero reportBalance SheetWhat the Xero Balance Sheet report shows, where to find it, comparison and tracking options, and how to send it to directors or lenders each month.Xero reportAged Receivables SummaryWhat the Xero Aged Receivables Summary (aged debtors) shows, how to read the ageing columns, key settings and how to get it emailed every week.Xero reportAged Payables SummaryWhat the Xero Aged Payables Summary (aged creditors) shows, its ageing and grouping options, common gotchas, and how to have it emailed before each payment run.Xero reportBank SummaryWhat the Xero Bank Summary report shows (cash received and spent per bank account), its options and gotchas, and how to send it automatically each week or month.Xero reportTrial BalanceWhat the Xero Trial Balance shows, its comparison and grouping options, the gotchas, and how to send it to your accountant at month end.Xero reportExecutive SummaryWhat the Xero Executive Summary includes (cash, profit, balance sheet and key ratios), its options and limits, and how to email it every month.Xero reportBudget SummaryWhat the Xero Budget Summary report shows, how budgets are set up in Budget Manager, and how to send the budget summary on a schedule.Xero reportBudget vs ActualHow to compare actuals with your budget in Xero (Budget Variance), what to look for, and how to have a budget vs actual report emailed every month.Built from your Xero dataCash Flow Statement (indirect)Xero only has a direct-method cash flow statement. How the indirect method works and how Reportpost builds one from your Xero data and emails it.Xero reportUnpaid InvoicesHow to get a list of unpaid invoices from Xero (Aged Receivables Detail), what it shows, and how to have the list emailed every week.Xero reportInvoices RaisedHow to list the invoices raised in a period in Xero (Receivable Invoice Summary or Detail), the options and gotchas, and how to email the list automatically.Xero reportDraft InvoicesHow to keep track of draft invoices in Xero, why they matter at month end, and how to have a list of drafts emailed to you so nothing is left unapproved.

Next month's pack could send itself.

Reportpost emails your Xero reports on a schedule, as PDF, Excel or CSV. 14 days free, no card.

Try the demo, no signupSee how it works