Aging Report
Collecting outstanding cash is extremely important to those in accounting. View your various aging invoices by Publisher, Company, Rep, etc. Review outstanding collections. This report can be used to view your invoice aging. To use this report, navigate to Reports > All Reports – Finance, or use the global search bar. If this is a report that you plan to use frequently, mark it as a favorite and add it to your Quick Links. There may also be specific permissions that you need for report access.
We recommend that you have the following set up in order to use the report filters:
To access the report, you need the User Permission ‘Aging Report’. This permission gives you access to the Aging Report, and the Aging Report Detail. The sub-permission to ‘View All Users’ allows you to see data for all users in your site. Without the sub-permission you can only view your own data and data of any users who report to you.
Report Search
Use the various filters to generate your desired report. The default will search by All Publishers, but you can choose a specific publisher if desired. You can also add the company, publication(s) & market. The Advanced Search option can help you narrow down the details, I.e., print & online options, Rep, Market, Agency and Invoice Dates.
The ‘As of Date’ search field by default gets set to the current date, but you can change this if needed. The report calculates the aging based off of the As of Date. The best way to explain this is through an example. You have an invoice that was due on 2/10 and was paid on 2/20. If you run the report with an As of Date set to 2/21, that invoice will not show up in the results, since it has been paid. If you run the report with an As of Date set to 2/15, that invoice will show up in the results, since it had not yet been paid as of 2/15.
The ‘Display’ field lets you choose which results you want to see. You can view results for all open invoices, or only those with open cash, or only those with open barter.
Report Results
Your search will generate an interactive table with the information as selected. You can interact with the Company, Avg Pay, Past Due Status, & Subtotal, as well as view collection notes. Each record in the table is for a company in your system, and includes their aging information.
Click on the company name to open their overview page.
The Avg Pay column shows the average number of days it takes that company to make their payments after invoicing. Clicking on the number will open a popup that shows some more details about where the average is coming from. In the popup, you’ll see how many payments were made, along with the minimum number of days, and the maximum.
Clicking the values in the various aging buckets will open the Invoice Search page with some fields automatically filled in.
The Pending column reflects the value of open orders on the account.
If there are values in the Current column, it means the invoice is still current (not overdue) based on the billing terms set up on the company.
Each of the other aging buckets reflect ranges of days past due, with regards to the terms set with the company and invoice dates.
The Collection amounts are those that have been sent to collections for non-payment.
A Write-Off is any value written off for various reasons.
The Cash & Credits column reflects any cash or credits placed on the company’s account.
The Terms are the payment terms set on the company.
If you click on the magnifying glass icon on the left side of the table, you’ll open the company’s collection notes.