Invoice Aging Report

Purpose

This report is helpful to determine clients who are not paying their invoices in a timely manner. It splits out the invoices into current, 30 day, 60 day, 90 day and 90 day+ categories. 

  • The current column is any invoice that has not reached its due date. 
  • The 0-30 is any invoice that is 0-30 days out from the due date.  
    This report can also allow you to go back in time and view what invoices were marked as paid or unpaid on any given date.
Where You Can Run this Report

This report can be run in Enterprise under All Options > Reports. Select the Sales & Invoicing category on the left. 

You can also run this report in Beyond under B menu > Reports. Select All Reports and search by report name or report group of sales & invoicing.

*Note* Don't see this report? Report access is based on Security Role or Security Group permissions. 

Parameters
  1. Branch: A drop -down list of all branches in the user’s current hierarchy. Is a multi-value parameter so they can select all branches, just one specific branch or any combination of different branches in the list.
  2. Show: Will determine if the report will show the invoice number of the invoice that the payment was entered on or if it will show the invoice number of the parent invoice that the child invoice (the one that the payment was actually entered on in the system) was merged into. This allows you to see what was actually entered into the system vs. what the client put on their payment detail.
  3. Group By: A list of different fields to group the data into on the report. Has the following options:
    • Branch
    • Customer
    • Department
    • Invoice Date
    • Due Date
    • (no grouping)
  4. Sort By: A list of different fields to sort the data within the specified group. Has the following options:
    • Invoice Date 
    • Invoice Number
    • Invoice Amount 
    • Due Date 
    • Amount Paid 
    • Balance
  5. Period End Date: The date on which you want to view your invoice balances and aging 
  6. Date Filter: A drop- down determining what field your date filters on.
    • Invoice Date
    • Due Date
    • Weekend Bill Date
  7. Customer Filter: Filters for a specified customer name

Related Articles