I need to download a report for ‘Not Paid’ invoices within a specific period.

Modified on: Wed, 26 Apr, 2023 at 8:26 PM


How to download unpaid invoices for last month?

How to export not paid invoices reports?


You can either download the report from the Invoice Index Page or from the Import & Export Data section using the following filters.

  • Status  >  is  >  Not Paid

  • Updated at  >  Choose the date range


There are two ways you can download the report and the steps are mentioned below.

Invoice & Credit Notes

Navigate to Invoices & Credit Notes > Invoices Index page then choose the filter as ‘All Invoices > Add Filter > Status > is > Not Paid > Apply Filter’

Then choose another filter ‘Add Filter > Updated at > Choose the date range > Apply Filter

Note: On the recent UI enhancement you can now scroll the index pages - Customers, Subscriptions, Invoices, and Credit Notes vertically. Earlier, the pages will be paginated which may prolong your search however with the new enhancement as you scroll down the list it will load all other data in a single page as highlighted below on the screenshot. Refer to this link for more information. 

Now you will see the list of invoices as per your search criteria. You can click on ‘Export’ and ‘Export as CSV’.

Import & Export Data

Navigate to Settings > Import & Export Data > Export Data > Invoices > Select criteria to export

Use the same filter process as before. 

  1. Add Condition  >  Status  >  is  >  Not Paid

  2. Add Condition  >  Updated at  >  Choose the date range

  3. You can ‘Preview’ or ‘Export’ it in CSV format.

Note: Once the export is initiated, this exported report will be available in Chargebee for the next 14 days under Settings > Import & Export Data > Export history.

Related Articles

Is it possible to have a list of outstanding payments?
How to mark several invoices as paid?
Can I filter my reports? Also, how to export data and lists in CSV format?

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.