Invoice Aging

The Invoice Aging Report provides a detailed view of unpaid invoices categorized by the length of time they have been outstanding. This report is essential for finance teams to monitor overdue payments, assess customer payment behavior, and manage cash flow effectively.

The report breaks down invoices into different aging periods such as 0–30, 31–60, 61–90, 91-120, 120+ days, helping you identify customers with overdue payments and prioritize collection efforts.

For example,

• If a customer was invoiced on August 1st and hasn’t paid by August 31st, the invoice would fall into the 31–60 day aging bucket on October 1st.
• If another invoice has been overdue for more than 90 days, it will show in the 91-120 days column, highlighting it as a high-priority case for follow-up.

To view your Invoice Aging report from your SubscriptionFlow account, follow these steps:

1. Login to SubscriptionFlow to access your admin dashboard. Then click on ‘Reports’ in the left-hand side panel.

2. You will be redirected to the Reports Page.

   
   

    

3. Under the ‘Invoices’ section, click on ‘Aging Report’.

    

4. This will take you to the Aging Report page where you will see a table chart showing outstanding amounts across various aging brackets. Scroll down to view detailed data for each customer, including customer name, invoice number, due amount, due date, and aging days.
   
    

5. You can customize the report by adding columns of Current Subscription and Subscription Status.

   

6.  Moreover, to filter out your data from the report you can apply filters on the modules of Customers and Invoices. In select field, select the data column you want to target such as customer name, invoice id, and select and operator such as equals, contain, not equal ,e.t.c, and in the fixed value section give that specific value you do/don't want  the data for. Press the add filter button to save that filter and click on run report to run the report for these filters.   

    

   

7. Below is the default table view. 

   

8. To change these column ranges of aging report and the number of columns click on Use custom aging intervals checkbox in the customize report drop down menu. 

   

9. Select your preferred range and run the report. 

   

   

10. To save the data, click on ‘Export’.

11. A green notification at the top right will confirm that your export file is being prepared.

     

12. To download the file, go to the gear icon (Administration Settings) at the top right corner of the screen.

     

13. Then, click on ‘Export’ under the ‘Data Administration’ section.

    
    

     

14. You’ll be directed to the Exports page. Locate your export file and click on ‘Download’.